protected void bxdList_BxdSelect(object sender, BxdSelectedEventArgs e)
{
MRS.BLL.BXD bll_bxd = new BLL.BXD();
MRS.Model.BXD bxd = bll_bxd.GetBXD_By_BXDId(e.BxdId);
this.BxdId = e.BxdId;
this.Ybh = bxd.YBH;
}
public IList <MRS.Model.BXD> GetBXD_By_YBH(string YBH, DateTime BeginDate, DateTime EndDate)
{
IList <MRS.Model.BXD> mBXDs = new List <MRS.Model.BXD>();
SqlParameter ybh_parm = new SqlParameter(DSL.BXD.YBH_PARM, SqlDbType.NChar, 10);
SqlParameter begin_date_parm = new SqlParameter(DSL.BXD.CHARGE_UP_BEGIN_DATE_PARM, SqlDbType.DateTime);
SqlParameter end_date_parm = new SqlParameter(DSL.BXD.CHARGE_UP_END_DATE_PARM, SqlDbType.DateTime);
ybh_parm.Value = YBH;
begin_date_parm.Value = BeginDate;
end_date_parm.Value = EndDate;
SqlParameter[] parms = new SqlParameter[3];
parms.SetValue(ybh_parm, 0);
parms.SetValue(begin_date_parm, 1);
parms.SetValue(end_date_parm, 2);
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.SELECT_BXD_BY_YBH, parms))
{
while (reader.Read())
{
MRS.Model.BXD bxd = Parse(reader);
mBXDs.Add(bxd);
}
}
return(mBXDs);
}
private int AddBXD()
{
MRS.Model.BXD bxd = new MRS.Model.BXD();
bxd.MPeriodId = (cbbMPeriod.SelectedItem as MRS.Model.MPeriod).Id;
bxd.BXDate = DateTime.Now;
bxd.YBH = lbMedicareId.Text;
bxd.PsnType = lbPsnType.Text;
bxd.Accountant = tslbAccount.Text;
bxd.Name = lbBXPersonName.Text;
bxd.JobNumber = lbJobNumber.Text;
bxd.IdentityCard = lbIdentityCard.Text;
bxd.Birthday = Convert.ToDateTime(lbBirthday.Text);
bxd.Organization = lbOrganization.Text;
bxd.Sex = lbSex.Text;
bxd.ChargeUpSign = MRS.Model.BXD.ChargeUpSignType.NochargeUP.ToString();
int bxdId = bll_BXD.CreateBXD(bxd);
if (this.BxdCreated != null)
{
BxdSelectedEventArgs arg = new BxdSelectedEventArgs();
arg.BxdId = bxdId;
this.BxdCreated(this, arg);
}
return(bxdId);
}
public void UpdateBXD(MRS.Model.BXD bxd)
{
SqlParameter bxdid_parm = new SqlParameter(DSL.BXD.BXDID_PARM, SqlDbType.Int);
SqlParameter att_number_parm = new SqlParameter(DSL.BXD.ATT_NUMBER_PARM, SqlDbType.Int);
SqlParameter yyf_parm = new SqlParameter(DSL.BXD.YYF_PARM, SqlDbType.Decimal);
SqlParameter bxje_parm = new SqlParameter(DSL.BXD.BXJE_PARM, SqlDbType.Decimal);
SqlParameter zlf_parm = new SqlParameter(DSL.BXD.ZLF_PARM, SqlDbType.Decimal);
SqlParameter tcjj_parm = new SqlParameter(DSL.BXD.TCJJ_PARM, SqlDbType.Decimal);
SqlParameter grzfei_parm = new SqlParameter(DSL.BXD.GRZFEI_PARM, SqlDbType.Decimal);
SqlParameter grzfu_parm = new SqlParameter(DSL.BXD.GRZFU_PARM, SqlDbType.Decimal);
bxdid_parm.Value = bxd.BXDId;
att_number_parm.Value = bxd.AttNumber;
yyf_parm.Value = bxd.YYF;
bxje_parm.Value = bxd.BXJE;
zlf_parm.Value = bxd.ZLF;
tcjj_parm.Value = bxd.TCJJ;
grzfei_parm.Value = bxd.GRZFei;
grzfu_parm.Value = bxd.GRZFu;
SqlParameter[] parms = new SqlParameter[8];
parms.SetValue(bxdid_parm, 0);
parms.SetValue(att_number_parm, 1);
parms.SetValue(yyf_parm, 2);
parms.SetValue(bxje_parm, 3);
parms.SetValue(zlf_parm, 4);
parms.SetValue(tcjj_parm, 5);
parms.SetValue(grzfei_parm, 6);
parms.SetValue(grzfu_parm, 7);
SqlHelper.ExecuteNonQuery(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.UPDATE_BXD, parms);
}
protected MRS.Model.BXD Parse(SqlDataReader Reader)
{
MRS.Model.BXD mBXD = new MRS.Model.BXD();
mBXD.BXDId = Convert.ToInt32(Reader[DSL.BXD.BXDID_FIELD]);
mBXD.MPeriodId = Convert.ToInt32(Reader[DSL.BXD.M_PERIOD_ID_FIELD]);
mBXD.BXDate = Convert.ToDateTime(Reader[DSL.BXD.BXDATE_FIELD]);
mBXD.YBH = Reader[DSL.BXD.YBH_FIELD].ToString().Trim();
mBXD.PsnType = Reader[DSL.BXD.PSN_TYPE_FIELD].ToString().Trim();
mBXD.AttNumber = Convert.ToInt32(Reader[DSL.BXD.ATT_NUMBER_FIELD]);
mBXD.Accountant = Reader[DSL.BXD.ACCOUNTANT_FIELD].ToString().Trim();
mBXD.YYF = Convert.ToDecimal(Reader[DSL.BXD.YYF_FIELD]);
mBXD.BXJE = Convert.ToDecimal(Reader[DSL.BXD.BXJE_FIELD]);
mBXD.ZLF = Convert.ToDecimal(Reader[DSL.BXD.ZLF_FIELD]);
mBXD.TCJJ = Convert.ToDecimal(Reader[DSL.BXD.TCJJ_FIELD]);
mBXD.GRZFei = Convert.ToDecimal(Reader[DSL.BXD.GRZFEI_FIELD]);
mBXD.GRZFu = Convert.ToDecimal(Reader[DSL.BXD.GRZFU_FIELD]);
mBXD.Name = Reader[DSL.BXD.NAME_FIELD].ToString().Trim();
mBXD.JobNumber = Reader[DSL.BXD.JOB_NUMBER_FIELD].ToString().Trim();
mBXD.IdentityCard = Reader[DSL.BXD.IDENTITY_CARD_FIELD].ToString().Trim();
mBXD.Birthday = Convert.ToDateTime(Reader[DSL.BXD.BIRTHDAY_FIELD]);
mBXD.Organization = Reader[DSL.BXD.ORGANIZATION_FIELD].ToString().Trim();
mBXD.Sex = Reader[DSL.BXD.SEX_FIELD].ToString().Trim();
mBXD.ChargeUpSign = Reader[DSL.BXD.CHARGE_UP_SIGN_FIELD].ToString().Trim();
return(mBXD);
}
private void btnPrint_Click(object sender, EventArgs e)
{
if (gvIndividual.Rows.Count > 0)
{
int BXDId;
MRS.Model.BXD bxd = new MRS.Model.BXD();
BXDId = (int)gvIndividual.SelectedRows[0].Cells["BXDId"].Value;
bxd = bllBXD.GetBXD_By_BXDId(BXDId);
WarrantPrintDocument.DocumentName = "报销凭证 " + bxd.Name + " 记录单号：" + bxd.BXDId.ToString();
WarrantPrintDocument.Print();
}
}
private void InitDrawWarrantGraphic()
{
BaoXiaoDan = new MRS.Model.BXD();
WarrantTable = new MRS.Model.BXWarrantTable();
//WarrantSite = new Point();
MarginTop = 0;
MarginLeft = 15; //单元格内字与左边框的间距
TextFont = new Font("宋体", 12);
TitleFont = new Font("黑体", 16);
LineHeight = 30;
}
// 当收集完毕报销发票明细数据后，添加报销明细
void AddInvoice_InvoiceGetted(Model.BXMX bxmx)
{
if (gvBXD_Not_ChargeUP.SelectedRows.Count > 0)
{
int bxdId = (int)gvBXD_Not_ChargeUP.SelectedRows[0].Cells["BXDId"].Value;
//需要给bxmx 赋bxdId,和报销比例。
MRS.Model.BXD bxd = bllBXD.GetBXD_By_BXDId(bxdId);
bxmx.BXDId = bxdId;
bxmx.ReimbursementRatio = bll_ratio.GetRatio(bxd.MPeriodId, bxd.YBH, bxmx.JZFS);
bllBXMX.AddBXMX(bxmx);
bllBXD.Save_BXMX_Stat_To_BXD(bxdId);
Show_Bxmx(bxmx.BXDId);
}
}
/// <summary>
/// 从报销单数据表中获取未记账的记录。
/// </summary>
/// <returns></returns>
public IList <MRS.Model.BXD> GetBXD_Not_Charge_Up()
{
IList <MRS.Model.BXD> mBXDs = new List <MRS.Model.BXD>();
DBProcedure.Select_BXD_Not_Charge_Up prdCmd = new DBProcedure.Select_BXD_Not_Charge_Up();
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, prdCmd.Text, null))
{
while (reader.Read())
{
MRS.Model.BXD bxd = Parse(reader);
mBXDs.Add(bxd);
}
}
return(mBXDs);
}
public MRS.Model.BXD GetBXD_By_BXDId(int BXDId)
{
MRS.Model.BXD mBXD = new MRS.Model.BXD();
SqlParameter bxdid_parm = new SqlParameter(DSL.BXD.BXDID_PARM, SqlDbType.Int);
bxdid_parm.Value = BXDId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.SELECT_BXD_BY_BXDID, bxdid_parm))
{
if (reader.Read())
{
mBXD = Parse(reader);
}
}
return(mBXD);
}
public int CreateBXD(MRS.Model.BXD bxd)
{
int bxdid;
SqlParameter m_period_id_parm = new SqlParameter(DSL.BXD.M_PERIOD_ID_FIELD, SqlDbType.Int);
SqlParameter bxdate_parm = new SqlParameter(DSL.BXD.BXDATE_PARM, SqlDbType.DateTime);
SqlParameter ybh_parm = new SqlParameter(DSL.BXD.YBH_PARM, SqlDbType.NChar, 10);
SqlParameter psntype_parm = new SqlParameter(DSL.BXD.PSN_TYPE_PARM, SqlDbType.NChar, 10);
SqlParameter attnumber_parm = new SqlParameter(DSL.BXD.ATT_NUMBER_PARM, SqlDbType.Int);
SqlParameter accountant_parm = new SqlParameter(DSL.BXD.ACCOUNTANT_PARM, SqlDbType.NChar, 10);
SqlParameter yyf_parm = new SqlParameter(DSL.BXD.YYF_PARM, SqlDbType.Decimal);
SqlParameter bxje_parm = new SqlParameter(DSL.BXD.BXJE_PARM, SqlDbType.Decimal);
SqlParameter zlf_parm = new SqlParameter(DSL.BXD.ZLF_PARM, SqlDbType.Decimal);
SqlParameter tcjj_parm = new SqlParameter(DSL.BXD.TCJJ_PARM, SqlDbType.Decimal);
SqlParameter grzfei_parm = new SqlParameter(DSL.BXD.GRZFEI_PARM, SqlDbType.Decimal);
SqlParameter grzfu_parm = new SqlParameter(DSL.BXD.GRZFU_PARM, SqlDbType.Decimal);
SqlParameter name_parm = new SqlParameter(DSL.BXD.NAME_PARM, SqlDbType.NChar, 12);
SqlParameter jobnumber_parm = new SqlParameter(DSL.BXD.JOB_NUMBER_PARM, SqlDbType.NChar, 6);
SqlParameter identity_card_parm = new SqlParameter(DSL.BXD.IDENTITY_CARD_PARM, SqlDbType.NChar, 21);
SqlParameter birthday_parm = new SqlParameter(DSL.BXD.BIRTHDAY_PARM, SqlDbType.DateTime);
SqlParameter organization_parm = new SqlParameter(DSL.BXD.ORGANIZATION_PARM, SqlDbType.NChar, 50);
SqlParameter sex_parm = new SqlParameter(DSL.BXD.SEX_PARM, SqlDbType.NChar, 1);
SqlParameter charge_up_sign_parm = new SqlParameter(DSL.BXD.CHARGE_UP_SIGN_PARM, SqlDbType.NChar, 10);
m_period_id_parm.Value = bxd.MPeriodId;
bxdate_parm.Value = bxd.BXDate;
ybh_parm.Value = bxd.YBH;
psntype_parm.Value = bxd.PsnType;
attnumber_parm.Value = bxd.AttNumber;
accountant_parm.Value = bxd.Accountant;
yyf_parm.Value = bxd.YYF;
bxje_parm.Value = bxd.BXJE;
zlf_parm.Value = bxd.ZLF;
tcjj_parm.Value = bxd.TCJJ;
grzfei_parm.Value = bxd.GRZFei;
grzfu_parm.Value = bxd.GRZFu;
name_parm.Value = bxd.Name;
jobnumber_parm.Value = bxd.JobNumber;
identity_card_parm.Value = bxd.IdentityCard;
birthday_parm.Value = bxd.Birthday;
organization_parm.Value = bxd.Organization;
sex_parm.Value = bxd.Sex;
charge_up_sign_parm.Value = bxd.ChargeUpSign;
SqlParameter[] parms = new SqlParameter[19];
parms.SetValue(m_period_id_parm, 0);
parms.SetValue(bxdate_parm, 1);
parms.SetValue(ybh_parm, 2);
parms.SetValue(psntype_parm, 3);
parms.SetValue(attnumber_parm, 4);
parms.SetValue(accountant_parm, 5);
parms.SetValue(yyf_parm, 6);
parms.SetValue(bxje_parm, 7);
parms.SetValue(zlf_parm, 8);
parms.SetValue(tcjj_parm, 9);
parms.SetValue(grzfei_parm, 10);
parms.SetValue(grzfu_parm, 11);
parms.SetValue(name_parm, 12);
parms.SetValue(jobnumber_parm, 13);
parms.SetValue(identity_card_parm, 14);
parms.SetValue(birthday_parm, 15);
parms.SetValue(organization_parm, 16);
parms.SetValue(sex_parm, 17);
parms.SetValue(charge_up_sign_parm, 18);
bxdid = Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.INSERT_BXD, parms));
return(bxdid);
}
