| | |
| | | string FID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | |
| | | string updateSql = string.Format(@" |
| | | update a set |
| | | a.HERPInterID = {0} , |
| | | a.HERPBillNO ='{1}' |
| | | from Cg_POInStockBillMain a |
| | | join Cg_POInStockBillSub b on a.hinterid = b.hinterid |
| | | where b.HInterID = ({2}) |
| | | and b. HSOURCEINTERID = {3} |
| | | and a.HERPInterID = 0 |
| | | ", FID, FBillNo, dr["HINTERID"].ToString(), dr["FID"].ToString()); |
| | | update a set |
| | | a.HERPInterID = {0} , |
| | | a.HERPBillNO ='{1}' |
| | | from Cg_POInStockBillMain a |
| | | join Cg_POInStockBillSub b on a.hinterid = b.hinterid |
| | | where b.HInterID = ({2}) |
| | | and b. HSOURCEINTERID = {3} |
| | | and a.HERPInterID = 0 |
| | | ", FID, FBillNo, dr["HINTERID"].ToString(), dr["FID"].ToString()); |
| | | oCn.RunProc(updateSql); |
| | | } |
| | | else |