public DataSet GetAllItemConsume(QueryConditionComsume c)
{
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@CustomerName", c.CustomerName),
para = new SqlParameter("@LessonName", c.LessonName),
para = new SqlParameter("@TeacherName", c.TeacherName),
para = new SqlParameter("@DateBegin", c.DateBegin),
para = new SqlParameter("@DateEnd", c.DateEnd),
};
ds = sh.GetDataSet("PR_ItemConsume_GetAll", sp);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
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];
}
