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