| | |
|---|
| | | public object set_SaveLookingForBill_Json([FromBody]JObject oMain) |
|---|
| | | { |
|---|
| | | string oMainData = oMain["oMain"].ToString(); |
|---|
| | | string HJiaYe = oMain["HJiaYe"].ToString(); |
|---|
| | | oMainData = oMainData.Substring(8,oMainData.Length-9); |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | oCN.BeginTran(); |
|---|
| | | List<LookingForBill> lsmain = new List<LookingForBill>(); |
|---|
| | | ListModels oListModels = new ListModels(); |
|---|
| | | List<LookingForBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<LookingForBill>>(oMainData); |
|---|
| | | oCN.BeginTran(); |
|---|
| | | //var mainSql1 = "Insert Into Kf_LookingForReturnBillMain " + |
|---|
| | | // "(HInterID,HBillNo,HSourceInterID,HSourceBillNo,HCreateBy)" + |
|---|
| | | // " values" + |
|---|
| | | // "(" + list[0].HInterID + ",'" + list[0].HBillNo + "'," + list[0].HSourceInterID + ",'" + list[0].HSourceBillNo + "','" + list[0].HMaker + "')"; |
|---|
| | | var mainSql = "Insert Into Kf_LookingForBillMain " + |
|---|
| | | "(HInterID,HBillNo,HSourceInterID,HSourceBillNo,HWhID,HWhName,HSPID,HSPName,HGroupID,HGroup" + |
|---|
| | | ",HSourceID,HSource,HCreateBy)" + |
|---|
| | | ",HSourceID,HSource,HCreateBy,HJiaYe)" + |
|---|
| | | " values" + |
|---|
| | | "(" + list[0].HInterID + ",'" + list[0].HBillNo + "'," + list[0].HSourceInterID+ ",'" + list[0].HSourceBillNo + "'," + list[0].HWHID + ",'" + list[0].HWHName + "'," + list[0].HSPID + ",'" + list[0].HSPName + "'," + list[0].HGroupID + ",'" + list[0].HGroup + "'," |
|---|
| | | + list[0].HSourceID + ",'" + list[0].HSource + "','" + list[0].HMaker + "')"; |
|---|
| | | + list[0].HSourceID + ",'" + list[0].HSource + "','" + list[0].HMaker + "','" + HJiaYe + "')"; |
|---|
| | | oCN.RunProc(mainSql); |
|---|
| | | for (int i = 0; i < list.Count; i++) |
|---|
| | | { |
|---|
