/// <summary>
/// 绑定数据到DataGrid控件MyDataGrid上
/// </summary>
private void BindDataGrid()
{
//创建操作员记录数据表类实例
MemCardLevelOperate clsRecord = new MemCardLevelOperate();
//获取记录数据
DataTable dt = new DataTable();
if (Session["UserGroupID"].ToString() == "2" || Session["UserGroupID"].ToString() == "3")
{
dt = clsRecord.Bind(Convert.ToDateTime(this.txtBeginDate.Text.Trim()).ToShortDateString(), Convert.ToDateTime(this.txtEndDate.Text.Trim()).AddDays(1).ToShortDateString(), Session["UserID"].ToString());
}
else
{
dt = clsRecord.Bind(Convert.ToDateTime(this.txtBeginDate.Text.Trim()).ToShortDateString(), Convert.ToDateTime(this.txtEndDate.Text.Trim()).AddDays(1).ToShortDateString(), "");
}
DataView dv = new DataView();
dt.TableName = "Mem_Log";
if (dt != null)
{
dv.Table = dt;
dv.Sort = " operatetime DESC";
if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "")
{
dv.RowFilter = ViewState["Condition"].ToString();
}
else
{
dv = dt.DefaultView;
}
//新增ID自增值列绑定
dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32")));
int intCountRecNum = dv.Count; //获取数据表记录数
for (int i = 0; i < intCountRecNum; i++)
{
dv[i]["idno"] = i + 1;
}
MyDataGrid.DataSource = dv;
int PageCount = 0;
if (intCountRecNum % MyDataGrid.PageSize == 0)
{
PageCount = intCountRecNum / MyDataGrid.PageSize;
}
else
{
PageCount = intCountRecNum / MyDataGrid.PageSize + 1;
}
if (PageCount != 0 && MyDataGrid.CurrentPageIndex >= PageCount)
{
MyDataGrid.CurrentPageIndex = PageCount - 1;
}
MyDataGrid.DataBind();
lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数
ShowStats(); //显示页数信息
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strCardId = this.lbCardID.Text.ToString();
string strMoney = this.txtMoney.Text.ToString();
string dir = this.ddlOperate.SelectedValue.ToString();
if (strCardId == "")
{
UtilLib.Common.ShowMsg("请先查询卡号！");
this.txtCardID2.Focus();
return;
}
if (strMoney == "")
{
Common.ShowMsg("请输入金额！");
this.txtMoney.Focus();
return;
}
double money = 0.00;
if (!Double.TryParse(strMoney, out money))
{
Common.ShowMsg("金额输入不合法！");
this.txtMoney.Focus();
return;
}
if (dir == "2")
{
money = -money;
}
Member m = new Member();
MemberDB mem = m.FindMemByCardId(strCardId);
if (mem == null)
{
Common.ShowMsg("用户不存在！");
return;
}
if (mem.Status == 0)
{
Common.ShowMsg("会员卡尚未激活！请与系统管理员联系");
return;
}
string msg = "";
m.UpdateMoney(strCardId, money, "充值", out msg);
Common.ShowMsg(msg);
//RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员卡充值", "充值卡号：" + strCardId + "；充值金额：" + money);
if (dir == "1")
{
MemCardLevelOperate.SaveRecord(Session["UserId"].ToString(), strCardId, "充值", "充值 " + strMoney + " 元", money, 1);
}
else if (dir == "2")
{
MemCardLevelOperate.SaveRecord(Session["UserId"].ToString(), strCardId, "扣除", "扣除" + strMoney + " 元", money, 1);
}
this.lbAccount.Text = "";
this.txtCardID2.Text = "";
this.lbUserName.Text = "";
//this.txtCardID2.Enabled = true;
this.lbCardID.Text = "";
this.txtMoney.Text = "";
}
/// <summary>
/// 绑定数据到DataGrid控件MyDataGrid上
/// </summary>
private void BindDataGrid()
{
//创建操作员记录数据表类实例
MemCardLevelOperate clsRecord = new MemCardLevelOperate();
DataTable dt = new DataTable();
//获取记录数据
//if (Session["UserGroupID"].ToString() != "1")
//{
// dt = clsRecord.BindAgent(Convert.ToDateTime(this.txtBeginDate.Text.Trim()).ToShortDateString(), Convert.ToDateTime(this.txtEndDate.Text.Trim()).AddDays(1).ToShortDateString(), Session["UserGroupId"].ToString(), Session["UserId"].ToString());
//}
//else
//{
// dt = clsRecord.BindAgent(Convert.ToDateTime(this.txtBeginDate.Text.Trim()).ToShortDateString(), Convert.ToDateTime(this.txtEndDate.Text.Trim()).AddDays(1).ToShortDateString(),, Session["UserId"].ToString()"");
//}
dt = clsRecord.BindAgent(Convert.ToDateTime(this.txtBeginDate.Text.Trim()).ToShortDateString(), Convert.ToDateTime(this.txtEndDate.Text.Trim()).AddDays(1).ToShortDateString(), Session["UserGroupId"].ToString(), Session["UserId"].ToString());
//获取记录数据
//DataTable dt = clsRecord.BindAgent(Convert.ToDateTime(this.txtBeginDate.Text.Trim()).ToShortDateString(), Convert.ToDateTime(this.txtEndDate.Text.Trim()).AddDays(1).ToShortDateString(),Session["UserId"].ToString());
DataView dv = new DataView();
dt.TableName = "Mem_Log";
if (dt != null)
{
dv.Table = dt;
if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "")
{
dv.RowFilter = ViewState["Condition"].ToString();
}
else
{
dv = dt.DefaultView;
}
//新增ID自增值列绑定
dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32")));
int intCountRecNum = dv.Count; //获取数据表记录数
//double totalAccount = 0.00;
double totalZongXiaofei = 0.00;
double totalZongChongzhi = 0.00;
for (int i = 0; i < intCountRecNum; i++)
{
dv[i]["idno"] = i + 1;
//totalAccount += Convert.ToDouble(dv[i]["Account"]);
totalZongXiaofei += Convert.ToDouble(dv[i]["ZongXiaofei"]);
totalZongChongzhi += Convert.ToDouble(dv[i]["ZongCongzhi"]);
}
MyDataGrid.DataSource = dv;
this.lbTotalXiaofei.Text = totalZongXiaofei.ToString();
this.lbTotalChongzhi.Text = totalZongChongzhi.ToString();
int PageCount = 0;
if (intCountRecNum % MyDataGrid.PageSize == 0)
{
PageCount = intCountRecNum / MyDataGrid.PageSize;
}
else
{
PageCount = intCountRecNum / MyDataGrid.PageSize + 1;
}
if (PageCount != 0 && MyDataGrid.CurrentPageIndex >= PageCount)
{
MyDataGrid.CurrentPageIndex = PageCount - 1;
}
MyDataGrid.DataBind();
lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数
ShowStats(); //显示页数信息
}
}
protected void btnJiezhang_Click(object sender, EventArgs e)
{
try
{
if (this.lbCardID.Text.Trim() == "")
{
Common.ShowMsg("请刷卡！");
return;
}
if (this.lbAccount.Text.Trim() == "")
{
Common.ShowMsg("账户错误！");
return;
}
double dAccount = Convert.ToDouble(this.lbAccount.Text.Trim());
dAccount -= Convert.ToDouble(this.txtSumMoney.Text.Trim());
if (dAccount < 0)
{
Common.ShowMsg("余额不足，购买失败！");
return;
}
string strSql = "update Mem_Card set Account = '" + dAccount + "' where cardid = '" + this.lbCardID.Text.Trim() + "'";
DBManager db = DBManager.Instance();
int i = 0;
db.Transact(strSql, out i);
if (i > 0)
{
Common.ShowMsg("结账完成！");
//记录操作员操作
//RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员消费", "卡号【" + this.txtCardID2.Text + "】消费" + this.txtSumMoney.Text + "元");
dtGoods = ViewState["dtGoods"] as DataTable;
DataTable dt1 = dtGoods;
for (int j = 0; j < this.dtGoods.Rows.Count; j++)
{
MemCardLevelOperate.SaveRecord(Session["UserId"].ToString(), this.lbCardID.Text.Trim(), "消费", "买商品【" + dtGoods.Rows[j]["GoodsName"].ToString() + "】数量：" + dtGoods.Rows[j]["Count"].ToString(), Convert.ToDouble(dtGoods.Rows[j]["Money"].ToString()), 0);
}
var user = new[] { lbCardID.Text, lbUserName.Text, txtSumMoney.Text, lbAccount.Text };
this.lbAccount.Text = "";
this.txtCardID2.Text = "";
this.txtPwd2.Text = "";
this.txtSumMoney.Text = "";
this.lbUserName.Text = "";
this.txtSum.Text = "";
this.txtGoodsCode.Text = "";
this.lbCardID.Text = "";
DataTable dt = new DataTable();
dt.Columns.Add("idno");
dt.Columns.Add("GoodsCode");
dt.Columns.Add("GoodsName");
dt.Columns.Add("Price");
dt.Columns.Add("Count");
dt.Columns.Add("Money");
ViewState["dtGoods"] = dt;
BindDataGrid();
this.txtCardID2.Enabled = true;
SetFocus("txtCardID2");
//StringBuilder sb = new StringBuilder();
//sb.Append(" 美奥口腔 \n");
//sb.Append("*************************************\n");
//sb.Append("会员卡号：" + user[0] + "\n");
//sb.Append("会员名称:" + user[1] + "\n");
//sb.Append("项目" + "\t\t" + "数量" + "\t" + "单价" + "\t" + "小计" + "\n");
//for (int j = 0; j < dt1.Rows.Count; j++)
//{
// sb.Append(dt1.Rows[j]["GoodsName"].ToString() + "\t" + dt1.Rows[j]["Count"].ToString() + "\t" + Convert.ToDouble(dt1.Rows[j]["Money"].ToString()) + "\t" + Convert.ToDouble(dt1.Rows[j]["Money"].ToString()) + "\n");
//}
//sb.Append("总计消费:\t\t\t" + user[2] + "\n");
//sb.Append("当前余额:\t\t\t" + (Convert.ToDecimal(user[3]) - Convert.ToDecimal(user[2])) + "\n");
//sb.Append("\n消费人\n\n");
//sb.Append("*************************************\n");
//sb.Append(" 谢谢惠顾欢迎下次光临 ");
//Print(sb.ToString());
}
else
{
Common.ShowMsg("结账失败！");
}
}
catch (Exception ex)
{
Common.ShowMsg("未知异常！");
}
}
protected void btnJiezhang_Click(object sender, EventArgs e)
{
try
{
if (this.lbCardID.Text.Trim() == "")
{
Common.ShowMsg("请刷卡！");
return;
}
if (this.lbAccount.Text.Trim() == "")
{
Common.ShowMsg("账户错误！");
return;
}
double dAccount = Convert.ToDouble(this.lbAccount.Text.Trim());
dAccount -= Convert.ToDouble(this.txtSumMoney.Text.Trim());
if (dAccount < 0)
{
Common.ShowMsg("余额不足，购买失败！");
return;
}
string strSql = "update Mem_Card set Account = '" + dAccount + "' where cardid = '" + this.lbCardID.Text.Trim() + "'";
DBManager db = DBManager.Instance();
int i = 0;
db.Transact(strSql, out i);
if (i > 0)
{
Common.ShowMsg("结账完成！");
//记录操作员操作
//RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员消费", "卡号【" + this.txtCardID2.Text + "】消费" + this.txtSumMoney.Text + "元");
dtGoods = ViewState["dtGoods"] as DataTable;
for (int j = 0; j < this.dtGoods.Rows.Count; j++)
{
MemCardLevelOperate.SaveRecord(Session["UserId"].ToString(), this.lbCardID.Text.Trim(), "消费", "买商品【" + dtGoods.Rows[j]["GoodsName"].ToString() + "】数量：" + dtGoods.Rows[j]["Count"].ToString(), Convert.ToDouble(dtGoods.Rows[j]["Money"].ToString()), 0);
}
this.lbAccount.Text = "";
this.txtCardID2.Text = "";
this.txtPwd2.Text = "";
this.txtSumMoney.Text = "";
this.lbUserName.Text = "";
this.txtSum.Text = "";
this.txtGoodsCode.Text = "";
this.lbCardID.Text = "";
DataTable dt = new DataTable();
dt.Columns.Add("idno");
dt.Columns.Add("GoodsCode");
dt.Columns.Add("GoodsName");
dt.Columns.Add("Price");
dt.Columns.Add("Count");
dt.Columns.Add("Money");
ViewState["dtGoods"] = dt;
BindDataGrid();
this.txtCardID2.Enabled = true;
SetFocus("txtCardID2");
}
else
{
Common.ShowMsg("结账失败！");
}
}
catch (Exception ex)
{
Common.ShowMsg("未知异常！");
}
}
