/// <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;
}
protected void Page_Load(object sender, EventArgs e)
{
//获取页面传来的值
string action = Request.Params["action"].ToString();
string strPatientInfoJson = "";//患者门诊住院信息
string strDiagnoseInfoJson = "";//门诊住院诊断信息
//string strExamineRequestJson = "";//检验申请单信息
//string strSurgeryRequestJson = "";//手术申请单信息
//string strEmployeeInfoJson = "";//员工信息
if (action == "gethisdata")
{
string In_CodeType = Request.Params["In_CodeType"].ToString();
string In_Code = Request.Params["In_Code"].ToString();
if (string.IsNullOrEmpty(In_Code) || string.IsNullOrEmpty(In_CodeType) || In_Code == "" || In_CodeType == "") { }
else
{
Model.FP_SY_HIS_IP_PublicInterface model = new Model.FP_SY_HIS_IP_PublicInterface();
model.In_Code = In_Code;
model.In_CodeType = int.Parse(In_CodeType);
Dictionary<string, string> dic = new Dictionary<string, string>();
#region 将获取到的存储过程转化为JSON再存放到dic里面，然后dic序列化成json
//strPatientInfoJson = GetSY_HC_GetPatientInfoJson(model);
//if (!string.IsNullOrEmpty(strPatientInfoJson))
//{
// strDiagnoseInfoJson = GetSY_HC_GetDiagnoseInfoJson(model);
// if (!string.IsNullOrEmpty(strDiagnoseInfoJson))
// {
// dic.Add("_BaseInfo", strPatientInfoJson);
// dic.Add("_ClinicalInfo", strDiagnoseInfoJson);
// }
//}
//Response.Write(FreezerProUtility.Fp_Common.FpJsonHelper.DictionaryToJsonString(dic));
#endregion
#region 临时数据
string testRes1 = "{\"_BaseInfo\":{\"ds\":[{\"PatientID\":1000456613,\"PatientName\":\"黄燕娥 \",\"SexFlag\":2,\"IdentityCardNo\":445122199111110088,\"BirthDay\":\"1952-07-24\",\"PatientCardNo\":\"诊疗卡号\",\"BloodTypeFlag\":3,\"InPatientID\":1000435093,\"IPSeqNoText\":\"P114083\",\"IPTimes\":1,\"InDateTime\":\"2003-10-08\",\"OutDate\":\"1900-01-01\",\"Phone\":\"13610187509 \",\"ContactPhone\":\"110\",\"ContactPerson\":\"110\",\"NativePlace\":\"广州市 \",\"RegisterID\":-1,\"RegisterSeqNO\":\"\"}]},\"_ClinicalInfo\":{\"ds\":[{\"DiagnoseTypeFlag\":0,\"DiagnoseDateTime\":\"1900-01-01\",\"DiseaseName\":\"子宫平滑肌瘤\",\"ICDCode\":\"D25.902\",\"Description\":\" \"},{\"DiagnoseTypeFlag\":2,\"DiagnoseDateTime\":\"2014-11-18\",\"DiseaseName\":\"子宫平滑肌瘤\",\"ICDCode\":\"D25.902\",\"Description\":\"\"}]}}";
string testRes3 = "{\"_BaseInfo\":{\"ds\":[{\"PatientID\":3708555,\"PatientName\":\"叶万福\",\"SexFlag\":1,\"BirthDay\":\"1979-06-20T00:00:00\",\"PatientCardNo\":\"00000000000003186114\",\"BloodTypeFlag\":2,\"InPatientID\":1000930666,\"IPSeqNoText\":\"P369939\",\"IPTimes\":4,\"InDateTime\":\"2011-02-21T15:15:00\",\"OutDate\":\"2011-03-04T00:00:00\",\"Phone\":\"13727579435\",\"ContactPhone\":\"13727579435\",\"ContactPerson\":\"曾瑞丽\",\"NativePlace\":\"广东 韶关\",\"RegisterID\":-1,\"RegisterSeqNO\":\"13727579435\"}]},\"_ClinicalInfo\":{\"ds\":[{\"DiagnoseTypeFlag\":0,\"DiagnoseDateTime\":\"1900-01-01T00:00:00\",\"DiseaseName\":\"肝恶性肿瘤\",\"ICDCode\":\"C22.902\",\"Description\":\"\"},{\"DiagnoseTypeFlag\":2,\"DiagnoseDateTime\":\"1900-01-01T00:00:00\",\"DiseaseName\":\"肝恶性肿瘤\",\"ICDCode\":\"C22.902\",\"Description\":\"\"}]}}";
string testRes4 = "{\"_BaseInfo\":{\"ds\":[{\"PatientID\":2893599,\"PatientName\":\"朱家昌\",\"SexFlag\":1,\"BirthDay\":\"1992-12-06T00:00:00\",\"PatientCardNo\":\"00000000000002410204\",\"BloodTypeFlag\":0,\"InPatientID\":1000802037,\"IPSeqNoText\":\"P316855\",\"IPTimes\":1,\"InDateTime\":\"2009-08-17T19:15:00\",\"OutDate\":\"1900-01-01T00:00:00\",\"Phone\":\"13650067289\",\"ContactPhone\":\"\",\"ContactPerson\":\"朱庆业\",\"NativePlace\":\"广西合浦\",\"RegisterID\":-1,\"RegisterSeqNO\":\"\"}]},\"_ClinicalInfo\":{\"ds\":[{\"DiagnoseTypeFlag\":0,\"DiagnoseDateTime\":\"1900-01-01T00:00:00\",\"DiseaseName\":\"\",\"ICDCode\":\"\",\"Description\":\"鞍区占位\"},{\"DiagnoseTypeFlag\":2,\"DiagnoseDateTime\":\"1900-01-01T00:00:00\",\"DiseaseName\":\"颅内（脑）恶性肿瘤\",\"ICDCode\":\"C71.901\",\"Description\":\"\"}]}}";
string testRes5 = "{\"_BaseInfo\":{\"ds\":[{\"PatientID\":1000027755,\"PatientName\":\"金澧\",\"SexFlag\":2,\"BirthDay\":\"1928-11-15T00:00:00\",\"PatientCardNo\":\"00000000000001818570\",\"BloodTypeFlag\":3,\"InPatientID\":1000731655,\"IPSeqNoText\":\"P229252\",\"IPTimes\":4,\"InDateTime\":\"2008-09-28T18:24:00\",\"OutDate\":\"2008-10-13T00:00:00\",\"Phone\":\"37633105\",\"ContactPhone\":\"\",\"ContactPerson\":\"陈渝新\",\"NativePlace\":\"河南\",\"RegisterID\":-1,\"RegisterSeqNO\":\"\"}]},\"_ClinicalInfo\":\"\"}";
string testRes6 = "{\"_BaseInfo\":\"{\"ds\":[{\"PatientID\":4275746,\"PatientName\":\"黄启明\",\"SexFlag\":1,\"BirthDay\":\"1957-08-07T00:00:00\",\"PatientCardNo\":\"00000000000003763896\",\"BloodTypeFlag\":6,\"InPatientID\":1001167124,\"IPSeqNoText\":\"P451545\",\"IPTimes\":4,\"InDateTime\":\"2013-06-13T15:06:00\",\"OutDate\":\"2013-06-21T00:00:00\",\"Phone\":\"34149533\",\"ContactPhone\":\"\",\"ContactPerson\":\"\",\"NativePlace\":\"广东省增城市\",\"RegisterID\":-1,\"RegisterSeqNO\":\"\"}]}\",\"_ClinicalInfo\":\"{\"ds\":[{\"DiagnoseTypeFlag\":2,\"DiagnoseDateTime\":\"2013-06-21T00:00:00\",\"DiseaseName\":\"肺恶性肿瘤\",\"ICDCode\":\"C34.900\",\"Description\":\"左上肺腺癌 cT4N3M1b(颈部淋巴结\"}]}\"}";
string testRes7 = "{\"_BaseInfo\":\"{\"ds\":[{\"PatientID\":1000316238,\"PatientName\":\"郑思凌\",\"SexFlag\":1,\"BirthDay\":\"1926-05-05T00:00:00\",\"PatientCardNo\":\" \",\"BloodTypeFlag\":2,\"InPatientID\":1001388333,\"IPSeqNoText\":\"P30449\",\"IPTimes\":20,\"InDateTime\":\"2015-04-28T15:25:00\",\"OutDate\":\"2015-05-26T00:00:00\",\"Phone\":\"83588146\",\"ContactPhone\":\"\",\"ContactPerson\":\"郑向群\",\"NativePlace\":\"广东省恩平市\",\"RegisterID\":-1,\"RegisterSeqNO\":\"\"}]}\",\"_ClinicalInfo\":\"{\"ds\":[{\"DiagnoseTypeFlag\":2,\"DiagnoseDateTime\":\"2015-05-26T08:22:19.853\",\"DiseaseName\":\"冠状动脉粥样硬化性心脏病\",\"ICDCode\":\"I25.103\",\"Description\":\"\"}]}\"}";
string testRes8 = "{\"_BaseInfo\":\"{\"ds\":[{\"PatientID\":4549694,\"PatientName\":\"冼孔文\",\"SexFlag\":1,\"BirthDay\":\"1943-08-26T00:00:00\",\"PatientCardNo\":\"00000000000003988514\",\"BloodTypeFlag\":1,\"InPatientID\":1001146625,\"IPSeqNoText\":\"P493488\",\"IPTimes\":1,\"InDateTime\":\"2013-04-08T08:56:00\",\"OutDate\":\"2013-05-26T00:00:00\",\"Phone\":\"13652855444\",\"ContactPhone\":\"\",\"ContactPerson\":\"冼玉清\",\"NativePlace\":\"广东省吴川市黄坡县(区)\",\"RegisterID\":-1,\"RegisterSeqNO\":\"\"}]}\",\"_ClinicalInfo\":\"{\"ds\":[{\"DiagnoseTypeFlag\":2,\"DiagnoseDateTime\":\"2013-05-26T09:06:32.367\",\"DiseaseName\":\"主动脉瓣狭窄\",\"ICDCode\":\"I35.000\",\"Description\":\"\"}]}\"}";
//object obj=FreezerProUtility.Fp_Common.FpJsonHelper.DeserializeObjectStr(testRes2);
switch (In_Code)
{
case "1": Response.Write(testRes1); break;
case "3": Response.Write(testRes3); break;
case "4": Response.Write(testRes4); break;
case "5": Response.Write(testRes5); break;
case "6": Response.Write(testRes6); break;
case "7": Response.Write(testRes7); break;
case "8": Response.Write(testRes8); break;
default:
break;
}
#endregion
}
}
//查询知情同意书
if (action == "getConsentForm")
{
string name = Request.Params["gname"].ToString();
string uid = Request.Params["guid"].ToString();
Model.TB_CONSENT_FORM consent = new Model.TB_CONSENT_FORM();
consent.PatientName = name;
consent.PatientID = Convert.ToInt32(uid);
BLL.TB_CONSENT_FORM bll = new TB_CONSENT_FORM();
string strJson = bll.GetTB_CONSENT_FORM_BLL(consent);
Response.Write(strJson);
}
//查询知情同意书数量
if (action == "getConsentFormCount")
{
string name = Request.Params["gname"].ToString();
string uid = Request.Params["guid"].ToString();
Model.TB_CONSENT_FORM consent = new Model.TB_CONSENT_FORM();
consent.PatientName = name;
consent.PatientID = Convert.ToInt32(uid);
BLL.TB_CONSENT_FORM bll = new TB_CONSENT_FORM();
int count = bll.GetTB_CONSENT_FORM_BLL(consent, 1);
Response.Write(count);
}
//查询设定
if (action == "QuerySettingByCom")
{
string strJson = "";
string type = Request.Params["valueType"].ToString();//获取传输类型
string username = Common.CookieHelper.GetCookieValue("username");
string keshi = Common.CookieHelper.GetCookieValue(username + "department");
string StrDepartments = PageConData.DecryptDepartments(keshi);
BLL.TB_SETTING_VALUE bll = new TB_SETTING_VALUE();
System.Data.DataSet ds = bll.GetList("SETTING_TYPE='" + type + "' AND DEPARTMENTS='" + StrDepartments + "'");
if (ds.Tables[0].Rows.Count > 0)
{
strJson = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(ds);
}
Response.Write(strJson);
}
//删除设定
if (action == "DelSetting")
{
string strJson = "";
BLL.TB_SETTING_VALUE bll = new TB_SETTING_VALUE();
string StrArray = Request.Params["settingID"].ToString();
bool ISDel = bll.DeleteList(StrArray);
if (ISDel)
{
strJson = "删除成功";
}
else
{
strJson = "删除失败";
}
Response.Write(strJson);
}
//根据日期及类型读取
if (action == "getLogImport")
{
string strJson = "";
string strGetDataType = "";
string strImportType = Request.Params["Importtype"].ToString();
string[] array = strImportType.Split('-');
//获取传入的时间
string strStartDate = Request.Params["stratDate"].ToString();
string strendDate = Request.Params["endDate"].ToString();
//获取页码
int startCount = Convert.ToInt32(Request["startCount"]);
int endCount = Convert.ToInt32(Request["endCount"]);
//当第一次获取时，默认获取前10的数据
if (startCount==0||endCount==0)
{
startCount = 1;
endCount = 10;
}
else if (startCount>1)
{
endCount = startCount+10-1;
}
//传入页码
if (array.Length > 0)
{
BLL.Log_Show log_bll = new Log_Show();
//1代表当前用户，2代表当前科室
if (array[0] == "1")
{
//获取当前用户
if (array[1].ToString() != "")
{
strGetDataType = array[1].ToString();
strJson = log_bll.GetDate(strGetDataType, "", strStartDate, strendDate, startCount, endCount);
}
else{}
}
else
{
//获取当前科室
if (array[1].ToString() != "")
{
strGetDataType= PageConData.DecryptDepartments(array[1].ToString());
strJson = log_bll.GetDate("", strGetDataType, strStartDate, strendDate, startCount, endCount);
}
else
{
}
}
}
Response.Write(strJson);
}
//默认获取
if (action == "getDefaultImport")
{
try
{
string user = Common.CookieHelper.GetCookieValue("username");
string department = Common.CookieHelper.GetCookieValue(user + "department");
string strJson = "";
if (string.IsNullOrEmpty(user) || string.IsNullOrEmpty(department))
{
Response.Redirect("../../Login.aspx");
}
BLL.Log_Show log_Show = new BLL.Log_Show();
strJson = log_Show.GetDate(user, "");
Response.Write(strJson);
}
catch (Exception)
{
Response.Redirect("../../Login.aspx");
}
}
}