protected void Page_Load(object sender, EventArgs e) { try { Aim.Portal.Web.WebPortalService.CheckLogon(); } catch { Response.Write("<script> window.location.href = '/Login.aspx';</script>"); Response.End(); } string action = Request["action"]; string where = ""; DataTable dt = null; string id = Request["id"]; InWarehouse iwEnt = null; IList<InWarehouseDetail> iwdEnts = null; switch (action) { case "load": if (!string.IsNullOrEmpty(Request["InWarehouseNo"])) { where += " and InWarehouseNo like '%" + Request["InWarehouseNo"].Trim() + "%'"; } if (!string.IsNullOrEmpty(Request["SupplierName"])) { where += " and SupplierName like '%" + Request["SupplierName"].Trim() + "%'"; } if (!string.IsNullOrEmpty(Request["State"])) { where += " and State = '" + Request["State"] + "'"; } if (!string.IsNullOrEmpty(Request["ProductCode"])) { where += " and Id in (select distinct InWarehouseId from SHHG_AimExamine..InWarehouseDetail where ProductCode like '%" + Request["ProductCode"] + "%')"; } sql = "select * from SHHG_AimExamine..InWarehouse where InWarehouseType ='采购入库' " + where; dt = DataHelper.QueryDataTable(GetPageSql(sql)); Response.Write("{total:" + totalProperty + ",rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}"); Response.End(); break; case "delete": if (!string.IsNullOrEmpty(id)) { iwEnt = InWarehouse.Find(id); iwdEnts = InWarehouseDetail.FindAllByProperty("InWarehouseId", id); foreach (InWarehouseDetail tempEnt in iwdEnts) { sql = "select sum(isnull(IQuantity,0)) from SHHG_AimExamine..InWarehouseDetail where PurchaseOrderDetailId='" + tempEnt.PurchaseOrderDetailId + "'"; tempEnt.DoDelete(); //删除完入库单明细后更新采购单明细的生成入库单数量 PurchaseOrderDetail podEnt = PurchaseOrderDetail.Find(tempEnt.PurchaseOrderDetailId); podEnt.RuKuDanQuan = DataHelper.QueryValue<Int32>(sql); podEnt.DoUpdate(); } iwEnt.DoDelete(); } break; } }
protected void Page_Load(object sender, EventArgs e) { switch (RequestActionString) { case "Judge": string id = RequestData.Get <string>("id"); if (!string.IsNullOrEmpty(id)) { InWarehouse iwEnt = InWarehouse.Find(id); WarehouseExchange weEnt = WarehouseExchange.Find(iwEnt.PublicInterface); if (weEnt.OutWarehouseState == "已出库") { PageState.Add("Allow", true); } else { PageState.Add("Allow", false); } } break; default: DoSelect(); break; } }
private void DoSelect() { if (!string.IsNullOrEmpty(id)) { InWarehouse ent = InWarehouse.Find(id); string tempsql = @"select A.* ,B.Name from SHHG_AimExamine..InWarehouse as A left join SHHG_AimExamine..Warehouse as B on A.WarehouseId=B.Id where A.Id='" + id + "'"; IList <EasyDictionary> dicsInWarehouse = DataHelper.QueryDictList(tempsql); if (dicsInWarehouse.Count > 0) { this.SetFormData(dicsInWarehouse[0]); } string sql = string.Empty; if (ent.InWarehouseType == "采购入库") { sql = @"select A.Id,A.ProductId, A.IQuantity as Quantity,A.InWarehouseId,A.InWarehouseState, A.Remark,A.SkinArray,A.SeriesArray,A.PurchaseOrderDetailId, UPPER(rtrim(ltrim(B.Isbn))) as ISBN,B.Name,UPPER(B.Code) as Code,B.ProductType, SHHG_AimExamine.dbo.fun_ActuallyHaveInQuantity(A.Id,'{0}') as HaveIn, (A.IQuantity-SHHG_AimExamine.dbo.fun_ActuallyHaveInQuantity(A.Id,'{1}')) as NoIn from SHHG_AimExamine..InWarehouseDetail as A left join SHHG_AimExamine..Products as B on A.ProductId=B.Id where A.InWarehouseId='{2}'"; sql = string.Format(sql, ent.InWarehouseType, ent.InWarehouseType, ent.Id); } else { sql = @"select A.Id,A.ProductId,A.Quantity,A.InWarehouseId,A.InWarehouseState,A.Remark,A.SkinArray,A.SeriesArray, UPPER(B.Code) as Code , B.Name,UPPER(rtrim(ltrim(B.Isbn))) as ISBN,B.ProductType, SHHG_AimExamine.dbo.fun_ActuallyHaveInQuantity(A.Id,'{0}') as HaveIn, (A.Quantity-SHHG_AimExamine.dbo.fun_ActuallyHaveInQuantity(A.Id,'{1}')) as NoIn from SHHG_AimExamine..OtherInWarehouseDetail as A left join SHHG_AimExamine..Products as B on A.ProductId=B.Id where A.InWarehouseId='{2}'"; sql = string.Format(sql, ent.InWarehouseType, ent.InWarehouseType, ent.Id); } IList <EasyDictionary> dics = DataHelper.QueryDictList(sql); PageState.Add("DetailList", dics); } }
protected void Page_Load(object sender, EventArgs e) { try { Aim.Portal.Web.WebPortalService.CheckLogon(); } catch { Response.Write("<script> window.location.href = '/Login.aspx';</script>"); Response.End(); } string action = Request["action"]; string sql = ""; DataTable dt = null; InWarehouse iwEnt = null; IList <InWarehouseDetail> iwdEnts = null; PurchaseOrderDetail podEnt = null; string PurchaseOrderIds = Request["PurchaseOrderIds"]; string id = Request["id"]; if (!string.IsNullOrEmpty(id)) { iwEnt = InWarehouse.Find(id); } switch (action) { case "loaddetail": if (!string.IsNullOrEmpty(PurchaseOrderIds)) { sql = @"select a.Id as PurchaseOrderDetailId, a.ProductId,a.Code as ProductCode, (a.Quantity-isnull(a.RuKuDanQuan,0)) as IQuantity, (a.Quantity-isnull(a.RuKuDanQuan,0)) as MaxQuan,b.PurchaseOrderNo from SHHG_AimExamine..PurchaseOrderDetail a left join SHHG_AimExamine..PurchaseOrder b on a.PurchaseOrderId=b.Id where '" + PurchaseOrderIds + "' like '%'+PurchaseOrderId+'%' and (a.Quantity-isnull(a.RuKuDanQuan,0))>0 order by a.Code asc"; } if (!string.IsNullOrEmpty(id)) { sql = @"select a.Id,a.PurchaseOrderDetailId, a.ProductId,a.ProductCode,a.IQuantity, a.YiRuQuan, c.PurchaseOrderNo,a.InWarehouseState, a.Remark,(b.Quantity-isnull(b.RuKuDanQuan,0)+a.IQuantity) as MaxQuan from SHHG_AimExamine..InWarehouseDetail a left join SHHG_AimExamine..PurchaseOrderDetail b on a.PurchaseOrderDetailId=b.Id left join SHHG_AimExamine..PurchaseOrder c on c.Id=b.PurchaseOrderId where a.InWarehouseId='" + id + "' order by a.ProductCode asc"; } dt = DataHelper.QueryDataTable(sql); Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}"); Response.End(); break; case "loadform": if (!string.IsNullOrEmpty(PurchaseOrderIds)) { iwEnt = new InWarehouse(); iwEnt.InWarehouseNo = DataHelper.QueryValue("select SHHG_AimExamine.dbo.fun_getInWarehouseNo()").ToString(); iwEnt.InWarehouseType = "采购入库"; string[] idarray = PurchaseOrderIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); PurchaseOrder poEnt = PurchaseOrder.Find(idarray[0]); iwEnt.SupplierId = poEnt.SupplierId; iwEnt.SupplierName = poEnt.SupplierName; Response.Write("{success:true,data:" + JsonHelper.GetJsonString(iwEnt) + "}"); } if (!string.IsNullOrEmpty(id)) { Response.Write("{success:true,data:" + JsonHelper.GetJsonString(iwEnt) + "}"); } Response.End(); break; case "create": string formdata = Request["formdata"]; string detaildata = Request["detaildata"]; iwEnt = JsonHelper.GetObject <InWarehouse>(Request["formdata"]); iwEnt.CreateId = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID; iwEnt.CreateName = Aim.Portal.Web.WebPortalService.CurrentUserInfo.Name; iwEnt.CreateTime = DateTime.Now; iwEnt.State = "未入库"; iwEnt.DoCreate(); iwdEnts = JsonHelper.GetObject <IList <InWarehouseDetail> >(Request["detaildata"]); foreach (InWarehouseDetail iwdEnt in iwdEnts) { iwdEnt.InWarehouseId = iwEnt.Id; iwdEnt.InWarehouseState = "未入库"; iwdEnt.DoCreate(); //创建完入库单明细后更新采购单明细的生成入库单数量 sql = "select sum(isnull(IQuantity,0)) from SHHG_AimExamine..InWarehouseDetail where PurchaseOrderDetailId='" + iwdEnt.PurchaseOrderDetailId + "'"; podEnt = PurchaseOrderDetail.Find(iwdEnt.PurchaseOrderDetailId); podEnt.RuKuDanQuan = DataHelper.QueryValue <Int32>(sql); podEnt.DoUpdate(); } Response.Write("{success:true}"); Response.End(); break; case "update": InWarehouse tempEnt = JsonHelper.GetObject <InWarehouse>(Request["formdata"]); EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(Request["formdata"]); iwEnt = DataHelper.MergeData <InWarehouse>(iwEnt, tempEnt, dic.Keys); iwEnt.DoUpdate(); sql = "delete SHHG_AimExamine..InWarehouseDetail where InWarehouseId='" + iwEnt.Id + "'"; DataHelper.ExecSql(sql); iwdEnts = JsonHelper.GetObject <IList <InWarehouseDetail> >(Request["detaildata"]); foreach (InWarehouseDetail iwdEnt in iwdEnts) { iwdEnt.InWarehouseId = iwEnt.Id; iwdEnt.InWarehouseState = "未入库"; iwdEnt.DoCreate(); //创建完入库单明细后更新采购单明细的生成入库单数量 sql = "select sum(isnull(IQuantity,0)) from SHHG_AimExamine..InWarehouseDetail where PurchaseOrderDetailId='" + iwdEnt.PurchaseOrderDetailId + "'"; podEnt = PurchaseOrderDetail.Find(iwdEnt.PurchaseOrderDetailId); podEnt.RuKuDanQuan = DataHelper.QueryValue <Int32>(sql); podEnt.DoUpdate(); } break; } }
private void CreateLog() { IList <InWarehouseDetailDetail> iwddEnts = InWarehouseDetailDetail.FindAll();//入库 foreach (InWarehouseDetailDetail iwddEnt in iwddEnts) { StockLog slEnt = new StockLog(); InWarehouse iwEnt = null; if (!string.IsNullOrEmpty(iwddEnt.InWarehouseDetailId)) { slEnt.InOrOutDetailId = iwddEnt.InWarehouseDetailId; InWarehouseDetail iwdEnt = InWarehouseDetail.Find(iwddEnt.InWarehouseDetailId); iwEnt = InWarehouse.Find(iwdEnt.InWarehouseId); } else { slEnt.InOrOutDetailId = iwddEnt.OtherInWarehouseDetailId; OtherInWarehouseDetail oiwdEnt = OtherInWarehouseDetail.Find(iwddEnt.OtherInWarehouseDetailId); iwEnt = InWarehouse.Find(oiwdEnt.InWarehouseId); } slEnt.InOrOutBillNo = iwEnt.InWarehouseNo; slEnt.OperateType = "产品入库"; slEnt.WarehouseId = iwEnt.WarehouseId; slEnt.WarehouseName = iwEnt.WarehouseName; //IList<StockInfo> siEnts = StockInfo.FindAllByProperties(StockInfo.Prop_ProductId, iwddEnt.ProductId, StockInfo.Prop_WarehouseId, iwEnt.WarehouseId); //if (siEnts.Count > 0) //{ // slEnt.StockQuantity = siEnts[0].StockQuantity; //} slEnt.Quantity = iwddEnt.Quantity; slEnt.ProductId = iwddEnt.ProductId; Product pEnt = Product.TryFind(iwddEnt.ProductId); if (pEnt != null) { slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.CreateId = iwddEnt.CreateId; slEnt.CreateName = iwddEnt.CreateName; slEnt.CreateTime = iwddEnt.CreateTime; slEnt.DoCreate(); } } //生成出库日志 IList <DelieryOrderPart> dopEnts = DelieryOrderPart.FindAllByProperty(DelieryOrderPart.Prop_State, "已出库"); foreach (DelieryOrderPart dopEnt in dopEnts) { StockLog slEnt = new StockLog(); slEnt.InOrOutDetailId = dopEnt.Id; DeliveryOrder doEnt = DeliveryOrder.Find(dopEnt.DId); slEnt.InOrOutBillNo = doEnt.Number; slEnt.OperateType = "产品出库"; slEnt.WarehouseId = doEnt.WarehouseId; slEnt.WarehouseName = doEnt.WarehouseName; //IList<StockInfo> siEnts = StockInfo.FindAllByProperties(StockInfo.Prop_ProductId, iwddEnt.ProductId, StockInfo.Prop_WarehouseId, iwEnt.WarehouseId); //if (siEnts.Count > 0) //{ // slEnt.StockQuantity = siEnts[0].StockQuantity; //} slEnt.Quantity = dopEnt.OutCount; if (!string.IsNullOrEmpty(dopEnt.ProductId)) { slEnt.ProductId = dopEnt.ProductId; Product pEnt = Product.TryFind(dopEnt.ProductId); if (pEnt != null) { slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.CreateId = dopEnt.CreateId; slEnt.CreateName = dopEnt.CreateName; slEnt.CreateTime = dopEnt.CreateTime; slEnt.DoCreate(); } } } //盘点操作库存日志 string sql = "select * from SHHG_AimExamine..StockCheckDetail where StockCheckResult!='正常' and StockCheckState='盘点结束'"; IList <EasyDictionary> scdDics = DataHelper.QueryDictList(sql); foreach (EasyDictionary scdDic in scdDics) { StockLog slEnt = new StockLog(); slEnt.InOrOutDetailId = scdDic.Get <string>("Id"); StockCheck scEnt = StockCheck.Find(scdDic.Get <string>("StockCheckId")); slEnt.InOrOutBillNo = scEnt.StockCheckNo; slEnt.OperateType = "库存盘点"; slEnt.WarehouseId = scEnt.WarehouseId; slEnt.WarehouseName = scEnt.WarehouseName; slEnt.StockQuantity = scdDic.Get <Int32>("StockQuantity"); slEnt.Quantity = scdDic.Get <Int32>("StockCheckQuantity") - scdDic.Get <Int32>("StockQuantity"); slEnt.ProductId = scdDic.Get <string>("ProductId"); Product pEnt = Product.TryFind(slEnt.ProductId); if (pEnt != null) { slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.CreateId = scEnt.CreateId; slEnt.CreateName = scEnt.CreateName; slEnt.CreateTime = scEnt.CreateTime; slEnt.DoCreate(); } } }
protected void Page_Load(object sender, EventArgs e) { try { Aim.Portal.Web.WebPortalService.CheckLogon(); } catch { Response.Write("<script> window.location.href = '/Login.aspx';</script>"); Response.End(); } string action = Request["action"]; string sql = ""; DataTable dt = null; PayBill pbEnt = null; IList <PayBillDetail> pbdEnts = null; InWarehouseDetail iwdEnt = null; string id = Request["id"]; string inwarehouseids = Request["inwarehouseids"]; if (!string.IsNullOrEmpty(id)) { pbEnt = PayBill.Find(id); } switch (action) { case "loaddetail": if (!string.IsNullOrEmpty(id)) { sql = @"select a.Id,a.PurchaseOrderDetailId, a.ProductId,a.ProductCode,a.PayQuantity,a.BuyPrice,a.Amount,a.ProductName, c.PurchaseOrderNo,(d.IQuantity-isnull(d.FuKuanDanQuan,0)+a.PayQuantity) as MaxQuan,a.InWarehouseDetailId from SHHG_AimExamine..PayBillDetail a left join SHHG_AimExamine..InWarehouseDetail d on d.Id=a.InWarehouseDetailId left join SHHG_AimExamine..PurchaseOrderDetail b on a.PurchaseOrderDetailId=b.Id left join SHHG_AimExamine..PurchaseOrder c on c.Id=b.PurchaseOrderId where a.PayBillId='" + id + "' order by a.ProductCode asc"; } if (!string.IsNullOrEmpty(inwarehouseids)) { sql = @"select a.Id InWarehouseDetailId, a.ProductId,a.PurchaseOrderDetailId, a.ProductCode,b.Name as ProductName, b.BuyPrice,c.PurchaseOrderNo, (a.IQuantity-isnull(a.FuKuanDanQuan,0)) as PayQuantity, (a.IQuantity-isnull(a.FuKuanDanQuan,0)) as MaxQuan,(a.IQuantity-isnull(a.FuKuanDanQuan,0))*(b.BuyPrice) as Amount from SHHG_AimExamine..InWarehouseDetail a left join SHHG_AimExamine..PurchaseOrderDetail b on a.PurchaseOrderDetailId=b.Id left join SHHG_AimExamine..PurchaseOrder c on c.Id=b.PurchaseOrderId where (a.IQuantity-isnull(a.FuKuanDanQuan,0))>0 and ('" + inwarehouseids + "' like '%'+a.InWarehouseId+'%') order by a.ProductCode asc"; } dt = DataHelper.QueryDataTable(sql); Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}"); Response.End(); break; case "loadform": if (!string.IsNullOrEmpty(inwarehouseids)) { pbEnt = new PayBill(); pbEnt.PayBillNo = DataHelper.QueryValue("select SHHG_AimExamine.dbo.fun_getPayBillNo()").ToString(); string[] idarray = inwarehouseids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); InWarehouse iwEnt = InWarehouse.Find(idarray[0]); pbEnt.SupplierId = iwEnt.SupplierId; pbEnt.SupplierName = iwEnt.SupplierName; Supplier sEnt = Supplier.Find(iwEnt.SupplierId); pbEnt.Symbo = sEnt.Symbo; Response.Write("{success:true,data:" + JsonHelper.GetJsonString(pbEnt) + "}"); } if (!string.IsNullOrEmpty(id)) { Response.Write("{success:true,data:" + JsonHelper.GetJsonString(pbEnt) + "}"); } Response.End(); break; case "create": pbEnt = JsonHelper.GetObject <PayBill>(Request["formdata"]); pbEnt.CreateId = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID; pbEnt.CreateName = Aim.Portal.Web.WebPortalService.CurrentUserInfo.Name; pbEnt.CreateTime = DateTime.Now; pbEnt.State = "未付款"; pbEnt.DoCreate(); pbdEnts = JsonHelper.GetObject <IList <PayBillDetail> >(Request["detaildata"]); foreach (PayBillDetail pbdEnt in pbdEnts) { pbdEnt.PayBillId = pbEnt.Id; pbdEnt.DoCreate(); //创建完付款单明细后更新入库单明细的生成付款单数量 sql = "select sum(isnull(PayQuantity,0)) from SHHG_AimExamine..PayBillDetail where InWarehouseDetailId='" + pbdEnt.InWarehouseDetailId + "'"; iwdEnt = InWarehouseDetail.Find(pbdEnt.InWarehouseDetailId); iwdEnt.FuKuanDanQuan = DataHelper.QueryValue <Int32>(sql); iwdEnt.DoUpdate(); } Response.Write("{success:true}"); Response.End(); break; case "update": PayBill tempEnt = JsonHelper.GetObject <PayBill>(Request["formdata"]); EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(Request["formdata"]); pbEnt = DataHelper.MergeData <PayBill>(pbEnt, tempEnt, dic.Keys); pbEnt.DoUpdate(); sql = "delete SHHG_AimExamine..PayBillDetail where PayBillId='" + pbEnt.Id + "'"; DataHelper.ExecSql(sql); pbdEnts = JsonHelper.GetObject <IList <PayBillDetail> >(Request["detaildata"]); foreach (PayBillDetail pbdEnt in pbdEnts) { pbdEnt.PayBillId = pbEnt.Id; pbdEnt.DoCreate(); //创建完付款单明细后更新入库单明细的生成付款单数量 sql = "select sum(isnull(PayQuantity,0)) from SHHG_AimExamine..PayBillDetail where InWarehouseDetailId='" + pbdEnt.InWarehouseDetailId + "'"; iwdEnt = InWarehouseDetail.Find(pbdEnt.InWarehouseDetailId); iwdEnt.FuKuanDanQuan = DataHelper.QueryValue <Int32>(sql); iwdEnt.DoUpdate(); } Response.Write("{success:true}"); Response.End(); break; } }
protected void Page_Load(object sender, EventArgs e) { string action = Request["action"]; DataTable dt; string sql = ""; PurchaseInvoice Pient = null; // PurchaseInvoiceDetail Pident = null; InWarehouseDetail IwdEnt = null; IList <PurchaseInvoiceDetail> Pidents = null; string inwarehouseids = Request["inwarehouseids"]; string id = Request["id"]; switch (action) { case "loadform": if (!string.IsNullOrEmpty(inwarehouseids)) { Pient = new PurchaseInvoice(); string[] idarray = inwarehouseids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); InWarehouse iwEnt = InWarehouse.Find(idarray[0]); Pient.SupplierId = iwEnt.SupplierId; Pient.SupplierName = iwEnt.SupplierName; Supplier sEnt = Supplier.Find(iwEnt.SupplierId); Pient.Symbo = sEnt.Symbo; Response.Write("{success:true,data:" + JsonHelper.GetJsonString(Pient) + "}"); } if (!string.IsNullOrEmpty(id)) { Response.Write("{success:true,data:" + JsonHelper.GetJsonString(PurchaseInvoice.Find(id)) + "}"); } Response.End(); break; case "loaddetail": if (!string.IsNullOrEmpty(id)) { sql = @"select a.Id,a.PurchaseOrderDetailId, a.ProductId,a.ProductCode,a.InvoiceQuantity,a.InvoiceAmount,a.ProductName,a.BuyPrice,a.Remark, (d.IQuantity-isnull(d.KaiPiaoQuan,0)+a.InvoiceQuantity) as MaxQuan,a.InWarehouseDetailId from SHHG_AimExamine..PurchaseInvoiceDetail a left join SHHG_AimExamine..InWarehouseDetail d on d.Id=a.InWarehouseDetailId left join SHHG_AimExamine..PurchaseOrderDetail b on a.PurchaseOrderDetailId=b.Id left join SHHG_AimExamine..PurchaseOrder c on c.Id=b.PurchaseOrderId where a.PurchaseInvoiceId='" + id + "' order by a.ProductCode asc"; } if (!string.IsNullOrEmpty(inwarehouseids)) { sql = @"select a.Id InWarehouseDetailId, a.ProductId,a.PurchaseOrderDetailId, a.ProductCode,b.Name as ProductName, b.BuyPrice, c.PurchaseOrderNo, (a.IQuantity-isnull(a.KaiPiaoQuan,0)) as InvoiceQuantity, (a.IQuantity-isnull(a.KaiPiaoQuan,0)) as MaxQuan,(a.IQuantity-isnull(a.KaiPiaoQuan,0))*(b.BuyPrice) as InvoiceAmount from SHHG_AimExamine..InWarehouseDetail a left join SHHG_AimExamine..PurchaseOrderDetail b on a.PurchaseOrderDetailId=b.Id left join SHHG_AimExamine..PurchaseOrder c on c.Id=b.PurchaseOrderId where (a.IQuantity-isnull(a.KaiPiaoQuan,0))>0 and ('" + inwarehouseids + "' like '%'+a.InWarehouseId+'%') order by a.ProductCode asc"; } dt = DataHelper.QueryDataTable(sql); Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}"); Response.End(); break; case "create": Pient = JsonHelper.GetObject <PurchaseInvoice>(Request["formdata"]); //Pient.CreateId = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID; //Pient.CreateName = Aim.Portal.Web.WebPortalService.CurrentUserInfo.Name; //Pient.CreateTime = DateTime.Now; //Pient.InvoiceNo Pient.DoCreate(); Pidents = JsonHelper.GetObject <IList <PurchaseInvoiceDetail> >(Request["detaildata"]); foreach (PurchaseInvoiceDetail Pident in Pidents) { Pident.PurchaseInvoiceId = Pient.Id; Pident.DoCreate(); //创建完付款单明细后更新入库单明细的生成付款单数量 sql = "select sum(isnull(InvoiceQuantity,0)) from SHHG_AimExamine..PurchaseInvoiceDetail where InWarehouseDetailId='" + Pident.InWarehouseDetailId + "'"; IwdEnt = InWarehouseDetail.Find(Pident.InWarehouseDetailId); IwdEnt.KaiPiaoQuan = DataHelper.QueryValue <Int32>(sql); IwdEnt.DoUpdate(); } Response.Write("{success:true}"); Response.End(); break; case "update": Pient = JsonHelper.GetObject <PurchaseInvoice>(Request["formdata"]); PurchaseInvoice oEnt = PurchaseInvoice.Find(Pient.Id); EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(Request["formdata"]); Pient = DataHelper.MergeData <PurchaseInvoice>(oEnt, Pient, dic.Keys); Pient.DoUpdate(); sql = "delete SHHG_AimExamine..PurchaseInvoiceDetail where PurchaseInvoiceId='" + Pient.Id + "'"; DataHelper.ExecSql(sql); Pidents = JsonHelper.GetObject <IList <PurchaseInvoiceDetail> >(Request["detaildata"]); foreach (PurchaseInvoiceDetail Pident in Pidents) { Pident.PurchaseInvoiceId = Pient.Id; Pident.DoCreate(); //创建完付款单明细后更新入库单明细的生成付款单数量 sql = "select sum(isnull(InvoiceQuantity,0)) from SHHG_AimExamine..PurchaseInvoiceDetail where InWarehouseDetailId='" + Pident.InWarehouseDetailId + "'"; IwdEnt = InWarehouseDetail.Find(Pident.InWarehouseDetailId); IwdEnt.KaiPiaoQuan = DataHelper.QueryValue <Int32>(sql); IwdEnt.DoUpdate(); } Response.Write("{success:true}"); Response.End(); break; } }
private void DoSelect() { string sql = string.Empty; string where = ""; foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches) { where += " and " + item.PropertyName + " like '%" + item.Value + "%' "; } string inWarehouseId = RequestData.Get <string>("InWarehouseId");//入库单id有可能为空 比如 if (!string.IsNullOrEmpty(inWarehouseId)) { InWarehouse iwEnt = InWarehouse.Find(inWarehouseId); if (iwEnt.InWarehouseType == "采购入库") { sql = @"select A.ProductId,A.IQuantity as Quantity,B.Name,A.InWarehouseState,B.Code from SHHG_AimExamine..InWarehouseDetail as A left join SHHG_AimExamine..Products as B on A.ProductId=B.Id where InWarehouseId='" + inWarehouseId + "'" + where; } else { sql = @"select A.ProductId,A.Quantity,A.InWarehouseState,B.Name,B.Code from SHHG_AimExamine..OtherInWarehouseDetail as A left join SHHG_AimExamine..Products as B on A.ProductId=B.Id where InWarehouseId='" + inWarehouseId + "'" + where; } PageState.Add("InWarehouseDetail", GetPageData(sql, SearchCriterion)); PageState.Add("InWarehouseNo", iwEnt.InWarehouseNo); } // else // { // DataTable tbl = new DataTable(); // DataColumn col = new DataColumn("ProductId", typeof(string)); tbl.Columns.Add(col); // col = new DataColumn("Quantity", typeof(int)); tbl.Columns.Add(col); // col = new DataColumn("Name", typeof(string)); tbl.Columns.Add(col); // col = new DataColumn("Code", typeof(string)); tbl.Columns.Add(col); // col = new DataColumn("Isbn", typeof(string)); tbl.Columns.Add(col); // col = new DataColumn("InWarehouseNo", typeof(string)); tbl.Columns.Add(col); // col = new DataColumn("InWarehouseState", typeof(string)); tbl.Columns.Add(col); // sql = @"select A.ProductId,A.IQuantity as Quantity,A.InWarehouseState,B.Name,B.Code,B.Isbn,C.InWarehouseNo // from SHHG_AimExamine..InWarehouseDetail as A // left join SHHG_AimExamine..Products as B on A.ProductId=B.Id // left join SHHG_AimExamine..InWarehouse as C on A.InWarehouseId=C.Id where 1=1 " + where; // IList<EasyDictionary> dics1 = DataHelper.QueryDictList(sql); // foreach (EasyDictionary ea in dics1) // { // DataRow dr = tbl.NewRow(); // dr["ProductId"] = ea.Get<string>("ProductId"); // dr["Quantity"] = ea.Get<int>("Quantity"); // dr["Name"] = ea.Get<string>("Name"); // dr["Code"] = ea.Get<string>("Code"); // dr["Isbn"] = ea.Get<string>("Isbn"); // dr["InWarehouseNo"] = ea.Get<string>("InWarehouseNo"); // dr["InWarehouseState"] = ea.Get<string>("InWarehouseState"); // tbl.Rows.Add(dr); // } // sql = @"select A.ProductId,A.Quantity,A.InWarehouseState,B.Name,B.Code,B.Isbn,C.InWarehouseNo // from SHHG_AimExamine..OtherInWarehouseDetail as A // left join SHHG_AimExamine..Products as B on A.ProductId=B.Id // left join SHHG_AimExamine..InWarehouse as C on A.InWarehouseId=C.Id where 1=1 " + where; // IList<EasyDictionary> dics2 = DataHelper.QueryDictList(sql); // foreach (EasyDictionary ea in dics2) // { // DataRow dr = tbl.NewRow(); // dr["ProductId"] = ea.Get<string>("ProductId"); // dr["Quantity"] = ea.Get<int>("Quantity"); // dr["Name"] = ea.Get<string>("Name"); // dr["Code"] = ea.Get<string>("Code"); // dr["Isbn"] = ea.Get<string>("Isbn"); // dr["InWarehouseNo"] = ea.Get<string>("InWarehouseNo"); // dr["InWarehouseState"] = ea.Get<string>("InWarehouseState"); // tbl.Rows.Add(dr); // } // PageState.Add("InWarehouseDetail", tbl); // } }