| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList where hmainid=" + HInterID, "h_v_IF_POInStockBillList"); |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillEdit where hmainid=" + HInterID, "h_v_IF_POInStockBillList"); |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | |
|---|
| | | } |
|---|
| | | string sql = "select * from h_v_Cg_POInStockBillQuerySub where hmainid = " + hmainid; |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Cg_POInStockBillQuerySub"); |
|---|
| | | ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Cg_POInStockBillQuerySub"); |
|---|
| | | |
|---|
| | | |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
