/// <summary> /// 生成 很纯洁的 实体对象 /// </summary> /// <returns></returns> public P_User ToExtModle() { P_User info = new P_User() { ID = this.ID, DepID = this.DepID, LoginName = this.LoginName, WorkCode = this.WorkCode, Name = this.Name, PassWord = this.PassWord, Gender = this.Gender, IsActive = this.IsActive, SN = this.SN, P_Department = this.P_Department.ToPOCO() }; return info; }
/// <summary> /// 生成 很纯洁的 实体对象 /// </summary> /// <returns></returns> public P_User ToExtModle() { P_User info = new P_User() { ID = this.ID, DepID = this.DepID, LoginName = this.LoginName, WorkCode = this.WorkCode, Name = this.Name, PassWord = this.PassWord, Gender = this.Gender, IsActive = this.IsActive, SN = this.SN, P_Department = this.P_Department.ToPOCO() }; return(info); }
public object GetAmbulanceState() { StringBuilder sb = new StringBuilder(); sb.Append(@" select 编码,名称 from TZAmbulanceState where 是否有效=1 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); List<P_User> list = new List<P_User>(); if (ds.Tables[0].Rows.Count > 0) { P_User info = new P_User(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new P_User(); info.ID = Convert.ToInt32(dr["编码"]); info.Name = dr["名称"].ToString(); list.Add(info); } } return list; }
//获取combobox姓名 public object GetNameList() { List<P_User> list = new List<P_User>(); StringBuilder strSQL = new StringBuilder(); strSQL.Append(@"select ID,Name from P_User where IsActive = 1"); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.Text, strSQL.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { P_User info = new P_User(); info.ID = Convert.ToInt32(dr["ID"]); info.Name = dr["Name"].ToString(); list.Add(info); } } return list; }
/// <summary> /// 视图-任务列表 /// </summary> public ActionResult MedicalManagement() { string menuName = ""; string startTime = null; string endTime = null; string searchBound = null; P_User pUser = new P_User(); pUser = UserOperateContext.Current.Session_UsrInfo;//获取登录人信息 ViewData["MenuName"] = menuName; ViewData["WorkCode"] = pUser.WorkCode;//登录人ID //this.ViewData["startTime"] = startTime == null ? "2012-10-20" : startTime;//测试 //this.ViewData["endTime"] = endTime == null ? "2012-10-21" : endTime;//测试 this.ViewData["startTime"] = startTime == null ? DateTime.Now.AddDays(-AppConfig.GetConfigInt("PRSearchTime")).ToString("yyyy-MM-dd HH:mm:ss") : startTime; this.ViewData["endTime"] = endTime == null ? DateTime.Now.AddHours(1).ToString("yyyy-MM-dd HH:mm:ss") : endTime; UserOperateContext userOperateContext = new UserOperateContext(); bool SelectALL = userOperateContext.getGongneng(38);//查看全部出车信息 bool SelectOwnCenter = userOperateContext.getGongneng(42);//查看本分中心 bool SelectOwnStation = userOperateContext.getGongneng(43);//查看本分站 bool SelectOwn = userOperateContext.getGongneng(44);//查看本人出车信息 bool Insert = userOperateContext.getGongneng(45);//判断登录人有“新增”病历权限 bool Edit = userOperateContext.getGongneng(46);//判断登录人有“修改”病历权限 bool Delete = userOperateContext.getGongneng(55);//判断登录人有“删除”病历权限 bool Look = userOperateContext.getGongneng(56);//判断登录人有“查看”病历权限 if (SuperRole("SuperRole")) { this.ViewData["SuperRole"] = "SuperRole";//登录人有超级权限 } else this.ViewData["SuperRole"] = ""; this.ViewData["SelectOwn"] = "";// this.ViewData["PatientRole"] = "";// if (SelectALL) { searchBound = "1"; } else { if (SelectOwnCenter) searchBound = "2"; else { if (SelectOwnStation) searchBound = "3"; else { if (SelectOwn) { searchBound = "4"; this.ViewData["SelectOwn"] = "SelectOwn";// string role = UserOperateContext.Current.getMaxPerForRole();//获取登录人角色(医生、护士、司机) this.ViewData["PatientRole"] = role;// } else { searchBound = "4"; this.ViewData["SelectOwn"] = "";// this.ViewData["PatientRole"] = "";// } } } } if (Insert) { this.ViewData["RolePermissionInsert"] = "Insert";//登录人有新增病历权限 } else this.ViewData["RolePermissionInsert"] = "";// if (Edit) { this.ViewData["RolePermissionEdit"] = "Edit";//登录人有修改病历权限 } else this.ViewData["RolePermissionEdit"] = "";// if (Delete) { this.ViewData["RolePermissionDelete"] = "Delete";//登录人有删除病历权限 } else this.ViewData["RolePermissionDelete"] = "";// if (Look) { this.ViewData["RolePermissionLook"] = "Look";//登录人有查看病历权限 } else this.ViewData["RolePermissionLook"] = "";// this.ViewData["searchBound"] = searchBound == null ? "4" : searchBound;//权限 return View(); }
private static object m_SyncRoot = new Object(); //互斥对象 #endregion Fields #region Methods /// <summary> /// 病历页面初始化 /// </summary> /// <param name="TaskCode">任务编码</param> /// <param name="PatientOrder">序号</param> /// <param name="state">填写状态</param> /// <returns></returns> public ActionResult AddPatientRecord(string TaskCode, int PatientOrder, string state) { //, int PatientOrder//测试 M_PatientRecordBLL prBLL = new M_PatientRecordBLL(); M_DictionaryBLL dBLL = new M_DictionaryBLL(); //int PatientOrder = 1;//测试 M_AttemperData result = prBLL.GetAttemperData(TaskCode, state);//根据任务编码获取调度信息 ViewBag.Attemper = result; ViewData["TaskCode"] = TaskCode == null ? "2012102023555200020101" : TaskCode; M_PatientRecord prInfo;//病历主表信息 M_PatientRecordAppend pra;//病历附表--体检等信息 M_PatientRecordCPR prCPR;//病历附表--心肺复苏 if (state == "new") { int AddPatientOrder = prBLL.GetPatientMaxOrder(TaskCode); ViewData["PatientOrder"] = AddPatientOrder; prInfo = new M_PatientRecord(); pra = new M_PatientRecordAppend(); prCPR = new M_PatientRecordCPR(); ViewBag.PRInfo = prInfo;//病历主表信息--传到页面 ViewBag.PRAppendInfo = pra;//病历附表--体检等信息--传到页面 ViewBag.PRCPRInfo = prCPR;//病历附表--心肺复苏--传到页面 } else { object oPatientInfo;//病历主表 prBLL.GetPatientInfo(TaskCode, PatientOrder, out oPatientInfo, out pra, out prCPR); if (PatientOrder > 0) { prInfo = (M_PatientRecord)oPatientInfo; ViewBag.PRInfo = prInfo;//病历主表信息--传到页面 ViewBag.PRAppendInfo = pra;//病历附表--体检等信息--传到页面 ViewBag.PRCPRInfo = prCPR;//病历附表--心肺复苏--传到页面 ViewData["PatientOrder"] = PatientOrder; if (SuperRole("SuperRole")) { this.ViewData["SuperRole"] = "SuperRole";//登录人有超级权限 } else this.ViewData["SuperRole"] = ""; string role = UserOperateContext.Current.getMaxPerForRole();//获取登录人角色(医生、护士、司机) this.ViewData["PatientRole"] = role;// } } ViewData["state"] = state == null ? "new" : state; if (SuperRole("PRAuditCPR")) { this.ViewData["PRAuditCPR"] = "PRAuditCPR";//登录人有“心肺复苏审核”权限 } else this.ViewData["PRAuditCPR"] = ""; if (SuperRole("SubCenterSpotChecks")) { this.ViewData["SubCenterSpotChecks"] = "SubCenterSpotChecks";//登录人有"分中心抽查"权限 } else this.ViewData["SubCenterSpotChecks"] = ""; if (SuperRole("CenterSpotChecks")) { this.ViewData["CenterSpotChecks"] = "CenterSpotChecks";//登录人有"中心抽查"权限 } else this.ViewData["CenterSpotChecks"] = ""; P_User pUser = new P_User(); pUser = UserOperateContext.Current.Session_UsrInfo;//获取登录人信息 ViewData["AgentCode"] = pUser.ID; ViewData["AgentWorkID"] = pUser.WorkCode; ViewData["AgentName"] = pUser.Name; ViewData["BeginFillPatientTime"] = DateTime.Now.ToString();//开始填写病历时间 #region 为病历页面的CheckBoxList项目赋值 CheckViewModel model = new CheckViewModel(); //model.DiseasesClassification = dBLL.GetCheckBoxModelByTableName("M_ZCaseTemplate");//病种分类 //model.GongShiRen = dBLL.GetCheckBoxModel("GongShiRen");//供史人 //model.AnamnesisllnessHistory = dBLL.GetCheckBoxModel("PastMedicalHistory");//既往病史 model.BodyFigure = dBLL.GetCheckBoxModel("PiFu");//皮肤 model.Head = dBLL.GetCheckBoxModel("Head");//头部 model.Neck = dBLL.GetCheckBoxModel("Neck");//颈部 model.Chest = dBLL.GetCheckBoxModel("Chest");//胸部 model.Lung = dBLL.GetCheckBoxModel("Lung");//肺脏 model.LungLeft = dBLL.GetCheckBoxModel("LungLeft");//左肺 model.LungRight = dBLL.GetCheckBoxModel("LungLeft");//右肺 model.FuBu = dBLL.GetCheckBoxModel("FuBu");//腹部 model.JiZhu = dBLL.GetCheckBoxModel("JiZhu");//脊柱 model.Limb = dBLL.GetCheckBoxModel("Limb");//四肢 #endregion #region 为病历页面的RadioButtonList从数据库传值 var ProvideMedicalHistoryPeople = new object();//供史人 var DiseasesClassification = new object();//病种分类 var PastMedicalHistory = new object();//既往病史 var BabinskiSign = new object();//神经系统--巴氏征 var ChestExtrusionTest = new object();//胸廓挤压试验 var PelvicExtrusionTest = new object();//骨盆挤压试验 lock (m_SyncRoot) { ProvideMedicalHistoryPeople = CacheHelper.GetCache("ProvideMedicalHistoryPeople"); DiseasesClassification = CacheHelper.GetCache("DiseasesClassification"); PastMedicalHistory = CacheHelper.GetCache("PastMedicalHistory"); BabinskiSign = CacheHelper.GetCache("BabinskiSign"); ChestExtrusionTest = CacheHelper.GetCache("ChestExtrusionTest"); PelvicExtrusionTest = CacheHelper.GetCache("PelvicExtrusionTest"); if (ProvideMedicalHistoryPeople == null) { ProvideMedicalHistoryPeople = dBLL.GetCheckBoxOrRadioButtonList("Checkbox", "ProvideMedicalHistoryPeople", "checkbox"); CacheHelper.SetCache("ProvideMedicalHistoryPeople", ProvideMedicalHistoryPeople); } if (DiseasesClassification == null) { DiseasesClassification = dBLL.GetCheckBoxListByTableName("M_ZCaseTemplate", "DiseasesClassification", "checkbox"); CacheHelper.SetCache("DiseasesClassification", DiseasesClassification); } if (PastMedicalHistory == null) { PastMedicalHistory = dBLL.GetCheckBoxOrRadioButtonList("Checkbox", "PastMedicalHistory", "checkbox"); CacheHelper.SetCache("PastMedicalHistory", PastMedicalHistory); } if (BabinskiSign == null) { BabinskiSign = dBLL.GetCheckBoxOrRadioButtonList("Checkbox", "BabinskiSign", "checkbox"); CacheHelper.SetCache("BabinskiSign", BabinskiSign); } if (ChestExtrusionTest == null) { ChestExtrusionTest = dBLL.GetCheckBoxOrRadioButtonList("Radio", "ChestExtrusionTest", "radio"); CacheHelper.SetCache("ChestExtrusionTest", ChestExtrusionTest); } if (PelvicExtrusionTest == null) { PelvicExtrusionTest = dBLL.GetCheckBoxOrRadioButtonList("Radio", "PelvicExtrusionTest", "radio"); CacheHelper.SetCache("PelvicExtrusionTest", PelvicExtrusionTest); } } this.ViewData["ProvideMedicalHistoryPeople"] = ProvideMedicalHistoryPeople; this.ViewData["DiseasesClassification"] = DiseasesClassification; this.ViewData["PastMedicalHistory"] = PastMedicalHistory; this.ViewData["BabinskiSign"] = BabinskiSign; this.ViewData["ChestExtrusionTest"] = ChestExtrusionTest; this.ViewData["PelvicExtrusionTest"] = PelvicExtrusionTest; #endregion return View(model); }
public ActionResult DataLoad(int page, int rows, string order, string sort, DateTime startTime, DateTime endTime , string linkPhone, int alarmEventType, string localAddr, string taskResult, int taskAbendReason , string centerCode, string stationCode, string ambCode, string driver, string doctor, string litter, string isCharge , string isFill, string nurse, string patientName, string searchBound, string isTest, string CPRIFSuccess, string PatientState) { try { P_User pUser = new P_User(); pUser = UserOperateContext.Current.Session_UsrInfo;//获取登录人信息 //bool t= UserOperateContext.Current.Session_UsrRole.Contains(10);//判断登录人是否为司机 M_UserLoginInfo loginInfo = new M_UserLoginInfo(); loginInfo.LoginName = pUser.LoginName; loginInfo.Name = pUser.Name;//姓名 loginInfo.WorkCode = pUser.WorkCode;//工号 loginInfo.DispatchSubCenterID = pUser.P_Department.DispatchSubCenterID;//所属分中心 loginInfo.DispatchSationID = pUser.P_Department.DispatchSationID;//所属分站 //loginInfo.RoleID = pUser.P_UserRole.RoleID; M_PatientRecordBLL M_PateintRecord = new M_PatientRecordBLL(); var list = M_PateintRecord.GetTasks(page, rows, order, sort, startTime, endTime, linkPhone, alarmEventType, localAddr , taskResult, taskAbendReason, centerCode, stationCode, ambCode, driver, doctor, litter, isCharge, isFill , nurse, patientName, searchBound, isTest, loginInfo, CPRIFSuccess, PatientState); //if (list != null) //{ //return this.Json(new { total = list, rows = list }, "appliction/json", JsonRequestBehavior.AllowGet); return this.Json(list, "appliction/json", JsonRequestBehavior.AllowGet); //} //else //{ // return this.Json(new { total = 0, rows = 0 }, "appliction/json", JsonRequestBehavior.AllowGet); //} } catch { return this.Json(""); } }
public object Get_LS_DDYGZZT_RYXM() { StringBuilder sb = new StringBuilder(); sb.Append(@" select tp.编码,tp.姓名 from TPerson tp left join TRole tr on tr.编码 = tp.类型编码 where tp.类型编码 = 2 and tp.是否有效 = 1"); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); List<P_User> list = new List<P_User>(); if (ds.Tables[0].Rows.Count > 0) { P_User info = new P_User(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new P_User(); info.ID = Convert.ToInt32(dr["编码"]); info.Name = dr["姓名"].ToString(); list.Add(info); } } return list; }
//根据中心编码取分站 (中心,分站联动,统计流水用) //public string ListToString(List<int> list) //{ // string result = ""; // foreach (int i in list) // { // result = result + i.ToString() + ","; // } // return result.TrimEnd(','); //} //根据中心编码取分站 (中心,分站联动,统计流水用) public object GetStation(string centerID) { StringBuilder sb = new StringBuilder(); sb.Append(@" select 编码,名称 from TStation "); sb.Append("where 是否有效 = 1"); WhereClauseUtility.AddInSelectQuery("中心编码", centerID, sb); //where 中心编码 in (" + centerID + ") and 是否有效 =1 "); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.AttemperConnectionString, CommandType.Text, sb.ToString(), null); List<P_User> list = new List<P_User>(); if (ds.Tables[0].Rows.Count > 0) { P_User info = new P_User(); foreach (DataRow dr in ds.Tables[0].Rows) { info = new P_User(); info.ID = Convert.ToInt32(dr["编码"]); info.Name = dr["名称"].ToString(); list.Add(info); } } return list; }