| | |
|---|
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 |
|---|
| | | } |
|---|
| | | |
|---|
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
|---|
| | | //{ |
|---|
| | | |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | objJsonResult.list = columnNameList; |
|---|
| | | return objJsonResult; |
|---|
| | | //} |
|---|
| | | //else |
|---|
| | | //{ |
|---|
| | | //objJsonResult.code = "0"; |
|---|
| | | //objJsonResult.count = 0; |
|---|
| | | //objJsonResult.Message = "无数据"; |
|---|
| | | //objJsonResult.data = null; |
|---|
| | | //return objJsonResult; |
|---|
| | | //} |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
| | |
|---|
| | | if (string.IsNullOrEmpty(HID)) |
|---|
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | var dataSet = oCN.RunProcReturn("select top 1 * from Sc_MouldMaintainRuleBillMain where HInterID= " + HID + " ", "Sc_MouldMaintainRuleBillMain"); |
|---|
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMaintainRuleBill_Edit where HInterID= " + HID + " ", "h_v_Sc_MouldMaintainRuleBill_Edit"); |
|---|
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
|---|
| | | return new ApiResult<DataSet> { code = -1, msg = "不存在器具保养规程记录" }; |
|---|
| | | return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; |
|---|
