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