110,552
社区成员
发帖
与我相关
我的任务
分享
DataView view = new DataView(ds.Tables["xxx"]);
view.RowFilter = "过滤条件";
DataTable table = view.ToTable("tablename");
if (chkOustanding.Checked == true)
{
Status += "0,";
}
if (chkSubmitButOutstanding.Checked == true)
{
Status += "2,";
}
if (chkConsiderSing.Checked == true)
{
Status += "4,";
}
if (chkOustanding.Checked == true || chkSubmitButOutstanding.Checked == true || chkConsiderSing.Checked == true)
{
string b = Status.Remove(Status.Length - 1, 1);
string a = textBox1.Text.Trim().ToString();
user.getCall(dgvUserInfo, CamCode, AssUser, a);
}
public DataSet BindCall(string CamCode, string AssUser, string CaseStatus)
{
SqlParameter[] Params = new SqlParameter[3];
Params[0] = db.MakeInParam("@Cam_code", SqlDbType.VarChar, 50, CamCode);
Params[1] = db.MakeInParam("@Ass_User", SqlDbType.VarChar, 50, AssUser);
Params[2] = db.MakeInParam("@Case_status", SqlDbType.VarChar, 50, CaseStatus);
return SqlHelper.ExecuteDataset(db.ConnectionString, CommandType.StoredProcedure, "SP_CallQueryList", Params);
}
DataSet ds =user.BindCall(CamCode, AssUser,b);
dgvUserInfo.DataSource = ds.Tables[0];