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));
}
