| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | public static string BillType = "4610"; |
| | | Sc_WorkBillSortBillMain omdelMian = new Sc_WorkBillSortBillMain(); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | |
| | | #region ç产æ¥è®¡å æä»¶ä¸ä¼ |
| | | [Route("JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_DR")] |
| | |
| | | tb2.Columns.Add("ICMOBillHInterID", typeof(Int32));//ç产订å主id |
| | | tb2.Columns.Add("ICMOBillHEntryID", typeof(Int32));//ç产订ååid |
| | | tb2.Columns.Add("HProdORGID", typeof(Int32));//ç»ç»id |
| | | tb2.Columns.Add("HSeOrderBillNo", typeof(string));//éå®è®¢åå· |
| | | tb2.Columns.Add("HSeOrderBillNo", typeof(string));//éå®è®¢åå· |
| | | |
| | | //è·åç³»ç»åæ° |
| | | string Ret = ""; |
| | | oSystemParameter.ShowBill(ref Ret); |
| | | |
| | | LogService.Write("excelå¼ï¼" + ExcelDs.Tables[0].Rows[1][15].ToString());//2024-11-26 |
| | | //æ·»å æ°æ® |
| | | for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) |
| | | { |
| | | { |
| | | DataRow row = tb2.NewRow(); |
| | | for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) |
| | | { |
| | |
| | | if (ExcelDs.Tables[0].Rows[i][0].ToString() == "" && ExcelDs.Tables[0].Rows[i][1].ToString() == "") |
| | | { |
| | | continue; |
| | | } |
| | | } |
| | | //else if (oSystemParameter.omodel.JIT_DayPlan_TimeFrame != "0" && oSystemParameter.omodel.JIT_DayPlan_TimeFrame != "") |
| | | //{ |
| | | // Int32 HDays = Convert.ToInt32(oSystemParameter.omodel.JIT_DayPlan_TimeFrame) * 7; |
| | | |
| | | |
| | | |
| | | |
| | | // for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) |
| | | // { |
| | | // if (Convert.ToInt32(ExcelDs.Tables[0].Rows[i][j].ToString()) > 0 ) |
| | | // { |
| | | // continue; |
| | | // } |
| | | // } |
| | | //} |
| | | else |
| | | { |
| | | tb2.Rows.Add(row); |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sql1 = string.Format("select * from h_v_IF_ICMOBillList where åæ®å·='{0}' and ç产车é´ä»£ç ='{1}' and 产å代ç ='{2}' and æç»è¡å·={3} ", |
| | | string sql1 = string.Format("select * from h_v_JIT_ICMOBillList_DR where åæ®å·='{0}' and ç产车é´ä»£ç ='{1}' and 产å代ç ='{2}' and æç»è¡å·={3} ", |
| | | tb2.Rows[i]["ç产订åå·*"].ToString(), tb2.Rows[i]["ç产车é´ç¼ç *"].ToString(), tb2.Rows[i]["ç©æç¼ç *"].ToString(), tb2.Rows[i]["ç产订åæç»è¡å·*"].ToString()); |
| | | ds = oCN.RunProcReturn(sql1, "h_v_IF_ICMOBillList"); |
| | | ds = oCN.RunProcReturn(sql1, "h_v_JIT_ICMOBillList_DR"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | |
| | | tb2.Rows[i]["HSeOrderBillNo"] = ds.Tables[0].Rows[0]["éå®è®¢åå·"].ToString();//éå®è®¢åå· |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList " + |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_WorkBillSortBillList_DR " + |
| | | $"where ç产订åå·='{tb2.Rows[i]["ç产订åå·*"].ToString()}' and ç产订åæç»è¡å·='{tb2.Rows[i]["ç产订åæç»è¡å·*"].ToString()}' " + |
| | | $"and ç产车é´ç¼ç ='{tb2.Rows[i]["ç产车é´ç¼ç *"].ToString()}' and ç©æä»£ç ='{tb2.Rows[i]["ç©æç¼ç *"].ToString()}' " + |
| | | $"and çäº§èµæºç¼ç ='{tb2.Rows[i]["çäº§èµæºç¼ç *"].ToString()}' ", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | $"and çäº§èµæºç¼ç ='{tb2.Rows[i]["çäº§èµæºç¼ç *"].ToString()}' ", "h_v_JIT_WorkBillSortBillList_DR"); |
| | | //ç»ç»ç¼ç ='{tb2.Rows[i]["ç»ç»ç¼ç *"].ToString()}' and |
| | | //and çäº§èµæºç¼ç ='{tb2.Rows[i]["çäº§èµæºç¼ç *"].ToString()}' |
| | | |
| | |
| | | else |
| | | { |
| | | //åå·¥ |
| | | ds = oCN.RunProcReturn($"select * from Gy_Employee where HNumber='{tb2.Rows[i]["åå·¥ç¼ç "].ToString()}'", "Gy_Employee"); |
| | | ds = oCN.RunProcReturn($"select * from Gy_Employee with(nolock) where HNumber='{tb2.Rows[i]["åå·¥ç¼ç "].ToString()}'", "Gy_Employee"); |
| | | if (ds.Tables[0].Rows.Count > 0) { |
| | | tb2.Rows[i]["HEmpID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | tb2.Rows[i]["åå·¥"] = ds.Tables[0].Rows[0]["HName"].ToString(); |
| | |
| | | } |
| | | |
| | | //计éåä½ |
| | | ds = oCN.RunProcReturn($"select * from Gy_Unit where HNumber='{tb2.Rows[i]["计éåä½"].ToString()}'", "Gy_Unit"); |
| | | ds = oCN.RunProcReturn($"select * from Gy_Unit with(nolock) where HNumber='{tb2.Rows[i]["计éåä½"].ToString()}'", "Gy_Unit"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HUnitID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | |
| | | } |
| | | |
| | | //çäº§èµæº |
| | | ds = oCN.RunProcReturn($"select * from Gy_Source where HNumber='{tb2.Rows[i]["çäº§èµæºç¼ç *"].ToString()}'", "Gy_Source"); |
| | | ds = oCN.RunProcReturn($"select * from Gy_Source with(nolock) where HNumber='{tb2.Rows[i]["çäº§èµæºç¼ç *"].ToString()}'", "Gy_Source"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HSourceID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | |
| | | } |
| | | } |
| | | //ç»ç» |
| | | ds = oCN.RunProcReturn($"select * from Xt_ORGANIZATIONS where HNumber='{tb2.Rows[i]["ç»ç»ç¼ç *"].ToString()}'", "Xt_ORGANIZATIONS"); |
| | | ds = oCN.RunProcReturn($"select * from Xt_ORGANIZATIONS with(nolock) where HNumber='{tb2.Rows[i]["ç»ç»ç¼ç *"].ToString()}'", "Xt_ORGANIZATIONS"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HProdORGID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |