private void BindList()
{
VipSoft.BLL.MemCard memCard = new BLL.MemCard();
DataSet ds = memCard.GetList(pageSize, currentPage, out resCount, condition);
this.dataGridView_List.DataSource = ds.Tables[0];
for (int i = 0; i < dataGridView_List.Rows.Count; i++)
{
dataGridView_List.Rows[i].Cells[0].Value = false;
}
BindPage();
}
public void search_Click(object sender, EventArgs e)
{
String conditionStr = "";
if (this.search_box.Text == null)
{
MessageBox.Show("请先录入会员卡号或者手机号。");
search_box.Focus();
return;
}
conditionStr += " cardid ='"+search_box.Text+"' or mobile ='"+search_box.Text+"' ";
VipSoft.BLL.MemCard memCard = new BLL.MemCard();
DataSet ds = memCard.GetList(conditionStr);
DataTable dt = ds.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
this.v_cardid.Text = dr["cardid"].ToString();
this.name.Text = dr["name"].ToString();
this.v_money.Text = dr["money"].ToString();
this.totalMoney.Text = dr["totalMoney"].ToString();
this.point.Text = dr["point"].ToString();
this.mobile.Text = dr["mobile"].ToString();
this.pasttime.Text = dr["pasttime"].ToString().Substring(0, 10);
this.levelid.Text = dr["levelid"].ToString();
this.id.Text = dr["id"].ToString();
}
else
{
this.v_cardid.Text = "";
this.name.Text = "";
this.v_money.Text ="";
this.totalMoney.Text = "";
this.point.Text = "";
this.mobile.Text = "";
this.pasttime.Text ="";
this.levelid.Text = "";
this.id.Text = "";
}
//SearchMem searchDlg = new SearchMem();
// this.dataGridView_List.DataSource = ds.Tables[0];
}
