/// <summary>
/// 响应 InputInvoice 发票数据输入结束事件的方法。
/// </summary>
/// <param name="bxmx"></param>
void AddBXMX(MRS.Model.BXMX bxmx)
{
int mPeriodId = 0;
string ybh = string.Empty;
mPeriodId = (cbbMPeriod.SelectedItem as MRS.Model.MPeriod).Id;
ybh = lbMedicareId.Text;
if (lbBXDid.Text == "")
{
lbBXDid.Text = AddBXD().ToString();
}
if (lbBXDid.Text != "")
{
bxmx.BXDId = Convert.ToInt32(lbBXDid.Text);
bxmx.ReimbursementRatio = bll_ratio.GetRatio(mPeriodId, ybh, bxmx.JZFS);
bllBXMX.AddBXMX(bxmx);
gvBXMX_DataBind();
nudAttNumber.Value++;
btnStat.Enabled = true;
btnPrint1.Enabled = false;
btnNextPerson.Enabled = false;
}
}
// 点击“修改”报销明细按钮。
private void btnUpdateFpmx_Click(object sender, EventArgs e)
{
if (gvBXMX.SelectedRows.Count > 0)
{
int bxmxId = 0;
bxmxId = (int)gvBXMX.SelectedRows[0].Cells["BXMXId"].Value;
MRS.Model.BXMX bxmx = bllBXMX.GetBxmx_By_BxmxId(bxmxId);
MRS.MRModule.InputInvoice invoice = new MRModule.InputInvoice();
invoice.InvoiceGetted += new MRModule.InvoiceGetEventHandler(invoice_InvoiceGetted);
invoice.Bxmx = bxmx;
invoice.ShowDialog(this);
}
}
/// <summary>
/// 更新报销发票明细。
/// </summary>
/// <param name="bxmx"></param>
public void UpdateBXMX(MRS.Model.BXMX bxmx)
{
DBProcedure.Update_BXMX prdCmd = new DBProcedure.Update_BXMX();
SqlParameter bxmxid_parm = new SqlParameter(DSL.BXMX.BXMX_ID_FIELD, SqlDbType.Int);
SqlParameter fpdate_parm = new SqlParameter(prdCmd.PARM_FpDate.ParameterName, SqlDbType.DateTime);
SqlParameter yyf_parm = new SqlParameter(DSL.BXMX.YYF_PARM, SqlDbType.Decimal);
SqlParameter grzfei_parm = new SqlParameter(DSL.BXMX.GRZFEI_PARM, SqlDbType.Decimal);
SqlParameter grzfu_parm = new SqlParameter(DSL.BXMX.GRZFU_PARM, SqlDbType.Decimal);
SqlParameter grzfuHide_parm = new SqlParameter(prdCmd.PARM_GRZFuHide.ParameterName, SqlDbType.Decimal);
SqlParameter grzfbao_parm = new SqlParameter(prdCmd.PARM_GRZFBao.ParameterName, SqlDbType.Decimal);
SqlParameter grcdbao_parm = new SqlParameter(DSL.BXMX.GRCD_BAO_PARM, SqlDbType.Decimal);
SqlParameter lnzhbao_parm = new SqlParameter(DSL.BXMX.LNZH_BAO_PARM, SqlDbType.Decimal);
SqlParameter tcjj_parm = new SqlParameter(DSL.BXMX.TCJJ_PARM, SqlDbType.Decimal);
SqlParameter jzfs_parm = new SqlParameter(DSL.BXMX.JZFS_PARM, SqlDbType.NChar, 10);
SqlParameter rbmRatio_parm = new SqlParameter(DSL.BXMX.RBM_RATIO_PARM, SqlDbType.Decimal);
bxmxid_parm.Value = bxmx.BXMXId;
fpdate_parm.Value = bxmx.FPDate;
yyf_parm.Value = bxmx.YYF;
grzfei_parm.Value = bxmx.GRZFei;
grzfu_parm.Value = bxmx.GRZFu;
grzfuHide_parm.Value = bxmx.GRZFuHide;
grzfbao_parm.Value = bxmx.GRZFBao;
grcdbao_parm.Value = bxmx.GRCDBao;
lnzhbao_parm.Value = bxmx.LNZHBao;
tcjj_parm.Value = bxmx.TCJJ;
jzfs_parm.Value = bxmx.JZFS;
rbmRatio_parm.Value = bxmx.ReimbursementRatio;
SqlParameter[] parms = new SqlParameter[12];
parms.SetValue(bxmxid_parm, 0);
parms.SetValue(fpdate_parm, 1);
parms.SetValue(yyf_parm, 2);
parms.SetValue(grzfei_parm, 3);
parms.SetValue(grzfu_parm, 4);
parms.SetValue(grzfuHide_parm, 5);
parms.SetValue(grzfbao_parm, 6);
parms.SetValue(grcdbao_parm, 7);
parms.SetValue(lnzhbao_parm, 8);
parms.SetValue(tcjj_parm, 9);
parms.SetValue(jzfs_parm, 10);
parms.SetValue(rbmRatio_parm, 11);
SqlHelper.ExecuteNonQuery(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.UPDATE_BXMX, parms);
}
/// <summary>
/// 根据报销明细Id，获取报销明细记录。
/// </summary>
/// <param name="bxmxId">报销明细记录号。</param>
/// <returns></returns>
public MRS.Model.BXMX GetBxmx_By_BxmxId(int bxmxId)
{
MRS.Model.BXMX bxmx = new MRS.Model.BXMX();
DBProcedure.Select_BXMX_By_BxmxId prdCmd = new DBProcedure.Select_BXMX_By_BxmxId();
SqlParameter bxmxId_parm = new SqlParameter(prdCmd.PARM_BxmxId.ParameterName, SqlDbType.Int);
bxmxId_parm.Value = bxmxId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, prdCmd.Text, bxmxId_parm))
{
if (reader.Read())
{
bxmx = Parse(reader);
}
}
return(bxmx);
}
public IList <MRS.Model.BXMX> GetBXMX_By_BXDId(int BXDId)
{
IList <MRS.Model.BXMX> mBXMXs = new List <MRS.Model.BXMX>();
SqlParameter bxdid_parm = new SqlParameter(DSL.BXMX.BXD_ID_PARM, SqlDbType.Int);
bxdid_parm.Value = BXDId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.SELECT_BXMX_BY_BXDID, bxdid_parm))
{
while (reader.Read())
{
MRS.Model.BXMX mBXMX = Parse(reader);
mBXMXs.Add(mBXMX);
}
}
return(mBXMXs);
}
protected MRS.Model.BXMX Parse(SqlDataReader Reader)
{
MRS.Model.BXMX mBXMX = new MRS.Model.BXMX();
mBXMX.BXMXId = Convert.ToInt32(Reader[DSL.BXMX.BXMX_ID_FIELD]);
mBXMX.BXDId = Convert.ToInt32(Reader[DSL.BXMX.BXD_ID_FIELD]);
mBXMX.FPDate = Convert.ToDateTime(Reader[DSL.BXMX.FP_DATE_FIELD]);
mBXMX.YYF = Convert.ToDecimal(Reader[DSL.BXMX.YYF_FIELD]);
mBXMX.GRZFei = Convert.ToDecimal(Reader[DSL.BXMX.GRZFEI_FIELD]);
mBXMX.GRZFu = Convert.ToDecimal(Reader[DSL.BXMX.GRZFU_FIELD]);
mBXMX.GRZFuHide = Convert.ToDecimal(Reader[DSL.BXMX.GRZFU_HIDE_FIELD]);
mBXMX.GRZFBao = Convert.ToDecimal(Reader[DSL.BXMX.GRZF_BAO_FIELD]);
mBXMX.GRCDBao = Convert.ToDecimal(Reader[DSL.BXMX.GRCD_BAO_FIELD]);
mBXMX.LNZHBao = Convert.ToDecimal(Reader[DSL.BXMX.LNZH_BAO_FIELD]);
mBXMX.TCJJ = Convert.ToDecimal(Reader[DSL.BXMX.TCJJ_FIELD]);
mBXMX.JZFS = Reader[DSL.BXMX.JZFS_FIELD].ToString().Trim();
mBXMX.ReimbursementRatio = Convert.ToDecimal(Reader[DSL.BXMX.RBM_RATIO_FIELD]);
return(mBXMX);
}
