public string GetDate(string user, string department, string start_date, string end_date, int starindex, int endindex)
{
DateTime Timestart = Convert.ToDateTime(start_date);
DateTime Timeend = Convert.ToDateTime(end_date);
if (DateTime.Compare(Timestart, Timeend) == 0)
{
end_date = Timeend.AddDays(1).ToString("yyyy-MM-dd");
}
string strWhere = "";
string strJson = "";
StringBuilder SB = new StringBuilder();
DataSet ds = new DataSet();
if (user != "")
{
strWhere = "Import_User_Id='" + user + "' AND Import_Date BETWEEN CONVERT(datetime,'" + start_date + "',120) AND CONVERT(datetime,'" + end_date + "',120)";
SB.Append(strWhere);
}
else if (department != "")
{
strWhere = "Import_User_Department='" + department + "'AND Import_Date BETWEEN CONVERT(datetime,'" + start_date + "',120) AND CONVERT(datetime,'" + end_date + "',120)";
SB.Append(strWhere);
}
RuRo.Model.ModelForDataGrid model = new RuRo.Model.ModelForDataGrid();
model = GetDateByDate(SB, starindex, endindex);
strJson = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(model);
return strJson;
}
/// <summary>
/// 获取数据根据当前日期
/// </summary>
/// <param name="date"></param>
public string GetDate(string user, string department)
{
//默认情况下查询当前日期下的当前用户的数据
//根据用户获取当前日期的数据
//判断department是否为空
StringBuilder SB = new StringBuilder();
string strDate = DateTime.Now.ToString("yyyy-MM-dd");
RuRo.Model.ModelForDataGrid model = new RuRo.Model.ModelForDataGrid();
string strJson = GetDate(user, "", strDate, strDate, 1, 10);
return strJson;
}
/// <summary>
///
/// </summary>
/// <param name="strWhere">默认请指定科室或用户</param>
/// <param name="stratIndex"></param>
/// <param name="endIndex"></param>
private RuRo.Model.ModelForDataGrid GetDateByDate(StringBuilder strWhere, int stratIndex, int endIndex)
{
Log_Import log_Import = new Log_Import();
BasedInfo basedInfo = new BasedInfo();
TB_CONSENT_FORM tb_CONSENT_FORM = new TB_CONSENT_FORM();
RuRo.Model.ModelForDataGrid model = new RuRo.Model.ModelForDataGrid();
int count = log_Import.GetRecordCount(strWhere.ToString());
model.Total = count.ToString();
if (string.IsNullOrEmpty(strWhere.ToString()))
{
strWhere = new StringBuilder();
strWhere.Append(" T.Import_State=1 and T.Import_Type = 'sample' ");
}
else
{
strWhere.Append(" and T.Import_State=1 and T.Import_Type = 'sample' ");
}
DataSet ds_Log_Import = log_Import.GetListByPage(strWhere.ToString(), "", stratIndex, endIndex);
String strWherePatients = "";
if (ds_Log_Import.Tables[0].Rows.Count>0)
{
strWherePatients = CreatPatientIDWhere(ds_Log_Import);
}
if (strWherePatients.ToString().Length > 0)
{
//查询基本信息
DataSet ds_BaseInfo = basedInfo.GetList(" PatientID in (" + strWherePatients + ")");
//查询知情同意信息
DataSet ds_Tb_CONSENT_FORM = tb_CONSENT_FORM.GetList(" PatientID in (" + strWherePatients + ")");
model.JsonData = CreatResultDataSet(ds_Log_Import, ds_BaseInfo, ds_Tb_CONSENT_FORM);
}
else
{
model.JsonData = ds_Log_Import;
}
return model;
}
