private SqlParameter para; //参数
public int AddItemConsume(ItemConsumeBean b)
{
int count = 0;
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@OrderFlowSerial", b.ItemReserve.Order.FlowSerial),
para = new SqlParameter("@LessonId", b.ItemReserve.Lesson.Id),
para = new SqlParameter("@ItemTotal", b.ItemReserve.Count),
para = new SqlParameter("@ConsumeCount", b.ConsumeCount),
para = new SqlParameter("@RemainCount", b.RemainCount),
para = new SqlParameter("@CustomerId", b.Consumer.Id),
para = new SqlParameter("@TeacherId", b.Teacher.Id),
para = new SqlParameter("@OperatorId", b.Oper.Id),
para = new SqlParameter("@Remark", b.Remark),
};
count = sh.RunSql("PR_ItemConsume_Add", sp);
}
catch (Exception ex)
{
throw ex;
}
return(count);
}
private void SaveConsume()
{
ItemConsumeDAO d = new ItemConsumeDAO();
ItemConsumeBean b = new ItemConsumeBean();
b.Consumer.Id = customerId;
foreach (DataRow r in tabSelect.Rows)
{
b.ItemReserve.Order.FlowSerial = r["FlowSerial"].ToString();
b.ItemReserve.Lesson.Id = Convert.ToInt32(r["LessonId"].ToString());
b.Consumer.Id = customerId;
b.RemainCount = Convert.ToInt32(r["Remain"].ToString());
b.ConsumeCount = Convert.ToInt32(r["CurrentConsume"].ToString());
b.Teacher.Id = Convert.ToInt32(r["TeacherId"].ToString());
b.Oper.Id = Program.loginUser.Id;
b.Remark = "";
d.AddItemConsume(b);
}
}