派生自 MES-WEB-API
WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
@@ -3190,7 +3190,7 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string msg5 = sArray[3].ToString(); //string msg5 = sArray[3].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); @@ -3278,30 +3278,30 @@ } //配件项表体数据 //按 },{来拆分数组 //去掉【和】 msg5 = msg5.Substring(1, msg5.Length - 2); msg5 = msg5.Replace("\\", ""); msg5 = msg5.Replace("\n", ""); //\n //msg2 = msg2.Replace("'", "’"); List<Model.ClsSc_MouldDotCheckBillSub_Item> ls1 = new List<Model.ClsSc_MouldDotCheckBillSub_Item>(); ls1 = oListModels.getObjectByJson_Sc_MouldDotCheckBillSub_Item(msg5); int j = 0; foreach (Model.ClsSc_MouldDotCheckBillSub_Item oItemSub in ls1) { ////配件项表体数据 ////按 },{来拆分数组 //去掉【和】 //msg5 = msg5.Substring(1, msg5.Length - 2); //msg5 = msg5.Replace("\\", ""); //msg5 = msg5.Replace("\n", ""); //\n // //msg2 = msg2.Replace("'", "’"); //List<Model.ClsSc_MouldDotCheckBillSub_Item> ls1 = new List<Model.ClsSc_MouldDotCheckBillSub_Item>(); //ls1 = oListModels.getObjectByJson_Sc_MouldDotCheckBillSub_Item(msg5); //int j = 0; //foreach (Model.ClsSc_MouldDotCheckBillSub_Item oItemSub in ls1) //{ j++; oItemSub.HEntryID = j; //oItemSub.HCloseMan = ""; //行关闭 oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HCloseType = false; //关闭类型 // j++; // oItemSub.HEntryID = j; // //oItemSub.HCloseMan = ""; //行关闭 // oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); // oItemSub.HCloseType = false; //关闭类型 oItemSub.HSourceInterID = 0; // 源单主内码 oItemSub.HSourceEntryID = 0; //源单子内码 // oItemSub.HSourceInterID = 0; // 源单主内码 // oItemSub.HSourceEntryID = 0; //源单子内码 oItemSub.HRelationQty = 0; //关联数量 oBill.DetailCol.Add(oItemSub); } // oItemSub.HRelationQty = 0; //关联数量 // oBill.DetailCol.Add(oItemSub); //} //保存 //保存完毕后处理 @@ -3525,7 +3525,7 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string msg5 = sArray[3].ToString(); //string msg5 = sArray[3].ToString(); string UserName = ""; @@ -3613,30 +3613,30 @@ } //配件项表体数据 //按 },{来拆分数组 //去掉【和】 msg5 = msg5.Substring(1, msg5.Length - 2); msg5 = msg5.Replace("\\", ""); msg5 = msg5.Replace("\n", ""); //\n //msg2 = msg2.Replace("'", "’"); List<Model.ClsSc_MouldDotCheckPlanBillSub_Item> ls1 = new List<Model.ClsSc_MouldDotCheckPlanBillSub_Item>(); ls1 = oListModels.getObjectByJson_Sc_MouldDotCheckPlanBillSub_Item(msg5); int j = 0; foreach (Model.ClsSc_MouldDotCheckPlanBillSub_Item oItemSub in ls1) { ////配件项表体数据 ////按 },{来拆分数组 //去掉【和】 //msg5 = msg5.Substring(1, msg5.Length - 2); //msg5 = msg5.Replace("\\", ""); //msg5 = msg5.Replace("\n", ""); //\n // //msg2 = msg2.Replace("'", "’"); //List<Model.ClsSc_MouldDotCheckPlanBillSub_Item> ls1 = new List<Model.ClsSc_MouldDotCheckPlanBillSub_Item>(); //ls1 = oListModels.getObjectByJson_Sc_MouldDotCheckPlanBillSub_Item(msg5); //int j = 0; //foreach (Model.ClsSc_MouldDotCheckPlanBillSub_Item oItemSub in ls1) //{ j++; oItemSub.HEntryID = j; //oItemSub.HCloseMan = ""; //行关闭 oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HCloseType = false; //关闭类型 // j++; // oItemSub.HEntryID = j; // //oItemSub.HCloseMan = ""; //行关闭 // oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); // oItemSub.HCloseType = false; //关闭类型 oItemSub.HSourceInterID = 0; // 源单主内码 oItemSub.HSourceEntryID = 0; //源单子内码 // oItemSub.HSourceInterID = 0; // 源单主内码 // oItemSub.HSourceEntryID = 0; //源单子内码 oItemSub.HRelationQty = 0; //关联数量 oBill.DetailCol.Add(oItemSub); } // oItemSub.HRelationQty = 0; //关联数量 // oBill.DetailCol.Add(oItemSub); //} //保存 //保存完毕后处理 @@ -3706,15 +3706,17 @@ { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //获取点检项目编辑数据 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 where 1=1 " + sqlWhere, "Sc_MouldDotCheckPlanBillSub"); //获取配件项目编辑数据 ds1 = oCN.RunProcReturn(@"select b.HMaterID, mt.Hnumber HMaterNumber ,mt.HName HMaterName, b.HUnitID ,u2.hnumber HUnitNumber,u2.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldDotCheckPlanBillSub_Item b left join Gy_Material mt on b.HMaterID=mt.HItemID left join h_v_IF_Unit u2 on b.HUnitID=u2.HItemID where 1=1 " + sqlWhere, "Sc_MouldDotCheckPlanBillSub_Item"); ds = oCN.RunProcReturn(@"select a.HDotCheckItemID,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 " + sqlWhere, "Sc_MouldDotCheckPlanBillSub"); ////获取配件项目编辑数据 //ds1 = oCN.RunProcReturn(@"select b.HMaterID, mt.Hnumber HMaterNumber ,mt.HName HMaterName, b.HUnitID // ,u2.hnumber HUnitNumber,u2.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark // from Sc_MouldDotCheckPlanBillSub_Item b // left join Gy_Material mt on b.HMaterID=mt.HItemID // left join h_v_IF_Unit u2 on b.HUnitID=u2.HItemID where 1=1 " + sqlWhere, "Sc_MouldDotCheckPlanBillSub_Item"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); //list.Add(ds1.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; @@ -3853,7 +3855,7 @@ ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性名称 HPropertyName, HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位名称 HSecUnitName, HUnitID, 计量单位代码 HUnitCode, 计量单位名称 HUnitName, 批次 HBatchNo, 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实收数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 收料仓库代码 HWHCode, 收料仓库名称 HWHName, HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark,HStockOrgID HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 子备注 HRemark,HStockOrgID FROM h_v_Sc_MouldScrapInHouseBillList"), "h_v_Sc_MouldScrapInHouseBillList"); } @@ -3864,7 +3866,7 @@ string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,HPropertyID,辅助属性代码 HPropertyCode,辅助属性名称 HPropertyName, HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位名称 HSecUnitName, HUnitID, 计量单位代码 HUnitCode, 计量单位名称 HUnitName, 批次 HBatchNo, 设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife, 实收数量 HQty, 单价 HPrice, 金额 HMoney, HWHID, 收料仓库代码 HWHCode, 收料仓库名称 HWHName, HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 备注 HRemark,HStockOrgID HSPID, 仓位代码 HSPCode, 仓位名称 HSPName, 子备注 HRemark,HStockOrgID FROM h_v_Sc_MouldScrapInHouseBillList where 1 = 1 "); string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapInHouseBillList");
