派生自 MES-WEB-API
WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs
@@ -1425,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; @@ -1512,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; @@ -1844,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; @@ -2125,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; @@ -2396,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; @@ -2997,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; @@ -3270,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; @@ -3997,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; @@ -4084,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; @@ -4219,7 +4219,7 @@ 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; @@ -4268,6 +4268,8 @@ public object Sc_MouldRepairInBillListCheckDetai(string sqlWhere) { DataSet ds; DataSet ds1; List<object> list = new List<object>(); try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -4275,13 +4277,10 @@ { ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec, 批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust, 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID 实收数量 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 { @@ -4289,16 +4288,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,HStockOrgID 实收数量 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) { @@ -4335,7 +4341,7 @@ 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; @@ -4479,6 +4485,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 = "保存成功！"; @@ -4523,7 +4531,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; @@ -4630,7 +4638,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; @@ -4733,7 +4741,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; @@ -4827,7 +4835,7 @@ { //flag=1 审核； flag=2 反审核 //编辑权限 if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairIn_SingleBill_Check", 1, true, user)) if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldRepairIn_SingleBill_Check", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -5161,7 +5169,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; @@ -5491,7 +5499,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;
