| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æ¥æ¾æ¯å¦åå¨å¯¹åºç产订å |
| | | string sql1 = string.Format("select * from h_v_IF_ICMOBillList where 客æ·è®¢åå·='{0}' and 产å代ç ='{1}' and ç¶æ in ('计å确认','å¼å·¥')", |
| | | tb2.Rows[i]["客æ·è®¢åå·"].ToString(), tb2.Rows[i]["ç©æç¼ç "].ToString()); |
| | | string sql1 = ""; |
| | | //æç»è¡å·ä¸ºç©ºä¸èè |
| | | if (tb2.Rows[i]["æç»è¡å·"].ToString() == "") |
| | | { |
| | | //æ¥æ¾æ¯å¦åå¨å¯¹åºç产订å |
| | | sql1 = string.Format("select * from h_v_IF_ICMOBillList where 客æ·è®¢åå·='{0}' and 产å代ç ='{1}' and ç¶æ in ('计å确认','å¼å·¥')", |
| | | tb2.Rows[i]["客æ·è®¢åå·"].ToString(), tb2.Rows[i]["ç©æç¼ç "].ToString()); |
| | | } |
| | | else |
| | | { |
| | | //æ¥æ¾æ¯å¦åå¨å¯¹åºç产订å |
| | | sql1 = string.Format("select * from h_v_IF_ICMOBillList where 客æ·è®¢åå·='{0}' and 产å代ç ='{1}' and ç¶æ in ('计å确认','å¼å·¥') and æç»è¡å· = '{2}'", |
| | | tb2.Rows[i]["客æ·è®¢åå·"].ToString(), tb2.Rows[i]["ç©æç¼ç "].ToString(),tb2.Rows[i]["æç»è¡å·"].ToString()); |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn(sql1, "h_v_IF_ICMOBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | |
| | | } |
| | | } |
| | | |
| | | //æ¥æ¾æ¯å¦åå¨å¯¹åºç产订å |
| | | string sql1 = string.Format("select * from h_v_IF_ICMOBillList where 客æ·è®¢åå·='{0}' and 产å代ç ='{1}' and ç¶æ in ('计å确认','å¼å·¥')", |
| | | tb2.Rows[i]["客æ·è®¢åå·"].ToString(), tb2.Rows[i]["ç©æç¼ç "].ToString()); |
| | | string sql1 = ""; |
| | | //æç»è¡å·ä¸ºç©ºä¸èè |
| | | if (tb2.Rows[i]["æç»è¡å·"].ToString() == "") |
| | | { |
| | | //æ¥æ¾æ¯å¦åå¨å¯¹åºç产订å |
| | | sql1 = string.Format("select * from h_v_IF_ICMOBillList where 客æ·è®¢åå·='{0}' and 产å代ç ='{1}' and ç¶æ in ('计å确认','å¼å·¥')", |
| | | tb2.Rows[i]["客æ·è®¢åå·"].ToString(), tb2.Rows[i]["ç©æç¼ç "].ToString()); |
| | | } |
| | | else |
| | | { |
| | | //æ¥æ¾æ¯å¦åå¨å¯¹åºç产订å |
| | | sql1 = string.Format("select * from h_v_IF_ICMOBillList where 客æ·è®¢åå·='{0}' and 产å代ç ='{1}' and ç¶æ in ('计å确认','å¼å·¥') and æç»è¡å· = '{2}'", |
| | | tb2.Rows[i]["客æ·è®¢åå·"].ToString(), tb2.Rows[i]["ç©æç¼ç "].ToString(), tb2.Rows[i]["æç»è¡å·"].ToString()); |
| | | } |
| | | ds = oCN.RunProcReturn(sql1, "h_v_IF_ICMOBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | |
| | | var HSourceID = list[i]["HSourceID"].ToString(); |
| | | var HYX = list[i]["ä¼å
级"].ToString(); |
| | | var HPlanEndDate = list[i]["计åç»ææ¥æ"].ToString(); |
| | | //æ´æ°æ¶å é¤å表å
容 |
| | | oCN.RunProc($"delete from Sc_WorkBillSortBillSub where HInterID ={hmainid}"); |
| | | //æ´æ°å°æ¶äº§è½ |
| | | if (HWorkQty != ""&& HWorkQty != "0") |
| | | { |