| | |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | |
| | | List<Models.ClsGy_EquipFileMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileMain>>(msg2); |
| | | |
| | | string hbillno= list[0].HBillNo; |
| | | string HYear = DateTime.Now.Year.ToString(); |
| | | DateTime HDate = list[0].HDate; |
| | | long HInterID = list[0].HInterID; |
| | | string HEquipFileNumber = list[0].HEquipFileNumber; |
| | |
| | | string HLogo = list[0].HLogo; //â varchar(50) //åç |
| | | int HSellSupID = list[0].HSellSupID; // â int //ä¾åºå(Gy_Supplier) |
| | | int HMakeSupID = list[0].HMakeSupID; // int //å¶é å (Gy_Supplier) |
| | | string HMaker = msg4; |
| | | string HMakeDate = DateTime.Now.Date.ToString(); |
| | | |
| | | if (!DBUtility.ClsPub.AllowNumber(HEquipFileNumber)) |
| | | { |
| | |
| | | oCN.RunProc("Insert into Gy_EquipFileBillMain " + |
| | | " (hbillno,HEquipFileNumber,HEquipFileNo,HName,HModel,HModel2,HMaterID,HUnitID,HOutComDate" + |
| | | ",HOutComNo,HDeptID,HUseEmpID,HRepairEmpID,HAddress,HSetupDate,HStartupDate,HStatus," + |
| | | "HEquipFileTypeID,HProNum,HBarCode,HWorkArea,HLogo,HSellSupID,HMakeSupID,hbilltype,HDate) " + |
| | | "HEquipFileTypeID,HProNum,HBarCode,HWorkArea,HLogo,HSellSupID,HMakeSupID,hbilltype,HDate,HYear) " + |
| | | " Values('" + hbillno + "','" + HEquipFileNumber + "','" + HEquipFileNo + "','" + HName + "','" + HModel + "','" + HModel2 + "'," + HMaterID + "," + HUnitID + |
| | | ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HUseEmpID + "," + HRepairEmpID + ",'" + HAddress + |
| | | "','" + HSetupDate + "','" + HStartupDate + "','" + HStatus + "'," + HEquipFileTypeID + ",'" + HProNum + |
| | | "','" + HBarCode + "','" + HWorkArea + "','" + HLogo + "'," + HSellSupID + "," + HMakeSupID +",'3308','" + HDate + |
| | | "','" + HBarCode + "','" + HWorkArea + "','" + HLogo + "'," + HSellSupID + "," + HMakeSupID +",'3308','" + HDate +"','"+ HYear+ |
| | | "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.Commit(); |
| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | |
| | | string HWorkArea = list[0].HWorkArea; //â varchar(50) //äº§å° |
| | | string HLogo = list[0].HLogo; //â varchar(50) //åç |
| | | int HSellSupID = list[0].HSellSupID; // â int //ä¾åºå(Gy_Supplier) |
| | | int HMakeSupID = list[0].HMakeSupID; // int //å¶é å (Gy_Supplier) |
| | | int HMakeSupID = list[0].HMakeSupID; // int //å¶é å (Gy_Supplier) |
| | | string HUpDater = msg4; |
| | | string HUpDateDate = DateTime.Now.Date.ToString(); |
| | | |
| | | if (!DBUtility.ClsPub.AllowNumber(HEquipFileNumber)) |
| | | { |
| | |
| | | ",HLogo=" + HLogo + |
| | | ",HSellSupID=" + HSellSupID + |
| | | ",HMakeSupID= " + HMakeSupID + |
| | | ",HUpDater= " + HUpDater + |
| | | ",HUpDateDate= " + HUpDateDate + |
| | | " Where HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |