| | |
|---|
| | | ListModels oListModels = new ListModels(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill(); |
|---|
| | | List<Model.ClsCg_POInStockBillMain> lsmain = new List<Model.ClsCg_POInStockBillMain>(); |
|---|
| | | DAL.ClsCg_POInStockBills oBill = new DAL.ClsCg_POInStockBills(); |
|---|
| | | List<Model.ClsCg_POInStockBillMains> lsmain = new List<Model.ClsCg_POInStockBillMains>(); |
|---|
| | | msg2 = msg2.Replace("\\", ""); |
|---|
| | | msg2 = msg2.Replace("\n", ""); //\n |
|---|
| | | lsmain = oListModels.getObjectByJson_POInStockMain(msg2); |
|---|
| | | foreach (Model.ClsCg_POInStockBillMain oItem in lsmain) |
|---|
| | | lsmain = oListModels.getObjectByJson_POInStockMains(msg2); |
|---|
| | | foreach (Model.ClsCg_POInStockBillMains oItem in lsmain) |
|---|
| | | { |
|---|
| | | //oItem.HMaker = ""; |
|---|
| | | UserName = oItem.HMaker; |
|---|
| | |
|---|
| | | msg3 = msg3.Replace("\\", ""); |
|---|
| | | msg3 = msg3.Replace("\n", ""); //\n |
|---|
| | | //msg2 = msg2.Replace("'", "’"); |
|---|
| | | List<Model.ClsCg_POInStockBillSub> ls = new List<Model.ClsCg_POInStockBillSub>(); |
|---|
| | | ls = oListModels.getObjectByJson_POInStockSub(msg3); |
|---|
| | | List<Model.ClsCg_POInStockBillSubs> ls = new List<Model.ClsCg_POInStockBillSubs>(); |
|---|
| | | ls = oListModels.getObjectByJson_POInStockSubs(msg3); |
|---|
| | | int i = 0; |
|---|
| | | foreach (Model.ClsCg_POInStockBillSub oItemSub in ls) |
|---|
| | | foreach (Model.ClsCg_POInStockBillSubs oItemSub in ls) |
|---|
| | | { |
|---|
| | | i++; |
|---|
| | | if (oItemSub.HQty <= 0) |
|---|
| | |
|---|
| | | //其他过滤 |
|---|
| | | if (msg.Trim() == "") |
|---|
| | | { |
|---|
| | | msg = " Where hsupid in (select HItemID from h_v_IF_Supplier where hnumber=^^" + HSupNo.Trim() + "^^) " + sqlWhere; |
|---|
| | | msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 =^^" + HSupNo.Trim() + "^^) " + sqlWhere; |
|---|
| | | // msg = " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)"; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | msg = msg + " and hsupid in (select HItemID from h_v_IF_Supplier where hnumber=^^" + HSupNo.Trim() + "^^) " + sqlWhere; |
|---|
| | | msg = msg + " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 =^^" + HSupNo.Trim() + "^^) " + sqlWhere; |
|---|
| | | // msg = msg + " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)"; |
|---|
| | | } |
|---|
| | | //转换特殊字符 |
|---|
