/// <summary>
/// 应用套餐
/// </summary>
/// <param name="serviceType"></param>
private void ApplyCombo(string serviceType)
{
DataTable dt_cb02 = new DataTable();
OracleDataAdapter cb02Adapter = new OracleDataAdapter("select * from cb02 where cb001=(select cb001 from cb01 where cb002 = '0' and cb005 = :service)", SqlHelper.conn);
OracleParameter op_service = new OracleParameter("service", OracleDbType.Varchar2, 3);
op_service.Direction = ParameterDirection.Input;
cb02Adapter.SelectCommand.Parameters.Add(op_service);
op_service.Value = serviceType;
cb02Adapter.Fill(dt_cb02);
/////循环处理套餐明细
foreach (DataRow dr in dt_cb02.Rows)
{ ///如果套餐明细项目不存在!
if (!FireAction.ItemIsExisted(ac01.AC001, dr["CB022"].ToString(), dr["CB021"].ToString()))
{
SA01 sa01 = new SA01(unitOfWork1);
sa01.SA001 = MiscAction.GetEntityPK("SA01");
sa01.AC001 = ac01.AC001;
sa01.SA002 = dr["CB022"].ToString(); //类型
sa01.SA003 = FireAction.GetItemName(dr["CB021"].ToString());
sa01.SA004 = dr["CB021"].ToString();
sa01.SA005 = "0";
sa01.PRICE = FireAction.GetItemPrice(dr["CB021"].ToString());
sa01.NUMS = Convert.ToInt32(dr["CB030"]);
sa01.SA007 = sa01.PRICE * sa01.NUMS;
sa01.SA006 = sa01.PRICE;
sa01.SA008 = "0";
sa01.SA100 = Envior.cur_user.UC001;
sa01.SA200 = MiscAction.GetServerTime();
sa01.STATUS = "1";
}
}
}
private void gridView1_DoubleClick(object sender, EventArgs e)
{
GridHitInfo _info;
Point _pt = gridView1.GridControl.PointToClient(Control.MousePosition);
_info = gridView1.CalcHitInfo(_pt);
if (_info.HitTest != GridHitTest.RowCell)
{
return;
}
string s_bitDesc = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.FocusedColumn).ToString();
string s_rowerId = rower_arry[gridView1.FocusedRowHandle]["RG001"].ToString();
string s_status = MiscAction.GetTombStatus(s_rowerId, s_bitDesc);
if (s_status == "2" || s_status == "3")
{
Tools.msg(MessageBoxIcon.Warning, "提示", "该墓位已经被占用!");
return;
}
else if (s_status == "4")
{
return;
}
else if (s_status == "1")
{
string s_bitId = MiscAction.GetTombId(s_rowerId, s_bitDesc);
this.swapdata["bi001"] = s_bitId;
this.DialogResult = DialogResult.OK;
this.Close();
}
}
/// <summary>
/// 打印财政发票
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rowHandle = gridView1.FocusedRowHandle;
if (rowHandle >= 0)
{
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(0, 1) == "1")
{
string s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString();
//如果是新接口上线前开具的发票,不能打印
if (MiscAction.FinRefundBeforeOnline(s_fa001))
{
XtraMessageBox.Show("此笔收费财政发票为新接口上线前开具,不能通过新接口打印!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
return;
}
OracleDataReader reader = SqlAssist.ExecuteReader("select INVOICENO,INVOICEZCH from fin_log where settleId ='" + s_fa001 + "'");
if (reader.HasRows && reader.Read())
{
string s_batch_code = reader["INVOICEZCH"].ToString();
string s_billno = reader["INVOICENO"].ToString();
reader.Dispose();
if (XtraMessageBox.Show("打印财政发票?\r\n" + "注册号:" + s_batch_code + "\r\n" + "发票号:" + s_billno, "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.PrintInvoice(s_batch_code, s_billno);
}
}
}
else
{
XtraMessageBox.Show("当前收费记录未开财政发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
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();
}
/// <summary>
/// 刷新数据
/// </summary>
private void RefreshData()
{
this.Cursor = Cursors.WaitCursor;
int re = MiscAction.ClassStat(s_begin, s_end, classArry);
if (re > 0)
{
gridView1.BeginUpdate();
dt_cs.Rows.Clear();
csAdapter.Fill(dt_cs);
gridColumn4.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn4.SummaryItem.DisplayFormat = "合计 = {0:N2}";
gridColumn6.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn6.SummaryItem.DisplayFormat = "税额合计 = {0:N2}";
gridColumn8.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn8.SummaryItem.DisplayFormat = "不含税合计 = {0:N2}";
bs_bs.Caption = " 共有收费笔数:" + MiscAction.GetClassStat_BS().ToString() + "笔";
//gridColumn1.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
//gridColumn1.SummaryItem.DisplayFormat = "合计 = {0:N2}";
gridView1.EndUpdate();
}
this.Cursor = Cursors.Arrow;
}
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Frm_business03 frm_1 = new Frm_business03();
frm_1.swapdata["dataset"] = business_ds;
frm_1.swapdata["SALESTYPE"] = "1";
DialogResult result = frm_1.ShowDialog();
if (result == DialogResult.OK)
{
List <string> itemId_list = frm_1.swapdata["xxs"] as List <string>;
for (int i = 0; i < itemId_list.Count; i++)
{
DataRow dr = business_ds.Sa01.Rows.Add();
dr["SA003"] = MiscAction.GetItemFullName(itemId_list[i]);
dr["SA002"] = "03";
dr["SA004"] = itemId_list[i];
dr["PRICE"] = MiscAction.GetItemFixPrice(itemId_list[i]);
dr["SA005"] = "1";
dr["NUMS"] = 1;
dr["SA007"] = dr["PRICE"];
dr["SA020"] = MiscAction.GetItemInvoiceType(itemId_list[i]);
dr.EndEdit();
}
}
frm_1.Dispose();
this.CalcSum();
}
private void gridView2_MouseDown(object sender, MouseEventArgs e)
{
GridHitInfo hInfo = gridView2.CalcHitInfo(new Point(e.X, e.Y));
if (e.Button == MouseButtons.Right && e.Clicks == 1 && hInfo.InRow && hInfo.Column != null)
{
contextMenuStrip1.Show(MousePosition);
//处理菜单项状态
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.STATUS == '2')
{
toolStripMenuItem_edit.Enabled = true;
ToolStripMenuItem_move.Enabled = true;
toolStripMenuItem_mfee.Enabled = true;
}
else
{
toolStripMenuItem_edit.Enabled = false;
ToolStripMenuItem_move.Enabled = false;
toolStripMenuItem_mfee.Enabled = false;
}
}
}
/// <summary>
/// 新增 冷藏
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem13_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Frm_business02 frm_1 = new Frm_business02();
frm_1.swapdata["dataset"] = business_ds;
frm_1.swapdata["SALESTYPE"] = "1";
DialogResult result = frm_1.ShowDialog();
if (result == DialogResult.OK)
{
string s_itemId = frm_1.swapdata["ITEMID"].ToString();
DataRow dr = business_ds.Sa01.Rows.Add();
dr["SA003"] = MiscAction.GetItemFullName(s_itemId);
dr["SA002"] = "02"; //类型：冷藏柜
dr["SA004"] = s_itemId;
dr["PRICE"] = MiscAction.GetItemFixPrice(s_itemId); //单价
dr["SA005"] = "1"; //临时性销售
dr["NUMS"] = Convert.ToDecimal(frm_1.swapdata["NUMS"]); //数量
dr["SA007"] = Convert.ToDecimal(dr["PRICE"]) * Convert.ToDecimal(dr["NUMS"]); //金额
dr["SA020"] = "F";
dr.EndEdit();
}
frm_1.Dispose();
this.CalcSum();
}
/// <summary>
/// 刷新数据
/// </summary>
private void RefreshData()
{
if (MiscAction.WorkStationStat(s_ws001, s_begin, s_end) > 0)
{
this.Cursor = Cursors.WaitCursor;
dt_wsStat.Rows.Clear();
statAdapter.Fill(dt_wsStat);
//财政笔数
gridColumn3.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn3.SummaryItem.DisplayFormat = "{0:N0}";
//财政金额
gridColumn4.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn4.SummaryItem.DisplayFormat = "{0:N2}";
//税务笔数
gridColumn5.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn5.SummaryItem.DisplayFormat = "{0:N0}";
//税务金额
gridColumn6.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn6.SummaryItem.DisplayFormat = "{0:N2}";
this.Cursor = Cursors.Arrow;
}
}
private void gridView1_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
string ws001 = MiscAction.GetEntityPK("WS01");
gridView1.SetRowCellValue(e.RowHandle, "WS001", ws001);
gridView1.SetRowCellValue(e.RowHandle, "STATUS", "0");
}
/// <summary>
/// 刷新数据
/// </summary>
private void RefreshData()
{
if (MiscAction.CasherStat(s_begin, s_end, s_fa100) > 0)
{
slock = true;
this.Cursor = Cursors.WaitCursor;
dt_casherStat.Rows.Clear();
statAdapter.Fill(dt_casherStat);
gridColumn15.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn15.SummaryItem.DisplayFormat = "{0:N0}";
gridColumn16.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn16.SummaryItem.DisplayFormat = "{0:N2}";
decimal dec_total = Convert.ToDecimal(gridView_center.Columns["gridColumn18"].SummaryItem.SummaryValue);
decimal dec_fin_sum = Convert.ToDecimal(gridView_center.Columns["FIN_JE"].SummaryItem.SummaryValue);
decimal dec_tax_sum = Convert.ToDecimal(gridView_center.Columns["TAX_JE"].SummaryItem.SummaryValue);
if (dec_total == dec_fin_sum + dec_tax_sum)
{
groupControl1.Text = "统计日期 " + s_begin + "至" + s_end;
}
else
{
groupControl1.Text = "<color=255,0,0>统计日期 " + s_begin + "至" + s_end + "</color>";
}
this.Cursor = Cursors.Arrow;
slock = false;
}
}
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();
}
/// <summary>
/// 骨灰处理方式改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtedit_ac006_CustomDisplayText(object sender, DevExpress.XtraEditors.Controls.CustomDisplayTextEventArgs e)
{
if (e.Value == null)
{
return;
}
e.DisplayText = MiscAction.Mapper_DD(e.Value.ToString());
}
private void sb_ok_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(s_bi001) || bi01 == null)
{
be_position.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
be_position.ErrorText = "请先选择一个墓位!";
return;
}
else if (string.IsNullOrEmpty(te_bk003.Text))
{
te_bk003.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
te_bk003.ErrorText = "请输入预定人姓名!";
te_bk003.Focus();
return;
}
else if (string.IsNullOrEmpty(te_bk005.Text))
{
te_bk005.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
te_bk005.ErrorText = "请输入联系电话!";
te_bk005.Focus();
return;
}
else if (DateTime.Compare(Convert.ToDateTime(dateEdit1.EditValue.ToString()), Tools.GetServerDate()) < 0)
{
dateEdit1.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
dateEdit1.ErrorText = "预定截至日期必须大于当前日期!";
dateEdit1.Focus();
return;
}
try
{
session1.BeginTransaction();
//1.保存 bi01
bi01.STATUS = '3'; //使用情况 1-未使用 2-已使用 3-预定 4-冻结
bi01.Save();
//2.记录预定记录
bk01 = new BK01(session1);
bk01.BK001 = MiscAction.GetEntityPK("BK01");
bk01.BK003 = te_bk003.Text;
bk01.BK005 = te_bk005.Text;
bk01.BI001 = bi01.BI001; //墓位编号
bk01.BK009 = Convert.ToDateTime(dateEdit1.Text); //预留截至日期
bk01.BK100 = Envior.cur_userId;
bk01.BK200 = Tools.GetServerDate().Date;
bk01.STATUS = '1';
bk01.Save();
session1.CommitTransaction();
Tools.msg(MessageBoxIcon.Information, "提示", "墓位预定成功!");
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ee)
{
session1.RollbackTransaction();
Tools.msg(MessageBoxIcon.Error, "错误", ee.ToString());
}
}
/// <summary>
/// 退费操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bBi_refund_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rowHandle;
string s_billType = string.Empty;
string s_fa001 = string.Empty;
if (tabPane1.SelectedPageIndex == 0)
{
return;
}
else if (tabPane1.SelectedPageIndex == 1)
{
rowHandle = gridView3.FocusedRowHandle;
s_billType = gridView3.GetRowCellValue(rowHandle, "BILLTYPE").ToString();
s_fa001 = gridView3.GetRowCellValue(rowHandle, "FA001").ToString();
string s_fa002 = SqlAssist.ExecuteScalar("select fa002 from fa01 where fa001='" + s_fa001 + "'").ToString();
//检查与开票所在工作站是否一致!!!
if (MiscAction.CheckWorkStationCompare(s_fa001, Envior.WORKSTATIONID, s_billType) == "0")
{
XtraMessageBox.Show("此笔收费发票不是在当前工作站开具,不能继续!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//if(s_fa002 == "2")
//{
// XtraMessageBox.Show("此收费记录不能退费!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
if (MiscAction.HaveRefund(s_fa001))
{
XtraMessageBox.Show("此收费记录已经有退费记录,不能再次退费!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
BaseDialog frm_1 = null;
if (s_billType == "F")
{
frm_1 = new Frm_refund_select();
}
else
{
frm_1 = new Frm_refund_select2();
}
frm_1.swapdata["SA010"] = s_fa001; //结算流水号
frm_1.swapdata["SA020"] = s_billType; //票别
if (frm_1.ShowDialog() == DialogResult.OK)
{
this.RefreshData();
}
frm_1.Dispose();
}
private void Frm_RegOut_Load(object sender, EventArgs e)
{
s_rc001 = this.swapdata["rc001"].ToString();
RC01 rc01 = unitOfWork1.GetObjectByKey <RC01>(s_rc001);
if (rc01 != null)
{
txtEdit_rc001.Text = rc01.RC001;
txtEdit_rc109.Text = rc01.RC109; //寄存证号
be_position.Text = RegAction.GetRegPosition(s_rc001); //寄存位置
txtEdit_rc003.Text = rc01.RC003;
txtEdit_rc303.EditValue = rc01.RC303;
rg_rc002.EditValue = rc01.RC002;
rg_rc202.EditValue = rc01.RC202;
txtEdit_rc004.EditValue = rc01.RC004;
txtEdit_rc404.EditValue = rc01.RC404;
//寄存号位单价
price = RegAction.GetRegPrice(s_rc001);
txtEdit_price.EditValue = price;
txtEdit_rc150.EditValue = rc01.RC150; //寄存到期时间
int diff = RegAction.CalcOutDiffDays(s_rc001);
int compare = string.Compare(rc01.RC150.ToString("yyyyMMdd"), MiscAction.GetServerTime().ToString("yyyyMMdd"));
if (compare == 0)
{
checkEdit1.Enabled = false;
txtEdit_nums.Enabled = false;
}
else if (compare > 0) //退费
{
lc_1.Text = "剩余天数";
lc_2.Text = "应退费月数";
lc_3.Text = "退费金额";
isrefund = true;
//txtEdit_nums.EditValue = Math.Round((diff * 1.0f) / 30, 0);
//txtEdit_fee.EditValue = Convert.ToDecimal(Math.Round((diff * 1.0f) / 30, 0)) * price;
txtEdit_nums.EditValue = 0;
txtEdit_fee.EditValue = 0;
}
else
{
lc_1.Text = "过期天数";
lc_2.Text = "应补费月数";
lc_3.Text = "补费金额";
txtEdit_nums.EditValue = Math.Round((diff * 1.0f) / 30, 0);
txtEdit_fee.EditValue = Convert.ToDecimal(Math.Round((diff * 1.0f) / 30, 0)) * price;
}
txtEdit_diff.EditValue = diff;
}
else
{
sb_ok.Enabled = false;
XtraMessageBox.Show("数据未找到!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 新行初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
//// 初始化新行时触发(当在新行中)
GridView view = sender as GridView;
string ti001 = MiscAction.GetEntityPK("TI01");
gridView1.SetRowCellValue(e.RowHandle, "TI001", ti001);
gridView1.SetRowCellValue(e.RowHandle, "STATUS", "1");
}
private void gridView1_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
//// 初始化新行时触发(当在新行中)
GridView view = sender as GridView;
string ro001 = MiscAction.GetEntityPK("RO01");
int currow = view.FocusedRowHandle;
view.SetRowCellValue(e.RowHandle, view.Columns["RO001"], ro001);
}
/// <summary>
/// 新行初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_InitNewRow(object sender, InitNewRowEventArgs e)
{
string newkey = string.Empty;
newkey = MiscAction.GetEntityPK("SI01");
gridView1.SetRowCellValue(e.RowHandle, "SI001", newkey);
gridView1.SetRowCellValue(e.RowHandle, "STATUS", "1");
gridView1.SetRowCellValue(e.RowHandle, "PRICE", 0.00);
gridView1.SetRowCellValue(e.RowHandle, "SORTID", Convert.ToInt32(newkey));
}
/// <summary>
/// 新行初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
//// 初始化新行时触发(当在新行中)
string s_st001 = MiscAction.GetEntityPK("ST01");
gridView1.SetRowCellValue(e.RowHandle, "ST002", GetDataTypeByIndex(i_sel_index));
gridView1.SetRowCellValue(e.RowHandle, "ST001", s_st001);
gridView1.SetRowCellValue(e.RowHandle, "STATUS", "1");
gridView1.SetRowCellValue(e.RowHandle, "SORTID", Convert.ToInt32(s_st001));
}
/// <summary>
/// 选择告别厅
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void glookup_gbt_EditValueChanged(object sender, EventArgs e)
{
if (glookup_gbt.EditValue != null)
{
de_gbsj.EditValue = MiscAction.GetServerTime();
}
else
{
de_gbsj.EditValue = null;
}
}
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());
}
}
}
/// <summary>
/// 初始化新行
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
//// 初始化新行时触发(当在新行中)
GridView view = sender as GridView;
string st001 = MiscAction.GetEntityPK("ST01");
gridView1.SetRowCellValue(e.RowHandle, "ST002", GetCurTypeStr(curIndex));
gridView1.SetRowCellValue(e.RowHandle, "ST001", st001);
gridView1.SetRowCellValue(e.RowHandle, "STATUS", "1");
gridView1.SetRowCellValue(e.RowHandle, "SORTID", Convert.ToInt32(st001));
}
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>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
RO01 ro01 = new RO01(unitOfWork1);
ro01.RO001 = MiscAction.GetEntityPK("RO01");
ro01.STATUS = "1";
int rowHandle = gridView1.GetRowHandle(xpCollection1.Add(ro01));
gridView1.FocusedRowHandle = rowHandle;
gridView1.FocusedColumn = gridView1.Columns["RO003"];
gridView1.ShowEditor();
}
/// <summary>
/// 新行初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView2_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
string s_ac111 = MiscAction.GetEntityPK("AC03");
gridView2.SetRowCellValue(e.RowHandle, "AC001", s_ac001);
gridView2.SetRowCellValue(e.RowHandle, "AC112", "0");
gridView2.SetRowCellValue(e.RowHandle, "AC111", s_ac111);
gridView2.SetRowCellValue(e.RowHandle, "STATUS", '1');
gridView2.SetRowCellValue(e.RowHandle, "AC118", DateTime.Today);
gridView2.SetRowCellValue(e.RowHandle, "AC119", DateTime.Today);
gridView2.SetRowCellValue(e.RowHandle, "AC199", s_ac199);
}
/// <summary>
/// 业务初始化
/// </summary>
public override void Business_Init()
{
//获取逝者编号
AC001 = this.swapdata["parm"].ToString();
//填充逝者个人信息
parm1.Value = AC001;
parm2.Value = AC001;
reader = SqlAssist.ExecuteReader("select * from v_ac01 where ac001 = :ac001", new OracleParameter[] { parm2 });
if (!reader.HasRows)
{
XtraMessageBox.Show("参数传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
reader.Read();
txtedit_ac001.EditValue = AC001;
txtedit_ac003.EditValue = reader["AC003"]; //逝者姓名
txtedit_ac004.EditValue = reader["AC004"]; //年龄
rg_ac002.EditValue = reader["AC002"]; //性别
txtedit_ac020.EditValue = reader["AC020"]; //到达中心时间
txtedit_ac050.EditValue = reader["AC050"]; //联系人
txtedit_ac051.EditValue = reader["AC051"]; //电话
txtedit_ac052.Text = reader["AC052"].ToString(); //与逝者关系
this.Parent.Text = "火化业务办理" + "【" + reader["AC003"] + "】";
reader.Dispose();
//读入照片
if (MiscAction.HasIDC(AC001))
{
OracleDataReader photo_reader = SqlAssist.ExecuteReader("select ic020 from ic01 where ic000 = '0' and ac001 ='" + AC001 + "'");
if (photo_reader.HasRows && photo_reader.Read())
{
MemoryStream ms = new MemoryStream((byte[])photo_reader["IC020"]); //把照片读到MemoryStream里
Image imageBlob = Image.FromStream(ms, true); //用流创建Image
pictureEdit1.Image = imageBlob; //输出图片
}
photo_reader.Dispose();
}
else
{
pictureEdit1.Image = null;
}
///刷新销售数据
this.RefreshSalesData();
}
private void sb_ok_Click(object sender, EventArgs e)
{
int nums;
if (!int.TryParse(comboBox1.Text, out nums))
{
comboBox1.Focus();
XtraMessageBox.Show("请输入正确的缴费期限!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!(bitprice > 0))
{
XtraMessageBox.Show("参数传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string cuname = txtEdit_rc003.Text;
string s_fa001 = MiscAction.GetEntityPK("FA01");
string s_billno = string.Empty;
int re = RegAction.RegisterPay(s_rc001, s_fa001, bitprice, nums, Envior.cur_user.UC001);
if (re > 0)
{
dt_rc04.Rows.Clear();
rc04Adapter.Fill(dt_rc04);
if (XtraMessageBox.Show("缴费成功!现在打印【收据】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
//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 4 打印缴费记录
if (XtraMessageBox.Show("现在打印缴费记录吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
PrintAction.Print_PayRecord(s_fa001);
}
DialogResult = DialogResult.OK;
this.Close();
}
}
/// <summary>
/// 到达日期编辑校验
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dateEdit_ac020_Validating(object sender, CancelEventArgs e)
{
if (dateEdit_ac020.EditValue == null)
{
return;
}
if (DateTime.Compare((DateTime)dateEdit_ac020.EditValue, MiscAction.GetServerTime()) > 0)
{
dateEdit_ac020.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
dateEdit_ac020.ErrorText = "到达时间不能大于系统当前时间!";
e.Cancel = true;
}
}
private void Frm_Register_Load(object sender, EventArgs e)
{
register_ds = this.swapdata["dataset"] as Register_ds;
source = this.swapdata["source"].ToString();
if (source == "0") //本馆火化寄存
{
ac001 = this.swapdata["AC001"].ToString();
OracleDataReader reader = SqlAssist.ExecuteReader("select * from ac01 where ac001='" + ac001 + "'");
while (reader.Read())
{
txtEdit_rc001.EditValue = reader["AC001"];
txtEdit_rc003.EditValue = reader["AC003"];
rg_rc002.EditValue = reader["AC002"];
txtEdit_rc004.EditValue = reader["AC004"];
txtedit_rc014.EditValue = reader["AC014"];
txtEdit_rc050.EditValue = reader["AC050"];
txtEdit_rc051.EditValue = reader["AC051"];
lookUp_rc052.EditValue = reader["AC052"];
txtEdit_ac055.EditValue = reader["AC055"];
}
}
lookup_sa004.DataSource = register_ds.Jcfp;
lookup_sa004.DisplayMember = "ITEM_TEXT";
lookup_sa004.ValueMember = "ITEM_ID";
lookUp_rc052.Properties.DataSource = register_ds.Relation;
lookUp_rc052.Properties.ValueMember = "ST003";
lookUp_rc052.Properties.DisplayMember = "ST003";
register_ds.Sa01.Rows.Clear();
gridControl1.DataSource = register_ds.Sa01;
//寄存所属套餐
DataRow dr_new = null;
foreach (DataRow r in register_ds.RegCombo.Rows)
{
dr_new = register_ds.Sa01.NewRow();
dr_new["SA004"] = r["CB021"]; //商品或服务编号
dr_new["PRICE"] = MiscAction.GetItemFixPrice(r["CB021"].ToString());
dr_new["NUMS"] = r["CB030"];
dr_new["SA007"] = Convert.ToDecimal(dr_new["PRICE"]) * Convert.ToInt32(dr_new["NUMS"]);
fpfee += Convert.ToDecimal(dr_new["SA007"]);
register_ds.Sa01.Rows.Add(dr_new);
}
this.CalcHJ();
}
