private void be_newposition_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Frm_freeBit frm_free = new Frm_freeBit();
BI01 bi01 = null;
if (frm_free.ShowDialog() == DialogResult.OK)
{
s_new_bi001 = frm_free.swapdata["bi001"].ToString();
if (s_new_bi001 == ac01.AC015)
{
Tools.msg(MessageBoxIcon.Warning, "提示", "新墓穴位置与原来相同!");
return;
}
bi01 = session1.GetObjectByKey(typeof(BI01), s_new_bi001) as BI01;
if (bi01 != null)
{
if (bi01.PRICE != ac01.AC020)
{
if (XtraMessageBox.Show("新墓穴位置与原位置定价不同,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
be_newposition.Text = MiscAction.GetTombPosition(bi01.BI001);
te_new_price.EditValue = bi01.PRICE;
}
}
frm_free.Dispose();
}
private void Frm_bookinDelay_Load(object sender, EventArgs e)
{
s_bk001 = this.swapdata["bk001"].ToString();
using (OracleDataReader reader = SqlAssist.ExecuteReader("select * from bk01 where bk001='" + s_bk001 + "'"))
{
if (reader.Read())
{
be_position.Text = MiscAction.GetTombPosition(reader["BI001"].ToString());
}
}
}
private void buttonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Frm_freeBit frm_free = new Frm_freeBit();
if (frm_free.ShowDialog() == DialogResult.OK)
{
s_bi001 = frm_free.swapdata["bi001"].ToString();
bi01 = session1.GetObjectByKey(typeof(BI01), s_bi001) as BI01;
if (bi01 != null)
{
be_position.Text = MiscAction.GetTombPosition(bi01.BI001);
}
}
frm_free.Dispose();
}
private void Frm_checkinEdit_Load(object sender, EventArgs e)
{
s_ac001 = this.swapdata["ac001"].ToString();
ac01 = unitOfWork1.GetObjectByKey <AC01>(s_ac001, true);
if (ac01 == null)
{
Tools.msg(MessageBoxIcon.Warning, "提示", "未找到数据!");
sb_ok.Enabled = false;
return;
}
bi01 = unitOfWork1.GetObjectByKey <BI01>(ac01.AC015, true);
if (bi01 == null)
{
Tools.msg(MessageBoxIcon.Warning, "提示", "未找到数据!");
sb_ok.Enabled = false;
return;
}
te_ac003.EditValue = ac01.AC003;
be_position.EditValue = MiscAction.GetTombPosition(ac01.AC015);
le_mx.EditValue = bi01.BI005; //墓型
te_fixprice.EditValue = ac01.AC020; //定价
te_ac004.EditValue = ac01.AC004; //联系电话
te_ac002.EditValue = ac01.AC002; //身份证号
te_price.EditValue = ac01.AC022; //售价
te_ac250.EditValue = ac01.AC250; //备注
//检索 ac03
xpCollection_ac03.Criteria = CriteriaOperator.Parse("AC001='" + s_ac001 + "'");
xpCollection_ac03.LoadingEnabled = true;
//检索缴费记录
xpCollection_pr01.Criteria = CriteriaOperator.Parse("AC001='" + s_ac001 + "'");
xpCollection_pr01.LoadingEnabled = true;
//安葬批次号
s_ac199 = MiscAction.GetEntityPK("AC01");
if (BusinessAction.IsDebt(s_ac001) == 1)
{
lc_debt.Text = "欠费";
}
else
{
lc_debt.Text = "不欠费";
}
}
private void gridView2_MouseMove(object sender, MouseEventArgs e)
{
GridHitInfo hInfo = gridView2.CalcHitInfo(new Point(e.X, e.Y));
if (hInfo.InRow && hInfo.Column != null)
{
panel_info.Visible = true;
string s_bi003 = gridView2.GetRowCellValue(hInfo.RowHandle, hInfo.Column).ToString();
int rowerOrder = hInfo.RowHandle + 1;
string s_bi001 = MiscAction.GetBi001ByBitdescRowOrder(curRegionId, s_bi003, rowerOrder);
bi01 = session1.GetObjectByKey <BI01>(s_bi001);
if (bi01 != null)
{
lc_position.Text = MiscAction.GetTombPosition(bi01.BI001);
lc_price.Text = string.Format("{0:C2}", bi01.PRICE);
lc_bi005.Text = MiscAction.Mapper_mx(bi01.BI005);
if (bi01.STATUS != '2')
{
lc_ac003_cap.Visible = false;
lc_ac003.Visible = false;
lc_ac049_cap.Visible = false;
lc_ac049.Visible = false;
}
else
{
lc_ac003_cap.Visible = true;
lc_ac003.Visible = true;
lc_ac049_cap.Visible = true;
lc_ac049.Visible = true;
AC01 ac01 = session1.GetObjectByKey <AC01>(bi01.AC001);
if (ac01 != null)
{
lc_ac003.Text = ac01.AC003;
lc_ac049.Text = ac01.AC049.ToString();
}
}
}
}
else
{
panel_info.Visible = false;
}
}
/// <summary>
/// 调用 选择墓位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void be_position_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (s_action == "bookin")
{
return;
}
Frm_freeBit frm_free = new Frm_freeBit();
if (frm_free.ShowDialog() == DialogResult.OK)
{
s_bi001 = frm_free.swapdata["bi001"].ToString();
bi01 = unitOfWork1.GetObjectByKey(typeof(BI01), s_bi001) as BI01;
if (bi01 != null)
{
be_position.Text = MiscAction.GetTombPosition(bi01.BI001);
te_fixprice.EditValue = bi01.PRICE;
te_price.EditValue = bi01.PRICE;
le_mx.EditValue = bi01.BI005;
if (bi01.PRICE > 0)
{
te_fixprice.ReadOnly = true;
}
else
{
te_fixprice.ReadOnly = false;
}
if (bi01.BI005 != null)
{
le_mx.ReadOnly = true;
}
else
{
le_mx.ReadOnly = false;
}
}
}
frm_free.Dispose();
}
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 Frm_checkin_Load(object sender, EventArgs e)
{
if (this.swapdata.ContainsKey("action"))
{
s_action = this.swapdata["action"].ToString();
}
else
{
s_action = "add";
}
if (s_action == "add")
{
s_ac001 = MiscAction.GetEntityPK("AC01");
s_ac199 = s_ac001;
te_free_nums.EditValue = MiscAction.GetSysParaValue1("FREEYEARS");
de_ac049.EditValue = Tools.GetServerDate();
}
else if (s_action == "bookin") //预定登记
{
s_bk001 = this.swapdata["bk001"].ToString();
bk01 = unitOfWork1.GetObjectByKey <BK01>(s_bk001);
bi01 = unitOfWork1.GetObjectByKey <BI01>(bk01.BI001);
if (bi01 != null && bk01 != null)
{
be_position.Text = MiscAction.GetTombPosition(bi01.BI001);
te_fixprice.EditValue = bi01.PRICE;
te_price.EditValue = bi01.PRICE;
le_mx.EditValue = bi01.BI005;
te_ac003.Text = bk01.BK003;
if (bi01.PRICE > 0)
{
te_fixprice.ReadOnly = true;
}
else
{
te_fixprice.ReadOnly = false;
}
if (bi01.BI005 != null)
{
le_mx.ReadOnly = true;
}
else
{
le_mx.ReadOnly = false;
}
s_ac001 = MiscAction.GetEntityPK("AC01");
s_ac199 = s_ac001;
te_free_nums.EditValue = MiscAction.GetSysParaValue1("FREEYEARS");
de_ac049.EditValue = Tools.GetServerDate();
}
}
else //如果是更新资料,检索信息
{
s_ac001 = this.swapdata["ac001"].ToString();
}
///增加购墓自动选择项
if (s_action == "add" || s_action == "bookin")
{
AutoAdd();
}
}
