智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zzr99
2021-09-01 6ced0cff2123105422ec0d66d6e5f3c5b7dba8e0 
 WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs


@@ -219,7 +219,18 @@




        public static DataSet Sc_MouldMaintainBillList_s(string sWhere)


        {


            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainBillList ", "h_v_Sc_MouldMaintainBillList");


            if (sWhere == null || sWhere.Equals(""))


            {


                return new SQLHelper.ClsCN().RunProcReturn("select *  from h_v_Sc_MouldMaintain", "h_v_Sc_MouldMaintain");


            }


            else


            {


                string sql1 = "select * from h_v_Sc_MouldMaintain where 1 = 1 ";


                string sql = sql1 + sWhere;


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMaintain");


              


            }


            //return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainBillList ", "h_v_Sc_MouldMaintainBillList");


        }


        #endregion




@@ -317,7 +328,7 @@




        public static DataSet Sc_MouldDotCheckBillList_s(string sWhere)


        {


            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList ", "h_v_Sc_MouldDotCheckBillList");


            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 "+sWhere+" ", "h_v_Sc_MouldDotCheckBillList");


        }


        #endregion




@@ -432,22 +443,11 @@


            {




                ds = Sc_MouldConkBookBillList_s(sWhere);


                if (ds == null || ds.Tables[0].Rows.Count <= 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何记录！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "返回记录成功！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception ex)


            {


@@ -464,7 +464,18 @@




        public static DataSet Sc_MouldConkBookBillList_s(string sWhere)


        {


            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList ", "h_v_Sc_MouldConkBookBillList");


            DataSet ds;


            if (sWhere == null || sWhere.Equals(""))


            {


               ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList " + sWhere, "h_v_Sc_MouldConkBookBillList");


            }


            else


            {


                string sql1 = "select * from h_v_Sc_MouldConkBookBillList where 1 = 1 ";


                string sql = sql1 + sWhere;


                ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldConkBookBillList");


            }


            return ds;


        }


        #endregion




@@ -480,7 +491,6 @@


        {


            try


            {




                ds = Sc_MouldRepairCheckBillList_s(sWhere);


                objJsonResult.code = "1";


                objJsonResult.count = 1;


@@ -504,7 +514,18 @@




        public static DataSet Sc_MouldRepairCheckBillList_s(string sWhere)


        {


            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList ", "h_v_Sc_MouldRepairCheckBillList");


            DataSet ds;


            if (sWhere == null || sWhere.Equals(""))


            {


                ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList_Edit " + sWhere, "h_v_Sc_MouldRepairCheckBillList_Edit");


            }


            else


            {


                string sql1 = "select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 ";


                string sql = sql1 + sWhere;


                ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairCheckBillList_Edit");


            }


            return ds;


        }


        #endregion




@@ -1362,7 +1383,7 @@


                if (sqlWhere == null || sqlWhere.Equals(""))


                {


                    //ds = oCN.RunProcReturn("select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark   from Sc_MouldRepairWorkBillSub", "Sc_MouldRepairWorkBillSub");


                    ds = oCN.RunProcReturn("select HRepairSonID HRepairID, 子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark  from h_v_Sc_MouldRepairWorkBillList_Edit", "h_v_Sc_MouldRepairWorkBillList_Edit");


                    ds = oCN.RunProcReturn("select HRepairID, 子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark  from h_v_Sc_MouldRepairWorkBillList_Edit", "h_v_Sc_MouldRepairWorkBillList_Edit");


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -1371,7 +1392,7 @@


                else


                {


                    //string sql1 = "select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark  from Sc_MouldRepairWorkBillSub where 1 = 1 ";


                    string sql1 = "select HRepairSonID HRepairID, 子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark  from h_v_Sc_MouldRepairWorkBillList_Edit where 1 = 1 ";


                    string sql1 = "select HRepairID,子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark  from h_v_Sc_MouldRepairWorkBillList_Edit where 1 = 1 ";


                    string sql = sql1 + sqlWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList_Edit");


                    objJsonResult.code = "0";


@@ -1627,6 +1648,7 @@


            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


            string msg2 = sArray[0].ToString();


            string msg3 = sArray[1].ToString();


            string msg4 = sArray[2].ToString();






            string UserName = "";


@@ -1640,7 +1662,7 @@


                lsmain = oListModels.getObjectByJson_Gy_MouldRepairCheckBillMain(msg2);


                foreach (Model.ClsSc_MouldRepairCheckBillMain oItem in lsmain)


                {


                    //oItem.HMaker = "";


                    oItem.HMaker = msg4;


                    UserName = oItem.HMaker;  //制单人


                    oItem.HBillType = "3817";


                    oItem.HBillSubType = "3817";


@@ -1922,6 +1944,7 @@


                {


                    //oItem.HMaker = "";


                    UserName = oItem.HMaker;  //制单人


                    DBUtility.ClsPub.CurUserName = UserName;


                    oItem.HBillType = "3815";


                    oItem.HBillSubType = "3815";


                    //oItem.HBillNo = "";    //单据号


@@ -2057,7 +2080,7 @@


                {




                    //ds = oCN.RunProcReturn("select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark   from Sc_MouldRepairCheckBillSub", "Sc_MouldRepairCheckBillSub");


                    ds = oCN.RunProcReturn("select HConkReasonID,故障原因代码 HConkReasonCode,故障原因 HHConkReasonName,故障原因描述 HConkExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldConkBookBillList_Edit", "h_v_Sc_MouldConkBookBillList_Edit");


                    ds = oCN.RunProcReturn("select HConkReasonID,故障原因代码 HConkReasonCode,故障原因 HConkReasonName,故障原因描述 HConkExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldConkBookBillList_Edit", "h_v_Sc_MouldConkBookBillList_Edit");




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


@@ -2068,7 +2091,7 @@


                {




                    //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark  from Sc_MouldRepairCheckBillSub where 1 = 1 ";


                    string sql1 = "select HConkReasonID,故障原因代码 HConkReasonCode,故障原因 HHConkReasonName,故障原因描述 HConkExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldConkBookBillList_Edit where 1 = 1 ";


                    string sql1 = "select HConkReasonID,故障原因代码 HConkReasonCode,故障原因 HConkReasonName,故障原因描述 HConkExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,备注 HRemark from h_v_Sc_MouldConkBookBillList_Edit where 1 = 1 ";


                    string sql = sql1 + sqlWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldConkBookBillList_Edit");




@@ -2441,6 +2464,7 @@


        #endregion




        #endregion




        #region 模具保养记录表




        #region 模具保养记录表 保存/编辑


@@ -2602,7 +2626,6 @@


        }


        #endregion






        #region[模具保养记录表编辑时获取表头数据]


        [Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListCheckDetai")]


        [HttpGet]


@@ -2617,6 +2640,7 @@


            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };


        }


        #endregion




        #region[模具保养记录表编辑时获取表题数据]


        [Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListProjectDetai")]


        [HttpGet]


@@ -2680,8 +2704,8 @@


                string sql = "select HMaintainItemID, 保养项目代码 HMaintainItemNumber,保养项目名称 HMaintainItem,保养部位 HMaintainPart,具体要求 HClaim,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark  from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + "";


                ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem");


               //获取配件项目编辑数据


                string sql1 = "select HMaterID, 配件代码 HMaterNumber,配件名称 HMaterName,规格型号 HMaterSpec,HUnitID,单位代码 HUnitNumber,单位名称 HUnitName,实际用量 HQty,标准用量 HQtyMust,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark  from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + "";


                ds1 = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem");


                string sql1 = "select HMaterID, 配件代码 HMaterNumber,配件名称 HMaterName,规格型号 HMaterSpec,HUnitID,单位代码 HUnitNumber,单位名称 HUnitName,实际用量 HQty,标准用量 HQtyMust,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark  from h_v_Sc_MouldMaintainBillList where 1 = 1 " + Swhere + "";


                ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainBillList");


                list.Add(ds.Tables[0]);


                list.Add(ds1.Tables[0]);


                objJsonResult.code = "0";


@@ -2700,8 +2724,7 @@


        }


        #endregion






       #region [模具保养记录表删除功能]


        #region [模具保养记录表删除功能]


            /// <summary>


            /// 模具维修单删除功能


            /// </summary>


@@ -2781,8 +2804,8 @@


        }


        #endregion






        #endregion




        #region 模具点检记录表




        #region 模具点检记录表 保存/编辑


@@ -2944,7 +2967,7 @@


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                if (sqlWhere == null || sqlWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select HDotCheckItem,HDotCheckPart,HClaim,HRemark,HManagerID from Sc_MouldDotCheckBillSub", "Sc_MouldMaintainBillSub");


                    ds = oCN.RunProcReturn("select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName from h_v_Sc_MouldDotCheckBillList", "h_v_Sc_MouldDotCheckBillList");


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -2952,9 +2975,9 @@


                }


                else


                {


                    string sql1 = "select HDotCheckItem,HDotCheckPart,HClaim,HRemark,HManagerID from Sc_MouldDotCheckBillSub where 1 = 1 ";


                    string sql1 = "select 点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName from h_v_Sc_MouldDotCheckBillList where 1 = 1 ";


                    string sql = sql1 + sqlWhere;


                    ds = oCN.RunProcReturn(sql, "Sc_MouldDotCheckBillSub");


                    ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldDotCheckBillList");


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -2971,7 +2994,6 @@


            return objJsonResult;


        }


        #endregion






        #region [模具点检记录表删除功能]


        /// <summary>


@@ -3055,6 +3077,7 @@






        #endregion




        #region 模具点检计划表




        #region 模具点检计划表 保存/编辑