private void Query(object obj, EventArgs e)
{
#region 查询
UIControl.GetSqlParams(group1.Controls, wheres, parameters);
gridCtrl.DataSource = dal.GetTable(wheres.ToArray(), parameters.ToArray());
#endregion
}
private void Query(object obj, EventArgs e)
{
#region 查询
UIControl.GetSqlParams(group1.Controls, wheres, parameters);
if (cbox_bQuality.Text == "是")
{
wheres.Add("isnull(qmQty,0) > 0");
}
else if (cbox_bQuality.Text == "否")
{
wheres.Add("isnull(qmQty,0) = 0");
}
if (cb_iState.Text == "审核")
{
wheres.Add("iState = 1");
}
else if (cb_iState.Text == "未审核")
{
wheres.Add("isnull(iState,0) = 0");
}
gridCtrl.DataSource = Controller.GetList(wheres.ToArray(), parameters.ToArray());
#endregion
}
private void Query(object obj, EventArgs e)
{
#region 查询
UIControl.GetSqlParams(group1.Controls, wheres, parameters);
gridCtrl.DataSource = dal.GetRepRecord(wheres, parameters);
#endregion
}
private void Query(object obj, EventArgs e)
{
#region 查询
UIControl.GetSqlParams(group1.Controls, wheres, parameters);
//默认显示未处理, U8未入库, 已审核
//cState = 1: 审核 2:关闭
wheres.Add("QmQty > 0 and QmQty > isnull(haveQmQty,0) ");
gridCtrl.DataSource = Controller.GetList(wheres.ToArray(), parameters.ToArray());
#endregion
}