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); }