private void cmbIgEXGoods_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbIgEXGoods.Items.Count > 0)
{
using (AMSEntities amsContext = new AMSEntities())
{
string strGoodsCode = cmbIgEXGoods.SelectedValue.ToString();
tbCommCode IgExGoods1 = amsContext.tbCommCode.FirstOrDefault(cc => cc.vcCommSign == "EX" && cc.vcCommCode == strGoodsCode);
if (IgExGoods1 == null)
{
txtIgExCost.Text = "";
throw new Exception("获取积分兑换项目异常，请检查积分兑换项目的参数配置是否正确！");
}
else
{
txtIgExCost.Text = IgExGoods1.vcComments;
}
}
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "刷新异常");
}
}
private void frmAssInfoQuery_Load(object sender, EventArgs e)
{
txtPTAssCount.Text = "0";
txtPTSumCharge.Text = "0";
txtPTSumIG.Text = "0";
txtJKAssCount.Text = "0";
txtJKSumCharge.Text = "0";
txtJKSumIG.Text = "0";
dtpBegin.Value = DateTime.Now;
dtpEnd.Value = DateTime.Now;
tbCommCode allcomm = new tbCommCode();
allcomm.vcCommCode = "";
allcomm.vcCommName = "全部";
List <tbCommCode> AssLevel = GlobalParams.CommCode.Where(al => al.vcCommSign == "AL").OrderBy(al => al.vcCommCode).ToList();
AssLevel.Insert(0, allcomm);
cmbAssLevel.DataSource = AssLevel;
cmbAssLevel.DisplayMember = "vcCommName";
cmbAssLevel.ValueMember = "vcCommCode";
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 tabControl1_Selected(object sender, TabControlEventArgs e)
{
switch (e.TabPage.Name)
{
case "tabPage1":
BindGoods();
break;
case "tabPage2":
BindGoodsRate();
break;
case "tabPage3":
BindFillProm();
break;
case "tabPage4":
tbCommCode af = amsContext.tbCommCode.FirstOrDefault(c => c.vcCommSign == "AF" && c.vcCommName == "Awoke");
if (af != null)
{
if (af.vcCommCode == "1")
{
chkAF.Checked = true;
}
else
{
chkAF.Checked = false;
}
}
else
{
chkAF.Checked = true;
}
tbCommCode agf = amsContext.tbCommCode.FirstOrDefault(c => c.vcCommSign == "AGF" && c.vcCommName == "AgianFee");
if (agf != null)
{
txtAgf.Value = Convert.ToDecimal(agf.vcCommCode);
}
tbCommCode ak = amsContext.tbCommCode.FirstOrDefault(c => c.vcCommSign == "AK" && c.vcCommName == "Awoke");
if (ak != null)
{
txtAK.Value = Convert.ToDecimal(ak.vcCommCode);
}
BindCommCode();
break;
case "tabPage5":
BindOperLevel();
break;
case "tabPage6":
BindAL();
break;
}
}
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 btnRead_Click(object sender, EventArgs e)
{
int ret = 0;
try
{
//调用读卡函数
string strAssCardID = "";
ret = Helper.ReadCard(ref strAssCardID);
//strAssCardID = "00104";//测试用
if (ret != 0)
{
throw new Exception("卡操作异常");
}
if (strAssCardID == "")
{
throw new Exception("所刷卡卡号为空，请检查该卡片是否正确或被损坏！");
}
using (AMSEntities amsContext = new AMSEntities())
{
tbAssociatorCard asscard1 = amsContext.tbAssociatorCard.FirstOrDefault(ac => ac.vcAssCardID == strAssCardID);
if (asscard1 == null)
{
throw new Exception("该会员卡信息不存在，请检查！");
}
if (asscard1.cCardState != "1")
{
throw new Exception("该会员卡处于非正常在用状态，不能进行积分兑换！");
}
tbIntegral intg1 = amsContext.tbIntegral.FirstOrDefault(ig => ig.iAssID == asscard1.iAssID && ig.vcAssCardID == asscard1.vcAssCardID);
if (intg1 == null)
{
throw new Exception("获取会员卡余额和积分错误，请重试！");
}
tbAssociator ass1 = amsContext.tbAssociator.FirstOrDefault(a => a.iAssID == asscard1.iAssID);
if (ass1 == null)
{
throw new Exception("会员基本信息不存在，请重试！");
}
string strGoodsCode = cmbIgEXGoods.SelectedValue.ToString();
tbCommCode IgExGoods1 = amsContext.tbCommCode.FirstOrDefault(cc => cc.vcCommSign == "EX" && cc.vcCommCode == strGoodsCode);
if (IgExGoods1 == null)
{
txtIgExCost.Text = "";
throw new Exception("获取积分兑换项目异常！");
}
else
{
txtIgExCost.Text = IgExGoods1.vcComments;
}
txtCardID.Text = asscard1.vcAssCardID;
txtAssID.Text = asscard1.iAssID.ToString();
txtAssName.Text = ass1.vcAssName;
txtCurCharge.Text = intg1.nBalance.ToString();
txtCurIg.Text = intg1.iIgValue.ToString();
cmbIgEXGoods.Focus();
btnAdd.Enabled = true;
btnDel.Enabled = true;
btnPrint.Enabled = true;
btnRead.Enabled = false;
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "刷卡错误");
Helper.ShowError(this, Helper.ReadCardError(ret));
}
}
private void frmCardAdd_Load(object sender, EventArgs e)
{
try
{
cmbAssLevel.DataSource = GlobalParams.CommCode.Where(cc => cc.vcCommSign == ConstApp.AST).ToList();
cmbAssLevel.DisplayMember = "vcCommName";
cmbAssLevel.ValueMember = "vcCommCode";
cmbCardState.DataSource = GlobalParams.CommCode.Where(cc => cc.vcCommSign == ConstApp.CST).ToList();
cmbCardState.DisplayMember = "vcCommName";
cmbCardState.ValueMember = "vcCommCode";
List <tbCommCode> agf = GlobalParams.CommCode.Where(cc => cc.vcCommSign == ConstApp.AGF).ToList <tbCommCode>();
if (agf.Count < 1)
{
throw new Exception("补发卡工本费参数有误，请检查参数设置！");
}
tbCommCode ccagf = agf[0];
if (!Helper.IsNum(ccagf.vcCommCode.Trim()))
{
throw new Exception("补发卡工本费参数有误，请检查参数设置！");
}
dBusiFee = Convert.ToDecimal(ccagf.vcCommCode.Trim());
if (string.IsNullOrEmpty(AssCardID))
{
throw new Exception("请首先查询选择可进行补发卡的会员卡信息");
}
lblAgf.Text = dBusiFee.ToString();
using (AMSEntities amsContext = new AMSEntities())
{
assCard = amsContext.tbAssociatorCard.FirstOrDefault(ac => ac.vcAssCardID == AssCardID && ac.iAssID == AssID);
if (assCard == null)
{
throw new Exception("未找到相应的会员卡信息，请重试");
}
ass = amsContext.tbAssociator.FirstOrDefault(a => a.iAssID == AssID);
if (ass == null)
{
throw new Exception("未找到相应的会员信息，请重试");
}
ig = amsContext.tbIntegral.FirstOrDefault(i => i.iAssID == AssID && i.vcAssCardID == AssCardID);
txtAssCardID.Text = assCard.vcAssCardID;
txtAssName.Text = ass.vcAssName;
if (ig != null)
{
txtBalance.Text = ig.nBalance.ToString();
txtIg.Text = ig.iIgValue.ToString();
}
cmbAssLevel.SelectedValue = ass.vcAssState;
cmbCardState.SelectedValue = assCard.cCardState;
dtpPutCardDate.Value = Convert.ToDateTime(assCard.dtCardPutDate);
dtpExpDate.Value = Convert.ToDateTime(assCard.dtCardExpDate);
}
}
catch (Exception ex)
{
btnPrint.Enabled = false;
btnCardAdd.Enabled = false;
lblCardAdd.Visible = false;
txtCardAdd.Visible = false;
ErrorLog.Write(this, ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
tbCommCode af = amsContext.tbCommCode.FirstOrDefault(c => c.vcCommSign == "AF" && c.vcCommName == "Awoke");
if (af != null)
{
if (chkAF.Checked)
{
af.vcCommCode = "1";
}
else
{
af.vcCommCode = "0";
}
}
else
{
af = new tbCommCode();
af.vcComments = "是否启用自动提醒";
af.vcCommName = "Awoke";
af.vcCommSign = "AF";
if (chkAF.Checked)
{
af.vcCommCode = "1";
}
else
{
af.vcCommCode = "0";
}
amsContext.AddTotbCommCode(af);
}
tbCommCode agf = amsContext.tbCommCode.FirstOrDefault(c => c.vcCommSign == "AGF" && c.vcCommName == "AgianFee");
if (agf != null)
{
agf.vcCommCode = txtAgf.Value.ToString();
}
else
{
agf = new tbCommCode();
agf.vcComments = "补发卡工本费金额";
agf.vcCommName = "AgianFee";
agf.vcCommSign = "AGF";
agf.vcCommCode = txtAgf.Value.ToString();
amsContext.AddTotbCommCode(agf);
}
tbCommCode ak = amsContext.tbCommCode.FirstOrDefault(c => c.vcCommSign == "AK" && c.vcCommName == "Awoke");
if (ak != null)
{
ak.vcCommCode = txtAK.Value.ToString();
}
else
{
ak = new tbCommCode();
ak.vcComments = "自动提醒积分分值";
ak.vcCommName = "Awoke";
ak.vcCommSign = "AK";
ak.vcCommCode = txtAK.Value.ToString();
amsContext.AddTotbCommCode(ak);
}
Helper.Save(amsContext);
MessageBox.Show(this, "修改成功", "提示");
}
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();
string strAssLevel = cmbAssLevel.SelectedValue.ToString();
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.vwAssInfoRecord where a.dtOperDate >= dtbegin && a.dtOperDate <= 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 (strAssLevel != "")
{
queryresult = queryresult.Where(a => a.vcAssLevel == strAssLevel);
}
queryresult = queryresult.OrderBy(a => a.vcAssCardID);
int sumPTCount = 0;
decimal sumPTCharge = 0;
decimal sumPTIg = 0;
int sumJKCount = 0;
decimal sumJKCharge = 0;
decimal sumJKIg = 0;
foreach (var dr in queryresult)
{
tbCommCode asslevel = GlobalParams.CommCode.FirstOrDefault(al => al.vcCommSign == "AL" && al.vcCommCode == dr.vcAssLevel);
dr.vcAssLevel = asslevel.vcCommName;
if (dr.cCardState.Trim() == "")
{
dr.cCardState = "";
}
else
{
tbCommCode assCardState = GlobalParams.CommCode.FirstOrDefault(al => al.vcCommSign == "CST" && al.vcCommCode == dr.cCardState);
dr.cCardState = assCardState.vcCommName;
}
tbCommCode assPutCardFlag = GlobalParams.CommCode.FirstOrDefault(al => al.vcCommSign == "AST" && al.vcCommCode == dr.vcAssState);
dr.vcAssState = assPutCardFlag.vcCommName;
if (dr.vcAssLevel == "普通会员")
{
sumPTCount++;
sumPTCharge += (decimal)dr.nBalance;
sumPTIg += (decimal)dr.iIgValue;
}
if (dr.vcAssLevel == "金卡会员")
{
sumJKCount++;
sumJKCharge += (decimal)dr.nBalance;
sumJKIg += (decimal)dr.iIgValue;
}
}
dgvResult.DataSource = queryresult;
dgvResult.Columns["iAssID"].HeaderText = "会员ID";
dgvResult.Columns["vcAssCardID"].HeaderText = "会员卡号";
dgvResult.Columns["vcAssName"].HeaderText = "会员名称";
dgvResult.Columns["vcAssLevel"].HeaderText = "会员级别";
dgvResult.Columns["nBalance"].HeaderText = "卡余额";
dgvResult.Columns["iIgValue"].HeaderText = "积分";
dgvResult.Columns["FillSum"].HeaderText = "充值总额";
dgvResult.Columns["FillCount"].HeaderText = "充值次数";
dgvResult.Columns["FillAvg"].HeaderText = "平均充值";
dgvResult.Columns["ConsSum"].HeaderText = "消费总额";
dgvResult.Columns["ConsCount"].HeaderText = "消费次数";
dgvResult.Columns["ConsAvg"].HeaderText = "平均消费";
dgvResult.Columns["FillProm"].HeaderText = "赠金总额";
dgvResult.Columns["cAssSex"].HeaderText = "性别";
dgvResult.Columns["vcMobile"].HeaderText = "手机号码";
dgvResult.Columns["iAssAge"].HeaderText = "年龄";
dgvResult.Columns["vcAssNbr"].HeaderText = "身份证号";
dgvResult.Columns["vcPassPort"].HeaderText = "护照号码";
dgvResult.Columns["vcLinkAddress"].HeaderText = "家庭联系地址";
dgvResult.Columns["vcLinkPhone"].HeaderText = "家庭联系电话";
dgvResult.Columns["vcPostID"].HeaderText = "住址邮编";
dgvResult.Columns["vcEmail"].HeaderText = "Email";
dgvResult.Columns["vcCompanyName"].HeaderText = "公司名称";
dgvResult.Columns["vcComPhone"].HeaderText = "公司电话";
dgvResult.Columns["vcComFax"].HeaderText = "公司传真";
dgvResult.Columns["vcComAddress"].HeaderText = "公司地址";
dgvResult.Columns["vcComPostID"].HeaderText = "公司邮编";
dgvResult.Columns["dtCardPutDate"].HeaderText = "发卡日期";
dgvResult.Columns["cCardState"].HeaderText = "卡状态";
dgvResult.Columns["dtCardEffDate"].HeaderText = "卡生效日期";
dgvResult.Columns["dtCardExpDate"].HeaderText = "卡失效日期";
dgvResult.Columns["vcAssState"].HeaderText = "是否发卡";
dgvResult.Columns["dtInAssDate"].HeaderText = "入会日期";
dgvResult.Columns["vcComments"].HeaderText = "备注";
dgvResult.Columns["dtOperDate"].HeaderText = "操作日期";
dgvResult.Columns["iAssID"].Visible = false;
dgvResult.Columns.Remove("iAssID");
txtPTAssCount.Text = sumPTCount.ToString();
txtPTSumCharge.Text = sumPTCharge.ToString();
txtPTSumIG.Text = sumPTIg.ToString();
txtJKAssCount.Text = sumJKCount.ToString();
txtJKSumCharge.Text = sumJKCharge.ToString();
txtJKSumIG.Text = sumJKIg.ToString();
}
}
catch (Exception ex)
{
ErrorLog.Write(this, ex, "查询异常");
}
}
