public void DeleteAccount(int Id)
{
DBProcedure.Delete_Account prdCmdText = new ShareOS.SQLServerDAL.DBProcedure.Delete_Account();
SQLProcedure prdHelper = new SQLProcedure(ConnectionString.ConnectionStringShares, prdCmdText.Text);
prdHelper.SetInputValue(prdCmdText.PARM_Id.ParameterName, Id);
prdHelper.ExecuteNonQuery();
}
public DataTable Create_Report_ZHJFYLF_Stat(int mPeriodId, decimal zhjfylf_greater_than)
{
DataTable report = new DataTable("ZHJFYLF");
Common.DBUtility.SQLProcedure Procedure = new SQLProcedure(ConnectionString.ConnectionStringMRS, CommandText.REPORT_ZHJFYLF_STAT);
Procedure.SetInputValue(DSL.AccountBook.MPERIOD_ID_PARM, mPeriodId);
Procedure.SetInputValue(DSL.AccountBook.ZHJFYLF_PARM, zhjfylf_greater_than);
Procedure.ExecuteAdapter().Fill(report);
return(report);
}
public string Get()
{
try
{
SQLProcedure.StoredProcedure("Upload");
return("Загружено");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 综合减负医药费报告,按选定月份统计。
/// </summary>
/// <param name="beginDate">开始日期时间（包括）</param>
/// <param name="endDate">结束日期时间（不包括）</param>
/// <param name="zhjfylf_greater_than">大于此综合减负医药费</param>
/// <returns></returns>
public DataTable Create_Report_ZHJFYLF_Stat_ByMonth(DateTime beginDate, DateTime endDate, decimal zhjfylf_greater_than)
{
DataTable report = new DataTable("ZHJFYLF");
Common.DBUtility.SQLProcedure Procedure = new SQLProcedure(ConnectionString.ConnectionStringMRS, CommandText.REPORT_ZHJFYLF_STAT_BYMONTH);
Procedure.SetInputValue(DSL.AccountBook.BEGINDATE_PARM, beginDate);
Procedure.SetInputValue(DSL.AccountBook.ENDDATE_PARM, endDate);
Procedure.SetInputValue(DSL.AccountBook.ZHJFYLF_PARM, zhjfylf_greater_than);
Procedure.ExecuteAdapter().Fill(report);
return(report);
}
public void InsertAccount(string UserName, string Password, string UserType, string TrueName)
{
DBProcedure.Insert_Account prdCmdText = new ShareOS.SQLServerDAL.DBProcedure.Insert_Account();
SQLProcedure prdHelper = new SQLProcedure(ConnectionString.ConnectionStringShares, prdCmdText.Text);
prdHelper.SetInputValue(prdCmdText.PARM_UserName.ParameterName, UserName);
prdHelper.SetInputValue(prdCmdText.PARM_Password.ParameterName, Password);
prdHelper.SetInputValue(prdCmdText.PARM_UserType.ParameterName, UserType);
prdHelper.SetInputValue(prdCmdText.PARM_TrueName.ParameterName, TrueName);
prdHelper.ExecuteNonQuery();
}
public bool Delete(int ruleId)
{
bool returnValue = false;
DBProcedure.Delete_BXRatio prdCmdText = new DBProcedure.Delete_BXRatio();
SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
prdHelper.SetInputValue(prdCmdText.PARM_Id.ParameterName, ruleId);
returnValue = prdHelper.ExecuteNonQuery();
prdHelper.Dispose();
return(returnValue);
}
/// <summary>
/// 获取公司补充医保资金历年使用情况报告。
/// </summary>
/// <returns></returns>
public DataTable GetReportZJLNSYQK()
{
DataTable report = new DataTable("ZJLNSYQK");
DBProcedure.Report_ZJLNSYQK prdCmdText = new DBProcedure.Report_ZJLNSYQK();
SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
using (SqlDataReader reader = prdHelper.ExecuteReader())
{
SqlDataReaderHelper rdHelper = new SqlDataReaderHelper(reader);
rdHelper.LoopReadToTable(out report);
}
prdHelper.Dispose();
return(report);
}
public bool Insert(MRS.Model.BXRatio ratio)
{
bool returnValue = false;
DBProcedure.Insert_BXRatio prdCmdText = new SQLServerDAL.DBProcedure.Insert_BXRatio();
SQLProcedure Procedure = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
Procedure.SetInputValue(prdCmdText.PARM_OrderNumber.ParameterName, ratio.OrderNumber);
Procedure.SetInputValue(prdCmdText.PARM_MinKBJE.ParameterName, ratio.MinKBJE);
Procedure.SetInputValue(prdCmdText.PARM_MaxKBJE.ParameterName, ratio.MaxKBJE);
Procedure.SetInputValue(prdCmdText.PARM_HspType.ParameterName, ratio.HspType);
Procedure.SetInputValue(prdCmdText.PARM_Ratio.ParameterName, ratio.Ratio);
returnValue = Procedure.ExecuteNonQuery();
Procedure.Dispose();
return(returnValue);
}
/// <summary>
/// 获取个人历年报销情况报告
/// </summary>
/// <param name="ybh">医保号</param>
/// <returns></returns>
public DataTable GetReportGRLNBX(string ybh)
{
DataTable report = new DataTable("GRLNBX");
DBProcedure.Report_GRLNBX prdCmdText = new DBProcedure.Report_GRLNBX();
SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
prdHelper.SetInputValue(prdCmdText.PARM_YBH.ParameterName, ybh);
using (SqlDataReader reader = prdHelper.ExecuteReader())
{
SqlDataReaderHelper rdHelper = new SqlDataReaderHelper(reader);
rdHelper.LoopReadToTable(out report);
}
prdHelper.Dispose();
return(report);
}
/// <summary>
/// 获取公司补充医保资金季度使用情况报告。
/// </summary>
/// <returns></returns>
public DataTable GetReportZJJDSYQK(int mPeriodId)
{
DataTable report = new DataTable("ZJJDSYQK");
DBProcedure.Report_ZJJDSYQK prdCmdText = new DBProcedure.Report_ZJJDSYQK();
SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
prdHelper.SetInputValue(prdCmdText.PARM_MPeriodId.ParameterName, mPeriodId);
using (SqlDataReader reader = prdHelper.ExecuteReader())
{
SqlDataReaderHelper rdHelper = new SqlDataReaderHelper(reader);
rdHelper.LoopReadToTable(out report);
}
prdHelper.Dispose();
return(report);
}
public IList <MRS.Model.BXRatio> Select()
{
IList <MRS.Model.BXRatio> ratioes = new List <MRS.Model.BXRatio>();
DBProcedure.Select_BXRatio_All prdCmdText = new SQLServerDAL.DBProcedure.Select_BXRatio_All();
SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
using (SqlDataReader reader = prdHelper.ExecuteReader())
{
while (reader.Read())
{
Model.BXRatio ratio = Parse(reader);
ratioes.Add(ratio);
}
}
prdHelper.Dispose();
return(ratioes);
}
public ShareOS.Model.Account GetAccountByUserName(string UserName)
{
ShareOS.Model.Account account;
DBProcedure.Select_Account_By_UserName prdCmdText = new ShareOS.SQLServerDAL.DBProcedure.Select_Account_By_UserName();
SQLProcedure prdHelper = new SQLProcedure(ConnectionString.ConnectionStringShares, prdCmdText.Text);
prdHelper.SetInputValue(prdCmdText.PARM_UserName.ParameterName, UserName);
using (SqlDataReader reader = prdHelper.ExecuteReader())
{
if (reader.Read())
{
account = Parse(reader);
}
else
{
account = new ShareOS.Model.Account();
}
}
return(account);
}
/// <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);
}
public ServicesController(SQLProcedure service)
{
_serviceSQL = service;
}
