private void sbtnOk_Click(object sender, System.EventArgs e) { switch (label2.Text.Trim()) { case "Again": if (txtCardID.Text.Trim() == "" || txtCardID.Text.Trim().Length != 5) { MessageBox.Show("会员卡号不可为空且为5位,请重新填写会员卡号!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); txtCardID.Focus(); return; } Exception err = null; CommAccess cs = new CommAccess(SysInitial.ConString); if (!cs.ChkCardIDDup(txtCardID.Text.Trim(), out err)) { SysInitial.strTmp = txtCardID.Text.Trim(); } else { MessageBox.Show("该卡号已经被其他会员使用过,不能再使用,请重新输入!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); if (err != null) { clog.WriteLine(err); } txtCardID.Focus(); return; } break; default: break; } this.Close(); }
protected void RetailConsPrint(CMSMData.CMSMStruct.ConsItemStruct cis, CommAccess cs, string strSerialok, DataTable dtConsItem, double dTolCharge, double dPay, double dBalance, double dDiscount) { Exception err; string strConsTypeTmp = cis.strConsType; switch (cis.strConsType) { case "PT002": strConsTypeTmp = "支付现金"; break; case "PT005": strConsTypeTmp = "门店报损"; break; case "PT006": strConsTypeTmp = "门店品尝"; break; case "PT007": strConsTypeTmp = "门店退货"; break; case "PT008": strConsTypeTmp = "银行卡"; break; } string strEn = cs.GetEnterpriseName(out err); if (err != null) { MessageBox.Show("查询企业名称出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strEn = "道讯收银"; } DataTable dtNewItem = cs.GetNewGoods(out err); if (err != null) { MessageBox.Show("查询推荐新品出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); dtNewItem = new DataTable(); } string strTel = cs.GetTel2(out err); if (err != null) { MessageBox.Show("查询服务电话出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strTel = ""; } DataTable dtIgItem = new DataTable(); CMSM.Print.ConsTicket pBill = new CMSM.Print.ConsTicket(strSerialok, this.GetColCh(cis.strDeptID, "MD"), "", "", 0, 0, dtConsItem, dTolCharge, dDiscount, strConsTypeTmp, dPay, dBalance, dtNewItem, strTel, dtIgItem, 0, cis.strOperDate); Print(strEn, pBill); }
private void sbtnSet_Click(object sender, System.EventArgs e) { CMSMData.CMSMStruct.CommStruct cos = new CMSMData.CMSMStruct.CommStruct(); if (txtFee.Text.Trim() == "") { cos.strCommName = "0"; } else if (double.Parse(txtFee.Text.Trim()) < 0) { MessageBox.Show("消费金额不能小于0!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } else { cos.strCommName = txtFee.Text.Trim(); } if (txtIg.Text.Trim() == "") { cos.strCommCode = "0"; } else if (double.Parse(txtIg.Text.Trim()) < 0) { MessageBox.Show("赠送积分分值不能小于0!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } else { cos.strCommCode = txtIg.Text.Trim(); } cos.strCommSign = "IG"; cos.strComments = "积分赠送"; CommAccess cs = new CommAccess(SysInitial.ConString); Exception err = null; cs.UpdateIgComm(cos, out err); if (err == null) { MessageBox.Show("消费积分设置成功!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information); err = null; SysInitial.CreatDS(out err); if (err != null) { MessageBox.Show("系统出错,将自动关闭,稍后请重新登录系统!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); Application.Exit(); } return; } else { MessageBox.Show("消费积分设置失败!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); return; } }
private void sbtnOk_Click(object sender, System.EventArgs e) { CMSMStruct.OperStruct opsnew = new CMSMData.CMSMStruct.OperStruct(); opsnew.strLimit = SysInitial.CurOps.strLimit; string strpwdCon = ""; if (txtPwd.Text.Trim() == "" || txtPwd.Text.Trim().Length > 6) { MessageBox.Show("密码小于等于6位字符!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); txtPwd.Focus(); return; } else { opsnew.strPwd = txtPwd.Text.Trim(); } if (txtPwdConf.Text.Trim() == "" || txtPwdConf.Text.Trim().Length > 6) { MessageBox.Show("密码小于等于6位字符!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); txtPwdConf.Focus(); return; } else { strpwdCon = txtPwdConf.Text.Trim(); } if (opsnew.strPwd != strpwdCon) { MessageBox.Show("两次输入的密码不一致,请重新输入!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); this.txtPwd.Text = ""; this.txtPwdConf.Text = ""; this.txtPwd.Focus(); return; } CommAccess cs = new CommAccess(SysInitial.ConString); Exception err = null; cs.UpdateOper(SysInitial.CurOps, opsnew, out err); if (err != null) { MessageBox.Show("修改密码失败,请重试!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); this.Close(); } else { MessageBox.Show("修改密码成功,新密码将于下次登录时生效!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information); this.txtPwd.Text = ""; this.txtPwdConf.Text = ""; this.txtPwd.Focus(); } }
private void txtCardID_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) { if (e.KeyChar != 13) { if (e.KeyChar == 8 || e.KeyChar == 42) { return; } if (e.KeyChar < 48 || e.KeyChar > 57) { e.Handled = true; return; } } else { switch (label2.Text.Trim()) { case "Again": if (txtCardID.Text.Trim() == "" || txtCardID.Text.Trim().Length > 10) { MessageBox.Show("会员卡号不可为空且小于10位,请重新填写会员卡号!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); txtCardID.Focus(); return; } Exception err = null; CommAccess cs = new CommAccess(SysInitial.ConString); if (!cs.ChkCardIDDup(txtCardID.Text.Trim(), out err)) { SysInitial.strTmp = txtCardID.Text.Trim(); } else { MessageBox.Show("该卡已经有其他会员使用,请重新输入!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); if (err != null) { clog.WriteLine(err); } txtCardID.Focus(); return; } break; default: break; } this.Close(); } }
// 当日结账 protected void ChangeCheckPrint(CMSMData.CMSMStruct.DailyAccountStruct ffs, CommAccess cs, string strOperName, string strDeptName) { Exception err; CMSM.Print.PrintChangeCheck pBill = new CMSM.Print.PrintChangeCheck(); pBill.cnvcDateType = "当日结账"; pBill.cnvcOperName = ffs.strOper; DateTime dtnow = DateTime.Now; pBill.cnvcOperDate = dtnow.ToShortDateString() + dtnow.ToShortTimeString(); pBill.cnvcDeptName = strDeptName; pBill.cnvcFillCount = ffs.strFillCount; pBill.cnvcFillFee = ffs.strFillFee; pBill.cnvcFillCountBank = ffs.strFillCountBank; pBill.cnvcFillFeeBank = ffs.strFillFeeBank; pBill.cnvcConsCount = ffs.strConsCount; pBill.cnvcRetail = ffs.strRetail; pBill.cnvcRetailBank = ffs.strRetailBank; pBill.cnvcAssCons = ffs.strAssCons; pBill.cnvcRoll = ffs.strRoll; pBill.cnvcRollSum = ffs.strRollSum; pBill.cnvcLargCount = ffs.strLargCount; pBill.cnvcCash = ffs.strCash; string strEn = cs.GetEnterpriseName(out err); if (err != null) { MessageBox.Show("查询企业名称出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strEn = "道讯收银"; } string strTel = cs.GetTel2(out err); if (err != null) { MessageBox.Show("查询服务电话出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strTel = ""; } pBill.cnvcTel = strTel; Print(strEn, pBill); }
static public void GetLocalDept(out Exception e) { try { CommAccess ca = new CommAccess(ConString); Exception er = null; LocalDept = ca.GetLocalDept(out er); if (er != null) { e = er; return; } e = null; } catch (Exception err) { e = err; } }
protected void BusiPrint(CMSMData.CMSMStruct.BusiStruct ffs, CommAccess cs, string strOperName, string strDeptName) { Exception err; CMSM.Print.PrintBusi pBill = new CMSM.Print.PrintBusi(); pBill.strDateType = "业务量报表"; pBill.strNewAssCount = ffs.strNewAssCount; pBill.strLostAssCount = ffs.strLostAssCount; pBill.strFillFeeCount = ffs.strFillFeeCount; pBill.strFIllFee = ffs.strFIllFee; pBill.strBankFillFee = ffs.strBankFillFee; pBill.strAssConsCount = ffs.strAssConsCount; pBill.strAssCons = ffs.strAssCons; pBill.strRetailCount = ffs.strRetailCount; pBill.strRetail = ffs.strRetail; pBill.strSum = ffs.strSum; pBill.strOperName = ffs.strOperName; DateTime dtnow = DateTime.Now; pBill.strOperDate = dtnow.ToShortDateString() + dtnow.ToShortTimeString(); pBill.strDeptName = ffs.strDeptname; string strEn = cs.GetEnterpriseName(out err); if (err != null) { MessageBox.Show("查询企业名称出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strEn = "道讯收银"; } string strTel = cs.GetTel2(out err); if (err != null) { MessageBox.Show("查询服务电话出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strTel = ""; } pBill.cnvcTel = strTel; Print(strEn, pBill); }
protected void FillFeePrint(CMSMData.CMSMStruct.FillFeeStruct ffs, CommAccess cs, string strAssName, string strOperName, string strDeptName) { Exception err; CMSM.Print.PrintedBill pBill = new CMSM.Print.PrintedBill(); pBill.cnvcBillType = "充值"; pBill.cnvcMemberCardNo = ffs.strCardID; pBill.cnvcMemberName = strAssName; pBill.cnnLastBalance = Convert.ToDecimal(ffs.dFeeLast); pBill.cnnBalance = Convert.ToDecimal(ffs.dFeeCur); pBill.cnnPrepay = Convert.ToDecimal(ffs.dFillFee); pBill.cnnDonate = Convert.ToDecimal(ffs.dFillProm); pBill.cnvcOperName = strOperName; pBill.cndOperDate = Convert.ToDateTime(ffs.strFillDate); pBill.cnvcDeptName = strDeptName; string strEn = cs.GetEnterpriseName(out err); if (err != null) { MessageBox.Show("查询企业名称出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strEn = "道讯收银"; } string strTel = cs.GetTel2(out err); if (err != null) { MessageBox.Show("查询服务电话出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strTel = ""; } pBill.cnvcTel = strTel; Print(strEn, pBill); }
protected void ChangeCheckPrint(CMSMData.CMSMStruct.DailyAccountStruct ffs, CommAccess cs) { ChangeCheckPrint(ffs, cs, SysInitial.CurOps.strOperName, this.GetColCh(ffs.strDeptID, "MD")); }
protected void FillFeePrint(CMSMData.CMSMStruct.FillFeeStruct ffs, CommAccess cs, string strAssName) { FillFeePrint(ffs, cs, strAssName, SysInitial.CurOps.strOperName, this.GetColCh(ffs.strDeptID, "MD")); }
private void sbtnProm_Click(Object sender, System.EventArgs e) { CMSMData.CMSMStruct.CommStruct cos = new CMSMData.CMSMStruct.CommStruct(); Hashtable htpar = new Hashtable(); if (txtPromRate1.Text.Trim() == "") { cos.strCommCode = "0"; } else if (double.Parse(txtPromRate1.Text.Trim()) < 0) { MessageBox.Show("充值赠款比例不能小于0!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } else { cos.strCommCode = txtPromRate1.Text.Trim(); } cos.strCommName = "充值赠款100-500"; cos.strCommSign = "FP1"; cos.strComments = "充值赠款"; htpar.Add("FP1", cos); CMSMData.CMSMStruct.CommStruct cos2 = new CMSMData.CMSMStruct.CommStruct(); if (txtPromRate2.Text.Trim() == "") { cos2.strCommCode = "0"; } else if (double.Parse(txtPromRate2.Text.Trim()) < 0) { MessageBox.Show("充值赠款比例不能小于0!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } else { cos2.strCommCode = txtPromRate2.Text.Trim(); } cos2.strCommName = "充值赠款500-1000"; cos2.strCommSign = "FP2"; cos2.strComments = "充值赠款"; htpar.Add("FP2", cos2); CMSMData.CMSMStruct.CommStruct cos3 = new CMSMData.CMSMStruct.CommStruct(); if (txtPromRate3.Text.Trim() == "") { cos3.strCommCode = "0"; } else if (double.Parse(txtPromRate3.Text.Trim()) < 0) { MessageBox.Show("充值赠款比例不能小于0!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } else { cos3.strCommCode = txtPromRate3.Text.Trim(); } cos3.strCommName = "充值赠款1000以上"; cos3.strCommSign = "FP3"; cos3.strComments = "充值赠款"; htpar.Add("FP3", cos3); CommAccess cs = new CommAccess(SysInitial.ConString); Exception err = null; // cs.UpdateFillPromComm(htpar,out err); if (err == null) { MessageBox.Show("充值赠款比例设置成功!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information); err = null; SysInitial.CreatDS(out err); if (err != null) { MessageBox.Show("系统出错,将自动关闭,稍后请重新登录系统!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); Application.Exit(); } return; } else { MessageBox.Show("充值赠款比例设置失败!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); return; } }
static public void CreatDS(out Exception e) { try { e = null; string FileName = "comset.bet"; string filePath = Environment.CurrentDirectory; if (!System.IO.File.Exists(filePath + @"\" + FileName)) { intCom = 0; } else { StreamReader fReader = new StreamReader(filePath + @"\" + FileName); string strline = ""; if ((strline = fReader.ReadLine()) == null) { intCom = 0; } else { intCom = Int16.Parse(strline.Substring(8, strline.Length - 8)); } } CommAccess ca = new CommAccess(ConString); Exception er = null; LocalDeptName = ca.GetLocalDept(out LocalDeptName, out er); if (er != null) { e = er; return; } CommAccess ca1 = new CommAccess(ConString); LocalDeptID = ca1.GetLocalDept1(out LocalDeptID, out er); if (er != null) { e = er; return; } if (LocalDeptID == "") { LocalDeptIDTmp = ""; LocalDeptNameTmp = ""; } else { LocalDeptIDTmp = LocalDeptID.Substring(0, 4); LocalDeptNameTmp = LocalDeptName.Substring(0, 2); } con.ConnectionString = ConString; dsSys.Tables.Clear(); string sql; int recount = 0; sql = "select cnvcDeptID as cnvcCommCode,cnvcDeptName as cnvcCommName from tbDept where (cnvcLocalFlag is null or cnvcLocalFlag<>'LOCAL') and cnvcDeptID like '" + LocalDeptIDTmp + "%'"; daTmp = new SqlDataAdapter(sql, con); recount = daTmp.Fill(dsSys, "Dept"); recount = 0; sql = "select cnvcDeptID as cnvcCommCode,cnvcDeptName as cnvcCommName from tbDept where cnvcLocalFlag is null or cnvcLocalFlag<>'LOCAL' "; daTmp1 = new SqlDataAdapter(sql, con); recount = daTmp1.Fill(dsSys, "DeptTmp"); recount = 0; sql = "select cnvcDeptID as cnvcCommCode,cnvcDeptName as cnvcCommName from tbDept where cnvcDeptID like '" + LocalDeptID + "%'"; daTmp = new SqlDataAdapter(sql, con); recount = daTmp.Fill(dsSys, "AllDept"); if (recount == 0) { e = new Exception("参数不全"); return; } recount = 0; sql = "select * from tbOper where cnbValidate=1 and cnvcDeptID=(select top 1 cnvcDeptID from tbDept where cnvcLocalFlag='LOCAL')"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "Oper"); sql = "select * from tbCommCode where cnvcCommSign='MemState'"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "MemState"); sql = "select * from tbCommCode where cnvcCommSign='OPType'"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "OPType"); sql = "select distinct a.cnvcCommName as cnvcGoodsName,b.cnvcCommName as cnvcGoodsType from tbCommCode a,tbCommCode b where a.cnvcCommSign='GoodsName' and b.cnvcCommSign like 'GoodsType%' and b.cnvcCommSign='GoodsType'+a.cnvcCommCode"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "Goods"); sql = "select cnvcCompanyID,cnvcCompanyName,cnvcDeptID,cnvcDeptName from tbMebCompanyPrepay where cnbValidate=1 and cnvcDeptname like '" + LocalDeptNameTmp + "%' "; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "MebComp"); sql = "select cnvcDeliveryCompany from tbSpecialOilDept where cnvcDeliveryComPany like '" + LocalDeptNameTmp + "%' order by cnvcDeliveryCompany"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "SpecDelivery"); sql = "select * from tbCommCode where cnvcCommSign='TRANLOSE'"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "TRANLOSE"); sql = "select * from tbCommCode where cnvcCommSign='OFFSET'"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dsSys, "OFFSET"); htSpecOilDept = null; htSpecOilDept = new Hashtable(); DataTable dttmp = new DataTable(); sql = "select cnvcContractNo,cnvcDeliveryCompany from tbSpecialOilDept where cnvcDeliveryComPany like '" + LocalDeptNameTmp + "%' order by cnvcDeliveryCompany"; daTmp = new SqlDataAdapter(sql, con); daTmp.Fill(dttmp); if (dttmp.Rows.Count > 0) { string strDeliName = ""; ArrayList alContractList = null; for (int i = 0; i < dttmp.Rows.Count; i++) { if (strDeliName == dttmp.Rows[i]["cnvcDeliveryCompany"].ToString()) { alContractList.Add(dttmp.Rows[i]["cnvcContractNo"].ToString()); if (i == dttmp.Rows.Count - 1) { htSpecOilDept.Add(strDeliName, alContractList); } } else { if (strDeliName != "" && alContractList.Count > 0) { htSpecOilDept.Add(strDeliName, alContractList); } alContractList = new ArrayList(); alContractList.Add(dttmp.Rows[i]["cnvcContractNo"].ToString()); strDeliName = dttmp.Rows[i]["cnvcDeliveryCompany"].ToString(); if (i == dttmp.Rows.Count - 1) { htSpecOilDept.Add(strDeliName, alContractList); } } } } } catch (Exception err) { e = err; } }
static public void CreatDS(out Exception e) { try { string FileName = "comset.bet"; string filePath = Environment.CurrentDirectory; if (!System.IO.File.Exists(filePath + @"\" + FileName)) { intCom = 0; } else { StreamReader fReader = new StreamReader(filePath + @"\" + FileName); string strline = ""; if ((strline = fReader.ReadLine()) == null) { intCom = 0; } else { intCom = Int16.Parse(strline.Substring(8, strline.Length - 8)); } } CommAccess ca10 = new CommAccess(ConString); Exception er = null; LocalDeptName = ca10.GetLocalDept(out LocalDeptName, out er); if (er != null) { e = er; return; } con.ConnectionString = ConString; dsSys.Tables.Clear(); string sql; sql = "select * from tbCommCode where vcCommSign='AT' order by vcCommCode"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "AT"); sql = "select * from tbCommCode where vcCommSign='AT' and substring(vcComments,1,1)='Y' order by vcCommCode"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "AT1"); sql = "select * from tbCommCode where vcCommSign='AS'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "AS"); sql = "select * from tbCommCode where vcCommSign='ERR'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "ERR"); sql = "select * from tbCommCode where vcCommSign='GT'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "GoodsGT"); sql = "select * from tbCommCode where vcCommSign='OP'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "OP"); sql = "select distinct vcAssName,vcSpell from tbAssociator"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "AssSpell"); sql = "select distinct vcGoodsName,vcSpell from tbGoods"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "GoodsSpell"); sql = "select * from tbGoods"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "Goods"); sql = "select vcOperID,vcOperName,vcLimit,vcDeptID,IsDiscount from tbOper";// "select * from tbOper"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "Oper"); sql = "select * from tbCommCode where vcCommSign='LM' "; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "LM"); sql = "select * from tbCommCode where vcCommCode='LM003' and vcCommSign='LM'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "LM2"); sql = "select * from tbCommCode where vcCommCode<>'LM003' and vcCommSign='LM'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "LM3"); sql = "select * from tbCommCode where vcCommSign='IG'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "IG"); //sql="select * from tbCommCode where vcCommSign='FP1'"; sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP1-'+vcCommCode from tbCommCode where vcCommSign='local')) " + " select * from tbCommCode where vcCommSign=(select 'FP1-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP1'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "FP1"); //sql="select * from tbCommCode where vcCommSign='FP2'"; sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP2-'+vcCommCode from tbCommCode where vcCommSign='local')) " + " select * from tbCommCode where vcCommSign=(select 'FP2-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP2'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "FP2"); //sql="select * from tbCommCode where vcCommSign='FP3'"; sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP3-'+vcCommCode from tbCommCode where vcCommSign='local')) " + " select * from tbCommCode where vcCommSign=(select 'FP3-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP3'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "FP3"); //sql="select * from tbCommCode where vcCommSign='FP4'"; sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP4-'+vcCommCode from tbCommCode where vcCommSign='local')) " + " select * from tbCommCode where vcCommSign=(select 'FP4-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP4'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "FP4"); //sql="select * from tbCommCode where vcCommSign='FP5'"; sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP5-'+vcCommCode from tbCommCode where vcCommSign='local')) " + " select * from tbCommCode where vcCommSign=(select 'FP5-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP5'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "FP5"); sql = "select * from tbCommCode where vcCommSign='FP6'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "FP6"); sql = "select * from tbCommCode where vcCommSign='GT' order by vcCommCode "; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "GT"); sql = "select * from tbCommCode where vcCommSign='PT'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "PT"); sql = "select * from tbCommCode where vcCommSign='MD' and vcCommCode<>'CEN00'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "MD"); sql = "select * from tbCommCode where vcCommSign='BF'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "BF"); sql = "select * from tbCommCode where vcCommSign='DE'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "DE"); sql = "select * from tbCommCode where vcCommSign='ES'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "ES"); sql = "select * from tbCommCode where vcCommSign='OF'"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "OF"); sql = "select * from tbCommCode where vcCommSign='SFlag' and vcCommCode not in('1','2')"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dsSys, "SFlag"); DataTable dtoperfunc = new DataTable(); //sql="select * from tbOperFunc where vcFuncAddress in(select cnvcFuncAddress from tbFunc where cnvcFuncType='CS') order by vcOperID,vcFuncAddress"; sql = "select * from tbOperFunc order by vcOperID,vcFuncAddress"; daptmp = new SqlDataAdapter(sql, con); daptmp.Fill(dtoperfunc); ArrayList aloperfunc = new ArrayList(); hsOperFunc = new Hashtable(); foreach (DataRow dr in dtoperfunc.Rows) { if (hsOperFunc.ContainsKey(dr["vcOperID"].ToString())) { aloperfunc = (ArrayList)hsOperFunc[dr["vcOperID"].ToString()]; CMSMStruct.OperFuncStruct ops = new CMSMData.CMSMStruct.OperFuncStruct(); ops.strOperID = dr["vcOperID"].ToString(); ops.strFuncName = dr["vcFuncName"].ToString(); ops.strFuncAddress = dr["vcFuncAddress"].ToString(); aloperfunc.Add(ops); } else { aloperfunc = new ArrayList(); CMSMStruct.OperFuncStruct ops = new CMSMData.CMSMStruct.OperFuncStruct(); ops.strOperID = dr["vcOperID"].ToString(); ops.strFuncName = dr["vcFuncName"].ToString(); ops.strFuncAddress = dr["vcFuncAddress"].ToString(); aloperfunc.Add(ops); hsOperFunc.Add(dr["vcOperID"].ToString(), aloperfunc); } } con.Open(); sql = "select vcCommName from tbCommCode where vcCommSign='SPF' and vcCommCode='Q1'"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader drr = cmd.ExecuteReader(); drr.Read(); string strQLTime = drr[0].ToString(); drr.Close(); con.Close(); dtQLTime = new DateTime(int.Parse(strQLTime.Substring(0, 4)), int.Parse(strQLTime.Substring(5, 2)), int.Parse(strQLTime.Substring(8, 2))); CommAccess ca1 = new CommAccess(ConString); LocalDept = ca1.GetLocalDept(out er); if (er != null) { e = er; return; } CommAccess ca11 = new CommAccess(ConString); er = null; CP = ca11.GetCP(out er); if (er != null) { e = er; return; } CommAccess ca2 = new CommAccess(ConString); er = null; Card = ca2.GetCard(out er); if (er != null) { e = er; return; } CommAccess ca3 = new CommAccess(ConString); er = null; Tel = ca3.GetTel2(out er); if (er != null) { e = er; return; } CommAccess ca4 = new CommAccess(ConString); er = null; TP = ca4.GetTP(out er); if (er != null) { e = er; return; } er = null; MainDept = ca4.GetMainDept(out er); if (er != null) { e = er; return; } e = null; } catch (Exception err) { e = err; } }
protected void BusiPrint(CMSMData.CMSMStruct.BusiStruct ffs, CommAccess cs) { BusiPrint(ffs, cs, ffs.strOperName, ffs.strOperName); }
protected void AssIgPrint(CMSMData.CMSMStruct.CardHardStruct chs, CMSMData.CMSMStruct.ConsItemStruct cis, CommAccess cs, string strSerialok, DataTable dtIgItem, double dTolCharge) { Exception err; string strEn = cs.GetEnterpriseName(out err); if (err != null) { MessageBox.Show("查询企业名称出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strEn = "道讯收银"; } DataTable dtNewItem = cs.GetNewGoods(out err); if (err != null) { MessageBox.Show("查询推荐新品出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); dtNewItem = new DataTable(); } string strTel = cs.GetTel2(out err); if (err != null) { MessageBox.Show("查询服务电话出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); strTel = ""; } DataTable dtConsItem = new DataTable(); CMSM.Print.ConsTicket pBill = new CMSM.Print.ConsTicket(strSerialok, this.GetColCh(cis.strDeptID, "MD"), cis.strCardID, "当前余额", cis.dChargeLast, chs.dCurCharge, dtConsItem, dTolCharge, 0, "积分兑换", dTolCharge, 0, dtNewItem, strTel, dtIgItem, 0, cis.strOperDate); Print(strEn, pBill); }
private void RepeatPrint(string strSerial) { CommAccess cs = new CommAccess(SysInitial.ConString); Exception err; DataTable dtConsItem = cs.GetConsItemBySerial(out err, strSerial); if (err != null) { MessageBox.Show("查询消费明细出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); dtConsItem = new DataTable(); } DataTable dtBill = cs.GetBillBySerial(out err, strSerial); if (err != null) { MessageBox.Show("查询小票信息出错,请与管理员联系!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); dtBill = new DataTable(); } DataRow dr = dtBill.Rows[0]; CMSMData.CMSMStruct.ConsItemStruct cis = new CMSMData.CMSMStruct.ConsItemStruct(); cis.strCardID = dr["vcCardId"].ToString(); string strConsType = dr["vcConsType"].ToString(); cis.strConsType = strConsType; cis.dTRate = Convert.ToDouble(dr["nTRate"].ToString()); cis.dFee = Convert.ToDouble(dr["nFee"].ToString()); cis.dPay = Convert.ToDouble(dr["nPay"].ToString()); cis.dBalance = Convert.ToDouble(dr["nBalance"].ToString()); cis.iIgValue = Convert.ToInt32(dr["iIgValue"].ToString()); cis.strOperName = dr["vcOperName"].ToString(); cis.strOperDate = dr["dtConsDate"].ToString(); cis.strDeptID = dr["vcDeptId"].ToString(); CMSMData.CMSMStruct.CardHardStruct chs = new CMSMData.CMSMStruct.CardHardStruct(); switch (strConsType) { case "PT001": //会员刷卡 this.AssConsPrint(chs, cis, cs, strSerial, dtConsItem, cis.dFee); break; case "PT002": //支付现金 this.RetailConsPrint(cis, cs, strSerial, dtConsItem, cis.dFee, cis.dPay, cis.dBalance, cis.dTRate); break; case "PT003": //积分兑换 dtConsItem.Columns["Price"].ColumnName = "IgValue"; dtConsItem.Columns["Fee"].ColumnName = "IgPay"; this.AssIgPrint(chs, cis, cs, strSerial, dtConsItem, cis.dFee); break; case "PT004": //赠送商品 this.AssGiftPrint(chs, cis, cs, strSerial, dtConsItem, cis.dFee); break; case "PT005": this.RetailConsPrint(cis, cs, strSerial, dtConsItem, cis.dFee, cis.dPay, cis.dBalance, cis.dTRate); break; case "PT006": this.RetailConsPrint(cis, cs, strSerial, dtConsItem, cis.dFee, cis.dPay, cis.dBalance, cis.dTRate); break; case "PT007": this.RetailConsPrint(cis, cs, strSerial, dtConsItem, cis.dFee, cis.dPay, cis.dBalance, cis.dTRate); break; case "PT008": this.RetailConsPrint(cis, cs, strSerial, dtConsItem, cis.dFee, cis.dPay, cis.dBalance, cis.dTRate); break; } }