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