private void btnCancel_Click(object sender, EventArgs e)
{
string strType = btnAdd.Text;
switch (strType)
{
case "添加":
txtOperID.Text = "";
txtOperID.Enabled = true;
txtOperName.Text = "";
txtOperPwd.Text = "";
txtOperPwdConfirm.Text = "";
break;
case "修改":
using (AMSEntities amsContext = new AMSEntities())
{
tbOper oper = amsContext.tbOper.FirstOrDefault(o => o.vcOperID == txtOperID.Text);
//txtOperID.Text = oper.vcOperID;
//txtOperID.Enabled = false;
txtOperName.Text = oper.vcOperName;
txtOperPwd.Text = oper.vcOperPwd;
txtOperPwdConfirm.Text = oper.vcOperPwd;
cmbRole.SelectedValue = oper.vcLimit;
}
break;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (txtOperID.Text.Equals("admin"))
{
throw new Exception("系统管理员帐户不能注销");
}
DialogResult dr = MessageBox.Show(this, "是否注销\"" + txtOperName.Text + "\"操作员", "注销操作员", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
using (AMSEntities amsContext = new AMSEntities())
{
tbOper oper = amsContext.tbOper.FirstOrDefault(o => o.vcOperID == txtOperID.Text);
//oper.vcLimit = cmbRole.SelectedValue.ToString();
//oper.vcOperName = txtOperName.Text;
//oper.vcOperPwd = txtOperPwd.Text;
//oper.vcOperLevel = cmbOperLevel.SelectedValue.ToString();
oper.iFlag = 1;
oper.dtExpDate = DateTime.Now;
amsContext.SaveChanges();
MessageBox.Show(this, "操作员注销成功", "注销操作员");
}
//frmOper_Load(null, null);
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "操作员");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
string strOperID = cmbOper.SelectedValue.ToString();
string strOperPwd = txtOperPwd.Text;
if (string.IsNullOrEmpty(strOperPwd))
{
throw new Exception("请输入密码");
}
tbOper oper = GlobalParams.Opers.FirstOrDefault(o => o.vcOperID == strOperID && o.vcOperPwd == strOperPwd && o.iFlag == 0);
if (oper == null)
{
throw new Exception("用户名或密码错误");
}
GlobalParams.oper = oper;
GlobalParams.strClass = cmbClass.Text.Trim();
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
txtOperPwd.Text = "";
ErrorLog.Write(this, ex);
}
}
private void InitFrm()
{
tbCommCode comm = new tbCommCode();
comm.vcCommCode = "%";
comm.vcCommName = "*";
List <tbCommCode> alcomm = GlobalParams.CommCode.Where(cc => cc.vcCommSign == "AL").ToList();
alcomm.Insert(0, comm);
cmbAssLevel.DataSource = alcomm;
cmbAssLevel.DisplayMember = "vcCommName";
cmbAssLevel.ValueMember = "vcCommCode";
List <tbCommCode> astcomm = GlobalParams.CommCode.Where(cc => cc.vcCommSign == "AST").ToList();
astcomm.Insert(0, comm);
cmbAssState.DataSource = astcomm;
cmbAssState.DisplayMember = "vcCommName";
cmbAssState.ValueMember = "vcCommCode";
List <tbCommCode> cstcomm = GlobalParams.CommCode.Where(cc => cc.vcCommSign == "CST").ToList();
cstcomm.Insert(0, comm);
cmbCardState.DataSource = cstcomm;
cmbCardState.DisplayMember = "vcCommName";
cmbCardState.ValueMember = "vcCommCode";
tbOper aOper = new tbOper();
aOper.vcOperID = "%";
aOper.vcOperName = "*";
List <tbOper> operList = GlobalParams.Opers.OrderBy(oo => oo.vcOperName).ToList();
operList.Insert(0, aOper);
cmbOper.DataSource = operList;
cmbOper.DisplayMember = "vcOperName";
cmbOper.ValueMember = "vcOperID";
dtpBeginInDate.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
dtpBeginOperDate.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
dtpEndInDate.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
dtpEndOperDate.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
}
private void frmConsQuery_Load(object sender, EventArgs e)
{
dtpBegin.Value = DateTime.Now;
dtpEnd.Value = DateTime.Now;
txtSumCount.Text = "0";
txtSumFee.Text = "0";
cmbClass.Items.Add("全部");
cmbClass.Items.Add("早班");
cmbClass.Items.Add("中班");
cmbClass.Items.Add("晚班");
cmbClass.SelectedIndex = 0;
tbOper operall = new tbOper();
operall.vcOperID = "全部";
operall.vcOperName = "全部";
List <tbOper> operlist = GlobalParams.Opers;
operlist.Insert(0, operall);
cmbOper.DataSource = operlist;
cmbOper.DisplayMember = "vcOperName";
cmbOper.ValueMember = "vcOperID";
tbGoods goodsall = new tbGoods();
goodsall.vcGoodsCode = "全部";
goodsall.vcGoodsName = "全部";
List <tbGoods> goodslist = GlobalParams.Goods;
goodslist.Insert(0, goodsall);
cmbConsName.DataSource = GlobalParams.Goods;
cmbConsName.DisplayMember = "vcGoodsName";
cmbConsName.ValueMember = "vcGoodsName";
dgvResult.AllowUserToAddRows = false;
dgvResult.AllowUserToDeleteRows = false;
dgvResult.AllowUserToResizeRows = true;
dgvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgvResult.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dgvResult.ReadOnly = true;
dgvResult.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
if (txtOldPwd.Text.Trim().Length == 0)
{
throw new Exception("请输入老密码");
}
if (txtPwd.Text.Trim().Length == 0)
{
throw new Exception("请输入新密码");
}
if (txtPwdConfirm.Text.Trim().Length == 0)
{
throw new Exception("请输入新密码确认");
}
if (!txtOldPwd.Text.Equals(GlobalParams.oper.vcOperPwd))
{
throw new Exception("输入的老密码不正确");
}
if (!txtPwd.Text.Equals(txtPwdConfirm.Text))
{
throw new Exception("输入的新密码和新密码确认不一致");
}
if (txtOldPwd.Text.Equals(txtPwd.Text))
{
throw new Exception("输入的新密码和老密码一样");
}
using (AMSEntities amsContext = new AMSEntities())
{
//tbOper oper = GlobalParams.oper;
GlobalParams.oper.vcOperPwd = txtPwd.Text;
tbOper oper = amsContext.tbOper.FirstOrDefault(o => o.vcOperID == GlobalParams.oper.vcOperID);
oper.vcOperPwd = txtPwd.Text;
amsContext.SaveChanges();
MessageBox.Show(this, "密码修改成功", "修改密码");
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "修改密码");
}
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
try
{
string strType = e.Node.Tag.ToString();
if (strType == "role")
{
txtOperID.Text = "";
txtOperID.Enabled = true;
txtOperName.Text = "";
txtOperPwd.Text = "";
txtOperPwdConfirm.Text = "";
btnAdd.Text = "添加";
cmbRole.SelectedValue = e.Node.Name;
//btnDelete.Visible = false;
//btnAdd.Tag = "tag";
}
if (strType == "oper")
{
using (AMSEntities amsContext = new AMSEntities())
{
tbOper oper = amsContext.tbOper.FirstOrDefault(o => o.vcOperID == e.Node.Name);
txtOperID.Text = oper.vcOperID;
txtOperID.Enabled = false;
txtOperName.Text = oper.vcOperName;
txtOperPwd.Text = oper.vcOperPwd;
txtOperPwdConfirm.Text = oper.vcOperPwd;
cmbRole.SelectedValue = oper.vcLimit;
cmbOperLevel.SelectedValue = oper.vcOperLevel;
btnAdd.Text = "修改";
btnDelete.Visible = true;
//btnDelete.Visible = true;
}
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "选择角色出错");
}
}
private void frmBusiLogQuery_Load(object sender, EventArgs e)
{
dtpBegin.Value = DateTime.Now;
dtpEnd.Value = DateTime.Now;
tbOper operall = new tbOper();
operall.vcOperID = "全部";
operall.vcOperName = "全部";
List <tbOper> operlist = GlobalParams.Opers;
operlist.Insert(0, operall);
cmbOper.DataSource = operlist;
cmbOper.DisplayMember = "vcOperName";
cmbOper.ValueMember = "vcOperID";
dgvResult.AllowUserToAddRows = false;
dgvResult.AllowUserToDeleteRows = false;
dgvResult.AllowUserToResizeRows = true;
dgvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgvResult.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dgvResult.ReadOnly = true;
dgvResult.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtOperID.Text.Trim().Length == 0)
{
throw new Exception("请输入操作员帐号");
}
if (txtOperName.Text.Trim().Length == 0)
{
throw new Exception("请输入操作员名称");
}
if (txtOperPwd.Text.Trim().Length == 0)
{
throw new Exception("请输入密码");
}
if (txtOperPwdConfirm.Text.Trim().Length == 0)
{
throw new Exception("请输入密码确认");
}
if (!txtOperPwd.Text.Equals(txtOperPwdConfirm.Text))
{
throw new Exception("确认密码不一致");
}
using (AMSEntities amsContext = new AMSEntities())
{
switch (btnAdd.Text)
{
case "添加":
tbOper eOper = amsContext.tbOper.FirstOrDefault(o => o.vcOperID == txtOperID.Text || o.vcOperName == txtOperName.Text);
if (eOper != null)
{
throw new Exception("相同名称或者(帐号的操作员已存在");
}
tbOper nOper = new tbOper();
nOper.vcLimit = cmbRole.SelectedValue.ToString();
nOper.vcOperID = txtOperID.Text;
nOper.vcOperLevel = cmbOperLevel.SelectedValue.ToString(); //"OL001";
nOper.vcOperName = txtOperName.Text;
nOper.vcOperPwd = txtOperPwd.Text;
nOper.iFlag = 0;
amsContext.AddTotbOper(nOper);
amsContext.SaveChanges();
MessageBox.Show(this, "操作员添加成功", "添加操作员");
break;
case "修改":
int i = amsContext.tbOper.Count(o => o.vcOperName == txtOperName.Text);
if (i > 1)
{
throw new Exception("相同名称的操作员已存在");
}
tbOper oper = amsContext.tbOper.FirstOrDefault(o => o.vcOperID == txtOperID.Text);
oper.vcLimit = cmbRole.SelectedValue.ToString();
oper.vcOperName = txtOperName.Text;
oper.vcOperPwd = txtOperPwd.Text;
oper.vcOperLevel = cmbOperLevel.SelectedValue.ToString();
amsContext.SaveChanges();
MessageBox.Show(this, "操作员修改成功", "修改操作员");
break;
}
}
frmOper_Load(null, null);
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "操作员");
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
string strCardID = txtCardID.Text.Trim();
string strAssName = txtAssName.Text.Trim();
long BillNo = 0;
if (txtBillNo.Text.Trim() != "")
{
BillNo = long.Parse(txtBillNo.Text.Trim());
}
string strClass = cmbClass.Text.Trim();
string strOper = cmbOper.SelectedValue.ToString();
string strGoods = cmbConsName.Text.Trim();
DateTime dtBegin = new DateTime(dtpBegin.Value.Year, dtpBegin.Value.Month, dtpBegin.Value.Day, 0, 0, 0);
DateTime dtEnd = new DateTime(dtpEnd.Value.Year, dtpEnd.Value.Month, dtpEnd.Value.Day, 23, 59, 59);
using (AMSEntities amsContext = new AMSEntities())
{
var queryresult = from a in amsContext.vwAssConsRecord where a.dtConsDate >= dtBegin && a.dtConsDate <= dtEnd select a;
if (strCardID != "")
{
queryresult = queryresult.Where(a => a.vcAssCardID == strCardID);
}
if (strAssName != "")
{
queryresult = queryresult.Where(a => a.vcAssName.StartsWith(strAssName) || a.vcAssName.EndsWith(strAssName));
}
if (BillNo > 0)
{
queryresult = queryresult.Where(a => a.iBillNo == BillNo);
}
if (strClass != "全部")
{
queryresult = queryresult.Where(a => a.vcClass == strClass);
}
if (strOper != "全部")
{
queryresult = queryresult.Where(a => a.vcOperID == strOper);
}
if (strGoods != "全部")
{
queryresult = queryresult.Where(a => a.vcGoodsCode == strGoods);
}
queryresult = queryresult.OrderBy(a => a.vcAssCardID).ThenBy(a => a.iConsSerial).ThenBy(a => a.iNO);
decimal deSumFee = 0;
foreach (var dr in queryresult)
{
deSumFee += (decimal)dr.nConsCharge2;
}
foreach (var dr in queryresult)
{
tbOper oper1 = GlobalParams.Opers.FirstOrDefault(o => o.vcOperID == dr.vcOperID);
if (oper1 != null)
{
dr.vcOperID = oper1.vcOperName;
}
}
dgvResult.DataSource = queryresult;
dgvResult.Columns["iBillNo"].HeaderText = "帐单号";
dgvResult.Columns["iConsSerial"].HeaderText = "消费流水";
dgvResult.Columns["iNO"].HeaderText = "序号";
dgvResult.Columns["vcAssCardID"].HeaderText = "会员卡号";
dgvResult.Columns["vcAssName"].HeaderText = "会员姓名";
dgvResult.Columns["vcGoodsCode"].HeaderText = "消费项目";
dgvResult.Columns["nGoodsPrice"].HeaderText = "单价";
dgvResult.Columns["nLastBalance"].HeaderText = "消费前余额";
dgvResult.Columns["nConsCharge1"].HeaderText = "消费应收金额";
dgvResult.Columns["nConsRate"].HeaderText = "折扣";
dgvResult.Columns["nConsCharge2"].HeaderText = "消费实收金额";
dgvResult.Columns["nBalance"].HeaderText = "消费后余额";
dgvResult.Columns["dtConsDate"].HeaderText = "消费日期";
dgvResult.Columns["dtOperDate"].HeaderText = "操作日期";
dgvResult.Columns["vcFlag"].HeaderText = "消费记录状态";
dgvResult.Columns["iLink"].HeaderText = "相关返销流水";
dgvResult.Columns["vcOperID"].HeaderText = "操作员";
dgvResult.Columns["vcComments"].HeaderText = "备注ID";
dgvResult.Columns["vcClass"].HeaderText = "班次";
txtSumCount.Text = dgvResult.Rows.Count.ToString();
txtSumFee.Text = deSumFee.ToString();
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "查询异常");
}
}
