| | |
|---|
| | | 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 h_v_Sb_EquipDotCheckRuleList where hmainid= " + HID + " ", "h_v_Sb_EquipDotCheckRuleList"); |
|---|
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EquipDotCheckRuleEdit where hmainid= " + HID + " ", "h_v_Sb_EquipDotCheckRuleEdit"); |
|---|
| | | 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 }; |
|---|
| | |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | string sql1 = @"select * from h_v_Sb_EquipDotCheckRuleList a |
|---|
| | | string sql1 = @"select * from h_v_Sb_EquipDotCheckRuleEdit a |
|---|
| | | left join Gy_DotCheck b on a.点检项目ID =b.HItemID where 1 = 1 "; |
|---|
| | | string sql = sql1 + sqlWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleEdit"); |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "获取信息成功！"; |
|---|
