111,094
社区成员




string cardId = txtCardID.Text.Trim();
string strSqlVipAcc = @"exec pr_user_vipacc_consume @cardid,@stime1,@etime1";
string strSelectVipAcc = @"select * from t_user_vip_acc";
if (string.IsNullOrEmpty(cardId))
{
msgDiv1.MsgDivShow("卡号不允许为空!",2);
}
else
{
SqlParameter[] paras = {
new SqlParameter("@cardid",cardId),
new SqlParameter("@stime1",dtpStime.Value.ToString()),
new SqlParameter("@etime1",dtpEtime.Value.ToString())
};
try
{
DataTable dt = new DataTable();
if (dgvVipConsume.Rows.Count>0)
{
foreach (DataGridViewRow item in dgvVipConsume.Rows)
{
dgvVipConsume.Rows.Remove(item);
}
}
if (CardIdIsRight(cardId,tempStrConn))
{
int ii = SqlHelper.DnhExecuteNonQuery(strSqlVipAcc, paras);
if (ii>0)
{
dt = new DataTable();
dt = SqlHelper.DataTableAdapter(strSelectVipAcc, null);
if (dt.Rows.Count > 0)
{
msgDiv1.MsgDivShow("查询成功!", 2);
dgvVipConsume.DataSource = dt;