派生自 MES-WEB-API
WebAPI/Controllers/Sc_MouldRepairInBillListController - .cs
@@ -18,6 +18,7 @@ public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类 public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill(); //模具报废入库对应单据类 @@ -227,9 +228,9 @@ else { string sql1 = "select * from h_v_Sc_MouldMaintain where 1 = 1 "; string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; 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"); } @@ -329,7 +330,7 @@ public static DataSet Sc_MouldDotCheckBillList_s(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 "+sWhere+ "order by 日期 desc", "h_v_Sc_MouldDotCheckBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 " + sWhere + "order by 日期 desc", "h_v_Sc_MouldDotCheckBillList"); } #endregion @@ -468,12 +469,12 @@ DataSet ds; if (sWhere == null || sWhere.Equals("")) { ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList order by 日期 desc" + sWhere, "h_v_Sc_MouldConkBookBillList"); ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList order by 日期 desc" + sWhere, "h_v_Sc_MouldConkBookBillList"); } else { string sql1 = "select * from h_v_Sc_MouldConkBookBillList where 1 = 1 "; string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldConkBookBillList"); } return ds; @@ -523,7 +524,7 @@ else { string sql1 = "select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 "; string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairCheckBillList_Edit"); } return ds; @@ -639,7 +640,7 @@ else { string sql1 = "select * from h_v_Sc_MouldRepairWorkBillList where 1 = 1 "; string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList"); } } @@ -791,56 +792,6 @@ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MoveStockBillList order by 日期 desc", "h_v_IF_MoveStockBillList"); } #endregion /// <summary> /// 生产领料单列表 /// </summary> /// <returns></returns> [Route("Kf_MateOutBill/GetMateOutBillList")] [HttpGet] public object GetMateOutBillList(string sWhere) { try { ds = Sc_GetMateOutBillList(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; } } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #region sql语句 public static DataSet Sc_GetMateOutBillList(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MateOutBillList order by 日期 desc", "h_v_IF_MateOutBillList"); } #endregion /// <summary> /// 销售出库单列表 /// </summary> @@ -879,7 +830,36 @@ return objJsonResult; } } /// <summary> ///销售出库单删除功能 /// </summary> /// <returns></returns> [Route("Kf_SellOutBill/DeltetSellOutBill")] [HttpGet] public object DeltetSeOutStockBackBill(string HInterID) { try { oCN.BeginTran(); oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID); oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #region sql语句 @@ -988,44 +968,44 @@ #endregion /// <summary> /// 采购入库单列表 /// </summary> /// <returns></returns> [Route("Kf_POStockInBill/GetPOStockInBill")] [HttpGet] public object GetPOStockInBill(string sWhere) { try { ///// <summary> ///// 采购入库单列表 ///// </summary> ///// <returns></returns> //[Route("Kf_POStockInBill/GetPOStockInBill")] //[HttpGet] //public object GetPOStockInBill(string sWhere) //{ // try // { ds = Sc_GetPOStockInBill(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; } } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } // ds = Sc_GetPOStockInBill(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; // } // } // catch (Exception ex) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); // objJsonResult.data = null; // return objJsonResult; // } //} #region sql语句 @@ -1076,7 +1056,36 @@ return objJsonResult; } } /// <summary> ///产品入库单删除功能 /// </summary> /// <returns></returns> [Route("Kf_ProductInBill/DeltetProductInBill")] [HttpGet] public object DeltetProductInBill(string HInterID) { try { oCN.BeginTran(); oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID); oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #region sql语句 @@ -1146,24 +1155,12 @@ { try { ds = Sc_GetEntrustInBill(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 = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception ex) { @@ -1303,10 +1300,6 @@ oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HCloseType = false; //关闭类型 //oItemSub.HRemark = ""; //备注 oItemSub.HSourceInterID = 0; // 源单主内码 oItemSub.HSourceEntryID = 0; //源单子内码 //oItemSub.HSourceBillNo = ""; //源单单号 //oItemSub.HSourceBillType = ""; //源单类型 oItemSub.HRelationQty = 0; //关联数量 //oItemSub.HRelationMoney = 0; //关联金额 //oItemSub.HRepairID = 0; //维修项目 @@ -1384,7 +1377,7 @@ if (sqlWhere == null || sqlWhere.Equals("")) { //ds = oCN.RunProcReturn("select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark from Sc_MouldRepairWorkBillSub", "Sc_MouldRepairWorkBillSub"); 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"); ds = oCN.RunProcReturn("select HRepairID, 子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType from h_v_Sc_MouldRepairWorkBillList_Edit", "h_v_Sc_MouldRepairWorkBillList_Edit"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; @@ -1393,7 +1386,7 @@ else { //string sql1 = "select HRepairID,HRepairExplanation,HManagerID,HMoney,HRemark from Sc_MouldRepairWorkBillSub 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 sql1 = "select HRepairID,子维修项目代码 HRepairCode,子维修项目 HRepairName,子维修要求 HRepairExplanation,HManagerSonID HManagerID,子负责人代码 HManagerCode,子负责人 HManagerName,维修费用 HMoney,表体备注 HRemark,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,源单类型 HSourceBillType 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"; @@ -1506,7 +1499,7 @@ public object AuditProcessReportList(int HInterID, int IsAudit, string CurUserName) { string ModRightNameCheck = "Sb_MouldRepairWorkBill_Check"; DBUtility.ClsPub.CurUserName=CurUserName; DBUtility.ClsPub.CurUserName = CurUserName; try { //审核权限 @@ -1580,7 +1573,7 @@ return objJsonResult; } if (IsAudit == 0) //审核提交 { { //审核提交 if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { @@ -2357,7 +2350,7 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sqlWhere == null || sqlWhere.Equals("")) { ds = oCN.RunProcReturn("select HMaterID,HUnitID,HQty,HQtyMust,HRemark from Sc_MouldMaintainPlanBillSub", "Sc_MouldMaintainPlanBillSub"); ds = oCN.RunProcReturn("select a.HMaterID,m.HNumber HMaterNumber,a.HUnitID,u.HNumber HUnitNumber,a.HQty,a.HQtyMust,a.HRemark from Sc_MouldMaintainPlanBillSub a left join Gy_Unit u on a.HUnitID=u.HItemID left join h_v_IF_Material m on a.HMaterID=m.HItemID", "Sc_MouldMaintainPlanBillSub"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; @@ -2365,7 +2358,7 @@ } else { string sql1 = "select HMaterID,HUnitID,HQty,HQtyMust,HRemark from Sc_MouldMaintainPlanBillSub where 1 = 1 "; string sql1 = "select a.HMaterID,m.HNumber HMaterNumber,a.HUnitID,u.HNumber HUnitNumber,a.HQty,a.HQtyMust,a.HRemark from Sc_MouldMaintainPlanBillSub a left join Gy_Unit u on a.HUnitID=u.HItemID left join h_v_IF_Material m on a.HMaterID=m.HItemID where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "Sc_MouldMaintainPlanBillSub"); objJsonResult.code = "0"; @@ -2576,12 +2569,12 @@ //oItemSub.HSourceBillNo = ""; //源单单号 //oItemSub.HSourceBillType = ""; //源单类型 Sub.HRelationQty = 0; //关联数量 //oItemSub.HRelationMoney = 0; //关联金额 //HMaterID = "";//配件代码 //HUnitID = "";//单位代码 //HQty = "";//实际用量 //HQtyMust = "";//单位用量 //HRemark = "";//备注 //oItemSub.HRelationMoney = 0; //关联金额 //HMaterID = "";//配件代码 //HUnitID = "";//单位代码 //HQty = "";//实际用量 //HQtyMust = "";//单位用量 //HRemark = "";//备注 oBill.DetailColl.Add(Sub); @@ -2687,7 +2680,7 @@ public object Sc_MouldMaintainBillListProjectDetaiNew(string HInterID) { DataSet ds,ds1; DataSet ds, ds1; List<object> list = new List<object>(); string Swhere = ""; try @@ -2696,7 +2689,7 @@ { Swhere = " and hmainid='" + HInterID + "'"; } else else { Swhere = HInterID; } @@ -2704,7 +2697,7 @@ //获取保养项目编辑数据 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_MouldMaintainBillList where 1 = 1 " + Swhere + ""; ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainBillList"); list.Add(ds.Tables[0]); @@ -2726,11 +2719,11 @@ #endregion #region [模具保养记录表删除功能] /// <summary> /// 模具维修单删除功能 /// </summary> /// <returns></returns> [Route("Sc_MouldMaintainBill/DeltetSc_MouldMaintainBill")] /// <summary> /// 模具维修单删除功能 /// </summary> /// <returns></returns> [Route("Sc_MouldMaintainBill/DeltetSc_MouldMaintainBill")] [HttpGet] public object DeltetSc_MouldMaintainBill(string HInterID) { @@ -3229,7 +3222,7 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sqlWhere == null || sqlWhere.Equals("")) { ds = oCN.RunProcReturn("select HDotCheckItem,HDotCheckPart,HClaim,HRemark,HManagerID from Sc_MouldDotCheckPlanBillSub", "Sc_MouldDotCheckPlanBillSub"); ds = oCN.RunProcReturn("select HDotCheckItem, HDotCheckPart , HClaim, a.HRemark,a.HManagerID,e.HNumber HManagerCode,e.HName HManagerName from Sc_MouldDotCheckPlanBillSub a left join Gy_Employee e on a.HManagerID=e.HItemID", "Sc_MouldDotCheckPlanBillSub"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; @@ -3237,7 +3230,7 @@ } else { string sql1 = "select HDotCheckItem,HDotCheckPart,HClaim,HRemark,HManagerID from Sc_MouldDotCheckPlanBillSub where 1 = 1 "; string sql1 = "select HDotCheckItem, HDotCheckPart , HClaim, a.HRemark,a.HManagerID,e.HNumber HManagerCode,e.HName HManagerName from Sc_MouldDotCheckPlanBillSub a left join Gy_Employee e on a.HManagerID=e.HItemID where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "Sc_MouldDotCheckPlanBillSub"); objJsonResult.code = "0"; @@ -3368,6 +3361,8 @@ public object Sc_MouldScrapInHouseBillListProjectDetai(string sqlWhere) { DataSet ds; DataSet ds1; List<object> list = new List<object>(); try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -3379,10 +3374,6 @@ HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark,HStockOrgID FROM h_v_Sc_MouldScrapInHouseBillList"), "h_v_Sc_MouldScrapInHouseBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } else { @@ -3396,11 +3387,18 @@ string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapInHouseBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } //查汇总 ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实收数量)实收数量, hwhid1,max(收料仓库代码)收料仓库代码,max(收料仓库名称)收料仓库名称,子备注 from h_v_Sc_MouldScrapInHouseBillList where 1=1 " + sqlWhere + " group by 物料代码,规格型号,hwhid1,批次,子备注"), "h_v_Sc_MouldScrapInHouseBillList"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; } catch (Exception e) { @@ -3674,7 +3672,7 @@ oBill.omodel = oItem; } //子表体数据 List<Models.ClsSc_MouldStockBillSub> ls = new List<Models.ClsSc_MouldStockBillSub>(); ls = oListModels.getObjectByJson_Gy_MouldScrapInHouseBillSub(msg2); int i = 0; @@ -3752,7 +3750,7 @@ [Route("Sc_MouldScrapOutHouseBill/GetMouldScrapOutHouseBill")] [HttpGet] public object GetMouldScrapOutHouseBill(string sWhere,string user, string Organization) public object GetMouldScrapOutHouseBill(string sWhere, string user, string Organization) { try { @@ -3766,7 +3764,7 @@ return objJsonResult; } ds = Sc_GetMouldScrapOutHouseBill(sWhere,Organization); ds = Sc_GetMouldScrapOutHouseBill(sWhere, Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -3788,11 +3786,11 @@ string sql1 = string.Format(@"select * from h_v_Sc_MouldScrapOutHouseBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by 日期 desc", "h_v_Sc_MouldScrapOutHouseBillList"); return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 日期 desc", "h_v_Sc_MouldScrapOutHouseBillList"); } else { string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList"); } } @@ -3822,6 +3820,8 @@ public object Sc_MouldScrapOutHouseBillListProjectDetai(string sqlWhere) { DataSet ds; DataSet ds1; List<object> list = new List<object>(); try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -3832,10 +3832,6 @@ 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实发数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 发货仓库代码 HWHCode, 发货仓库名称 HWHName, HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark,HStockOrgID FROM h_v_Sc_MouldScrapOutHouseBillList"), "h_v_Sc_MouldScrapOutHouseBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } else { @@ -3848,11 +3844,18 @@ string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } //查汇总 ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量, hwhid1,max(发货仓库代码)发货仓库代码,max(发货仓库名称)发货仓库名称,子备注 from h_v_Sc_MouldScrapOutHouseBillList where 1=1 " + sqlWhere + " group by 物料代码,规格型号,hwhid1,批次,子备注"), "h_v_Sc_MouldScrapOutHouseBillList"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; } catch (Exception e) { @@ -4017,7 +4020,7 @@ /// <returns></returns> [Route("Sc_MouldScrapOutHouseBill/DeltetMouldScrapOutHouseBill")] [HttpGet] public object DeltetMouldScrapOutHouseBill(string HInterID,string user) public object DeltetMouldScrapOutHouseBill(string HInterID, string user) { //编辑权限 if (!DBUtility.ClsPub.Security_Log("Sc_MouldScrapOutBill_Delete", 1, true, user)) @@ -4321,7 +4324,7 @@ [Route("Sc_MouldProdBackBill/GetMouldProdBackBill")] [HttpGet] public object GetMouldProdBackBill(string sWhere,string user, string Organization) public object GetMouldProdBackBill(string sWhere, string user, string Organization) { try { @@ -4334,7 +4337,7 @@ return objJsonResult; } ds = Sc_GetMouldProdBackBill(sWhere,Organization); ds = Sc_GetMouldProdBackBill(sWhere, Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -4351,7 +4354,7 @@ } } public static DataSet Sc_GetMouldProdBackBill(string sWhere,string Organization) public static DataSet Sc_GetMouldProdBackBill(string sWhere, string Organization) { string sql1 = string.Format(@"select * from h_v_Sc_MouldProdBackBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) @@ -4360,7 +4363,7 @@ } else { string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdBackBillList"); } @@ -4391,6 +4394,8 @@ public object Sc_MouldProdBackBillListProjectDetai(string sqlWhere) { DataSet ds; DataSet ds1; List<object> list = new List<object>(); try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -4401,10 +4406,6 @@ 单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位 FROM h_v_Sc_MouldProdBackBillList"), "h_v_Sc_MouldProdBackBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } else { @@ -4417,11 +4418,18 @@ string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdBackBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } //查汇总 ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量, HWHSonID,max(发料仓库代码)发料仓库代码,max(发料仓库)发料仓库,表体备注 from h_v_Sc_MouldProdBackBillList where 1=1 " + sqlWhere + " group by 物料代码,规格型号,HWHSonID,批次,表体备注"), "h_v_Sc_MouldProdBackBillList"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; } catch (Exception e) { @@ -4585,7 +4593,7 @@ /// <returns></returns> [Route("Sc_MouldProdBackBill/DeltetMouldProdBackBill")] [HttpGet] public object DeltetMouldProdBackBill(string HInterID,string user) public object DeltetMouldProdBackBill(string HInterID, string user) { //编辑权限 if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, true, user)) @@ -4749,7 +4757,7 @@ [Route("Sc_MouldProdOutBill/GetMouldProdOutBill")] [HttpGet] public object GetMouldProdOutBill(string sWhere, string user,string Organization) public object GetMouldProdOutBill(string sWhere, string user, string Organization) { try { @@ -4762,7 +4770,7 @@ return objJsonResult; } ds = Sc_GetMouldProdOutBill(sWhere,Organization); ds = Sc_GetMouldProdOutBill(sWhere, Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -4784,11 +4792,11 @@ string sql1 = string.Format(@"select * from h_v_Sc_MouldProdOutHouseBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by 日期 desc", "h_v_Sc_MouldProdOutHouseBillList"); return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 日期 desc", "h_v_Sc_MouldProdOutHouseBillList"); } else { string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList"); } @@ -4819,6 +4827,8 @@ public object Sc_MouldProdOutBillListProjectDetai(string sqlWhere) { DataSet ds; DataSet ds1; List<object> list = new List<object>(); try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -4829,10 +4839,6 @@ 单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位 FROM h_v_Sc_MouldProdOutHouseBillList"), "h_v_Sc_MouldProdOutHouseBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } else { @@ -4844,12 +4850,18 @@ 仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位 FROM h_v_Sc_MouldProdOutHouseBillList where 1 = 1 "); string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } //查汇总 ds1 = oCN.RunProcReturn(string.Format(@"select 物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量, HWHSonID,max(发料仓库代码)发料仓库代码,max(发料仓库)发料仓库,表体备注 from h_v_Sc_MouldProdOutHouseBillList where 1=1 " + sqlWhere + " group by 物料代码,规格型号,HWHSonID,批次,表体备注"), "h_v_Sc_MouldProdOutHouseBillList"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; } catch (Exception e) { @@ -4877,7 +4889,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 msg4 = sArray[2].ToString(); string UserName = ""; @@ -5208,7 +5220,7 @@ else { string sql1 = "select * from h_v_Sc_MouldLifeChangeBillList where 1 = 1 "; string sql = sql1 + sWhere+ "order by 日期 desc"; string sql = sql1 + sWhere + "order by 日期 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList"); }
