| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select 点检项目ID HDotCheckItemID,点检项目代码 as HDotCheckCode ,点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName from h_v_Sb_EquipDotCheckBillList", "h_v_Sb_EquipDotCheckBillList"); |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckBill_Edit", "h_v_Sb_EquipDotCheckBill_Edit"); |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "获取信息成功！"; |
|---|
| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select 点检项目ID HDotCheckItemID,点检项目代码 as HDotCheckCode ,点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName from h_v_Sb_EquipDotCheckBillList where 1 = 1 "; |
|---|
| | | string sql1 = "select * from h_v_Sb_EquipDotCheckBill_Edit where 1 = 1 "; |
|---|
| | | string sql = sql1 + sqlWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckBillList"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckBill_Edit"); |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "获取信息成功！"; |
|---|
