派生自 MES-WEB-API
WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs
@@ -16,6 +16,7 @@ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public WebServer webserver = new WebServer(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类 @@ -1424,7 +1425,7 @@ //public object DeltetMouldRepairWorkBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -1511,7 +1512,7 @@ // try // { // //审核权限 // if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) // if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; @@ -1843,7 +1844,7 @@ //public object DeltetMouldRepairCheckBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairCheckBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairCheckBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -2124,7 +2125,7 @@ //public object DeltetMouldConkBookBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -2395,7 +2396,7 @@ //public object DeltetMouldMaintainPlanBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -2996,7 +2997,7 @@ //public object DeltetSc_MouldDotCheckBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -3269,7 +3270,7 @@ //public object DeltetSc_MouldDotCheckPlanBillBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -3996,7 +3997,7 @@ //public object DeltetMouldScrapOutHouseBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldScrapOutBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldScrapOutBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -4083,7 +4084,7 @@ // try // { // //审核权限 // if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) // if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; @@ -4213,21 +4214,22 @@ [Route("Sc_CheckToolsRepairWorkBillList/GetMouldRepairInBillList")] [HttpGet] public object GetMouldRepairInBillList(string sWhere,string user) public object GetMouldRepairInBillList(string sWhere,string user, string Organization) { try { //编辑权限 if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBillList", 1, true, user)) if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } ds = Sc_MouldRepairInBillList(sWhere); ds = Sc_MouldRepairInBillList(sWhere,Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -4244,16 +4246,16 @@ } } public static DataSet Sc_MouldRepairInBillList(string sWhere) public static DataSet Sc_MouldRepairInBillList(string sWhere,string Organization) { string sql1 = string.Format(@"select * from h_v_Sc_MouldRepairInBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairInBillList order by 日期 desc", "h_v_Sc_MouldRepairInBillList"); return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldRepairInBillList"); } else { string sql1 = "select * from h_v_Sc_MouldRepairInBillList where 1 = 1 "; string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList"); } @@ -4267,6 +4269,8 @@ public object Sc_MouldRepairInBillListCheckDetai(string sqlWhere) { DataSet ds; DataSet ds1; List<object> list = new List<object>(); try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -4274,13 +4278,10 @@ { ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec, 批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust, 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位 FROM h_v_Sc_MouldRepairInBillList"), "h_v_Sc_MouldRepairInBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } else { @@ -4288,16 +4289,23 @@ //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 "; string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec, 批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust, 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位 FROM h_v_Sc_MouldRepairInBillList where 1=1 "); string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } //查汇总 ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实收数量)实收数量, hwhid,max(仓库代码)仓库代码,max(仓库)仓库,子备注 from h_v_Sc_MouldRepairInBillList where 1=1 " + sqlWhere + " group by 物料代码,规格型号,hwhid,批次,子备注"), "h_v_Sc_MouldRepairInBillList"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; } catch (Exception e) { @@ -4334,11 +4342,11 @@ try { //编辑权限 if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBill_Edit", 1, true, msg4)) if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } @@ -4478,6 +4486,8 @@ } if (bResult) { string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; @@ -4522,7 +4532,7 @@ try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -4629,7 +4639,7 @@ try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -4732,7 +4742,7 @@ public object DeltetMouldRepairInBill(string HInterID,string user) { //编辑权限 if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBill_Delete", 1, true, user)) if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairIn_SingleBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -4819,6 +4829,89 @@ } #endregion #region 器具改制入库单审核/反审核 [Route("Sc_MouldRepairInBill/AuditMouldRepairInBill")] [HttpGet] public object AuditMouldRepairInBill(string HInterID, string user, int flag) { //flag=1 审核； flag=2 反审核 //编辑权限 if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairIn_SingleBill_Check", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无审核权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); if (lngBillKey == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据ID为空！"; objJsonResult.data = null; return objJsonResult; } DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { if (flag == 1) { if (oBill.omodel.HBillStatus == 2) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "当前单据已审核，无需再次审核"; objJsonResult.data = null; return objJsonResult; } else { string HCheckDate = DateTime.Now.Date.ToString(); oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker ='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3826' and HInterID=" + HInterID); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核成功！"; objJsonResult.data = 1; return objJsonResult; } } else { if (oBill.omodel.HBillStatus == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "当前单据未审核，无需反审核"; objJsonResult.data = null; return objJsonResult; } else { string HCheckDate = DateTime.Now.Date.ToString(); oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3826' and HInterID=" + HInterID); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "反审核成功！"; objJsonResult.data = 1; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未找到"; objJsonResult.data = null; return objJsonResult; } } #endregion #endregion //#region 模具领用单 @@ -5077,7 +5170,7 @@ //public object DeltetMouldProdOutBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; @@ -5407,7 +5500,7 @@ //public object DeltetMouldLifeChangeBill(string HInterID) //{ // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0;
