派生自 MES-WEB-API
WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
@@ -63,12 +63,12 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere, "h_v_Sb_EquipRepairWorkBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere+ "order by hmainid desc", "h_v_Sb_EquipRepairWorkBillList"); } else { string sql1 = "select * from h_v_Sb_EquipRepairWorkBillList where 1 = 1 "; string sql = sql1 + sWhere; string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairWorkBillList"); } @@ -113,12 +113,12 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairCheckBillList" + sWhere, "h_v_Sb_EquipRepairCheckBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairCheckBillList " + sWhere+ " order by hmainid desc", "h_v_Sb_EquipRepairCheckBillList"); } else { string sql1 = "select * from h_v_Sb_EquipRepairCheckBillList where 1 = 1 "; string sql = sql1 + sWhere; string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairCheckBillList"); } @@ -163,12 +163,12 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList" + sWhere, "h_v_Sb_EquipConkBookBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList order by hmainid desc" + sWhere, "h_v_Sb_EquipConkBookBillList"); } else { string sql1 = "select * from h_v_Sb_EquipConkBookBillList where 1 = 1 "; string sql = sql1 + sWhere; string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipConkBookBillList"); } } @@ -184,9 +184,9 @@ /// </summary> /// <param name="msg"></param> /// <returns></returns> [Route("Sb_EqpRepairWorkBill/SaveGetEqpRepairWorkBillList")] [Route("Sb_EqpRepairWorkBill/SaveGetEqpRepairWorkBillWebList")] [HttpPost] public object SaveGetMouldRepairWorkBillList([FromBody] JObject msg) public object SaveGetEqpRepairWorkBillWebList([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); @@ -346,7 +346,7 @@ if (sqlWhere == null || sqlWhere.Equals("")) { //ds = oCN.RunProcReturn("select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark from Sc_MouldRepairWorkBillSub", "Sc_MouldRepairWorkBillSub"); ds = oCN.RunProcReturn("select HManagerID1,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark from h_v_Sc_EquipRepairWorkBillList_Edit", "h_v_Sc_EquipRepairWorkBillList_Edit"); ds = oCN.RunProcReturn("select HRepairID,维修项目代码 HRepairCode,维修项目 HRepairName,HManagerID1 HManagerID,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1 HRepairID, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType from h_v_Sc_EquipRepairWorkBillList_Edit", "h_v_Sc_EquipRepairWorkBillList_Edit"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; @@ -355,7 +355,7 @@ else { //string sql1 = "select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark from Sc_MouldRepairWorkBillSub where 1 = 1 "; string sql1 = "select HManagerID1,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark from h_v_Sc_EquipRepairWorkBillList_Edit where 1 = 1 "; string sql1 = "select HRepairID,维修项目代码 HRepairCode,维修项目 HRepairName,HManagerID1 HManagerID,表体负责人代码 HManagerCode,表体负责人 HManagerName,HRepairID1 HRepairID, 表体维修项目代码 HRepairCode,表体维修项目 HRepairName,表体维修要求 HRepairExplanation,表体备注 HRemark ,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType from h_v_Sc_EquipRepairWorkBillList_Edit where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipRepairWorkBillList_Edit"); objJsonResult.code = "0"; @@ -363,6 +363,32 @@ objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; } return objJsonResult; } #endregion #region[新增编辑设备维修按选单号加载表体数据] [Route("Sb_EqpRepairWorkBill/Sb_EqpRepairWorkBillSubByHMainSourceBillNo")] [HttpGet] public object Sb_EqpRepairWorkBillSubByHMainSourceBillNo(string HMainSourceBillNo) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select 单据号,hmainid,hsubid,HBillType from h_v_Sb_EquipConkBookBillList where 单据号= '" + HMainSourceBillNo+"'", "h_v_Sb_EquipConkBookBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } catch (Exception e) { @@ -879,7 +905,7 @@ } #endregion #region[设备维修验收列表编辑时获取表头数据] #region[设备故障登记列表编辑时获取表头数据] [Route("Sb_EqpRepairWorkBill/Sb_EqpConkBookBillListCheckDetai")] [HttpGet] public ApiResult<DataSet> Sb_EqpConkBookBillListCheckDetai(string HID) @@ -894,7 +920,7 @@ } #endregion #region[设备维修列表编辑时获取表体数据] #region[设备故障登记列表编辑时获取表体数据] [Route("Sb_EqpRepairWorkBill/Sb_EqpConkBookBillListProjectDetai")] [HttpGet] public object Sb_EqpConkBookBillListProjectDetai(string sqlWhere) @@ -935,9 +961,9 @@ } #endregion #region [设备维修单删除功能] #region [设备故障登记单删除功能] /// <summary> /// 模具维修单删除功能 /// 设备故障登记单删除功能 /// </summary> /// <returns></returns> [Route("Sb_EqpRepairWorkBill/DeltetEqpConkBookBill")]
