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