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());
}
}
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());
}
}
/// <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());
}
}
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());
}
}