/// <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 Frm_Register_Load(object sender, EventArgs e)
{
///初始化
st01Adapter.Fill(dt_st01);
dv_relation = new DataView(dt_st01);
dv_relation.RowFilter = "ST002='RELATION'";
lookUp_rc052.Properties.DataSource = dv_relation;
lookUp_rc052.Properties.ValueMember = "ST003";
lookUp_rc052.Properties.DisplayMember = "ST003";
itemAdapter.Fill(dt_allItem);
rep_lookup_sa004.DataSource = dt_allItem;
rep_lookup_sa004.DisplayMember = "ITEM_TEXT";
rep_lookup_sa004.ValueMember = "ITEM_ID";
comboAdapter.Fill(dt_reg_combo);
//寄存所属套餐
foreach (DataRow r in dt_reg_combo.Rows)
{
SA01 sa01 = new SA01(unitOfWork1);
sa01.SA004 = r["CB021"].ToString(); //商品或服务编号
sa01.PRICE = FireAction.GetItemPrice(r["CB021"].ToString());
sa01.NUMS = Convert.ToInt32(r["CB030"]);
sa01.SA006 = sa01.PRICE;
sa01.SA007 = sa01.PRICE * sa01.NUMS;
fpfee += sa01.SA007;
xpCollection_sa01.Add(sa01);
}
this.CalcHJ();
s_source = this.swapdata["source"].ToString();
if (s_source == "0" /* 本馆火化 */ || s_source == "8" /*待缴费*/)
{
s_rc001 = this.swapdata["rc001"].ToString();
AC01 ac01 = unitOfWork1.GetObjectByKey <AC01>(s_rc001);
if (ac01 != null)
{
txtEdit_rc003.EditValue = ac01.AC003; //逝者姓名
rg_rc002.EditValue = ac01.AC002; //性别
txtEdit_rc004.EditValue = ac01.AC004; //年龄
txtedit_rc014.EditValue = ac01.AC014; //身份证号
txtEdit_rc050.EditValue = ac01.AC050; //联系人
lookUp_rc052.EditValue = ac01.AC052; //与逝者关系
txtEdit_rc051.EditValue = ac01.AC051; //联系电话
txtEdit_ac055.EditValue = ac01.AC055; //联系地址
txtEdit_rc001.Text = ac01.AC001; //逝者编号
sb_clear.Enabled = false;
}
else
{
XtraMessageBox.Show("数据参数错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
sb_ok.Enabled = false;
return;
}
}
}
/// <summary>
/// 单价数量变更
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
int rowHandle = gridView1.FocusedRowHandle;
if (e.Column.FieldName == "SA004" && e.Value != null && e.Value != System.DBNull.Value)
{
gridView1.SetRowCellValue(rowHandle, "PRICE", FireAction.GetItemPrice(gridView1.GetRowCellValue(rowHandle, "SA004").ToString()));
gridView1.SetRowCellValue(rowHandle, "NUMS", 1);
calcFee(rowHandle);
}
else if (e.Column.FieldName == "PRICE" || e.Column.FieldName == "NUMS")
{
calcFee(rowHandle);
}
else if (e.Column.FieldName == "SA007")
{
fpfee = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (i == rowHandle)
{
fpfee += Convert.ToDecimal(e.Value);
}
else
{
if (gridView1.GetRowCellValue(i, "SA007") != null && gridView1.GetRowCellValue(i, "SA007") != System.DBNull.Value)
{
fpfee += Convert.ToDecimal(gridView1.GetRowCellValue(i, "SA007"));
}
}
}
///// 如果是新行
if (rowHandle < 0)
{
fpfee += Convert.ToDecimal(e.Value);
}
this.CalcHJ();
}
}
