/* public IList<Entity.GroupQuery> select(Entity.GroupQuery GroupCheck)
* {
*
* // SqlParameter[] sqlparams = {new SqlParameter ("@Field1",GroupCheck.fileds1 ),
* // new SqlParameter ("@Field2",GroupCheck.fileds2 ),
* // new SqlParameter ("@Field3",GroupCheck.fileds3 ),
*
* // new SqlParameter ("@Operator1",GroupCheck.Operator1 ),
* // new SqlParameter ("@Operator2",GroupCheck.Operator2 ),
* // new SqlParameter ("@Operator3",GroupCheck.Operator3 ),
*
* // new SqlParameter ("@Context1",GroupCheck.Context1 ),
* // new SqlParameter ("@Context2",GroupCheck.Context2 ),
* // new SqlParameter ("@Context3",GroupCheck.Context3 ),
*
* // new SqlParameter ("@Relation1",GroupCheck.Relation1 ),
* // new SqlParameter ("@Relation2",GroupCheck.Relation2 )
*
* // //new SqlParameter ("@table",GroupCheck.table )
* // };
* // string sql ="GroupCheck";
* // //string y="select * from worklog_info where "+ GroupCheck.fileds1 + GroupCheck.Operator1 + GroupCheck.Context1;
* // //string sql;
* //// //拼接语句
* ////// sql = "select * from @table where @Field1 @Operator1 @Context1";
* //// sql = @"select * from @table where @Field1= @Context1";
* // DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.StoredProcedure , sqlparams);
* IList<Entity.GroupQuery> LgroupQuery = DAL.CovertHelper<Entity.GroupQuery>.ConvertToModel(table);
* return LgroupQuery;
* }
*/
DataTable IDal.IGroupQuery.select(Entity.GroupQuery GroupCheck)
{
SqlParameter[] sqlparams = { new SqlParameter("@Field1", GroupCheck.fileds1),
new SqlParameter("@Field2", GroupCheck.fileds2),
new SqlParameter("@Field3", GroupCheck.fileds3),
new SqlParameter("@Operator1", GroupCheck.Operator1),
new SqlParameter("@Operator2", GroupCheck.Operator2),
new SqlParameter("@Operator3", GroupCheck.Operator3),
new SqlParameter("@Context1", GroupCheck.Context1),
new SqlParameter("@Context2", GroupCheck.Context2),
new SqlParameter("@Context3", GroupCheck.Context3),
new SqlParameter("@Relation1", GroupCheck.Relation1),
new SqlParameter("@Relation2", GroupCheck.Relation2)
//new SqlParameter ("@table",GroupCheck.table )
};
string sql = "worklog_info";
if (GroupCheck.table == "worklog_info")
{
sql = "GroupCheck";
}
if (GroupCheck.table == "line")
{
sql = "Groupline";
}
if (GroupCheck.table == "Student")
{
sql = "GroupStudent";
}
//string sql = GroupCheck.table;
//switch (sql)
//{
// case "worklog_info":
// return "GroupCheck";
// case "line":
// return "Groupline";
// //case "":
// // sql = "";
//}
////string sql = "GroupCheck";
DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.StoredProcedure, sqlparams);
return(table);
}
//在dategridview中显示查询的结果
protected override void toDateGridView(Entity.GroupQuery Groupquery)
{
// base.toDateGridView(Groupquery);
//IList <Entity.GroupQuery > lgroupQuery = new List<Entity.GroupQuery >();
DataTable lgroupQuery = new DataTable();
Facade.GroupQueryFacade GroupQuery = new Facade.GroupQueryFacade();
lgroupQuery = GroupQuery.GroupQuery(Groupquery);
dataGridView1.DataSource = lgroupQuery;
dataGridView1.Columns[0].HeaderText = "教师";
dataGridView1.Columns[1].HeaderText = "上班日期";
dataGridView1.Columns[2].HeaderText = "上班时间";
dataGridView1.Columns[3].HeaderText = "下班日期";
dataGridView1.Columns[4].HeaderText = "下班时间";
dataGridView1.Columns[5].HeaderText = "机器号";
dataGridView1.Columns[6].HeaderText = "权限";
dataGridView1.Columns[7].HeaderText = "备注";
//dataGridView1.Columns[7].HeaderText = "";
}
private void btOk_Click(object sender, EventArgs e)
{
//每次点击按钮前先清空dgv
dataGridView1.DataSource = null;
//1 没有组合的查询判空
//限制输入不能为空
if (cmbRelation1.Text == "")
{
Control[] arrcontrol = new Control[3];
arrcontrol[0] = cmbFields1;
arrcontrol[1] = cmbOperator1;
arrcontrol[2] = txtContext1;
//调用函数判断控件中的内容是否为空
//EmptyUI.ISsomeEmpty(arrcontrol);
bool falg;
falg = EmptyUI.ISsomeEmpty(arrcontrol);
if (falg == true)
{
MessageBox.Show("内容填写不完整，请核对后再查询！");
enGroupQuery = null;
return;
}
}
else
{
if (cmbRelation2.Text == "")
{
//2 开始第一个组合的查询判空
Control[] arrcontrol2 = new Control[6];
arrcontrol2[0] = cmbFields1;
arrcontrol2[1] = cmbOperator1;
arrcontrol2[2] = txtContext1;
arrcontrol2[3] = cmbFields2;
arrcontrol2[4] = cmbOperator2;
arrcontrol2[5] = txtContext2;
bool falg;
falg = EmptyUI.ISsomeEmpty(arrcontrol2);
if (falg == true)
{
MessageBox.Show("内容填写不完整，请核对后再查询！");
enGroupQuery = null;
return;
}
}
else
{ //开始第三个条件的组合查询
Control[] arrcontrol3 = new Control[9];
arrcontrol3[0] = cmbFields1;
arrcontrol3[1] = cmbOperator1;
arrcontrol3[2] = txtContext1;
arrcontrol3[3] = cmbFields2;
arrcontrol3[4] = cmbOperator2;
arrcontrol3[5] = txtContext2;
arrcontrol3[6] = cmbFields3;
arrcontrol3[7] = cmbOperator3;
arrcontrol3[8] = txtContext3;
//EmptyUI.ISsomeEmpty(arrcontrol3);
bool falg;
falg = EmptyUI.ISsomeEmpty(arrcontrol3);
if (falg == true)
{
MessageBox.Show("内容填写不完整，请核对后再查询！");
enGroupQuery = null;
return;
}
}
}
//将参数传递给实体
//Entity.GroupQuery enGroupQuery = new Entity.GroupQuery();
enGroupQuery = new Entity.GroupQuery();
enGroupQuery.fileds1 = ToName(cmbFields1.Text);
enGroupQuery.fileds2 = ToName(cmbFields2.Text);
enGroupQuery.fileds3 = ToName(cmbFields3.Text);
enGroupQuery.Operator1 = cmbOperator1.Text;
enGroupQuery.Operator2 = cmbOperator2.Text;
enGroupQuery.Operator3 = cmbOperator3.Text;
enGroupQuery.Context1 = txtContext1.Text.Trim();
enGroupQuery.Context2 = txtContext2.Text.Trim();
enGroupQuery.Context3 = txtContext3.Text.Trim();
enGroupQuery.Relation1 = ToName(cmbRelation1.Text);
enGroupQuery.Relation2 = ToName(cmbRelation2.Text);
enGroupQuery.table = Getdbtable();
////调用子类的查询，返回不同的查询结果
////IList<Entity.GroupQuery> LgroupQuery = new BindingList<Entity.GroupQuery>();
//DataTable LgroupQuery = new DataTable();
//Facade.GroupQueryFacade GroupQuery = new Facade.GroupQueryFacade();
//LgroupQuery = GroupQuery.GroupQuery(enGroupQuery);
////dataGridView1.AutoGenerateColumns = false;
//if (LgroupQuery.Rows.Count > 0)
//{
// dataGridView1.DataSource = LgroupQuery;
//}
}
//通过实体，将不同的内容显示在各个窗体中
protected virtual void toDateGridView(Entity.GroupQuery Groupquery)
{
}
public DataTable GroupQuery(Entity.GroupQuery groupQuery)
{
BLL.GroupQueryBLL groupquery = new BLL.GroupQueryBLL();
return(groupquery.GroupQuery(groupQuery));
}
