public void TrueMail() { if (tb1.Text == registration.code.ToString()) { Table <Autorization_users> autoid = db.GetTable <Autorization_users>(); foreach (var id in autoid) { idusers = id.Id_users + 1; } Autorization_users autorization_Users = new Autorization_users { email = registration.EText.ToString(), password_users = registration.PText.ToString(), isenable = true }; db.GetTable <Autorization_users>().InsertOnSubmit(autorization_Users); db.SubmitChanges(); HospitalInfo hospitalInfo = new HospitalInfo { name_hospital = registration.text.ToString(), city_hospital = registration.HCity.ToString(), adress_hospital = registration.HAdress.ToString(), id_fk_autorization = idusers }; db.GetTable <HospitalInfo>().InsertOnSubmit(hospitalInfo); db.SubmitChanges(); MainWindow mainWindow = new MainWindow(); mainWindow.Show(); this.Close(); } else if (tb1.Text != registration.code.ToString()) { mark.Content = "Неверно указан код"; } }
/// <summary> /// 门诊农合接口 /// </summary> public MZ_NccmInterface() { HisData hisData = new HisData(); hisData.uploadorg = MED_ORG_CODE; hisData.uploadTime = DateTime.Now.ToString("yyyy-MM-dd"); DataClass dataClass = new DataClass(); DataType dataType = new DataType(); dataType.dataTypeName = ""; dataType.dataTypeValue = "1"; JoinArea joinArea = new JoinArea(); joinArea.code = JOIN_AREA_CODE; joinArea.name = JOIN_AREA_NAME; hisData.joinArea = joinArea; hisData.dataClass = dataClass; hisData.dataType = dataType; hospitalInfo = NccmInterfaces.DownLoadHospitalInfo(hisData); //初始化匹配列表 matchList = HIS.SYSTEM.Core.BindEntity <Model.NCMS_MATCH_CATALOG_TEMP> .CreateInstanceDAL(oleDb).GetListArray(""); }
private void btn_savehospital_Click(object sender, EventArgs e) { if (this.txthospitalname.Text.Trim().Length == 0) { MessageBox.Show("请输入医院名称!", "系统提示!"); this.txthospitalname.Focus(); return; } if (this.txtdepartment.Text.Trim().Length == 0) { MessageBox.Show("请输入科室名称!", "系统提示!"); this.txtdepartment.Focus(); return; } HospitalInfo objHospitalInfo = new HospitalInfo(); objHospitalInfo.Department = this.txtdepartment.Text.Trim(); objHospitalInfo.HospitalName = this.txthospitalname.Text.Trim(); addhospitalinfo(objHospitalInfo); int res = objHospitalInfoService.AddHospitalInfo(objHospitalInfo); if (res > 0) { MessageBox.Show("添加成功!", "系统提示!"); } }
public FrmDataExport(string bednum) { InitializeComponent(); int bed = Convert.ToInt16(bednum); string bedstr = ""; if (bed > 255) { bedstr = "#" + (bed - 256).ToString(); } else { bedstr = bed.ToString(); } this.txt_bednum.Text = bedstr; PatientInfo patientInfo = objPatientService.GetPatientInfoBybednum(Convert.ToInt16(bednum)); HospitalInfo hospitalInfo = new HospitalInfoService().GetHospitalInfo(); if (hospitalInfo == null) { hospitalInfo = new HospitalInfo(); hospitalInfo.Department = "科室名称"; hospitalInfo.HospitalName = "医院名称"; } dic.Add("name", patientInfo.PatientName); dic.Add("age", patientInfo.PatientAge); dic.Add("bednum", patientInfo.PatientBednum); dic.Add("patientnum", patientInfo.PatientNum); dic.Add("hospital", hospitalInfo.HospitalName); dic.Add("depart", hospitalInfo.Department); dic.Add("gender", patientInfo.PatientGender); }
public ActionResult DeleteConfirmed(int id) { HospitalInfo hospitalInfo = db.HospitalInfoes.Find(id); db.HospitalInfoes.Remove(hospitalInfo); db.SaveChanges(); return(RedirectToAction("Index")); }
public HospitalInfo AddHospitalInfo(string str1, string str2) { HospitalInfo objHospitalInfo = new HospitalInfo(); objHospitalInfo.HospitalName = str1; objHospitalInfo.Department = str2; return(objHospitalInfo); }
/// <summary> /// 添加医院信息 /// </summary> public int AddHospitalInfo(HospitalInfo objHospitalInfo) { string sql = "update HospitalInfo set HospitalName='{0}',Department='{1}' where Flag=1"; sql = string.Format(sql, objHospitalInfo.HospitalName, objHospitalInfo.Department); int res = SQLiteHelper.Update(sql); return(res); }
public int insertInfo(HospitalInfo hospitalInfo) { string sql = "insert into HospitalInfo(HospitalName,Department,Flag) values('{0}','{1}','{2}') "; sql = string.Format(sql, hospitalInfo.HospitalName, hospitalInfo.Department, 1); int res = SQLiteHelper.Update(sql); return(res); }
public ActionResult Edit([Bind(Include = "Id,Name,Address,ContactPhone,ContactMobile,Contactmobile2,DoctorName")] HospitalInfo hospitalInfo) { if (ModelState.IsValid) { db.Entry(hospitalInfo).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hospitalInfo)); }
public ActionResult Create([Bind(Include = "Id,Name,Address,ContactPhone,ContactMobile,Contactmobile2,DoctorName")] HospitalInfo hospitalInfo) { if (ModelState.IsValid) { db.HospitalInfoes.Add(hospitalInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hospitalInfo)); }
//查询 private void query(int pageNo) { try { resultInfo("正在查询,请稍后..."); isQuery = true; //清空面板 clear(); hospitalList = null; HospitalParam param = new HospitalParam(); param.pageNo = pageNo.ToString(); param.pageSize = "12"; hospitalList = RegistrationAccess.HospitalQuery(param); if ("9999".Equals(hospitalList.success)) { resultInfo(hospitalList.msg); return; } if (hospitalList.data.rows.Count == 0) { if (pageNo == 1) { resultInfo("今日暂无记录,请明日再查"); } else { resultInfo("未查询到医院信息"); } if (pageNo > 2) { pageNo--; } return; } for (int i = 0; i < hospitalList.data.rows.Count; i++) { setButton(this, ("button" + (i + 1)), ("name" + (i + 1)), hospitalList.data.rows[i].hospital_name); } resultInfo("请选择医院"); return; } catch (ThreadAbortException ae) { log.Write("error:" + ae.Message); } catch (Exception ex) { resultInfo("暂无预约信息"); log.Write("error:FormRegistrationHospital_1:query():" + ex.Message); } finally { isQuery = false; } }
// GET: HospitalInfoes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HospitalInfo hospitalInfo = db.HospitalInfoes.Find(id); if (hospitalInfo == null) { return(HttpNotFound()); } return(View(hospitalInfo)); }
public HospitalInfo GetHospitalizationInfo() { //Hashtable hs = new Hashtable(); //// 出入院 //hs.Add("cry", new Hashtable() { { "jrcyrs", 37 }, { "zrryrs", 482 } }); //出入院 //hs.Add("crytj", new Hashtable() { // 出入院统计 // {"ryrs",new int[]{460,455,463,152,90,678,482}}, // {"cyrs",new int[]{216,145,108,27,6,33,6}} //}); //// 住院收入 //hs.Add("zysr", new Hashtable() { // {"zrzysr", 699.12}, // {"jrzysr", 612} } //); //hs.Add("zysrje", // new double[] { 301.12, 465.87, 642.76, 812.12, 762.12, 542.02, 699.12 } //); //// 病床使用率 //hs.Add("bc", new Hashtable() { { "zcws", 3200 }, { "dqzy", 2842 } }); //床位 //hs.Add("bcsyl", new double[] { 87.12, 84.56, 86.34, 90.04, 92.17, 85.22, 88.89 }); //// 住院人均 //hs.Add("zyrj", new Hashtable() { { "zrrjfy", 1024 }, { "syrjfy", 652 }, { "qnrjfy", 864 } }); //住院人均 //hs.Add("rjjetj", new int[] { 545, 1944, 810, 697, 1604, 976, 1024 }); HospitalInfo hos = new HospitalInfo(); // 出入院 hos.cry.jrcyrs = 754; hos.cry.zrryrs = 765; hos.crytj.ryrs = new object[] { 460, 455, 463, 152, 90, 678, 482 }; hos.crytj.cyrs = new object[] { 216, 145, 108, 27, 6, 33, 6 }; // 住院收入 hos.zysr.zrzysr = 699.12; hos.zysr.jrzysr = 612; hos.zysrje = new object[] { 301.12, 465.87, 642.76, 812.12, 762.12, 542.02, 699.12 }; // 病床使用率 hos.bc.zcws = 4211; hos.bc.dqzy = 3892; hos.bcsyl = new object[] { 87.12, 84.56, 86.34, 90.04, 92.17, 85.22, 88.89 }; // 住院人均 hos.zyrj.zrrjfy = 1024; hos.zyrj.syrjfy = 652; hos.zyrj.qnrjfy = 864; hos.rjjetj = new object[] { 545, 1944, 810, 697, 1604, 976, 1024 }; return(hos); }
public ActionResult InsertHospital([FromBody] HospitalInfo hospitalInfo) { Hospital hospital = new Hospital { Id = Guid.NewGuid().ToString(), Name = hospitalInfo.Name, PhoneNumber = hospitalInfo.PhoneNumber, RegisterDate = DateTime.Now, ServiceCatalogId = hospitalInfo.ServiceCatalogId, AdminId = hospitalInfo.AdminId }; context.Hospitals.Add(hospital); context.SaveChanges(); return(new CreatedAtActionResult("GetHospitalInfo", "Hospitals", new { id = hospital.Id }, hospital)); }
private void FrmInsurMatch_Load(object sender, EventArgs e) { try { _hospitalInfo = HIS.Base_BLL.BaseDataReader.Get_Ncms_HisInfo(); } catch { MessageBox.Show("连接新农合服务器失败,未能读取到最新的医院信息。", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } LoadData(); ShowData(true, true, true); plPageIndex.Visible = false; }
/// <summary> /// 查询医院信息 /// </summary> /// <returns></returns> public HospitalInfo GetHospitalInfo() { string sql = "select HospitalName,Department from HospitalInfo where Flag=1"; SQLiteDataReader objReader = SQLiteHelper.GetReader(sql); HospitalInfo objHospitalInfo = null; if (objReader.Read()) { objHospitalInfo = new HospitalInfo() { HospitalName = objReader["HospitalName"].ToString(), Department = objReader["Department"].ToString() }; } objReader.Close(); return(objHospitalInfo); }
public async Task <ActionResult <CreatedHospitalDTO> > CreateHospital([FromBody] HospitalInfo hospitalInfo) { Hospital hospital = new Hospital { HospitalId = Guid.NewGuid().ToString(), Name = hospitalInfo.Name, PhoneNumber = hospitalInfo.PhoneNumber, RegisterDate = DateTime.Now, ServiceCatalogId = hospitalInfo.ServiceCatalogId, IsEnable = true }; await context.Hospitals.AddAsync(hospital); await context.SaveChangesAsync(); var hospitalDTO = mapper.Map <CreatedHospitalDTO>(hospital); return(new CreatedAtRouteResult($"GetHospitalInfo", new { id = hospitalDTO.HospitalId }, hospitalDTO)); }
/// <summary> /// 下载医院信息 /// </summary> /// <returns></returns> public static HospitalInfo DownLoadHospitalInfo(HisData hisData) { string strParameter = Newtonsoft.Json.JavaScriptConvert.SerializeObject(hisData); Message recieveMsg = new Message(); recieveMsg.DES = false; recieveMsg.GZipCompress = false; recieveMsg.dataContent = strParameter; Message retMsg = new Message(); try { retMsg = ncmsInterface.downLoadHospitalInfo(recieveMsg); //先解密 if (retMsg.DES == true) { retMsg.dataContent = NccmFunction.decrypt(retMsg.dataContent, sKey); } //再解压 if (retMsg.GZipCompress == true) { retMsg.dataContent = NccmFunction.gZipDeCompress(retMsg.dataContent); } Type type = typeof(DownLoadHospitalInfoResult); //反序列化对象 DownLoadHospitalInfoResult info = (DownLoadHospitalInfoResult)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(retMsg.dataContent, type); if (info.resultId == false) { throw new Exception(info.resultString); } HospitalInfo hsInfo = info.hospitalInfo; return(hsInfo); } catch (Exception err) { throw err; } }
public async Task <ActionResult> Create(HospitalInfo hospitalinfo) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44349"); var ck = ControllerContext.HttpContext.Request.Cookies["Token"]; client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", ck); var postTask = await client.PostAsJsonAsync <HospitalInfo>("api/Hospitals", hospitalinfo); if (postTask.IsSuccessStatusCode) { return(RedirectToAction("Index")); } else { ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator."); return(View("Create")); } } }
private void createdata6() { var count = db.HospitalInfoes.Where(a => a.Name == "-").Count(); if (count > 0) { } else { HospitalInfo hi = new HospitalInfo(); hi.Address = "-"; hi.ContactMobile = "0"; hi.Contactmobile2 = "0"; hi.ContactPhone = "0"; hi.DoctorName = "-"; hi.Id = 1; hi.Name = "-"; db.HospitalInfoes.Add(hi); db.SaveChanges(); } }
/// <summary> /// 获取农合医疗机构信息 /// </summary> /// <returns></returns> public static HospitalInfo Get_Ncms_HisInfo() { HisData hisData = new HisData(); hisData.uploadorg = "400866951"; hisData.uploadTime = DateTime.Now.ToString("yyyy-MM-dd"); DataClass dataClass = new DataClass(); DataType dataType = new DataType(); dataType.dataTypeName = ""; dataType.dataTypeValue = "1"; JoinArea joinArea = new JoinArea(); joinArea.code = "430121"; joinArea.name = "长沙县"; hisData.joinArea = joinArea; hisData.dataClass = dataClass; hisData.dataType = dataType; try { HospitalInfo hospitalInfo = NccmInterfaces.DownLoadHospitalInfo(hisData); if (hospitalInfo != null) { return(hospitalInfo); } else { throw new Exception("Invoke Successful but result is null"); } } catch (Exception err) { throw new Exception(err.Message); } }
/// <summary> /// 上传匹配关系 /// </summary> public static void UploadMatchInfo(MatchInfo[] matchList, HospitalInfo hospitalInfo, out string Msg) { JoinArea joinArea = new JoinArea(); joinArea.code = CURRENT_JOINAREA_CODE; joinArea.name = CURRENT_JOINAREA_NAME; DataType dataType = new DataType(); dataType.dataTypeName = NcmsDataType.门诊数据.ToString(); dataType.dataTypeValue = ((int)NcmsDataType.门诊数据).ToString(); //定义本次上传的项目集合 ItemMatchInfo[] matchItems = new ItemMatchInfo[matchList.Length]; for (int i = 0; i < matchList.Length; i++) { ItemMatchInfo matchItem = new ItemMatchInfo(); matchItem.drug_alias = matchList[i].drug_alias; matchItem.drug_form = matchList[i].drug_form; matchItem.drug_type = matchList[i].drug_type; matchItem.hospital_code = matchList[i].hospital_code; matchItem.if_equal = "0"; matchItem.limit_desc = matchList[i].limit_desc; matchItem.medorg_code = hospitalInfo.org_id; matchItem.ncms_code = matchList[i].ncms_code; matchItem.price = matchList[i].price1; matchItem.price1 = matchList[i].price1; matchItem.price2 = matchList[i].price2; matchItem.price3 = matchList[i].price3; matchItem.region_code = CURRENT_REGION_CODE; matchItem.specs = matchList[i].specs; matchItem.status = "1"; matchItem.therapy_content = matchList[i].therapy_content; matchItem.therapy_exclude = matchList[i].therapy_exclude; matchItem.type = matchList[i].type; matchItem.upload_time = DateTime.Now.ToString("yyyy-MM-dd"); matchItem.uploader = hospitalInfo.userCode; matchItem.use_level = matchList[i].use_levle; matchItems[i] = matchItem; } RecieveHospitalMatchInfo hisData = new RecieveHospitalMatchInfo(); hisData.itemMatchInfo = matchItems; hisData.joinArea = joinArea; hisData.dataType = dataType; hisData.uploadorg = "111"; try { ItemMatchInfo[] uploadFailedItems; if (NccmInterfaces.UploadMatchInfo(hisData, out uploadFailedItems, out Msg)) { //回写上传标识nnms_match_catalog_temp.status for (int i = 0; i < matchList.Length; i++) { bool uploadSuccess = true; if (uploadFailedItems != null) { for (int j = 0; j < uploadFailedItems.Length; j++) { //跳过上传失败的记录 if (matchList[i].ncms_code == uploadFailedItems[j].ncms_code && matchList[i].hospital_code == uploadFailedItems[j].hospital_code) { uploadSuccess = false; break; } } } if (uploadSuccess) { string strWhere = HIS.BLL.Tables.ncms_match_catalog_temp.HOSPITAL_CODE + oleDb.EuqalTo() + "'" + matchList[i].hospital_code + "'"; strWhere += oleDb.And() + HIS.BLL.Tables.ncms_match_catalog_temp.NCMS_CODE + oleDb.EuqalTo() + "'" + matchList[i].ncms_code + "'"; HIS.SYSTEM.Core.BindEntity <Model.NCMS_MATCH_CATALOG_TEMP> .CreateInstanceDAL(oleDb).Update(strWhere, "STATUS='1'"); } } } } catch (Exception err) { throw err; } }
/// <summary> /// 批量清洗医院 /// </summary> /// <param name="HospitalInfo"></param> /// <returns></returns> public ReturnValueModel AddUpdateHospitalInfo(List <YXHospitalViewModel> HospitalInfo) { ReturnValueModel rvm = new ReturnValueModel(); if (HospitalInfo == null || HospitalInfo.Count == 0) { rvm.Msg = "没有医院数据需要更新。"; rvm.Success = false; return(rvm); } List <HospitalInfo> list = new List <HospitalInfo>(); foreach (var item in HospitalInfo) { var hospital = _rep.FirstOrDefault <HospitalInfo>(s => s.Id == item.Id); if (hospital != null) { //item.Id = items.Id; switch ((item.status ?? "").Trim().ToLower()) { case "active": hospital.IsVerify = 1; break; case "inactive": hospital.IsVerify = 3; break; case "undetermined": hospital.IsVerify = 2; break; default: hospital.IsVerify = 0; break; } //hospital.YsId = item.YsId; hospital.hospital_code = item.hospital_code; hospital.hospital_name_SFE = item.hospital_name_SFE; hospital.serial_number = item.serial_number; hospital.status = item.status; hospital.reason = item.reason; hospital.unique_hospital_id = item.unique_hospital_id; hospital.yunshi_hospital_id = item.yunshi_hospital_id; hospital.hospital_name = item.hospital_name; hospital.hospital_alias = item.hospital_alias; hospital.hospital_level = item.hospital_level; hospital.hospital_category = item.hospital_category; hospital.hospital_nature = item.hospital_nature; hospital.hospital_organization_code = item.hospital_organization_code; hospital.province = item.province; hospital.city = item.city; hospital.area = item.area; hospital.YsAddress = item.YsAddress; hospital.post_code = item.post_code; hospital.hospital_phone = item.hospital_phone; hospital.website = item.website; //hospital.number_of_beds = Convert.ToInt32(item.number_of_beds); hospital.number_of_beds = item.number_of_beds; //hospital.number_of_outpatient = Convert.ToInt32(item.number_of_outpatient); hospital.number_of_outpatient = item.number_of_outpatient; //hospital.hospitalization = Convert.ToInt32(item.hospitalization); hospital.hospitalization = item.hospitalization; hospital.hospital_intro = item.hospital_intro; //hospital.number_of_employees = Convert.ToInt32(item.number_of_employees); hospital.number_of_employees = item.number_of_employees; hospital.modifier = item.modifier; if (item.change_time != null) { hospital.change_time = item.change_time; } else { hospital.change_time = DateTime.Now; } hospital.data_update_type = item.data_update_type; _rep.Update(hospital); _rep.SaveChanges(); LoggerHelper.WriteLogInfo($"---- AddUpdateHospitalInfo Update Begin 批量清洗医院 ---------------"); LoggerHelper.WriteLogInfo($"[doctor.Id]:{hospital?.Id}\n"); LoggerHelper.WriteLogInfo($"[doctor.HospitalName]:{ hospital?.HospitalName }\n"); LoggerHelper.WriteLogInfo($"[doctor.IsVerify]:{ hospital?.IsVerify }\n"); LoggerHelper.WriteLogInfo($"---- AddUpdateHospitalInfo Update End ----------------------------"); } else { hospital = new HospitalInfo() { Id = Guid.NewGuid().ToString(), IsDeleted = 0, IsEnabled = 0, //YsId = item.YsId, hospital_code = item.hospital_code, hospital_name_SFE = item.hospital_name_SFE, serial_number = item.serial_number, status = item.status, reason = item.reason, unique_hospital_id = item.unique_hospital_id, yunshi_hospital_id = item.yunshi_hospital_id, hospital_name = item.hospital_name, hospital_alias = item.hospital_alias, hospital_level = item.hospital_level, hospital_category = item.hospital_category, hospital_nature = item.hospital_nature, hospital_organization_code = item.hospital_organization_code, province = item.province, city = item.city, area = item.area, YsAddress = item.YsAddress, post_code = item.post_code, hospital_phone = item.hospital_phone, website = item.website, //number_of_beds = Convert.ToInt32(item.number_of_beds), number_of_beds = item.number_of_beds, //number_of_outpatient = Convert.ToInt32(item.number_of_outpatient), number_of_outpatient = item.number_of_outpatient, //hospitalization = Convert.ToInt32(item.hospitalization), hospitalization = item.hospitalization, hospital_intro = item.hospital_intro, //number_of_employees = Convert.ToInt32(item.number_of_employees), number_of_employees = item.number_of_employees, modifier = item.modifier, change_time = item.change_time, data_update_type = item.data_update_type, CreateTime = DateTime.Now }; switch ((item.status ?? "").Trim().ToLower()) { case "active": hospital.IsVerify = 1; break; case "inactive": hospital.IsVerify = 3; break; case "undetermined": hospital.IsVerify = 2; break; default: hospital.IsVerify = 0; break; } list.Add(hospital); LoggerHelper.WriteLogInfo($"---- AddUpdateHospitalInfo Add Begin 批量清洗医院 ---------------"); LoggerHelper.WriteLogInfo($"[doctor.Id]:{hospital?.Id}\n"); LoggerHelper.WriteLogInfo($"[doctor.HospitalName]:{ hospital?.HospitalName }\n"); LoggerHelper.WriteLogInfo($"[doctor.IsVerify]:{ hospital?.IsVerify }\n"); LoggerHelper.WriteLogInfo($"---- AddUpdateHospitalInfo Add End ----------------------------"); } } if (list.Count() > 0) { _rep.BulkCopyInsert(list); } _rep.SaveChanges(); rvm.Msg = "success"; rvm.Success = true; rvm.Result = new { //DoctorInfo = DoctorInfo msg = "批量更新医院成功!" }; return(rvm); }
public HospitalInfo GetHospitalizationInfo() { //Hashtable hs = new Hashtable(); string[] weekArr = new string[] { DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"), DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd"), DateTime.Now.AddDays(-5).ToString("yyyy-MM-dd"), DateTime.Now.AddDays(-4).ToString("yyyy-MM-dd"), DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd"), DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd"), DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") }; // 获取今日出院人数 string getTodayOutHospitalNumCommand = GetIOHospitalNumSQL(DateTime.Now, DateTime.Now, "OUT"); object todayOutHospitalNum = GenerateDate("RS", db, getTodayOutHospitalNumCommand); // 获取昨日入院人数 string getLastdayInHospitalNumCommand = GetIOHospitalNumSQL(DateTime.Now.AddDays(-1), DateTime.Now.AddDays(-1), "IN"); object lastdayInHospitalNum = GenerateDate("RS", db, getLastdayInHospitalNumCommand); // 获取上一周入院人数统计数 string getLastweekInHospitalNumCommand = GetLastweekIOHospitalNumSQL("IN"); object[] lastweekInHospitalNum = GenerateDate("RQ", "RS", weekArr, db, getLastweekInHospitalNumCommand); // 获取上一周出院人数统计数 string getLastweekOutHospitalNumCommand = GetLastweekIOHospitalNumSQL("OUT"); object[] lastweekOutHospitalNum = GenerateDate("RQ", "RS", weekArr, db, getLastweekOutHospitalNumCommand); // 获取昨日收入 string getYestodayInncomeCommand = GetBeInHospitalInncomeSQL(DateTime.Now.AddDays(-1), DateTime.Now.AddDays(-1)); object yestodayInncomeNum = GenerateDate("ZSR", db, getYestodayInncomeCommand); // 获取今日目前收入 string getTodayInncomeCommand = GetBeInHospitalInncomeSQL(DateTime.Now, DateTime.Now); object getTodayInncome = GenerateDate("ZSR", db, getTodayInncomeCommand); // 获取近一周收入 string getLastweekInncomeCommand = GetBeInHospitalInncomeSQL(DateTime.Now.AddDays(-7), DateTime.Now.AddDays(-1)); object getLastweekInncome = GenerateDate("RQ", "ZSR", weekArr, db, getLastweekInncomeCommand); //// 出入院 //hs.Add("cry", new Hashtable() { // {"jrcyrs",todayOutHospitalNum}, // {"zrryrs",lastdayInHospitalNum} //}); //hs.Add("crytj", new Hashtable() { // {"ryrs",lastweekInHospitalNum}, // {"cyrs",lastweekOutHospitalNum} //}); //// 住院收入 //hs.Add("zysr", new Hashtable() { // {"zysr",yestodayInncomeNum}, // {"jrzysr",getTodayInncome} //}); //hs.Add("zysrje", getLastweekInncome); //// 病床使用率 //hs.Add("bc", new Hashtable() { { "zcws", 3200 }, { "dqzy", 2842 } }); //床位 //hs.Add("bcsyl", new double[] { 87.12, 84.56, 86.34, 90.04, 92.17, 85.22, 88.89 } ); //// 住院人均 //hs.Add("zyrj", new Hashtable() { { "zrrjfy", 1024 }, { "syrjfy", 652 }, { "qnrjfy", 864 } }); //住院人均 //hs.Add("rjjetj", new int[] { 545, 1944, 810, 697, 1604, 976, 1024 }); //return hs; HospitalInfo hos = new HospitalInfo(); // 出入院 hos.cry.jrcyrs = int.Parse(todayOutHospitalNum.ToString()); hos.cry.zrryrs = int.Parse(lastdayInHospitalNum.ToString()); hos.crytj.ryrs = lastweekInHospitalNum; hos.crytj.cyrs = lastweekOutHospitalNum; // 住院收入 hos.zysr.zrzysr = double.Parse(yestodayInncomeNum.ToString()); hos.zysr.jrzysr = double.Parse(getTodayInncome.ToString()); hos.zysrje = getLastweekInncome; // 病床使用率 hos.bc.zcws = 3200; hos.bc.dqzy = 2842; hos.bcsyl = new object[] { 87.12, 84.56, 86.34, 90.04, 92.17, 85.22, 88.89 }; // 住院人均 hos.zyrj.zrrjfy = 1024; hos.zyrj.syrjfy = 652; hos.zyrj.qnrjfy = 864; hos.rjjetj = new object[] { 545, 1944, 810, 697, 1604, 976, 1024 }; return(hos); }
///// <summary> ///// 更新微信用户的医院、科室信息 ///// </summary> ///// <param name="wxUserModel"></param> ///// <returns></returns> //public ReturnValueModel UpdateWxUser(WxUserModel wxUserModel) //{ // ReturnValueModel rvm = new ReturnValueModel(); // var wxUser = _rep.FirstOrDefault<WxUserModel>(s => s.IsDeleted != 1 && s.UnionId == wxUserModel.UnionId); // if (wxUser != null) // { // wxUser.HospitalName = wxUserModel.HospitalName; // wxUser.DepartmentName = wxUserModel.DepartmentName; // wxUser.UpdateTime = DateTime.Now; // wxUser.creation_time = DateTime.Now; // wxUser.IsCompleteRegister = 1; // if (wxUser.IsVerify == 0) wxUser.IsVerify = 5; //完成注册后变成认证中 // //创建手写签名 // RegisterModel model = new RegisterModel(); // model.UnionId = wxUser.UnionId; // //图片存储地址 // model.SignUpName = wxUser.Remark; // _rep.Insert(model); // _rep.Update(wxUser); // _rep.SaveChanges(); // rvm.Msg = "success"; // rvm.Success = true; // rvm.Result = new // { // wxUser = wxUser // }; // } // else // { // rvm.Msg = "fail"; // rvm.Success = false; // } // return rvm; //} /// <summary> /// 更新医生医院及科室 /// </summary> /// <param name="wxUserModel"> /// 微信用户信息: /// HospitalName, /// DepartmentName /// </param> /// <param name="isRegistering">是否想注册用户</param> /// <returns></returns> public ReturnValueModel UpdateDocHospitalOrDept(WorkUser workUser, WxUserModel wxUserModel, bool isRegistering) { ReturnValueModel rvm = new ReturnValueModel(); var id = workUser?.WxUser?.Id; var doc = _rep.FirstOrDefault <WxUserModel>(s => s.IsDeleted != 1 && s.Id == id); if (doc == null) { rvm.Success = false; rvm.Msg = "此用户未通过微信授权"; return(rvm); } if (doc.IsVerify == 1) { rvm.Success = false; rvm.Msg = "已认证用户无法修改个人信息"; return(rvm); } if (isRegistering && doc.IsCompleteRegister == 1) { LoggerHelper.WriteLogInfo($"---- UpdateDocHospitalOrDept Begin 重复注册了!! ----------"); LoggerHelper.WriteLogInfo($"[doctor.Id]:{doc?.Id}\n"); LoggerHelper.WriteLogInfo($"[doctor.UnionId]:{ doc?.UnionId }\n"); LoggerHelper.WriteLogInfo($"[doctor.WxName]:{ doc?.WxName }\n"); LoggerHelper.WriteLogInfo($"[doctor.IsVerify]:{ doc?.IsVerify }\n"); LoggerHelper.WriteLogInfo($"---- UpdateDocHospitalOrDept End -------------------------------------------"); } //认证失败的修改信息后,变成申诉中 if (!isRegistering && doc.IsVerify == 3 || doc.IsVerify == 2 || doc.IsVerify == 6) { LoggerHelper.WriteLogInfo($"---- UpdateDocHospitalOrDept Begin 认证失败的修改信息后,变成申诉中 ----------"); LoggerHelper.WriteLogInfo($"[doctor.Id]:{doc?.Id}\n"); LoggerHelper.WriteLogInfo($"[doctor.UnionId]:{ doc?.UnionId }\n"); LoggerHelper.WriteLogInfo($"[doctor.WxName]:{ doc?.WxName }\n"); LoggerHelper.WriteLogInfo($"[doctor.IsVerify]:{ doc?.IsVerify }\n"); LoggerHelper.WriteLogInfo($"---- UpdateDocHospitalOrDept End -------------------------------------------"); doc.IsVerify = 4; } //用户名 if (!string.IsNullOrEmpty(wxUserModel.UserName)) { string userName = wxUserModel.UserName; var isQua = IsQualified(userName); if (!isQua.Success) { return(isQua); } doc.UserName = userName; doc.Mobile = wxUserModel.Mobile;//手机号 } //医院名称 if (!string.IsNullOrEmpty(wxUserModel.HospitalName)) { var hospital = _rep.FirstOrDefault <HospitalInfo>(s => s.IsDeleted != 1 && s.HospitalName == wxUserModel.HospitalName); //医院名不存在就插入 if (hospital == null) { hospital = new HospitalInfo { Id = Guid.NewGuid().ToString().ToUpper(), CreateTime = DateTime.Now, CreateUser = workUser.WxUser.UnionId, HospitalName = wxUserModel.HospitalName, ComeFrom = "self", IsVerify = 0 }; _rep.Insert(hospital); _rep.SaveChanges(); } doc.HospitalName = wxUserModel.HospitalName; } //科室 if (!string.IsNullOrEmpty(wxUserModel.DepartmentName)) { doc.DepartmentName = wxUserModel.DepartmentName; } //职称 if (!string.IsNullOrEmpty(wxUserModel.Title)) { doc.Title = wxUserModel.Title; } //职务 if (!string.IsNullOrEmpty(wxUserModel.DoctorPosition)) { doc.DoctorPosition = wxUserModel.DoctorPosition; } //医生办公室电话 if (!string.IsNullOrEmpty(wxUserModel.doctor_office_tel)) { doc.doctor_office_tel = wxUserModel.doctor_office_tel; } //微信信息-城市 if (!string.IsNullOrEmpty(wxUserModel.WxCity)) { doc.WxCity = wxUserModel.WxCity; } //微信信息-微信名 if (!string.IsNullOrEmpty(wxUserModel.WxName)) { doc.WxName = wxUserModel.WxName; } //微信信息-国家 if (!string.IsNullOrEmpty(wxUserModel.WxCountry)) { doc.WxCountry = wxUserModel.WxCountry; } //微信信息-头像 if (!string.IsNullOrEmpty(wxUserModel.WxPicture)) { doc.WxPicture = wxUserModel.WxPicture; } //微信信息-性别 if (!string.IsNullOrEmpty(wxUserModel.WxGender)) { doc.WxGender = wxUserModel.WxGender; } //微信信息-省 if (!string.IsNullOrEmpty(wxUserModel.WxProvince)) { doc.WxProvince = wxUserModel.WxProvince; } if (!string.IsNullOrEmpty(wxUserModel.Province)) { doc.Province = wxUserModel.Province; } if (!string.IsNullOrEmpty(wxUserModel.City)) { doc.City = wxUserModel.City; } if (!string.IsNullOrEmpty(wxUserModel.Area)) { doc.Area = wxUserModel.Area; } doc.UpdateTime = DateTime.Now; _rep.Update(doc); _rep.SaveChanges(); //CacheWxUser(doc); rvm.Success = true; rvm.Msg = "success"; rvm.Result = new { doc }; return(rvm); }
private void btnexperthistoryinfo_Click(object sender, EventArgs e) { int count = 4; if (this.dgv_patientinfo.Rows.Count == 0) { MessageBox.Show("未选择导出病人!", "系统提示"); return; } string patientbednum = this.dgv_patientinfo.CurrentRow.Cells["PatientBednum"].Value.ToString(); string patientbedname = this.dgv_patientinfo.CurrentRow.Cells["PatientName"].Value.ToString(); PatientInfo patientInfo = objPatientService.GetPatientInfoBybednum(Convert.ToInt16(patientbednum)); HospitalInfo hospitalInfo = new HospitalInfoService().GetHospitalInfo(); if (hospitalInfo == null) { hospitalInfo = new HospitalInfo() { HospitalName = "医院名称", Department = "科室名称", }; } dic.Add("name", patientInfo.PatientName); dic.Add("age", patientInfo.PatientAge); dic.Add("bednum", patientInfo.PatientBednum); dic.Add("patientnum", patientInfo.PatientNum); dic.Add("hospital", hospitalInfo.HospitalName); dic.Add("depart", hospitalInfo.Department); dic.Add("gender", patientInfo.PatientGender); string strSaveFileLocation = ""; SaveFileDialog saveFileDialog1 = new SaveFileDialog(); // saveFileDialog1.InitialDirectory = Path.GetDirectoryName(strPartPath); //设置文件类型 saveFileDialog1.Filter = "Excel 97-2003工作簿(*.xls)|*.xls"; //saveFileDialog1.FilterIndex = 1;//设置文件类型显示 saveFileDialog1.FileName = patientbednum + "床病人" + "详细信息"; //设置默认文件名 saveFileDialog1.RestoreDirectory = true; //保存对话框是否记忆上次打开的目录 saveFileDialog1.CheckPathExists = true; //检查目录 if (saveFileDialog1.ShowDialog() == DialogResult.OK) { strSaveFileLocation = saveFileDialog1.FileName;//文件路径 } else { return; } DataTable ds = GetDgvToTable(this.dgv_bodyinfo); //string a = this.dgv_patientinfo.CurrentRow.Cells["PatientBednum"].Value.ToString(); //DataTable ds = objPatientBodyInfoService.GetPatientInfoBybednum(Convert.ToInt16(a), starttime, endtime); if (ds.Rows.Count == 0) { MessageBox.Show("没有任何数据!", "系统提示!"); return; } dic.Add("stime", ds.Rows[0][0].ToString()); dic.Add("etime", ds.Rows[ds.Rows.Count - 1][0].ToString()); if ((checkBox_30.Checked = true) && (checkBox_60.Checked == true)) { MessageBox.Show("不能同时选中两种导出设置!", "系统提示"); } if (checkBox_30.Checked == true) { count = 2; } if (checkBox_60.Checked == true) { count = 1; } // NPOI.NowPatientInfoToExcel(ds, strSaveFileLocation,count); try { NPOI.ExcelPrint("导出数据格式.xls", ds, dic, strSaveFileLocation, count); } catch (Exception ex) { MessageBox.Show(ex.Message); } dic.Clear(); }