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); } }
private void LoadData() { QueryConditionComsume c = new QueryConditionComsume(); string customer = textEditCustomer.Text.Trim(); if (!string.IsNullOrEmpty(customer)) { c.CustomerName = customer; } string lesson = textEditLesson.Text.Trim(); if (!string.IsNullOrEmpty(lesson)) { c.LessonName = lesson; } string teacher = textEditTeacher.Text.Trim(); if (!string.IsNullOrEmpty(teacher)) { c.TeacherName = teacher; } string begin = dateEditBegin.Text.Trim(); if (!string.IsNullOrEmpty(begin)) { c.DateBegin = begin; } string end = dateEditEnd.Text.Trim(); if (!string.IsNullOrEmpty(end)) { c.DateEnd = end; } ItemConsumeDAO d = new ItemConsumeDAO(); DataSet set = d.GetAllItemConsume(c); gridCtrl.DataSource = set.Tables[0]; }