protected void gvMain_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#EAF1FD',this.style.fontWeight='';"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';"); CAI_POOrder model = e.Row.DataItem as CAI_POOrder; if (model.Count2 != model.Count1) { e.Row.BackColor = System.Drawing.Color.LightGray; } } }
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>"); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.JXC.CAI_POOrder GetModel_File(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" fileName,fileType,fileNo "); strSql.Append(" from CAI_POOrder "); strSql.Append(" where CAI_POOrder.Id=" + id + ""); VAN_OA.Model.JXC.CAI_POOrder model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = new CAI_POOrder(); object ojb; ojb = dataReader["fileName"]; if (ojb != null && ojb != DBNull.Value) { model.fileName = ojb.ToString(); } ojb = dataReader["fileType"]; if (ojb != null && ojb != DBNull.Value) { model.fileType = ojb.ToString(); } ojb = dataReader["fileNo"]; if (ojb != null && ojb != DBNull.Value) { model.fileNo = (byte[])ojb; } } } } return(model); }
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)); }