private void Frm_checkinOrig_Load(object sender, EventArgs e) { s_ac001 = MiscAction.GetEntityPK("AC01"); s_ac199 = s_ac001; te_free_nums.EditValue = MiscAction.GetSysParaValue1("FREEYEARS"); de_ac049.EditValue = Tools.GetServerDate(); }
private void Frm_PayManageFee_Load(object sender, EventArgs e) { ac01 = this.swapdata["ac01"] as V_AC01_REPORT; if (ac01 != null) { te_ac001.EditValue = ac01.AC001; te_position.EditValue = ac01.POSITION; te_expire.EditValue = ac01.AC040; //管理费到期日期 te_price.EditValue = MiscAction.GetSysParaValue1("MANAGEFEE_PRICE"); te_nums.EditValue = MiscAction.GetSysParaValue1("MANAGEFEE_NUMS"); } }
/// <summary> /// 购墓时必选项目 /// </summary> private void AutoAdd() { using (OracleDataReader reader = SqlAssist.ExecuteReader("select * from v_all_validitem where autochoose = '1' ")) { SA01 sa01 = null; if (reader.HasRows) { while (reader.Read()) { sa01 = new SA01(unitOfWork1); sa01.SA004 = reader["ITEM_ID"].ToString(); sa01.SA001 = MiscAction.GetEntityPK("SA01"); sa01.SA002 = '1'; //销售项目类型 1 - 商品或服务 sa01.SA003 = reader["ITEM_NAME"].ToString(); //项目名称 sa01.STATUS = '1'; sa01.AC001 = s_ac001; //购墓流水号 sa01.SA005 = '0'; //销售类型 0-购墓 sa01.SA008 = '0'; //结算标志 0-未结算 sa01.SA100 = Envior.cur_userId; //经办人 sa01.SA200 = Tools.GetServerDate(); //经办日期 sa01.SA025 = Convert.ToDecimal(reader["TAXRATE"]); if (sa01.SA003 == "管理费") { sa01.NUMS = MiscAction.GetSysParaValue1("MANAGEFEE_NUMS"); } else { sa01.NUMS = 1; } sa01.PRICE = Convert.ToDecimal(reader["PRICE"]);//单价 sa01.SA007 = sa01.PRICE * sa01.NUMS; sa01.SA006 = sa01.PRICE; xpCollection_sa01.Add(sa01); } } } }
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(); } }
/// <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()); } }