protected void Button1_Click(object sender, EventArgs e) { int id = AddCai(); CAI_POOrderService mainSer = new CAI_POOrderService(); CAI_POOrder pp = mainSer.GetModel(id); CAI_POOrdersService ordersSer = new CAI_POOrdersService(); List <CAI_POOrders> orders = ordersSer.GetListArray(" 1=1 and CAI_POOrders.id=" + id); CAI_POCaiService CaiSer = new CAI_POCaiService(); List <CAI_POCai> caiList = CaiSer.GetListArray(" 1=1 and CAI_POCai.id=" + id); foreach (var cai in caiList) { var m = orders_CaiIn.Single(t => t.GooId == cai.GoodId); cai.Supplier = "本部门(含税)"; cai.SupperPrice = m.GoodPrice; cai.UpdateUser = "******"; cai.Idea = ""; cai.Num = m.GoodNum; cai.FinPrice1 = m.GoodPrice; cai.GoodId = m.GooId; cai.cbifDefault1 = true; cai.lastSupplier = "本部门(含税)"; cai.IsHanShui = true; cai.LastTruePrice = m.GoodPrice; cai.IfUpdate = true; } CAI_POOrderService POOrderSer = new CAI_POOrderService(); POOrderSer.UpdataCai(caiList); int checkId = AddCAI_OrderCheck(id); LastUpdate(checkId); base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('成功!');</script>"); }
protected void Button3_Click(object sender, EventArgs e) { if (CheckPoNO(txtKCPOno.Text) == false) { return; } CAI_POOrderService POSer = new CAI_POOrderService(); string sql = " 1=1 "; sql += string.Format(" and PONo= '{0}'", txtKCPOno.Text.Trim()); List <CAI_POOrder> pOOrderList = POSer.GetListArray(sql); foreach (var model in pOOrderList) { if (model.BusType == "0") { model.BusType = "项目订单采购"; } else if (model.BusType == "1") { model.BusType = "库存采购"; } } this.gvCaiMain.DataSource = pOOrderList; this.gvCaiMain.DataBind(); if (pOOrderList.Count > 0) { CAI_POOrdersService ordersSer = new CAI_POOrdersService(); List <CAI_POOrders> orders = ordersSer.GetListArray(" 1=1 and Cai_POOrders.id=" + pOOrderList[0].Id); gvCaiXiaoShou.DataSource = orders; gvCaiXiaoShou.DataBind(); } }
private int AddCai() { CAI_OrderInHousesService ordersSer = new CAI_OrderInHousesService(); orders_CaiIn = ordersSer.GetListArray(" 1=1 and CAI_OrderInHouses.id=1"); //采购单 CAI_POOrder order = new CAI_POOrder(); order.AppName = 1; order.CaiGou = "admin"; order.AE = ""; order.GuestName = ""; order.GuestNo = ""; order.INSIDE = ""; order.PODate = Convert.ToDateTime("2012-06-19"); order.POName = "库存初始化"; order.POPayStype = "1"; order.POTotal = Convert.ToDecimal(628650.72000); order.PONo = ""; order.BusType = "1"; order.CG_ProNo = ""; order.cRemark = ""; List <CAI_POOrders> POOrders = new List <CAI_POOrders>(); foreach (var m in orders_CaiIn) { CAI_POOrders cai = new CAI_POOrders(); cai.InvName = m.GoodName; cai.Num = m.GoodNum; cai.CostPrice = m.GoodPrice; cai.OtherCost = 0; cai.ToTime = Convert.ToDateTime("2012-06-26 00:00:00.000"); cai.Profit = 0; cai.GoodId = m.GooId; cai.CG_POOrdersId = 0; POOrders.Add(cai); } List <CAI_POCai> caiOrders = new List <CAI_POCai>(); foreach (var m in orders_CaiIn) { CAI_POCai cai = new CAI_POCai(); cai.Supplier = "本部门(含税)"; cai.SupperPrice = m.GoodPrice; cai.UpdateUser = "******"; cai.Idea = ""; cai.Num = m.GoodNum; cai.FinPrice1 = m.GoodPrice; cai.GoodId = m.GooId; cai.cbifDefault1 = true; cai.lastSupplier = "本部门(含税)"; cai.IsHanShui = true; cai.LastTruePrice = m.GoodPrice; caiOrders.Add(cai); } tb_EForm eform = new tb_EForm(); eform.appPer = 1; eform.appTime = DateTime.Now; eform.createPer = 1; eform.createTime = DateTime.Now; eform.proId = 20; eform.state = "通过"; eform.toPer = 0; eform.toProsId = 0; CAI_POOrderService POOrderSer = new CAI_POOrderService(); int MainId = 0; return(POOrderSer.addTran(order, eform, POOrders, caiOrders, out MainId, false)); }