protected Model.BXRatio Parse(System.Data.SqlClient.SqlDataReader reader) { Model.BXRatio ratio = new Model.BXRatio(); DBTable.BXRatio table = new SQLServerDAL.DBTable.BXRatio(); ratio.Id = Convert.ToInt32(reader[table.Id.Text]); ratio.OrderNumber = Convert.ToInt32(reader[table.OrderNumber.Text]); ratio.MinKBJE = Convert.ToDecimal(reader[table.MinKBJE.Text]); ratio.MaxKBJE = Convert.ToDecimal(reader[table.MaxKBJE.Text]); ratio.HspType = reader[table.HspType.Text].ToString().Trim(); ratio.Ratio = Convert.ToDecimal(reader[table.Ratio.Text]); return(ratio); }
/// <summary> /// 获取当前报销比例。 /// </summary> /// <param name="mPeriodId">医保年度。</param> /// <param name="YBH">医保号。</param> /// <param name="hspType">就诊方式。</param> /// <returns></returns> public decimal GetRatio(int mPeriodId, string YBH, string hspType) { decimal ratio = 0; DBProcedure.Select_BXRatio prdCmdText = new SQLServerDAL.DBProcedure.Select_BXRatio(); DBTable.BXRatio table = new SQLServerDAL.DBTable.BXRatio(); SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text); prdHelper.SetInputValue(prdCmdText.PARM_MPeriodId.ParameterName, mPeriodId); prdHelper.SetInputValue(prdCmdText.PARM_YBH.ParameterName, YBH); prdHelper.SetInputValue(prdCmdText.PARM_HspType.ParameterName, hspType); using (SqlDataReader reader = prdHelper.ExecuteReader()) { if (reader.Read()) { ratio = Convert.ToDecimal(reader[table.Ratio.Text]); } } prdHelper.Dispose(); return(ratio); }