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