| | |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string refSav = sArray[1].ToString();//æä½æ¹å¼æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ 2 å¤å¶ |
| | | string user = sArray[2].ToString();//ç¨æ·å |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); //å表 |
| | | string refSav = sArray[2].ToString();//æä½æ¹å¼æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ 2 å¤å¶ |
| | | string user = sArray[3].ToString();//ç¨æ·å |
| | | |
| | | |
| | | string UserName = ""; |
| | | string s = ""; |
| | |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | |
| | | |
| | | // è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg3 = msg3.Substring(1, msg3.Length - 2); |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | string jsonString1 = "[" + msg3.ToString() + "]"; |
| | | List<ClsQC_MonthTarGetBillSub> ls = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_MonthTarGetBillSub>>(jsonString1); |
| | | int i = 0; |
| | | foreach (Model.ClsQC_MonthTarGetBillSub oItemSub in ls) |
| | | { |
| | | i++; |
| | | oItemSub.HEntryID = i; |
| | | |
| | | |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oItemSub.HCloseType = false; //å
³éç±»å |
| | | |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | } |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | |
| | | } |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Delete From QC_MonthTarGetBillMain where HInterID = " + HInterID); |
| | | oCN.RunProc("Delete From QC_MonthTarGetBillSub where HInterID = " + HInterID); |
| | | oCN.Commit(); |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_MonthTarGetBillList where hmainid =" + HInterID, "h_v_QC_MonthTarGetBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_QC_MonthTarGetBill_Edit where hmainid =" + HInterID, "h_v_QC_MonthTarGetBill_Edit"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |