private void SaveEnroll()
{
OrderBean o = new OrderBean();
ItemReserveBean item;
float discount = 0;
float total = 0;
CustomerBean c = new CustomerBean();
c.Id = customerId;
foreach (DataRow varRow in tabSelect.Rows)
{
item = new ItemReserveBean();
item.Count = Convert.ToInt32(varRow["Count"].ToString());
item.Lesson.Id = Convert.ToInt32(varRow["Id"].ToString());
item.PriceDiscount = (float)Convert.ToDouble(varRow["PriceDiscount"].ToString());
item.PriceTotal = (float)Convert.ToDouble(varRow["PriceReal"].ToString());
item.Order = o;
o.Items.Add(item);
discount += item.PriceDiscount;
total += item.PriceTotal;
}
o.PriceTotal = total;
o.PriceDiscount = discount;
o.Customer = c;
OrderDAO d = new OrderDAO();
d.AddOrder(o);
}
private SqlParameter para; //参数
public int AddOrder(OrderBean b)
{
int count = 0;
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@FlowSerial", SqlDbType.VarChar, 30),
para = new SqlParameter("@PriceTotal", b.PriceTotal),
para = new SqlParameter("@CustomerId", b.Customer.Id),
};
sp[0].Direction = ParameterDirection.Output;
count = sh.RunSql("PR_Order_Add", sp);
b.FlowSerial = sp[0].Value.ToString();
ItemReserveDAO d = new ItemReserveDAO();
foreach (ItemReserveBean lesson in b.Items)
{
d.AddItemLesson(lesson);
}
}
catch (Exception ex)
{
throw ex;
}
return(count);
}
