/// <summary> /// 退墓 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem24_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int rowHandle = gridView1.FocusedRowHandle; V_AC01_REPORT ac01 = null; if (rowHandle >= 0) { ac01 = xpCollection_ac01[gridView1.GetDataSourceRowIndex(rowHandle)] as V_AC01_REPORT; FA01 fa01 = unitOfWork1.GetObjectByKey <FA01>(ac01.AC048, true); if (fa01 != null) { if (fa01.FA190 == '2' /*开具部分发票*/) { Tools.msg(MessageBoxIcon.Warning, "提示", "该购墓尚有未开具的发票!"); return; } } Frm_tombRefund frm_1 = new Frm_tombRefund(); frm_1.swapdata["ac01"] = ac01; if (frm_1.ShowDialog() == DialogResult.OK) { this.RefreshData(); } frm_1.Dispose(); } }
private void Frm_refund_Load(object sender, EventArgs e) { s_fa001 = this.swapdata["fa001"].ToString(); string s_criteria = string.Empty; s_criteria = "SA010 = '" + s_fa001 + "'"; CriteriaOperator criteria = CriteriaOperator.Parse(s_criteria); xpCollection1.Criteria = criteria; xpCollection1.LoadingEnabled = true; fa01 = unitOfWork1.GetObjectByKey <FA01>(s_fa001); if (fa01 == null) { Tools.msg(MessageBoxIcon.Warning, "提示", "检索数据错误!"); sb_ok.Enabled = false; } }
private void sb_ok_Click(object sender, EventArgs e) { bool b_payrecord = false; if (!checkBeforeSave()) { return; } try { s_fa001 = MiscAction.GetEntityPK("FA01"); //1.购墓登记 ac01 = new AC01(unitOfWork1); ac01.AC001 = s_ac001; //购墓登记编号 ac01.AC002 = te_ac002.Text; //购墓人身份证号 ac01.AC003 = te_ac003.Text; //购墓人 ac01.AC004 = te_ac004.Text; //联系电话 ac01.AC005 = te_ac005.Text; //联系地址 ac01.AC012 = bi01.RE001; //排编号 ac01.AC010 = bi01.RG001; //墓区编号 ac01.AC015 = bi01.BI001; //墓位编号 ac01.AC020 = Convert.ToDecimal(bi01.PRICE); //墓位定价 ac01.AC022 = Convert.ToDecimal(te_price.Text); //售价 ac01.AC038 = Convert.ToInt32(te_free_nums.Text); //免费管理年限 ac01.AC049 = Convert.ToDateTime(de_ac049.Text); //购墓日期 //管理费到期日期 if (ac01.AC038 > 0) { ac01.AC040 = ac01.AC049.AddYears(ac01.AC038); b_payrecord = true; } else { int rowHandle = gridView1.LocateByValue("SA003", "管理费"); if (rowHandle >= 0) { ac01.AC040 = ac01.AC049.AddYears(Convert.ToInt32(gridView1.GetRowCellValue(rowHandle, "NUMS"))); b_payrecord = true; } else { ac01.AC040 = ac01.AC049; } } ac01.AC042 = '1'; //缴费状态 ac01.AC048 = s_fa001; //缴费流水号 ac01.AC100 = Envior.cur_userId; //经办人 ac01.AC200 = Tools.GetServerDate(); //经办日期 ac01.AC250 = te_ac250.Text; //备注 ac01.AC300 = '1'; //登记类型 1-正常登记 0-原始登记 ac01.STATUS = '1'; //当前状态 ac01.Save(); //2.销售项目 foreach (SA01 sa01 in xpCollection_sa01) { sa01.SA008 = '1'; //结算状态 sa01.SA010 = s_fa001; //结算流水号 sa01.SA020 = 'T'; //发票类型 sa01.SA100 = Envior.cur_userId; //经办人 sa01.SA200 = Tools.GetServerDate(); //经办日期 sa01.Save(); if (sa01.SA003 == "管理费" /*如果是管理费*/ && sa01.SA002 == '1') { //插入缴费表 PR01 pr01 = new PR01(unitOfWork1); pr01.PR001 = s_fa001; pr01.AC001 = s_ac001; pr01.PR002 = ac01.AC049; //缴费开始日期 pr01.PR003 = ac01.AC049.AddYears(Convert.ToInt32(sa01.NUMS)); pr01.PRICE = sa01.PRICE; pr01.NUMS = sa01.NUMS; pr01.PR007 = sa01.SA007; pr01.PR008 = '1'; pr01.PR100 = Envior.cur_userId; pr01.PR200 = Tools.GetServerDate(); pr01.STATUS = '1'; pr01.Save(); } } //3.号位信息 bi01.STATUS = '2'; //已使用 bi01.PRICE = Convert.ToDecimal(te_fixprice.Text); //定价 bi01.BI005 = le_mx.EditValue.ToString(); //墓型 bi01.AC001 = s_ac001; //购墓登记编号 bi01.Save(); //4.财务收费信息 dec_total = dec_sales + Convert.ToDecimal(te_price.Text); FA01 fa01 = new FA01(unitOfWork1); fa01.FA001 = s_fa001; //缴费流水号 fa01.AC001 = s_ac001; //购墓流水号 fa01.FA002 = '0'; //收费类型 0-购墓 fa01.FA003 = te_ac003.Text; //缴费人 fa01.FA004 = dec_total; //收费金额 fa01.FA190 = '0'; //开票标志-未开票 fa01.FA100 = Envior.cur_userId; //收费人 fa01.FA180 = MiscAction.GetTombPosition(bi01.BI001); //备注(墓穴位置) fa01.FA200 = Tools.GetServerDate(); //缴费时间 fa01.STATUS = "1"; //状态 fa01.WS001 = Envior.WORKSTATIONID; //工作站标识 fa01.Save(); //如果是预定的记录 if (bk01 != null && s_action == "bookin") { bk01.STATUS = '2'; //已登记 bk01.Save(); } unitOfWork1.CommitTransaction(); ///设置附加信息 BusinessAction.SetExtraInfo(s_ac001); int i_papers = BusinessAction.GetInvoicePapers(s_fa001); if (XtraMessageBox.Show("登记办理成功!\r\n" + "本次结算共需要" + i_papers.ToString() + "张发票,现在开具吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { sb_ok.Enabled = false; //获取税务客户信息 string s_ac003 = te_ac003.Text; Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(s_ac003); if (frm_taxClient.ShowDialog() != DialogResult.OK) { return; } TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo; CriteriaOperator criteria = CriteriaOperator.Parse("FA001='" + s_fa001 + "'"); XPCollection <FP01> xpCollection_fp01 = new XPCollection <FP01>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, unitOfWork1, criteria); foreach (FP01 fp01 in xpCollection_fp01) { if (TaxInvoice.GetNextInvoiceNo() > 0) { if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { TaxInvoice.Invoice(fp01.FP001, clientInfo); } } } } ////打印证书 if (XtraMessageBox.Show("现在打印【购墓证书】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.PrintCert(s_ac001); } if (b_payrecord && XtraMessageBox.Show("现在打印【缴费记录】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.PrintPayRecord(s_fa001); } ////打印购墓协议 //if (XtraMessageBox.Show("现在打印【购墓协议】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) //{ // PrintAction.PrintProtocol(s_ac001); //} this.Close(); } catch (Exception ee) { unitOfWork1.RollbackTransaction(); Tools.msg(MessageBoxIcon.Error, "错误", ee.ToString()); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void sb_ok_Click(object sender, EventArgs e) { string s_fa001 = string.Empty; FA01 fa01 = null; SA01 sa01 = null; BI01 bi01 = null; AC01 ac01_m = null; REFUND refund = null; int i_invoice_num; if (XtraMessageBox.Show("确认要进行退墓操作,本操作将不可撤销,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } if (decimal.TryParse(te_refund.Text, out dec_tomb)) { if (dec_tomb <= 0 || dec_tomb > ac01.AC022) { te_refund.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight; te_refund.ErrorText = "退费金额错误!"; return; } } else { te_refund.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight; te_refund.ErrorText = "请输入退购墓费!"; return; } try { s_fa001 = MiscAction.GetEntityPK("FA01"); //2.保存销售记录 sa01 = new SA01(unitOfWork1); sa01.SA001 = MiscAction.GetEntityPK("SA01"); //销售流水号 sa01.AC001 = ac01.AC001; //购墓流水号 sa01.SA002 = '0'; //服务或商品类别 0-购墓费 1-商品或服务 2-管理费 sa01.SA003 = "购墓费"; sa01.SA004 = ac01.AC015; //墓位编号 sa01.SA005 = '0'; //业务类型 0-购墓 1-临时销售 sa01.PRICE = dec_tomb; //单价 sa01.NUMS = -1; //数量 sa01.SA007 = 0 - dec_tomb; //金额 sa01.SA006 = sa01.SA007; //原始单价 sa01.SA008 = '1'; //结算状态 1-已结算 0-未结算 sa01.SA010 = s_fa001; //结算流水号 sa01.SA020 = 'T'; //发票类型 sa01.SA025 = MiscAction.GetSysParaValue1("tomb_taxrate"); //税率 sa01.SA100 = Envior.cur_userId; //经办人 sa01.SA200 = Tools.GetServerDate(); //经办日期 sa01.STATUS = '1'; //状态 1-正常 0-删除 sa01.Save(); for (int i = 0; i < gridView1.RowCount; i++) { if (!gridView1.IsRowSelected(i)) { continue; } sa01 = new SA01(unitOfWork1); sa01.SA001 = MiscAction.GetEntityPK("SA01"); //销售流水号 sa01.AC001 = ac01.AC001; //购墓流水号 sa01.SA002 = '1'; //服务或商品类别 0-购墓费 1-商品或服务 2-管理费 sa01.SA003 = gridView1.GetRowCellValue(i, "SA003").ToString(); //项目名称 sa01.SA004 = gridView1.GetRowCellValue(i, "SA004").ToString(); //项目编号 sa01.SA005 = '0'; //业务类型 0-购墓 1-临时销售 sa01.PRICE = Convert.ToDecimal(gridView1.GetRowCellValue(i, "PRICE")); //单价 sa01.NUMS = 0 - Convert.ToDecimal(gridView1.GetRowCellValue(i, "NUMS")); //数量 sa01.SA007 = 0 - Convert.ToDecimal(gridView1.GetRowCellValue(i, "SA007")); //金额 sa01.SA006 = sa01.SA007; //原始单价 sa01.SA008 = '1'; //结算状态 1-已结算 0-未结算 sa01.SA010 = s_fa001; //结算流水号 sa01.SA020 = 'T'; //发票类型 sa01.SA025 = BusinessAction.GetTaxRate(sa01.SA004); //税率 sa01.SA100 = Envior.cur_userId; //经办人 sa01.SA200 = Tools.GetServerDate(); //经办日期 sa01.STATUS = '1'; //状态 1-正常 0-删除 sa01.Save(); } //3.保存退费日志 refund = new REFUND(unitOfWork1); refund.RF001 = s_fa001; refund.RF003 = te_reason.Text; refund.RF004 = 0 - (dec_tomb + dec_sales); refund.RF100 = Envior.cur_userId; refund.RF200 = Tools.GetServerDate(); refund.RF300 = ac01.AC048; //原结算流水号 refund.Save(); ///4.保存缴费记录 fa01 = new FA01(unitOfWork1); fa01.FA001 = s_fa001; //结算流水号 fa01.FA002 = '0'; //结算类型 0-购墓 1-服务祭品 2-管理费 fa01.FA003 = ac01.AC003; //购墓人 fa01.FA004 = 0 - (dec_tomb + dec_sales); //金额 fa01.FA190 = '0'; //开票标志 0-未开票 fa01.FA100 = Envior.cur_userId; //经办人 fa01.FA200 = Tools.GetServerDate(); //经办日期 fa01.STATUS = "1"; //状态 fa01.AC001 = ac01.AC001; fa01.WS001 = Envior.WORKSTATIONID; //工作站 fa01.Save(); //5.修改ac01 ac01_m = unitOfWork1.GetObjectByKey <AC01>(ac01.AC001, true); ac01_m.STATUS = '2'; //状态-退墓 ac01_m.Save(); //6.修改号位状态 bi01 = unitOfWork1.GetObjectByKey <BI01>(ac01.AC015, true); if (bi01 != null) { bi01.AC001 = ""; bi01.STATUS = '1'; bi01.Save(); } unitOfWork1.CommitTransaction(); i_invoice_num = BusinessAction.GetInvoicePapers(s_fa001); if (i_invoice_num == 0) { Tools.msg(MessageBoxIcon.Information, "提示", "退墓成功!"); } else { if (XtraMessageBox.Show("退墓办理成功!\r\n" + "本次业务共需要" + i_invoice_num.ToString() + "张发票,现在开具吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { sb_ok.Enabled = false; //获取税务客户信息 string s_ac003 = te_ac003.Text; Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(s_ac003); if (frm_taxClient.ShowDialog() != DialogResult.OK) { return; } TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo; CriteriaOperator criteria = CriteriaOperator.Parse("FA001='" + s_fa001 + "'"); XPCollection <FP01> xpCollection_fp01 = new XPCollection <FP01>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, unitOfWork1, criteria); foreach (FP01 fp01 in xpCollection_fp01) { if (TaxInvoice.GetNextInvoiceNo() > 0) { if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { TaxInvoice.Invoice(fp01.FP001, clientInfo); } } } } } this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ee) { unitOfWork1.RollbackTransaction(); Tools.msg(MessageBoxIcon.Error, "错误", ee.ToString()); } }
/// <summary> /// 结算 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridView1.RowCount <= 0) { XtraMessageBox.Show("请先选择项目!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrEmpty(be_cuname.Text)) { be_cuname.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight; be_cuname.ErrorText = "交款人或单位必须输入!"; return; } //if (string.IsNullOrEmpty(te_billno.Text)) //{ // XtraMessageBox.Show("尚未输入单据号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); // return; //} //1.检查是否有单价为0的项目 for (int i = 0; i < gridView1.RowCount; i++) { if (gridView1.GetRowCellValue(i, "PRICE") != null && Convert.ToDecimal(gridView1.GetRowCellValue(i, "PRICE")) <= 0) { gridView1.FocusedRowHandle = i; XtraMessageBox.Show("项目单价尚未设置!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } SA01 sa01 = null; string s_fa001 = MiscAction.GetEntityPK("FA01"); string s_cuname = be_cuname.Text; string s_billno = te_billno.Text; decimal dec_sum = decimal.Zero; for (int i = 0; i < gridView1.RowCount; i++) { sa01 = xpCollection1[gridView1.GetDataSourceRowIndex(i)] as SA01; sa01.SA010 = s_fa001; sa01.SA008 = "1"; dec_sum += sa01.SA007; } FA01 fa01 = new FA01(unitOfWork1); fa01.FA001 = s_fa001; fa01.FA002 = "1"; //交费类型 1-临时性销售 fa01.FA003 = s_cuname; //交款人 fa01.FA004 = dec_sum; fa01.FA100 = Envior.cur_user.UC001; fa01.FA200 = MiscAction.GetServerTime(); fa01.WS001 = Envior.workstationId; fa01.FA099 = s_billno; fa01.STATUS = "1"; try { unitOfWork1.CommitChanges(); XtraMessageBox.Show("办理成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); if (XtraMessageBox.Show("现在打印【收据】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.Print_Skpz0(s_fa001); } be_cuname.Text = ""; te_billno.Text = ""; CriteriaOperator criteria = CriteriaOperator.Parse("1<0"); xpCollection1.Criteria = criteria; xpCollection1.Criteria = null; be_cuname.Focus(); } catch (Exception ee) { unitOfWork1.RollbackTransaction(); LogUtils.Error(ee.Message); XtraMessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void sb_ok_Click(object sender, EventArgs e) { decimal dec_total = decimal.Zero; string s_new_fa001 = string.Empty; SA01 sa01 = null; FA01 fa01_new = null; if (gridView1.GetSelectedRows().Length == 0) { Tools.msg(MessageBoxIcon.Exclamation, "提示", "请先选择要退费的项目!"); return; } try { dec_total = Convert.ToDecimal(te_total.EditValue); s_new_fa001 = MiscAction.GetEntityPK("FA01"); for (int i = 0; i < gridView1.RowCount; i++) { if (!gridView1.IsRowSelected(i)) { continue; } sa01 = new SA01(unitOfWork1); sa01.SA001 = MiscAction.GetEntityPK("SA01"); //销售流水号 sa01.AC001 = fa01.AC001; //购墓流水号 sa01.SA002 = fa01.FA002 == '2' ? '2':'1'; //服务或商品类别 0-购墓费 1-商品或服务 2-管理费 sa01.SA003 = gridView1.GetRowCellValue(i, "SA003").ToString(); //项目名称 sa01.SA004 = gridView1.GetRowCellValue(i, "SA004").ToString(); //项目编号 sa01.SA005 = fa01.FA002; //业务类型 0-购墓 1-临时销售 sa01.PRICE = Convert.ToDecimal(gridView1.GetRowCellValue(i, "PRICE")); //单价 sa01.NUMS = 0 - Convert.ToDecimal(gridView1.GetRowCellValue(i, "NUMS")); //数量 sa01.SA007 = 0 - Convert.ToDecimal(gridView1.GetRowCellValue(i, "SA007")); //金额 sa01.SA006 = sa01.SA007; //原始单价 sa01.SA008 = '1'; //结算状态 1-已结算 0-未结算 sa01.SA010 = s_new_fa001; //结算流水号 sa01.SA020 = 'T'; //发票类型 sa01.SA025 = BusinessAction.GetTaxRate(sa01.SA004); //税率 sa01.SA100 = Envior.cur_userId; //经办人 sa01.SA200 = Tools.GetServerDate(); //经办日期 sa01.STATUS = '1'; //状态 1-正常 0-删除 sa01.Save(); } //2.保存退费日志 refund = new REFUND(unitOfWork1); refund.RF001 = s_new_fa001; refund.RF003 = te_reason.Text; refund.RF004 = 0 - dec_total; refund.RF100 = Envior.cur_userId; refund.RF200 = Tools.GetServerDate(); refund.RF300 = s_fa001; //原结算流水号 refund.Save(); ///3.保存缴费记录 fa01_new = new FA01(unitOfWork1); fa01_new.FA001 = s_new_fa001; //结算流水号 fa01_new.FA002 = fa01.FA002; //结算类型 0-购墓 1-服务祭品 2-管理费 fa01_new.FA003 = fa01.FA003; //缴款人 fa01_new.FA004 = 0 - dec_total; //金额 fa01_new.FA190 = '0'; //开票标志 0-未开票 fa01_new.FA100 = Envior.cur_userId; //经办人 fa01_new.FA200 = Tools.GetServerDate(); //经办日期 fa01_new.STATUS = "1"; //状态 fa01_new.AC001 = fa01.AC001; fa01_new.WS001 = Envior.WORKSTATIONID; //工作站 fa01_new.Save(); unitOfWork1.CommitTransaction(); int i_invoice_num = BusinessAction.GetInvoicePapers(s_new_fa001); if (i_invoice_num == 0) { Tools.msg(MessageBoxIcon.Information, "提示", "退费办理成功!"); } else { if (XtraMessageBox.Show("退费办理成功!\r\n" + "本次业务共需要" + i_invoice_num.ToString() + "张发票,现在开具吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { sb_ok.Enabled = false; //获取税务客户信息 string s_fa003 = fa01.FA003; Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(s_fa003); if (frm_taxClient.ShowDialog() != DialogResult.OK) { return; } TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo; CriteriaOperator criteria = CriteriaOperator.Parse("FA001='" + s_fa001 + "'"); XPCollection <FP01> xpCollection_fp01 = new XPCollection <FP01>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, unitOfWork1, criteria); foreach (FP01 fp01 in xpCollection_fp01) { if (TaxInvoice.GetNextInvoiceNo() > 0) { if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { TaxInvoice.Invoice(fp01.FP001, clientInfo); } } } } } this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ee) { unitOfWork1.RollbackTransaction(); Tools.msg(MessageBoxIcon.Error, "错误", ee.ToString()); } }
private void sb_ok_Click(object sender, EventArgs e) { if (!gridView1.PostEditor()) { return; } if (!gridView1.UpdateCurrentRow()) { return; } if (!SaveCheck()) { return; //数据合法性校验!!! } string s_billno = string.Empty; //0.再次判断寄存号位 是否占用 if (RegAction.GetBitStatus(regionId, i_bi005, bitDesc) != "9") { XtraMessageBox.Show("当前号位无效或已被占用!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //1.生成寄存记录 int i_months = Convert.ToInt32(comboBox1.Text); rc01 = new RC01(unitOfWork1); if (s_source == "1" /*外来寄存*/) { rc01.RC001 = MiscAction.GetEntityPK("RC01"); } else if (s_source == "0" || s_source == "8") { rc01.RC001 = txtEdit_rc001.Text; } rc01.RC002 = rg_rc002.EditValue.ToString(); //逝者性别 rc01.RC202 = rg_rc202.EditValue.ToString(); //逝者性别2 rc01.RC003 = txtEdit_rc003.Text; //逝者姓名 rc01.RC303 = txtEdit_rc303.Text; //逝者姓名2 rc01.RC004 = Convert.ToInt32(txtEdit_rc004.EditValue); //逝者年龄 rc01.RC404 = txtEdit_rc404.EditValue == null ? 0 : Convert.ToInt32(txtEdit_rc404.EditValue); rc01.RC014 = txtedit_rc014.Text; //身份证号 rc01.RC050 = txtEdit_rc050.Text; //联系人 rc01.RC051 = txtEdit_rc051.Text; //联系电话 rc01.RC052 = lookUp_rc052.EditValue.ToString(); //与逝者关系 rc01.RC055 = txtEdit_ac055.Text; //联系地址 rc01.RC099 = mem_rc099.Text; //备注 rc01.RC109 = RegAction.GenRegisterNo(s_source == "2" ? "1" : "0"); if (s_source == "0" || s_source == "8") { rc01.SOURCE = "0"; //本馆火化 } else if (s_source == "1") { rc01.SOURCE = "1"; } //状态 if (s_source == "8") { rc01.STATUS = "8"; } else { rc01.STATUS = "1"; } rc01.RC110 = RegAction.GetRoomIdByBitId(bitId); //寄存室编号 rc01.RC120 = regionId; //寄存架号 rc01.RC130 = bitId; //寄存号位 rc01.RC140 = MiscAction.GetServerTime(); //寄存日期 rc01.RC150 = rc01.RC140.AddMonths(i_months); //寄存到期日期 rc01.RC100 = Envior.cur_user.UC001; //经办人 rc01.RC200 = MiscAction.GetServerTime(); ///2.寄存费缴费记录表 string s_fa001 = MiscAction.GetEntityPK("FA01"); if (s_source == "0" || s_source == "1") //本馆火化 或外来寄存 { RC04 rc04 = new RC04(unitOfWork1); rc04.RC001 = rc01.RC001; rc04.RC010 = s_fa001; //结算流水号 rc04.RC020 = MiscAction.GetServerTime(); //缴费开始时间 rc04.RC022 = rc01.RC150; //缴费截至时间 rc04.PRICE = bitPrice; //单价 rc04.NUMS = Convert.ToInt32(comboBox1.Text); //缴费期限 rc04.RC030 = rc04.PRICE * rc04.NUMS; //寄存费金额 rc04.RC031 = "1"; //0-原始登记 1-正常交费 rc04.RC100 = Envior.cur_user.UC001; //经办人 rc04.RC200 = MiscAction.GetServerTime(); rc04.STATUS = "1"; } ///3.插入销售表 SA01 sa01 = new SA01(unitOfWork1); sa01.SA001 = MiscAction.GetEntityPK("SA01"); sa01.SA002 = "08"; //项目类别 08-寄存费 sa01.AC001 = rc01.RC001; //逝者编号 sa01.SA003 = "寄存费"; sa01.SA004 = bitId; sa01.SA005 = "2"; //销售业务类型 2-骨灰寄存 sa01.PRICE = bitPrice; sa01.NUMS = Convert.ToInt32(comboBox1.Text); sa01.SA007 = sa01.PRICE * sa01.NUMS; sa01.SA006 = bitPrice; sa01.SA008 = s_source == "8" ? "0" : "1"; sa01.SA010 = s_source == "8" ? "" : s_fa001; sa01.SA100 = Envior.cur_user.UC001; //经办人 sa01.SA200 = MiscAction.GetServerTime(); sa01.STATUS = "1"; ///4.处理附件销售. foreach (SA01 s in xpCollection_sa01) { s.SA001 = MiscAction.GetEntityPK("SA01"); s.SA002 = "13"; s.AC001 = rc01.RC001; s.SA003 = FireAction.Mapper_Item(s.SA004); s.SA005 = "2"; // 销售类别 0 - 火化业务 1 - 临时性销售 2骨灰寄存 s.SA008 = s_source == "8" ? "0" : "1"; s.SA010 = s_source == "8" ? "" : s_fa001; s.SA100 = Envior.cur_user.UC001; //经办人 s.SA200 = MiscAction.GetServerTime(); s.STATUS = "1"; } ////5. 处理财务结算表 if (s_source == "0" || s_source == "1") { FA01 fa01 = new FA01(unitOfWork1); fa01.FA001 = s_fa001; fa01.FA002 = "2"; //收费业务类型 2-寄存 fa01.FA003 = rc01.RC003; fa01.FA004 = regfee + fpfee; fa01.FA100 = Envior.cur_user.UC001; fa01.FA200 = MiscAction.GetServerTime(); fa01.FA099 = s_billno; fa01.WS001 = Envior.workstationId; fa01.AC001 = rc01.RC001; fa01.STATUS = "1"; } ////6. 处理号位表 BI01 bi01 = unitOfWork1.GetObjectByKey <BI01>(bitId); bi01.BI010 = rc01.RC001; if (s_source == "0" || s_source == "1") { bi01.STATUS = "1"; } else if (s_source == "8") { bi01.STATUS = "8"; } try { unitOfWork1.CommitChanges(); string s_tip = string.Empty; if (s_source == "0" || s_source == "1") { s_tip = "办理成功,现在打印【收据】"; } else { s_tip = "办理成功!"; } XtraMessageBox.Show(s_tip, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ////打印收据 if (s_source == "0" || s_source == "1") { //Frm_InputBill frm_bill = new Frm_InputBill(); //if (frm_bill.ShowDialog() == DialogResult.OK) //{ // s_billno = frm_bill.swapdata["billno"].ToString(); //} //frm_bill.Dispose(); //if (!string.IsNullOrEmpty(s_billno)) //{ PrintAction.Print_Skpz1(s_fa001); //MiscAction.SetFinanceBill(s_fa001, s_billno); //} } ////todo 2.打印寄存证 if (s_source == "0" || s_source == "1" || s_source == "2") { XtraMessageBox.Show("现在准备打印【寄存证】!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); PrintAction.Print_RegCardBase(rc01.RC001); } if (XtraMessageBox.Show("现在打印【骨灰安放卡】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.Print_RegSettle(rc01.RC001); } this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ee) { unitOfWork1.RollbackTransaction(); LogUtils.Error(ee.Message); XtraMessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void sb_ok_Click(object sender, EventArgs e) { if (!checkBeforeSave()) { return; } try { s_fa001 = MiscAction.GetEntityPK("FA01"); //保存销售记录 foreach (SA01 sa01 in xpCollection_sa01) { sa01.SA008 = '1'; //结算状态 sa01.SA010 = s_fa001; //结算流水号 sa01.SA020 = 'T'; //发票类型 sa01.SA100 = Envior.cur_userId; //经办人 sa01.SA200 = Tools.GetServerDate(); //经办日期 dec_sum += sa01.SA007; } //财务收费信息 FA01 fa01 = new FA01(unitOfWork1); fa01.FA001 = s_fa001; //缴费流水号 fa01.FA002 = '1'; //收费类型 0-购墓 1-服务祭品 2-管理费 fa01.FA003 = te_cuname.Text; //缴费人 fa01.FA004 = dec_sum; //收费金额 fa01.FA190 = '0'; //开票标志 0-未开票 fa01.FA100 = Envior.cur_userId; //收费人 fa01.FA180 = ""; //备注 fa01.FA200 = Tools.GetServerDate(); //缴费时间 fa01.STATUS = "1"; //状态 fa01.WS001 = Envior.WORKSTATIONID; //工作站标识 fa01.Save(); unitOfWork1.CommitTransaction(); //////////保存完成 ////////// int i_papers = BusinessAction.GetInvoicePapers(s_fa001); if (XtraMessageBox.Show("办理成功!\r\n" + "本次结算共需要" + i_papers.ToString() + "张发票,现在开具吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { sb_ok.Enabled = false; //获取税务客户信息 string s_ac003 = te_cuname.Text; Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(s_ac003); if (frm_taxClient.ShowDialog() != DialogResult.OK) { return; } TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo; CriteriaOperator criteria = CriteriaOperator.Parse("FA001='" + s_fa001 + "'"); XPCollection <FP01> xpCollection_fp01 = new XPCollection <FP01>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, unitOfWork1, criteria); foreach (FP01 fp01 in xpCollection_fp01) { if (TaxInvoice.GetNextInvoiceNo() > 0) { if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { TaxInvoice.Invoice(fp01.FP001, clientInfo); } } } } this.Close(); } catch (Exception ee) { unitOfWork1.RollbackTransaction(); Tools.msg(MessageBoxIcon.Error, "错误", ee.ToString()); } }
private void sb_ok_Click(object sender, EventArgs e) { string s_sa001 = string.Empty; SA01 sa01 = null; FA01 fa01 = null; string s_fa099 = string.Empty; decimal dec_sum = decimal.Zero; //if (string.IsNullOrEmpty(te_fa099.Text)) //{ // te_fa099.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight; // te_fa099.ErrorText = "请输入收费单据号!"; // te_fa099.Focus(); // return; //} try { string s_fa001 = MiscAction.GetEntityPK("FA01"); for (int i = 0; i < gridView1.RowCount; i++) { sa01 = xpCollection1[gridView1.GetDataSourceRowIndex(i)] as SA01; if (FireAction.SalesItemIsSettled(sa01.SA001)) { throw new Exception("第" + (i + 1).ToString() + "行数据已经结算,请重新选择结算数据!"); } sa01.SA008 = "1"; //结算标志 sa01.SA010 = s_fa001; //结算流水号 dec_sum += sa01.SA007; } fa01 = new FA01(session); fa01.FA001 = s_fa001; //结算流水号 fa01.FA002 = "0"; //收费类型 0-火化业务 fa01.FA003 = ac01.AC003; //交款人 fa01.AC001 = ac01.AC001; //逝者编号 fa01.FA004 = dec_sum; //交费金额 fa01.FA099 = te_fa099.Text; //单据流水号 fa01.FA100 = Envior.cur_user.UC001; //经办人 fa01.FA200 = MiscAction.GetServerTime(); //经办日期 fa01.WS001 = Envior.workstationId; //工作站ID fa01.STATUS = "1"; ///检查是否有寄存办理 int i_find = gridView1.LocateByValue("SA002", "08"); if (i_find >= 0) { string s_bi001 = gridView1.GetRowCellValue(i_find, "SA004").ToString(); BI01 bi01 = session.GetObjectByKey <BI01>(s_bi001); if (bi01 == null) { throw new Exception("找不到寄存号位!"); } bi01.STATUS = "1"; RC01 rc01 = session.GetObjectByKey <RC01>(gridView1.GetRowCellValue(i_find, "AC001").ToString()); if (rc01 == null) { throw new Exception("找不到寄存登记记录!"); } rc01.STATUS = "1"; ////增加寄存费缴纳记录 RC04 rc04 = new RC04(session); rc04.RC001 = rc01.RC001; rc04.RC010 = s_fa001; rc04.RC020 = rc01.RC140; //寄存日期 rc04.RC022 = rc01.RC150; //寄存截至日期 rc04.PRICE = Convert.ToDecimal(gridView1.GetRowCellValue(i_find, "PRICE")); rc04.NUMS = Convert.ToInt32(gridView1.GetRowCellValue(i_find, "NUMS")); rc04.RC030 = Convert.ToDecimal(gridView1.GetRowCellValue(i_find, "SA007")); rc04.RC031 = "1"; //寄存费缴纳类型 1-正常缴费 rc04.RC100 = Envior.cur_user.UC001; rc04.RC200 = MiscAction.GetServerTime(); rc04.STATUS = "1"; } session.CommitChanges(); XtraMessageBox.Show("结算办理成功!现在开始打印单据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); PrintAction.Print_Skpz0(s_fa001); if (gridView1.LocateByValue("SA002", "06") >= 0) { if (XtraMessageBox.Show("现在打印【火化证明】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.Print_HHZM(ac01.AC001); } } if (gridView1.LocateByValue("SA002", "08") >= 0) { if (XtraMessageBox.Show("现在打印【寄存证】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.Print_RegCardBase(ac01.AC001); } if (XtraMessageBox.Show("现在打印【骨灰安放卡】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { PrintAction.Print_RegSettle(ac01.AC001); } } this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ee) { session.RollbackTransaction(); LogUtils.Error(ee.Message); XtraMessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }