private void btnCard_Click(object sender, System.EventArgs e) { try { UltraGridRow row = this.ultraGrid1.ActiveRow; if (null == row) { throw new BusinessException("重新发卡", "请从查询结果中选择进行发卡的会员资料"); } if (txtMemberCardNo.Text.Trim().Length == 0) { throw new BusinessException("重新发卡", "请输入卡号"); } string strNewMemberCardNo = txtMemberCardNo.Text; //row.Cells["cnvcMemberCardNo"].Value.ToString(); // if (strNewMemberCardNo.StartsWith("A")||strNewMemberCardNo.StartsWith("B")) // { // throw new BusinessException("重新发卡","卡号必须为数字,现在卡号是:"+strNewMemberCardNo); // } // if (strNewMemberCardNo.Trim().Length < 8) // { // throw new BusinessException("重新发卡","卡号必须8位"); // } if (strNewMemberCardNo.Trim().Length < 8) { throw new BusinessException("重新发卡", "会员卡号必须是8位!"); } else { //string strMemberCardNo = txtMemberCardNo.Text.Trim(); if (strNewMemberCardNo.Equals("00000000")) { throw new BusinessException("重新发卡", "会员卡号不能都为零"); } else { //判断卡号是否存在 DataTable dtIsMember = Helper.Query("select * from tbMember where cnvcMemberCardNo = '" + strNewMemberCardNo + "'"); if (dtIsMember.Rows.Count > 0) { throw new BusinessException("重新发卡", "会员卡号已存在"); } } } string strMemberCardNo = row.Cells["cnvcOldMemberCardNo"].Value.ToString(); DataTable dtMember = Helper.Query("select * from tbMember where cnvcState='" + ConstApp.Card_State_NoCard + "' and cnvcMemberCardNo ='" + strMemberCardNo + "'"); if (dtMember.Rows.Count != 1) { throw new BusinessException("重新发卡", "未找到相应的会员资料"); } Member member = new Member(dtMember); //member.cnvcMemberCardNo = strNewMemberCardNo; member.cnvcProduct = strNewMemberCardNo; member.cnvcOperName = this.oper.cnvcOperName; member.cndOperDate = DateTime.Now; DataTable dtMemberProduct = Helper.Query("select * from tbMemberProduct where cnvcMemberCardNo = '" + strMemberCardNo + "'"); string strProduct = ""; foreach (DataRow drProduct in dtMemberProduct.Rows) { MemberProduct product = new MemberProduct(drProduct); strProduct += product.cnvcProductName + ",,,," + product.cnvcFree + ",|"; } DialogResult dr = MessageBox.Show(this, "【会员卡号】" + member.cnvcProduct + "\n【工商注册号】" + member.cnvcPaperNo + "\n【单位名称】" + member.cnvcMemberName, "信息确认", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { PrintedBill pBill = new PrintedBill(member.ToTable()); pBill.cnvcMemberCardNo = strNewMemberCardNo; pBill.cnvcBillType = ConstApp.Bill_Type_Provide; pBill.cnvcProduct = strProduct; MemberManageFacade mm = new MemberManageFacade(); mm.RenewCard(member, pBill); pBill.cnvcProduct = ""; Helper.PrintTicket(pBill); MessageBox.Show(this, "发卡成功!", "发卡"); this.txtMemberCardNo.Text = ""; this.txtPPaperNo.Text = ""; this.txtPMemberName.Text = ""; this.txtPrepay.Text = ""; } } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ultraButton1_Click(object sender, System.EventArgs e) { try { #region 数据验证 this.txtMemberName_Validated(null, null); this.txtPaperNo_Validated(null, null); this.cmbTrade_Validated(null, null); this.cmbEnterpriseType_Validated(null, null); string strMemberNameError = this.errorProvider1.GetError(txtMemberName); string strPaperNoError = this.errorProvider1.GetError(txtPaperNo); string strTrade = this.errorProvider1.GetError(cmbTrade); string strEnterpriseType = this.errorProvider1.GetError(cmbEnterpriseType); if (strMemberNameError.Length > 0) { throw new BusinessException("添加非会员信息", strMemberNameError); } if (strPaperNoError.Length > 0) { throw new BusinessException("添加非会员信息", strPaperNoError); } if (cmbEnterpriseType.Text == "") { throw new BusinessException("发卡", "企业性质不能为空!"); } if (cmbTrade.Text == "") { throw new BusinessException("发卡", "行业不能为空!"); } #endregion DataTable dtFMember = Helper.Query("select * from tbFMember where cnvcPaperNo='" + txtPaperNo.Text + "'"); if (dtFMember.Rows.Count > 0) { throw new BusinessException("添加非会员信息", "相同工商注册号的非会员已存在"); } // DataTable dtMember = Helper.Query("select * from tbMember where cnvcPaperNo='"+txtPaperNo.Text+"'"); // // if (dtMember.Rows.Count > 0) // { // throw new BusinessException("添加非会员信息","相同工商注册号的会员已存在"); // } FMember member = new FMember(); member.cnvcComments = txtCommnets.Text; member.cnvcEmail = txtEmail.Text; member.cnvcEnterpriseType = cmbEnterpriseType.Text; member.cnvcCompanyAddress = txtLinkAddress.Text; member.cnvcCorporation = txtCorporation.Text; member.cnvcLinkman = txtLinkman.Text; member.cnvcLinkPhone = txtLinkPhone.Text; member.cnvcMemberName = txtMemberName.Text; member.cnvcPaperNo = txtPaperNo.Text; member.cnvcOperName = this.oper.cnvcOperName; member.cndOperDate = DateTime.Now; member.cndInNetDate = member.cndOperDate; member.cnvcMobileTelePhone = txtMobileTelephone.Text; member.cnvcPostalCode = txtPostalcode.Text; member.cnvcSales = cmbSales.Text; member.cnvcHandleman = cmbHandleMan.Text; member.cnvcHandlemanPaperNo = txtHandleManPaperNo.Text; member.cnvcTrade = cmbTrade.Text; member.cnvcCustomerService = cmbCustomerService.Text; member.cnvcFax = txtFax.Text; MemberManageFacade mm = new MemberManageFacade(); mm.AddFMember(member); //strMemberName = txtMemberName.Text; //strPaperNo = txtPaperNo.Text; //MessageBox.Show(this,"添加非会员信息成功!","添加非会员信息!",MessageBoxButtons.OK,MessageBoxIcon.Information); DialogResult dr = MessageBox.Show(this, "恭喜!添加非会员信息成功!\r 继续添加吗?", "添加非会员信息!", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { //清空继续发卡 ClearText(); } else { this.Close(); } } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ultraButton1_Click(object sender, System.EventArgs e) { //充值缴费 try { UltraGridRow row = this.ultraGrid1.ActiveRow; if (null == row) { throw new BusinessException("服务产品消费", "请选择会员或者非会员"); } ArrayList alProduct = new ArrayList(); PrintedBill pBill = new PrintedBill(); string strProduct = ""; if (txtMemberCardNo.Text == "") { //非会员 foreach (UltraGridRow selRow in this.ultraGrid2.Rows) { string strSelected = selRow.Cells["cnvcIsSelected"].Value.ToString(); bool bSelected = bool.Parse(strSelected); if (bSelected) { FMemberProductLog productLog = new FMemberProductLog(); productLog.cndOperDate = DateTime.Now; productLog.cnvcOperName = this.oper.cnvcOperName; productLog.cnvcPaperNo = txtPaperNo.Text; productLog.cnvcMemberName = txtMemberName.Text; productLog.cnvcProductName = selRow.Cells["cnvcProductName"].Value.ToString(); productLog.cnnProductPrice = Decimal.Parse(selRow.Cells["cnnProductPrice"].Value.ToString()); productLog.cnvcProductDiscount = selRow.Cells["cnnProductDiscount"].Value.ToString(); productLog.cnnPrepay = Decimal.Parse(selRow.Cells["cnnPrepay"].Value.ToString()); productLog.cnvcFree = selRow.Cells["cnvcFree"].Value.ToString(); alProduct.Add(productLog); strProduct += productLog.cnvcProductName + "," + productLog.cnnProductPrice.ToString() + "," + productLog.cnvcProductDiscount + "," + productLog.cnnPrepay + "," + productLog.cnvcFree + ",|"; } } if (alProduct.Count < 1) { throw new BusinessException("服务产品消费", "请选择充值产品"); } if (txtPrepay.Text != "") { pBill.cnnPrepay = Decimal.Parse(txtPrepay.Text); } pBill.cndOperDate = DateTime.Now; pBill.cnvcOperName = this.oper.cnvcOperName; pBill.cnvcPaperNo = txtPaperNo.Text; pBill.cnvcMemberName = txtMemberName.Text; pBill.cnvcProduct = strProduct; pBill.cnvcBillType = ConstApp.Bill_Type_Product_Consume; MemberManageFacade mm = new MemberManageFacade(); mm.ConsumeProduct(alProduct, false, "", pBill); } else { //会员 foreach (UltraGridRow selRow in this.ultraGrid2.Rows) { string strSelected = selRow.Cells["cnvcIsSelected"].Value.ToString(); bool bSelected = bool.Parse(strSelected); if (bSelected) { MemberProductLog productLog = new MemberProductLog(); productLog.cndOperDate = DateTime.Now; productLog.cnvcOperName = this.oper.cnvcOperName; productLog.cnvcMemberCardNo = txtMemberCardNo.Text; productLog.cnvcPaperNo = txtPaperNo.Text; productLog.cnvcMemberName = txtMemberName.Text; productLog.cnvcProductName = selRow.Cells["cnvcProductName"].Value.ToString(); productLog.cnnProductPrice = Decimal.Parse(selRow.Cells["cnnProductPrice"].Value.ToString()); productLog.cnvcProductDiscount = selRow.Cells["cnnProductDiscount"].Value.ToString(); productLog.cnnPrepay = Decimal.Parse(selRow.Cells["cnnPrepay"].Value.ToString()); productLog.cnvcFree = selRow.Cells["cnvcFree"].Value.ToString(); alProduct.Add(productLog); strProduct += productLog.cnvcProductName + "," + productLog.cnnProductPrice.ToString() + "," + productLog.cnvcProductDiscount + "," + productLog.cnnPrepay + "," + productLog.cnvcFree + ",|"; } } if (alProduct.Count < 1) { throw new BusinessException("服务产品消费", "请选择充值产品"); } if (txtPrepay.Text != "") { pBill.cnnPrepay = Decimal.Parse(txtPrepay.Text); } pBill.cndOperDate = DateTime.Now; pBill.cnvcOperName = this.oper.cnvcOperName; pBill.cnvcMemberCardNo = txtMemberCardNo.Text; pBill.cnvcPaperNo = txtPaperNo.Text; pBill.cnvcMemberName = txtMemberName.Text; pBill.cnvcProduct = strProduct; pBill.cnvcBillType = ConstApp.Bill_Type_Product_Consume; MemberManageFacade mm = new MemberManageFacade(); mm.ConsumeProduct(alProduct, true, "", pBill); } Helper.PrintTicket(pBill); this.btnQuery_Click(null, null); MessageBox.Show(this, "充值缴费成功!", "服务产品消费"); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnInMoney_Click(object sender, System.EventArgs e) { //充值 try { if (txtInMoney.Text.Trim().Length == 0) { throw new BusinessException("充值", "充值金额不能为空"); } if (txtFree.Text.Trim().Length == 0) { throw new BusinessException("充值", "场次不能为空"); } // if (null == cmbShow.SelectedItem) // { // throw new BusinessException("充值","请选择招聘会"); // } UltraGridRow row = this.ultraGrid1.ActiveRow; if (null == row) { throw new BusinessException("充值", "请选择充值的会员"); } string strFree = row.Cells["cnvcFree"].Value.ToString(); if (strFree == ConstApp.Free_Time_NoLimit) { MessageBox.Show("场次,\"" + ConstApp.Free_Time_NoLimit + "\"将被修改成" + txtFree.Text, "充值"); } DialogResult dr2 = MessageBox.Show(this, "【会员卡号:" + txtMemberCardNo.Text + "】\n【单位名称:" + txtMemberName.Text + "】\n【工商注册号:" + txtPaperNo.Text + "】\n【充值金额:" + txtInMoney.Text + "】\n", "充值信息确认", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr2 == DialogResult.Yes) { Member member = new Member(); member.cnvcMemberCardNo = txtMemberCardNo.Text; member.cnnPrepay = Decimal.Parse(txtInMoney.Text); member.cnvcFree = txtFree.Text; member.cnvcOperName = this.oper.cnvcOperName; member.cnvcPaperNo = txtPaperNo.Text; member.cndOperDate = DateTime.Now; member.cnvcMemberName = txtMemberName.Text; MemberManageFacade memberManage = new MemberManageFacade(); PrintedBill pBill = new PrintedBill(member.ToTable()); pBill.cnvcBillType = ConstApp.Bill_Type_InMoney; memberManage.MemberInMoney(member, pBill); //pMember = member; DialogResult dr = MessageBox.Show(this, "恭喜!充值成功。打印小票吗?\n【否】继续充值,\n【取消】关闭充值界面。", "充值成功", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { //清空进行充值操作 Helper.PrintTicket(pBill); //this.ultraPrintDocument1.Print(); // txtInMoney.Text = ""; // txtFree.Text = ""; btnQuery_Click(null, null); } else if (dr == DialogResult.No) { txtInMoney.Text = ""; //txtFree.Text = ""; } else { this.Close(); } } } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnMemberModify_Click(object sender, System.EventArgs e) { try { UltraGridRow row = this.ultraGrid2.ActiveRow; if (null == row) { throw new BusinessException("会员参数设置", "请选择会员参数"); } if (cmbMember.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择会员类型"); } if (cmbMemberType.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择参数类型"); } string strType = row.Cells["cnvcMemberType"].Value.ToString(); string strValue = row.Cells["cnvcMemberValue"].Value.ToString(); if (strType != cmbMemberType.Text) { throw new BusinessException("会员参数设置", "参数类型不能修改"); } string strSql = "select * from tbMemberCode where cnvcMemberName ='" + cmbMember.Text + "' and cnvcMemberType='" + cmbMemberType.Text + "'"; DataTable dtMemberCode = Helper.Query(strSql); if (dtMemberCode.Rows.Count == 0) { throw new BusinessException("会员参数设置", "【会员类型+参数类型】不存在"); } if (txtMemberValue.Text.Trim().Length == 0) { throw new BusinessException("会员参数设置", "请输入参数值"); } if (!txtMemberValue.Text.Equals(ConstApp.Free_Time_NoLimit)) { int.Parse(txtMemberValue.Text); if (int.Parse(txtMemberValue.Text) < 0) { throw new BusinessException("会员参数设置", "请输入正数"); } if (strValue == txtMemberValue.Text) { throw new BusinessException("会员参数设置", "请修改参数值"); } } MemberCode memberCode = new MemberCode(dtMemberCode); memberCode.cnnMemberCodeID = int.Parse(row.Cells["cnnMemberCodeID"].Value.ToString()); memberCode.cnvcMemberType = cmbMemberType.Text; memberCode.cnvcMemberValue = txtMemberValue.Text; MemberManageFacade memberManage = new MemberManageFacade(); memberManage.ModifyMemberCode(memberCode); MessageBox.Show(this, "会员参数修改成功!", "会员参数设置", MessageBoxButtons.OK, MessageBoxIcon.Information); cmbMember_ValueChanged(null, null); SysInit.LoadPara(Login.constApp); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message + "\n参数异常,请核查", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnModify_Click(object sender, System.EventArgs e) { try { UltraGridRow row = this.ultraGrid1.ActiveRow; if (null == row) { throw new BusinessException("参数设置", "请选择参数"); } if (cmbType.SelectedItem == null) { throw new BusinessException("参数设置", "请选择参数类型"); } if (txtValue.Text.Trim().Length == 0) { throw new BusinessException("参数设置", "请输入参数值"); } string strType = row.Cells["cnvcType"].Value.ToString(); string strValue = row.Cells["cnvcValue"].Value.ToString(); if (strType != cmbType.Text) { throw new BusinessException("参数设置", "参数类型不能修改"); } if (strValue == txtValue.Text) { throw new BusinessException("参数设置", "请修改参数值"); } DataTable dtNameCode = Helper.Query("select * from tbNameCode where cnvcType='" + cmbType.Text + "' and cnvcValue='" + txtValue.Text + "'"); if (dtNameCode.Rows.Count > 0) { throw new BusinessException("参数设置", "【参数类型】+【参数值】已存在"); } if (cmbType.Text == ConstApp.TouchFlash) { //JudgeOne(cmbType.Text); int.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.TouchBookBeginDate || cmbType.Text == ConstApp.TouchBookEndDate || cmbType.Text == ConstApp.TouchSignInBeginDate || cmbType.Text == ConstApp.TouchSignInEndDate ) { //JudgeOne(cmbType.Text); if (txtValue.Text.IndexOf(":") < 0) { throw new BusinessException("会员参数设置", "请输入时间格式,例如05:01"); } //string strValue = txtValue.Text; string[] strValues = txtValue.Text.Split(':'); // string strHour = strValues[0]; // string strMinute = strValues[1]; int.Parse(strValues[0]); int.Parse(strValues[1]); } if (cmbType.Text == ConstApp.BookDate) { int.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.tishi) { int.Parse(txtValue.Text); } NameCode nameCode = new NameCode(dtNameCode); nameCode.cnvcCodeID = int.Parse(row.Cells["cnvcCodeID"].Value.ToString()); nameCode.cnvcType = cmbType.Text; nameCode.cnvcValue = txtValue.Text; MemberManageFacade memberManage = new MemberManageFacade(); memberManage.ModifyNameCode(nameCode); MessageBox.Show(this, "参数修改成功!", "会员参数设置", MessageBoxButtons.OK, MessageBoxIcon.Information); BindNamecode(); BindMemberRight(); cmbMember_ValueChanged(null, null); SysInit.LoadPara(Login.constApp); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message + "\n参数异常,请核查", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnAdd_Click(object sender, System.EventArgs e) { try { if (cmbType.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择参数类型"); } if (txtValue.Text.Trim().Length == 0) { throw new BusinessException("会员参数设置", "请输入参数值"); } DataTable dtNameCode = Helper.Query("select * from tbNameCode where cnvcType='" + cmbType.Text + "' and cnvcValue='" + txtValue.Text + "'"); if (dtNameCode.Rows.Count > 0) { throw new BusinessException("会员参数设置", "【参数类型】+【参数值】已存在"); } if (cmbType.Text == ConstApp.TouchFlash) { JudgeOne(cmbType.Text); int.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.TouchBookBeginDate || cmbType.Text == ConstApp.TouchBookEndDate || cmbType.Text == ConstApp.TouchSignInBeginDate || cmbType.Text == ConstApp.TouchSignInEndDate ) { JudgeOne(cmbType.Text); if (txtValue.Text.IndexOf(":") < 0) { throw new BusinessException("会员参数设置", "请输入时间格式,例如05:01"); } string strValue = txtValue.Text; string[] strValues = strValue.Split(':'); string strHour = strValues[0]; string strMinute = strValues[1]; int.Parse(strHour); int.Parse(strMinute); } if (cmbType.Text == ConstApp.BookDate) { JudgeOne(cmbType.Text); int.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.NetBookBeforeDate) { JudgeOne(cmbType.Text); int.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.tishi) { JudgeOne(cmbType.Text); int.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.JobListBeginDate || cmbType.Text == ConstApp.JobBookingListBeginDate || cmbType.Text == ConstApp.JobBookingListEndDate || cmbType.Text == ConstApp.JobRemainListBeginDate || cmbType.Text == ConstApp.JobRemainListEndDate) { JudgeOne(cmbType.Text); DateTime.Parse(txtValue.Text); } if (cmbType.Text == ConstApp.JobListEndDate) { JudgeOne(cmbType.Text); DateTime.Parse(txtValue.Text); } NameCode nameCode = new NameCode(); nameCode.cnvcType = cmbType.Text; nameCode.cnvcValue = txtValue.Text; if (cmbType.Text == ConstApp.JobListBeginDate || cmbType.Text == ConstApp.JobListEndDate || cmbType.Text == ConstApp.JobBookingListBeginDate || cmbType.Text == ConstApp.JobBookingListEndDate || cmbType.Text == ConstApp.JobRemainListBeginDate || cmbType.Text == ConstApp.JobRemainListEndDate) { nameCode.cnvcValue = Convert.ToDateTime(txtValue.Text).ToString("yyyy-MM-dd"); } MemberManageFacade memberManage = new MemberManageFacade(); memberManage.AddNameCode(nameCode); MessageBox.Show(this, "参数添加成功!", "会员参数设置", MessageBoxButtons.OK, MessageBoxIcon.Information); BindNamecode(); BindMemberRight(); cmbMember_ValueChanged(null, null); SysInit.LoadPara(Login.constApp); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }