protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HospitalModel hm = new HospitalModel();
SqlDataReader sdr = hm.findHospitalAll();
RecipeModel rm = new RecipeModel();
SqlDataReader sdr1 = rm.findRecipAlla();
hospitalname.Items.Add(new ListItem(" 全部 ", "0"));
DCompany.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr != null)
{
while (sdr.Read())
{
this.hospitalname.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString()));
}
}
if (sdr1 != null)
{
while (sdr1.Read())
{
this.DCompany.Items.Add(new ListItem(sdr1["b"].ToString()));
}
}
DataTable table = rm.finDistributInfoCount("", "", "", "0");
this.chartDatas.Value = DataTableToJson.ToJson(table);
}
this.FlexGridRecipe.InitConfig(
new string[] {
"title=配送统计信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=600" //宽度，可为auto或具体px值
},
// 序号、委托单号、医院编号、医院名称、处方号、煎药方式、姓名、性别、年龄、电话、地址、科室、病区号、
//病房号、病床号、诊断结果、剂数、服用方式、次数、包装量、服用方法、煎药方案、一煎时间、二煎时间、
//浸泡加水量、浸泡时间、标签数量、备注信息、医生、医生脚注、取药时间、取药序号、下单时间、当前状态、
//操作时间、操作人员、配送公司、配送地址、联系电话、快件类型
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 80, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 80, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Hospitalid", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("name", "患者姓名", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("phone", "联系电话", 140, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Sendpersonnel", "发货人员", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbcompany", "配送公司", 210, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbaddress", "配送地址", 210, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("SendTime", "发货时间", 210, false, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
},
null
,
null
);
this.FlexGridRecipe.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler);
}
public static JObject PostMultipartFormClinic(string url, ApiHeader apiHeader, HospitalModel model)
{
return(CallMultipartFormClinicApi(url, apiHeader, model));
}
protected void Page_Load(object sender, EventArgs e)
{
HospitalModel hm = new HospitalModel();
SqlDataReader sdr = hm.findHospitalAll();
if (sdr != null)
{
while (sdr.Read())
{
this.hospitalSelect.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString()));
}
}
this.FlexGridRecipe.InitConfig(
new string[] {
"title=处方信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=500", //宽度，可为auto或具体px值
"resizable= false "
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("delnum", "委托单号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("name", "患者姓名", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sex", "性别", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("age", "年龄", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("phone", "电话", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("address", "地址", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("department", "科室", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("inpatientarea", "病区号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ward", "病房号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sickbed", "病床号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("diagresult", "诊断结果", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takemethod", "服用方式", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takenum", "次数", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("packagenum", "包装量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("decscheme", "煎药方案", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("oncetime", "一煎时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("twicetime", "二煎时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soakwater", "浸泡加水量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soaktime", "浸泡时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("labelnum", "标签数量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("remark", "备注信息", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("doctor", "医生", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("footnote", "医生脚注", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugtime", "取药时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugnum", "取药序号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ordertime", "下单时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("curstate", "当前状态", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dotime", "操作时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("doperson", "操作人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbcompany", "配送公司", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbaddress", "配送地址", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbphone", "联系电话", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbtype", "快件类型", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Hospitalid", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("RemarksA", "备注A", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RemarksB", "备注B", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridRecipe.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridRecipeDataHandler); //提供数据的方法
this.FlexGridDrug.InitConfig(
new string[] {
"title=药物信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=500", //宽度，可为auto或具体px值
"resizable= false "
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
//new dotNetFlexGrid.FieldConfig("delnum","委托单号",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Drugnum", "药品编号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Drugname", "药品名称", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugDescription", "脚注", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugPosition", "药品规格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugAllNum", "单剂量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugWeight", "总剂量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("TieNum", "贴数", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Description", "说明", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("WholeSalePrice", "批发价格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RetailPrice", "零售价格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hospitalid", "医院id", 60, false, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
},
null
,
null
);
this.FlexGridDrug.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridDrugDataHandler); //提供数据的方法
}
protected void btnDrugOkClick(object sender, EventArgs e)
{
string strTip = "";
if (drugpspnum.Value == "")
{
strTip += "处方号；";
}
if (drugnum.Value == "")
{
strTip += "药品编号；";
}
if (drugname.Value == "")
{
strTip += "药品名称；";
}
if (drugposition.Value == "")
{
strTip += "药品规格；";
}
if (drugallnum.Value == "")
{
strTip += "单剂量；";
}
if (drugweight.Value == "")
{
strTip += "总剂量；";
}
if (tienum.Value == "")
{
strTip += "贴数；";
}
if (strTip != "")
{
strTip = "以下信息不能空，请填写: " + strTip;
Page.ClientScript.RegisterStartupScript(
this.GetType(), "myscript",
"<script type=\"text/javascript\">function ShowAlert(){alert('" + strTip + "');}window.onload=ShowAlert;</script>");
return;
}
DrugInfo dinfo = new DrugInfo();
//dinfo.strDelNum = drugdelnum.Value;
// dinfo.nHospitalNum = Convert.ToInt16(drughospitalnum.Value);
HospitalModel hm = new HospitalModel();
SqlDataReader sr = hm.findhospitalidbyhname(drughospitalname.Value);
string hospitalid = "";
if (sr.Read())
{
hospitalid = sr["id"].ToString();
}
dinfo.nHospitalNum = Convert.ToInt16(hospitalid);
dinfo.strPspnum = drugpspnum.Value;
dinfo.strDrugNum = drugnum.Value;
dinfo.strDrugName = drugname.Value;
if (drugdescription.Value == "")
{
dinfo.strDrugDsp = "无";
}
else
{
dinfo.strDrugDsp = drugdescription.Value;
}
dinfo.strDrugPosition = drugposition.Value;
dinfo.nAllNum = Convert.ToInt32(drugallnum.Value);
dinfo.dWeight = Convert.ToDouble(drugweight.Value);
dinfo.nTieNum = Convert.ToInt32(tienum.Value);
if (description.Value == "")
{
dinfo.strDsp = "无";
}
else
{
dinfo.strDsp = description.Value;
}
if (wholesaleprice.Value != "")
{
dinfo.dWholeSalePrice = Convert.ToDouble(wholesaleprice.Value);
}
else
{
}
if (retailprice.Value != "")
{
dinfo.dRetailPrice = Convert.ToDouble(retailprice.Value);
}
else
{
}
//dinfo.dWholeSaleCost = Convert.ToDouble(wholesalecost.Value);
// dinfo.dRetailCost = Convert.ToDouble(retailcost.Value);
// dinfo.dMoneyWithTax = Convert.ToDouble(moneywithtax.Value);
// dinfo.dFee = Convert.ToDouble(fee.Value);
EnterDrug ed = new EnterDrug();
bool rn = ed.AddDrug(dinfo);
if (rn)
{
Page.ClientScript.RegisterStartupScript(
this.GetType(), "myscript",
"<script type=\"text/javascript\">function ShowAlert(){alert('药品录入成功');}window.onload=ShowAlert;</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(
this.GetType(), "myscript",
"<script type=\"text/javascript\">function ShowAlert(){alert('药品录入失败，相同的药品不能被添加，或该处方已确认添加完成！');}window.onload=ShowAlert;</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HospitalModel hm = new HospitalModel();
SqlDataReader sdr = hm.findHospitalAll();
hospitalname.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr != null)
{
while (sdr.Read())
{
this.hospitalname.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString()));
}
}
string cTime = System.DateTime.Now.ToString("yyyy-MM-dd");//当前时间
// string currenttime = c
//cTime.ToString("yyyy-MM-dd");
JTime.Value = cTime;
}
this.FlexGridRecipe.InitConfig(
new string[] {
"title=处方信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"singleselected=true", //是否单选
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=1090" //宽度，可为auto或具体px值
},
// 序号、委托单号、医院编号、医院名称、处方号、煎药方式、姓名、性别、年龄、电话、地址、科室、病区号、
//病房号、病床号、诊断结果、剂数、服用方式、次数、包装量、服用方法、煎药方案、一煎时间、二煎时间、
//浸泡加水量、浸泡时间、标签数量、备注信息、医生、医生脚注、取药时间、取药序号、下单时间、当前状态、
//操作时间、操作人员、配送公司、配送地址、联系电话、快件类型
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("delnum", "委托单号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Hospitalid", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("name", "患者姓名", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sex", "性别", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("age", "年龄", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("phone", "电话", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("address", "地址", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("department", "科室", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("inpatientarea", "病区号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ward", "病房号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sickbed", "病床号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("diagresult", "诊断结果", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takemethod", "服用方式", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takenum", "次数", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("packagenum", "包装量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("decscheme", "煎药方案", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("oncetime", "一煎时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("twicetime", "二煎时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soakwater", "浸泡加水量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soaktime", "浸泡时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("labelnum", "标签数量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("remark", "备注信息", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("doctor", "医生", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("footnote", "医生脚注", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugtime", "取药时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugnum", "取药序号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ordertime", "下单时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("curstate", "当前状态", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbcompany", "配送公司", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbaddress", "配送地址", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbphone", "联系电话", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbtype", "快件类型", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("doperson1", "接方人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dotime", "接方时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("PartyPer", "审方人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("PartyTime", "审方时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("checkStatus", "审方结果", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("refusalreason", "审方说明", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("SwapPer", "调剂人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("wordDate", "调剂开始", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("endDate", "调剂结束", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ReviewPer", "复核人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("AuditTime", "复核时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("bubbleperson", "泡药人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("bstarttime", "泡药开始", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("bendDate", "泡药结束", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("tisaneman", "煎药人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("machineid", "煎药机组", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("tstarttime", "煎药开始", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("tendDate", "煎药结束", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Pacpersonnel", "包装人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("packmachine", "包装机", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("PacEndTime", "包装开始", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("PacTime", "包装结束", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Sendpersonnel", "发货人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("SendTime", "发货时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("SignPer", "签收人员", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("SignTime", "签收时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
//SignPer,签收人员；SignTime ，签收时间；
},
null
,
null
);
this.FlexGridRecipe.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler);
} //提供数据的方法
public static bool Delete(HospitalModel model)
{
return(SQLiteHelper.Delete <HospitalModel>(model));
}
public async Task <IActionResult> PostUser([FromBody] HospitalSignUpModel model) // from from in frontend //
{
bool x = await this._roleManager.RoleExistsAsync("Patient");
if (!x)
{
var role = new IdentityRole {
Name = "Patient"
};
await _roleManager.CreateAsync(role);
}
bool y = await _roleManager.RoleExistsAsync("Admin");
if (!y)
{
var role = new IdentityRole {
Name = "Admin"
};
await _roleManager.CreateAsync(role);
}
bool z = await _roleManager.RoleExistsAsync("hospital");
if (!z)
{
var role = new IdentityRole {
Name = "hospital"
};
await _roleManager.CreateAsync(role);
}
if (ModelState.IsValid)
{
var hospital = new ApplicationUser()
{
Email = model.Email,
UserName = model.Email,
};
var result = await _userManager.CreateAsync(hospital, model.Password);
if (result.Succeeded)
{
await _userManager.AddToRoleAsync(hospital, "hospital");
var files = model.Files.Select(file => new HospitalFile {
FilePath = file.FilePath, HospitalModelId = file.HospitalId
}).ToList();
var hospitalInDb = new HospitalModel
{
Email = model.Email,
ApplicationUserId = hospital.Id,
Files = files,
Location = model.Location,
Name = model.Name,
Password = model.Password
};
await _context.Hospitals.AddAsync(hospitalInDb);
await _context.SaveChangesAsync();
//context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.HospitalFiles ON");
//context.SaveChanges();
//await context.HospitalFiles.AddRangeAsync(model.Files);
//await context.SaveChangesAsync();
//context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.HospitalFiles OFF");
//context.SaveChanges();
return(Ok(result));
}
var errors = result.Errors.Select(e => e.Description);
return(BadRequest(errors));
}
return(StatusCode(201));
}
private OfficeModel GetOfficeModel(string pName, string name, int sort, bool enable, string PictureGuid, HospitalModel hospitalModel, List <OfficeModel> offices2, IEnumerable <dynamic> offices)
{
OfficeModel po = null;
if (pName != null)
{
po = offices2.FirstOrDefault(a => a.OfficeName == pName);
}
if (po == null)
{
dynamic dd = offices.FirstOrDefault(c => c.OfficeName == pName);
if (dd != null)
{
po = GetOfficeModel(dd?.ParentName, pName, dd?.Sort, dd?.Enable, dd?.PictureGuid, hospitalModel, offices2, offices);
}
}
var o = offices2.FirstOrDefault(a => a.OfficeName == name);
if (o != null)
{
return(o);
}
o = new OfficeModel
{
CreatedBy = UserID,
LastUpdatedBy = UserID,
Enable = enable,
OrgGuid = string.Empty,
HospitalGuid = hospitalModel.HospitalGuid,
HospitalName = hospitalModel.HosName,
OfficeGuid = Guid.NewGuid().ToString("N"),
OfficeName = name,
ParentOfficeGuid = po?.OfficeGuid,
Recommend = false,
PictureGuid = PictureGuid,
Sort = sort
};
offices2.Add(o);
return(o);
}
public async Task <IActionResult> AddHospitalAsync([FromBody] AddHospitalRequestDto request)
{
HospitalBiz hospitalBiz = new HospitalBiz();
if (await hospitalBiz.AnyAccountAsync(request.Account))
{
return(Failed(ErrorCode.UserData, "已经存在相同的账号！"));
}
var hospitalGuid = Guid.NewGuid().ToString("N");
var textGuid = Guid.NewGuid().ToString("N");
request.Content = string.IsNullOrWhiteSpace(request.Content) ? "暂无详细" : request.Content;
request.HosTag = string.IsNullOrWhiteSpace(request.HosTag) ? "暂无标签" : request.HosTag;
var richtextModel = new RichtextModel
{
Content = request.Content,
CreatedBy = UserID,
CreationDate = DateTime.Now,
Enable = true,
LastUpdatedBy = UserID,
LastUpdatedDate = DateTime.Now,
OrgGuid = string.Empty,
OwnerGuid = hospitalGuid,
TextGuid = textGuid,
};
var hospitalModel = new HospitalModel
{
HosAbstract = request.HosAbstract,
HosDetailGuid = textGuid,
HosLevel = request.HosLevel,
HosName = request.HosName,
HosTag = request.HosTag,
Location = request.Location,
LogoGuid = request.LogoGuid,
PlatformType = PlatformType.CloudDoctor.ToString(),
RegisteredDate = request.RegisteredDate,
Visibility = request.Visibility,
HospitalGuid = hospitalGuid,
CreatedBy = UserID,
LastUpdatedBy = UserID,
Enable = request.Enable,
OrgGuid = string.Empty,
ContactNumber = request.ContactNumber,
Sort = request.Sort,
GuidanceUrl = request.GuidanceUrl ?? string.Empty,
ExternalLink = request.ExternalLink ?? string.Empty,
Password = CryptoHelper.AddSalt(hospitalGuid, request.Password),
Account = request.Account,
IsHospital = request.IsHospital,
Longitude = request.Longitude,
Latitude = request.Latitude
};
var officeAll = await new OfficeBiz().GetAllAsync2();
var offices = officeAll.Select(a => (new
{
a.OfficeName,
ParentName = officeAll.FirstOrDefault(b => b.OfficeGuid == a.ParentOfficeGuid)?.OfficeName,
a.Sort,
a.Enable,
a.PictureGuid
})).Distinct();
var offices2 = new List <OfficeModel>();
foreach (var item in offices)
{
GetOfficeModel(item.ParentName, item.OfficeName, item.Sort, item.Enable, item.PictureGuid, hospitalModel, offices2, offices);
}
var result = await hospitalBiz.AddAsync(hospitalModel, richtextModel, offices2);
if (!result)
{
return(Failed(ErrorCode.UserData, "添加失败"));
}
return(Success());
}
private static bool CheckFileName(ResponseModel responseModel, HttpFile file, out int hospitalID, out HospitalModel hospitalModel)
{
hospitalID = 0;
hospitalModel = new HospitalModel();
string pattern = @"^\d+$";
var fileName = Path.GetFileNameWithoutExtension(file.Name);
if (!Regex.IsMatch(fileName, pattern))
{
responseModel.Success = false;
responseModel.Msg = "命名不正确,请看规则";
return(false);
}
else
{
var hospitalModels = SQLiteHelper.HospitalQuery(int.Parse(fileName));
if (hospitalModels.Count == 0)
{
responseModel.Success = false;
responseModel.Msg = string.Format("请先在网站创建医院ID为{0}的记录，看规则", fileName);
return(false);
}
hospitalModel = hospitalModels[0];
hospitalID = int.Parse(fileName);
}
return(true);
}
private static void CompareAction(string oldFilesDirectoryPath, string newestFileDirectoryPath, int hospitalID, HospitalModel hospitalModel, string zipPath)
{
//1.获取当前医院最新版本设置版本号
//2.对比,管理文件
//3.修改本地配置
var lastVersionModel = new VersionModel();
var number = ConstFile.BASEVERSION;
var newestAllDLLVersionDictionary = new Dictionary <string, string>();
var newestFileDirectoryInfo = new DirectoryInfo(newestFileDirectoryPath);
GetFileNameDictionary(newestFileDirectoryInfo, newestAllDLLVersionDictionary, ConstFile.BASEVERSION, hospitalID.ToString());
var newesterVsionModel = new VersionModel
{
ID = DateTime.Now.ToString("yyyyMMddhhmmssffff"),
HospitalID = hospitalID,
UpLoadTime = DateTime.Now,
User = currentUser
};
var versionModels = SQLiteHelper.VersionQuery(1000, hospitalID);
//对比逻辑：
//1.第一次上传的时候或者当前没有出新文件的时候。和模板文件匹配.
//2.第二次开始：
// A【修改】.上传文件和本地文件都存在，对比不同，则把最新的文件复制到work目录和仓库目录，并且设置上传文件version为最新version（存入数据库时）
// B【不变】.上传文件和本地文件都存在，对比相同，不复制文件，设置上传文件version为老版本文件的version（存入数据库时）
// C【新增】.上传文件存在，本地文件不存在，则把最新的文件复制到work目录和仓库目录，并且设置上传文件version为最新version（存入数据库时）
// D【删除】.上传文件不存在，本地文件存在。暂时不操作。
var oldAllDLLVersionDictionary = new Dictionary <string, string>();
var workPath = Path.Combine(ConstFile.WorkPath, hospitalID.ToString());
if (versionModels.Count != 0)
{
lastVersionModel = versionModels.FirstOrDefault(p => p.ID == versionModels.Max(t => t.ID));
number = AddVersion(lastVersionModel.Number);
oldAllDLLVersionDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(lastVersionModel.AllDLLVersion);
}
else
{
var baseModel = SQLiteHelper.VersionQuery("BaseModel")[0];
oldAllDLLVersionDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(baseModel.AllDLLVersion);
number = AddVersion(baseModel.Number);
}
var tempdllVersionDictionary = new Dictionary <string, string>();
foreach (var item in newestAllDLLVersionDictionary)
{
var newestFilePath = Path.Combine(newestFileDirectoryPath, item.Key);
var newestFileInfo = new FileInfo(newestFilePath);
if (oldAllDLLVersionDictionary.Keys.Contains(item.Key) && oldAllDLLVersionDictionary[item.Key] == ConstFile.BASEVERSION)
{
oldFilesDirectoryPath = ConstFile.BaseFilePath;
}
var localFilePath = Path.Combine(oldFilesDirectoryPath, item.Key);
if (File.Exists(localFilePath))
{
var localFileInfo = new FileInfo(localFilePath);
if (!isTheSame(newestFileInfo, localFileInfo))
{
FileCopy(newestFileInfo, hospitalID.ToString(), number, workPath, item.Key);
tempdllVersionDictionary.Add(item.Key, number);
}
else
{
tempdllVersionDictionary.Add(item.Key, oldAllDLLVersionDictionary[item.Key]);
}
oldAllDLLVersionDictionary.Remove(item.Key);
}
else
{
FileCopy(newestFileInfo, hospitalID.ToString(), number, workPath, item.Key);
tempdllVersionDictionary.Add(item.Key, number);
}
}
// 删除的文件
var deleteKey = new List <string>();
foreach (var item in oldAllDLLVersionDictionary)
{
if (item.Value != ConstFile.BASEVERSION)
{
deleteKey.Add(item.Key);
}
}
deleteKey.ForEach(p => oldAllDLLVersionDictionary.Remove(p));
foreach (var key in tempdllVersionDictionary.Keys)
{
if (oldAllDLLVersionDictionary.Keys.Contains(key))
{
oldAllDLLVersionDictionary[key] = tempdllVersionDictionary[key];
continue;
}
oldAllDLLVersionDictionary.Add(key, tempdllVersionDictionary[key]);
}
hospitalModel.NewestVersion = number;
newesterVsionModel.Number = number;
newesterVsionModel.AllDLLVersion = JsonConvert.SerializeObject(oldAllDLLVersionDictionary);
SQLiteHelper.Insert <VersionModel>(newesterVsionModel);
SQLiteHelper.Update <HospitalModel>(hospitalModel);
}
public HospitalModule() : base("Hospital")
{
this.RequiresAuthentication();
#region Hospital
Get["HospitalManage"] = _ =>
{
string manageHospital = GetManageHospitalIDs();
return(this.ValidPermission("HospitalManage")
? View["HospitalManage", HospitalBll.GetData(manageHospital)]
: View["NoPermissions"]);
};
Post["QueryHospital"] = p =>
{
var arg = Request.Form["arg"];
string manageHospital = GetManageHospitalIDs();
return(View["HospitalManage", HospitalBll.HospitalLikeQuery(arg, manageHospital)]);
};
Post["checkHospitalID/{ID}"] = p => (HospitalBll.GetDataById(p.ID) != null);
Get["HospitalAdd"] = _ => this.ValidPermission("HospitalAdd") ? View["HospitalAdd"] : View["NoPermissions"];
Post["HospitalAdd/{Name}"] = p =>
{
var model = new HospitalModel
{
//Id = p.ID,
Name = p.Name
};
return(JsonConvert.SerializeObject(HospitalBll.Insert(model)));
};
Get["HospitalEdit/{ID}"] =
p =>
this.ValidPermission("HospitalEdit")
? View["HospitalEdit", HospitalBll.GetDataById(p.ID)]
: View["NoPermissions"];
Post["HospitalEdit/"] = _ =>
{
var model = this.Bind <HospitalModel>();
HospitalBll.Update(model);
return(Response.AsRedirect("HospitalManage"));
};
Post["HospitalDelete/{ID}"] = p => JsonConvert.SerializeObject(HospitalBll.Delete(p.ID));
#endregion
#region Version
Get["VersionManage/{HospitalID}"] = p =>
{
if (!this.ValidPermission("VersionManage"))
{
return(View["NoPermissions"]);
}
int id = int.Parse(p.HospitalID);
var versionModels = VersionBll.GetModelsByHospitalId(id);
var hospitalModel = HospitalBll.GetDataById(p.HospitalID);
ViewBag["NewestVersion"] = hospitalModel.NewestVersion;
ViewBag["ClientFileName"] = p.HospitalID + "_AutoUpdater.zip";
versionModels.Reverse();
return(View["VersionManage", versionModels]);
};
Get["VersionEdit/{ID}"] = p =>
{
if (!this.ValidPermission("VersionEdit"))
{
return(View["NoPermissions"]);
}
var model = VersionBll.GetModelById(p.ID);
return((model != null) ? View["VersionEdit", model] : View["VersionManage/" + model.HospitalID]);
};
Post["VersionEdit"] = _ =>
{
var model = new VersionModel
{
Id = Request.Form["ID"],
Description = Request.Form["Description"],
BlackList = Request.Form["BlackList"],
ExistSoIgnoreList = Request.Form["ExistSoIgnoreList"],
DynamicCode = Request.Form["DynamicCode"],
DynamicCodeVersion = Request.Form["DynamicCodeVersion"]
};
VersionBll.Update(model);
string url = string.Format("VersionManage/{0}", Request.Form["HospitalID"]);
return(Response.AsRedirect(url));
};
//Post["VersionDelete/{VersionID}/{HospitalID}"] = p =>
//{
// var errorMsg = VersionBll.Delete(p.VersionID, p.HospitalID);
// return (!string.IsNullOrEmpty(errorMsg)) ? errorMsg : null;
//};
Post["VersionSet/{VersionNumber}/{HospitalID}"] = p =>
{
MemoryCenter.Instance.NewestHospitalVersionDic.Clear();
return(VersionBll.UpdateHospitalNewestNumber(p.VersionNumber, p.HospitalID));
}
;
Get["DownLoadAutoUpdateClient/{ClientFileName}"] = p =>
{
var errorMsg = string.Empty;
var hospitalId = p.ClientFileName.ToString().Split('_')[0];
var isWindows = Environment.OSVersion.Platform == PlatformID.Win32NT;
try
{
if (FileControlCenter.Instance.IsCreatClient)
{
return("服务器正忙，请稍等");
}
FileControlCenter.Instance.IsCreatClient = true;
if (!Directory.Exists(ConstFile.AutoUpdateClient))
{
FileInfo basefile = new DirectoryInfo(ConstFile.DownloadFilePath).GetFiles().FirstOrDefault(t => Path.GetFileNameWithoutExtension(t.Name) == "AutoUpdater");
if (basefile == null)
{
FileControlCenter.Instance.IsCreatClient = false;
return("服务端未发布自动更新客户端");
}
if (basefile.Extension.ToUpper() != ".7Z" && !isWindows)
{
FileControlCenter.Instance.IsCreatClient = false;
return("linux服务端请联系管理员发布7z版本自动更新客户端");
}
var zipFilePath = Path.Combine(ConstFile.DownloadFilePath, basefile.Name);
if (!ZipHelper.UnZip(zipFilePath, ConstFile.AutoUpdateClient))
{
FileControlCenter.Instance.IsCreatClient = false;
return("服务端解压失败");
}
}
var userConfig = new UserConfig();
userConfig.AutoUpdaterVersion = "1.0.0";
userConfig.CheckClientAliveTime = "5000";
userConfig.CheckUpdateTime = "120000";
userConfig.FirstInstall = true;
userConfig.HospitalID = hospitalId;
userConfig.TerminalVersion = "2.0.0";
userConfig.ServerUrl = Request.Url.SiteBase;
userConfig.StartOnPowerOn = true;
userConfig.CloseMainWindowProcesses = new List <string> {
ConstFile.CLIENTEXENAME
};
userConfig.KillProcesses = new List <string> {
"fileServer", "CameraService"
};
var configPath = Path.Combine(ConstFile.AutoUpdateClient,
"UserData", "UserConfig.xml");
FileUtil.XMLSaveData(userConfig, configPath);
var fileName = isWindows ? $"{hospitalId}_AutoUpdater.zip" : $"{hospitalId}_AutoUpdater.7z";
var packagePath = Path.Combine(ConstFile.DownloadFilePath, fileName);
if (File.Exists(packagePath))
{
File.Delete(packagePath);
}
if (ZipHelper.Zip(ConstFile.AutoUpdateClient, fileName))
{
FileControlCenter.Instance.IsCreatClient = false;
return(Response.AsFile(packagePath));
//return Response.FromStream(new FileStream(packagePath, FileMode.Open), "application/octet-stream;charset=UTF-8");
}
else
{
errorMsg = "服务端异常：解压失败";
}
}
catch (Exception ex)
{
errorMsg = ex.Message;
}
FileControlCenter.Instance.IsCreatClient = false;
return(errorMsg);
};
#endregion
}
private void SelfInfoForm_Load(object sender, EventArgs e)
{
//国际化
InitLanguage();
//清空显示的数据
lbl_hospital.Text = "";
lbl_username.Text = "";
lbl_realname.Text = "";
lbl_license.Text = "";
ResourceCulture.LanguageChanged += ResourceCulture_LanguageChanged;
new Thread(() =>
{
FlushFormCursor(Cursors.WaitCursor);
if (null != LoginStatus.UserInfo && !string.IsNullOrEmpty(LoginStatus.UserInfo.PhotoPath))
{
DoctorModel userInfo = LoginStatus.UserInfo;
//下载并显示个人照片
string photoPath = Path.Combine(GeneralHelper.DownloadPicFolder, userInfo.PhotoPath);
if (!File.Exists(photoPath))
{
if (HttpHelper.DownloadFile("PicDownloadHandler.ashx", userInfo.PhotoPath))
{
FlushImage(picBox_photo, photoPath);
}
}
else
{
FlushImage(picBox_photo, photoPath);
}
//下载并显示医师证
string licensePath = Path.Combine(GeneralHelper.DownloadPicFolder, userInfo.LicensePath);
if (!File.Exists(licensePath))
{
if (HttpHelper.DownloadFile("PicDownloadHandler.ashx", userInfo.LicensePath))
{
FlushImage(picBox_license, licensePath);
}
}
else
{
FlushImage(picBox_license, licensePath);
}
//其他UI控件显示
FlushLabel(lbl_username, userInfo.Name);
if (userInfo.Hospital_id == null)
{
this.Invoke(new FlushClient(() => { lbl_hospital.Text = ResourceCulture.GetString("not_written"); }));
}
else
{
string responseStr = HttpHelper.ConnectionForResult("HospitalInfoHandler.ashx", userInfo.Hospital_id.ToString());
if (!string.IsNullOrEmpty(responseStr))
{
HospitalModel hospital = JsonConvert.DeserializeObject <HospitalModel>(responseStr);
FlushLabel(lbl_hospital, hospital.Name);
}
else
{
FlushLabel(lbl_hospital, "");
}
}
FlushLabel(lbl_license, (userInfo.LicenseNo == null ? ResourceCulture.GetString("not_written") : userInfo.LicenseNo));
FlushLabel(lbl_realname, (userInfo.RealName == null ? ResourceCulture.GetString("not_written") : userInfo.RealName));
//认证与否
if (!this.IsDisposed)
{
this.Invoke(new FlushClient(() =>
{
if (userInfo.IfAuth)
{
lbl_ifAuth.Text = ResourceCulture.GetString("have_auth");
lbl_ifAuth.ForeColor = Color.FromArgb(245, 252, 255);
}
else
{
lbl_ifAuth.Text = ResourceCulture.GetString("not_auth");
lbl_ifAuth.ForeColor = Color.FromArgb(232, 161, 123);
}
}));
}
}
FlushFormCursor(Cursors.Default);
}).Start();
}
public dotNetFlexGrid.DataHandlerResult FlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
// result.table = dotNetFlexGrid.DemoMemoryTable(p.page * 100, p.rp);
HospitalModel hm = new HospitalModel();
result.table = hm.findPdaImgSwitchInfo();
dotNetFlexGrid.FieldFormatorHandle tiaoji = delegate(DataRow dr)
{
if (dr["tiaoji"].ToString() == "1")
{
return("<span style='color:red'>开启</span>");
}
else
{
return("<span style='color:black'>关闭</span>");
}
};
dotNetFlexGrid.FieldFormatorHandle fuhe = delegate(DataRow dr)
{
if (dr["fuhe"].ToString() == "1")
{
return("<span style='color:red'>开启</span>");
}
else
{
return("<span style='color:black'>关闭</span>");
}
};
dotNetFlexGrid.FieldFormatorHandle paoyao = delegate(DataRow dr)
{
if (dr["paoyao"].ToString() == "1")
{
return("<span style='color:red'>开启</span>");
}
else
{
return("<span style='color:black'>关闭</span>");
}
};
dotNetFlexGrid.FieldFormatorHandle jianyao = delegate(DataRow dr)
{
if (dr["jianyao"].ToString() == "1")
{
return("<span style='color:red'>开启</span>");
}
else
{
return("<span style='color:black'>关闭</span>");
}
};
dotNetFlexGrid.FieldFormatorHandle baozhuang = delegate(DataRow dr)
{
if (dr["baozhuang"].ToString() == "1")
{
return("<span style='color:red'>开启</span>");
}
else
{
return("<span style='color:black'>关闭</span>");
}
};
dotNetFlexGrid.FieldFormatorHandle fahuo = delegate(DataRow dr)
{
if (dr["fahuo"].ToString() == "1")
{
return("<span style='color:red'>开启</span>");
}
else
{
return("<span style='color:black'>关闭</span>");
}
};
result.FieldFormator.Register("tiaoji", tiaoji);
result.FieldFormator.Register("fuhe", fuhe);
result.FieldFormator.Register("paoyao", paoyao);
result.FieldFormator.Register("jianyao", jianyao);
result.FieldFormator.Register("baozhuang", baozhuang);
result.FieldFormator.Register("fahuo", fahuo);
return(result);
}
private void BindDataToRepeater()
{
// string strSql = "Data Source=118.244.237.123;Initial Catalog=rinfo;user id=sa;password=dalianvideo;MultipleActiveResultSets=true";
string strSql = ConfigurationManager.ConnectionStrings["SKConnection"].ConnectionString;
SqlConnection myConn = new SqlConnection(strSql);
int id = 0;
if (Request.QueryString["id"] != null)
{
id = Convert.ToInt16(Request.QueryString["id"]);
idnum123.Value = Request.QueryString["id"].ToString();
// string a = idnum123.Value;
}
string psp = "";
string hospitalid = "";
string drugtime = "";
string drugnum = "";
string name = "";
string sex = "";
string age = "";
string department = "";
string dot = "";
string getdrug1 = "";
string getdrug2 = "";
string getdrugweight = "";
RecipeModel rm = new RecipeModel();
SqlDataReader sdr = rm.print(id);
SqlDataReader sdr1 = rm.findrug(id);
SqlDataReader sdr2 = rm.findrug2(id);
if (sdr.Read() && sdr1.Read() && sdr2.Read())
{
psp = sdr["Pspnum"].ToString();
hospitalid = sdr["Hospitalid"].ToString();
drugtime = sdr["getdrugtime"].ToString();
drugnum = sdr["getdrugnum"].ToString();
name = sdr["name"].ToString();
sex = sdr["sex"].ToString();
age = sdr["age"].ToString();
department = sdr["department"].ToString();
dot = sdr["doctor"].ToString();
getdrug2 = sdr["dose"].ToString();
getdrug1 = sdr1["p"].ToString();
getdrugweight = sdr2["pp"].ToString();
}
// getdrugnum.Text = drugnum;
// getdrugtime.Text = drugtime;
// patientname.Text = name;
//
if (sex == "1")
{
sex = "男";
// patientsex.Text = sex;
}
else
{
sex = "女";
// patientsex.Text = sex;
}
// patientage.Text = age;
// patientdepartment.Text = department;
// pspnum.Text = psp;
string strDelNum = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
// printtime.Text = strDelNum;
// doctor.Text = dot;
//drug2.Text = getdrug2;
//drug1.Text = getdrug1;
// drugweight.Text = getdrugweight;
//adjustbarcodeinfo
this.namebar.Text = name;
if (sex == "1")
{
sex = "男";
this.sexbar.Text = sex;
}
else
{
sex = "女";
this.sexbar.Text = sex;
}
this.agebar.Text = age;
this.roomnumbar.Text = sdr["sickbed"].ToString();
HospitalModel hm = new HospitalModel();
SqlDataReader sdr10 = hm.findHospitalnamebyid(sdr["Hospitalid"].ToString());
string hname = "";
if (sdr10.Read())
{
hname = sdr10["hname"].ToString();
}
this.hospitalnamebar.Text = hname;//sdr["Hospitalid"].ToString();//
this.pspnumbar.Text = sdr["pspnum"].ToString();
this.strSchemebar.Text = sdr["decscheme"].ToString();
this.strInpatientAreaNumbar.Text = sdr["inpatientarea"].ToString();
this.strWardbar.Text = sdr["ward"].ToString();
this.strDepartmentbar.Text = sdr["department"].ToString();
this.dosebar.Text = sdr["dose"].ToString();
this.nNumbar.Text = sdr["takenum"].ToString();
this.nPackageNumbar.Text = sdr["packagenum"].ToString();
this.strDrugGetTimebar.Text = sdr["getdrugtime"].ToString();
this.strDrugGetNumbar.Text = sdr["getdrugnum"].ToString();
this.decmothedbar.Text = sdr["decmothed"].ToString();
this.takemethodbar.Text = sdr["takemethod"].ToString();
this.takewaybar.Text = sdr["takeway"].ToString();
this.ordertimebar.Text = sdr["ordertime"].ToString();
//packagebarcodeinfo
// this.namebar1.Text = name;
if (sex == "1")
{
sex = "男";
// this.sexbar1.Text = sex;
}
else
{
sex = "女";
// this.sexbar1.Text = sex;
}
string sql2 = "select ROW_NUMBER() OVER(ORDER BY d.id desc) as id,d.drugdescription,d.description,d.DrugAllNum,d.DrugWeight,d.DrugPosition,d.drugname,(select ypcdrugPositionNum from DrugMatching as m where m.pspId=d.pid and m.drugId = d.id) as ypcdrugPositionNum from drug as d where d.pid='" + id + "'";
// sql2 = "select ypcdrugPositionNum from DrugMatching where pspId ='" + id + "'";
SqlCommand cmd = new SqlCommand(sql2);
cmd.Connection = myConn;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds, "drug");
// rpTest.DataSource = ds.Tables["drug"];
// rpTest.DataBind();
myConn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sex.Items.Add(new ListItem("男", "1"));
sex.Items.Add(new ListItem("女", "2"));
scheme.Items.Add(new ListItem("微压（密闭）解表（15min）", "1"));
scheme.Items.Add(new ListItem("微压（密闭）汤药（15min）", "2"));
scheme.Items.Add(new ListItem("微压（密闭）补药（15min）", "3"));
scheme.Items.Add(new ListItem("常压解表（10min，10min）", "4"));
scheme.Items.Add(new ListItem("常压汤药（20min，15min）", "5"));
scheme.Items.Add(new ListItem("常压补药（25min，20min）", "6"));
scheme.Items.Add(new ListItem("先煎解表（10min，10min，10min）", "20"));
scheme.Items.Add(new ListItem("先煎汤药（10min，20min，15min）", "21"));
scheme.Items.Add(new ListItem("先煎补药（10min，25min，20min）", "22"));
scheme.Items.Add(new ListItem("后下解表（10min（3：7），10min）", "36"));
scheme.Items.Add(new ListItem("后下汤药（20min（13：7），15min）", "37"));
scheme.Items.Add(new ListItem("后下补药（25min（18：7），20min）", "38"));
scheme.Items.Add(new ListItem("微压自定义", "81"));
scheme.Items.Add(new ListItem("常压自定义", "82"));
scheme.Items.Add(new ListItem("先煎自定义", "83"));
scheme.Items.Add(new ListItem("后下自定义", "84"));
decmothed.Items.Add(new ListItem("先煎", "1"));
decmothed.Items.Add(new ListItem("后下", "2"));
decmothed.Items.Add(new ListItem("加糖加蜜", "3"));
takeway.Items.Add(new ListItem("水煎餐后", "1"));
dtbtype.Items.Add(new ListItem("顺丰", "1"));
dtbtype.Items.Add(new ListItem("圆通", "2"));
dtbtype.Items.Add(new ListItem("中通", "3"));
HospitalModel hm = new HospitalModel();
SqlDataReader sdr = hm.findHospitalAll();
if (sdr != null)
{
while (sdr.Read())
{
this.hospitalname.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString()));
}
}
if (Request.QueryString["id"] != null && Request.QueryString["randomnumber"] != null)
{
// string str = Request.QueryString[""];
string str = Request.QueryString["randomnumber"];
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum.Value = Request.QueryString["id"].ToString();
RecipeModel rm = new RecipeModel();
DataTable dt = rm.findRecipeInfo(id);
delnum.Value = dt.Rows[0]["delnum"].ToString();
hospitalnum.Value = dt.Rows[0]["hnum"].ToString();
//hospitalname.Value = dt.Rows[0]["hname"].ToString();
hospitalname.Value = dt.Rows[0]["hospitalid"].ToString();
pspnum.Value = dt.Rows[0]["pspnum"].ToString();
decmothed.Value = dt.Rows[0]["decmothed"].ToString();
name.Value = dt.Rows[0]["name"].ToString();
sex.Value = dt.Rows[0]["sex"].ToString();
age.Value = dt.Rows[0]["age"].ToString();
phone.Value = dt.Rows[0]["phone"].ToString();
address.Value = dt.Rows[0]["address"].ToString();
department.Value = dt.Rows[0]["department"].ToString();
inpatientnum.Value = dt.Rows[0]["inpatientarea"].ToString();
wardnum.Value = dt.Rows[0]["ward"].ToString();
sickbed.Value = dt.Rows[0]["sickbed"].ToString();
diagresult.Value = dt.Rows[0]["diagresult"].ToString();
dose.Value = dt.Rows[0]["dose"].ToString();
num.Value = dt.Rows[0]["takenum"].ToString();
takemethod.Value = dt.Rows[0]["takemethod"].ToString();
packquantity.Value = dt.Rows[0]["packagenum"].ToString();
takeway.Value = dt.Rows[0]["takeway"].ToString();
scheme.Value = dt.Rows[0]["decscheme"].ToString();
timeone.Value = dt.Rows[0]["oncetime"].ToString();
timetwo.Value = dt.Rows[0]["twicetime"].ToString();
soakwater.Value = dt.Rows[0]["soakwater"].ToString();
soaktime.Value = dt.Rows[0]["soaktime"].ToString();
labelnum.Value = dt.Rows[0]["labelnum"].ToString();
remark.Value = dt.Rows[0]["remark"].ToString();
doctor.Value = dt.Rows[0]["doctor"].ToString();
footnote.Value = dt.Rows[0]["footnote"].ToString();
druggettime.Value = dt.Rows[0]["getdrugtime"].ToString();
druggetnum.Value = dt.Rows[0]["getdrugnum"].ToString();
ordertime.Value = dt.Rows[0]["ordertime"].ToString();
// curstate.Value = dt.Rows[0]["curstate"].ToString();
//dotime.Value = dt.Rows[0]["dotime"].ToString();
// doperson.Value = dt.Rows[0]["doperson"].ToString();
dtbcompany.Value = dt.Rows[0]["dtbcompany"].ToString();
dtbaddress.Value = dt.Rows[0]["dtbaddress"].ToString();
dtbphone.Value = dt.Rows[0]["dtbphone"].ToString();
dtbtype.Value = dt.Rows[0]["dtbtype"].ToString();
RemarksA.Value = dt.Rows[0]["RemarksA"].ToString();
RemarksB.Value = dt.Rows[0]["RemarksB"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HospitalModel hm = new HospitalModel();
SqlDataReader sdr = hm.findHospitalAll();
hospitalname.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr != null)
{
while (sdr.Read())
{
this.hospitalname.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString()));
}
}
string cTime = System.DateTime.Now.ToString("yyyy-MM-dd");//当前时间
JTime.Value = cTime;
}
this.FlexGridRecipe.InitConfig(
new string[] {
"title=处方信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=1000", //宽度，可为auto或具体px值
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("delnum", "委托单号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hospitalId", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("decmothed", "煎药方法", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("name", "患者姓名", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sex", "性别", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("age", "年龄", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("phone", "手机号码", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("address", "地址", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("department", "科室", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("inpatientarea", "病区号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ward", "病房号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sickbed", "病床号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("diagresult", "诊断结果", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takemethod", "服用方式", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takenum", "次数", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("decscheme", "煎药方案", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("packagenum", "包装量", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("oncetime", "煎药时间一", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("twicetime", "煎药时间二", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soakwater", "浸泡加水量", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soaktime", "浸泡时间", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("labelnum", "标签数量", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("remark", "说明", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("doctor", "医生", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("footnote", "医生脚注", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugtime", "取药时间", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugnum", "取药号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ordertime", "下单时间", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("curstate", "当前状态", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("person", "操作人员", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dotime", "接方时间", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbcompany", "配送公司", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbaddress", "配送地址", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbphone", "快递电话", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbtype", "配送类型", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takeway", "服用方法", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RemarksA", "备注A", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RemarksB", "备注B", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridRecipe.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler); //提供数据的方法
this.FlexGridDrug.InitConfig(
new string[] {
"title=药物信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=1000" //宽度，可为auto或具体px值
},
//序号、委托单号、医院编号、医院名称、处方号、药品编号、药品名称、药品描述、药品位置、药品总数量、药品重量、贴数、说明、批发价格、零售价格
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("id", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("yy", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
// new dotNetFlexGrid.FieldConfig("delnum","委托单号",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 96, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Drugnum", "药品编号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Drugname", "药品名称", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugDescription", "脚注", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugPosition", "药品规格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugAllNum", "单剂量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugWeight", "总剂量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("TieNum", "贴数", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Description", "说明", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("WholeSalePrice", "批发价格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RetailPrice", "零售价格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridDrug.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridFlexGridDrugDataHandler); //提供数据的方法
}
public ActionResult CreateHospital()
{
HospitalModel hospital = new HospitalModel();
return(View(hospital));
}
public IActionResult Edit(HospitalModel model)
{
ViewBag.FormName = "Hospital :#" + model.Id;
//permissions
if (SharedData.isHospitalMenuAccessible == false)
{
return(AccessDeniedView());
}
try
{
var hospital = _hospitalServices.GetHospitalById(model.Id);
if (hospital == null || hospital.Deleted)
{
//No vendor found with the specified id
return(RedirectToAction("UserCustomerList"));
}
if (ModelState.IsValid)
{
hospital.HospitalName = _encryptionService.EncryptText(model.HospitalName);//pratiksha post hospital name in Encrypt format 28/nov/2019
hospital.ContactPerson = _encryptionService.EncryptText(model.ContactPerson);
hospital.Deleted = false;
hospital.CreatedOn = DateTime.UtcNow;
hospital.LastUpdated = DateTime.UtcNow;
_hospitalServices.UpdateHospital(hospital);
//address
var address = _addressService.GetAddressById(hospital.HospitalAddress.Id);
if (address == null)
{
address.FirstName = _encryptionService.EncryptText(model.HospitalAddress.FirstName);
address.LastName = _encryptionService.EncryptText(model.HospitalAddress.LastName);
address.PhoneNumber = _encryptionService.EncryptText(model.HospitalAddress.PhoneNumber);
address.StateProvince = _encryptionService.EncryptText(model.HospitalAddress.StateProvince);
address.ZipPostalCode = _encryptionService.EncryptText(model.HospitalAddress.ZipPostalCode);
address.Email = _encryptionService.EncryptText(model.HospitalAddress.Email);
address.City = _encryptionService.EncryptText(model.HospitalAddress.City);
address.Address1 = _encryptionService.EncryptText(model.HospitalAddress.Address1);
address.Address2 = _encryptionService.EncryptText(model.HospitalAddress.Address2);
_addressService.InsertAddress(address);
// customer.Id = address.Id;
_hospitalServices.UpdateHospital(hospital);
}
else
{
address.FirstName = _encryptionService.EncryptText(model.HospitalAddress.FirstName);
address.LastName = _encryptionService.EncryptText(model.HospitalAddress.LastName);
address.PhoneNumber = _encryptionService.EncryptText(model.HospitalAddress.PhoneNumber);
address.StateProvince = _encryptionService.EncryptText(model.HospitalAddress.StateProvince);
address.ZipPostalCode = _encryptionService.EncryptText(model.HospitalAddress.ZipPostalCode);
address.Email = _encryptionService.EncryptText(model.HospitalAddress.Email);
address.City = _encryptionService.EncryptText(model.HospitalAddress.City);
address.Address1 = _encryptionService.EncryptText(model.HospitalAddress.Address1);
address.Address2 = _encryptionService.EncryptText(model.HospitalAddress.Address2);
_addressService.UpdateAddress(address);
}
AddNotification(NotificationMessage.TitleSuccess, NotificationMessage.msgEditHospital, NotificationMessage.TypeSuccess);
return(RedirectToAction("Index", "Hospital"));
}
else
{
PrepareHospitalAddressModel(model, hospital, false, true);
return(View(model));
}
}
catch (Exception e)
{
AddNotification(NotificationMessage.TitleError, NotificationMessage.ErrorMsg, NotificationMessage.TypeError);
return(RedirectToAction("Edit", "Hospital", model.Id));
}
}
//Arrange -> Act -> Assert
//Given -> When -> Then
public void GivenAnExistingRandomlySelectedHospital()
{
hospitalTestData = pmsDataState.FetchARandomHospitalFromDatabase();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sex.Items.Add(new ListItem("男", "1"));
sex.Items.Add(new ListItem("女", "2"));
if (Session["userNamebar"] != null)
{
string usernamechange = "";
string usernamebar = Session["userNamebar"].ToString();
EmployeeModel em = new EmployeeModel();
SqlDataReader sdr3 = em.findusernamebyjobnum(usernamebar);
if (sdr3.Read())
{
usernamechange = sdr3["EName"].ToString();
}
this.doperson.Value = usernamechange;
}
else
{
Response.Write("<script>alert('用户名已失效');window.parent.loginview();</script>");
}
scheme.Items.Add(new ListItem("微压（密闭）解表（15min）", "1"));
scheme.Items.Add(new ListItem("微压（密闭）汤药（15min）", "2"));
scheme.Items.Add(new ListItem("微压（密闭）补药（15min）", "3"));
scheme.Items.Add(new ListItem("常压解表（10min，10min）", "4"));
scheme.Items.Add(new ListItem("常压汤药（20min，15min）", "5"));
scheme.Items.Add(new ListItem("常压补药（25min，20min）", "6"));
scheme.Items.Add(new ListItem("先煎解表（10min，10min，10min）", "20"));
scheme.Items.Add(new ListItem("先煎汤药（10min，20min，15min）", "21"));
scheme.Items.Add(new ListItem("先煎补药（10min，25min，20min）", "22"));
scheme.Items.Add(new ListItem("后下解表（10min（3：7），10min）", "36"));
scheme.Items.Add(new ListItem("后下汤药（20min（13：7），15min）", "37"));
scheme.Items.Add(new ListItem("后下补药（25min（18：7），20min）", "38"));
scheme.Items.Add(new ListItem("微压自定义", "81"));
scheme.Items.Add(new ListItem("常压自定义", "82"));
scheme.Items.Add(new ListItem("先煎自定义", "83"));
scheme.Items.Add(new ListItem("后下自定义", "84"));
decmothed.Items.Add(new ListItem("先煎", "1"));
decmothed.Items.Add(new ListItem("后下", "2"));
decmothed.Items.Add(new ListItem("加糖加蜜", "3"));
takeway.Items.Add(new ListItem("水煎餐后", "1"));
dtbtype.Items.Add(new ListItem("顺丰", "1"));
dtbtype.Items.Add(new ListItem("圆通", "2"));
dtbtype.Items.Add(new ListItem("中通", "3"));
HospitalModel hm = new HospitalModel();
SqlDataReader sdr = hm.findHospitalAll();
int hid = 0;
if (sdr != null)
{
while (sdr.Read())
{
if (hid == 0)
{
hid = Convert.ToInt32(sdr["ID"].ToString());
}
this.hospitalname.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString()));
}
}
DataTable dt = hm.findNumById(Convert.ToInt16(hospitalname.Value));
hospitalnum.Value = dt.Rows[0][0].ToString();
EntrustNumberModel enm = new EntrustNumberModel();
delnum.Value = enm.getEntrustNumber(hid) + "";
System.DateTime seconddayTime = new System.DateTime();
seconddayTime = System.DateTime.Now.AddDays(1);//当前时间
string getdrugtime = seconddayTime.ToString("yyyy-MM-dd 08:00:00");//
this.soaktime.Value = "30";
this.druggettime.Value = getdrugtime;
}
string strDelNum = DateTime.Now.ToString("MMddhhmmss");
// delnum.Value = strDelNum;
string strdotime = DateTime.Now.ToString();
string a = "";
this.FlexGridRecipe.InitConfig(
new string[] {
"title=处方信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=1000", //宽度，可为auto或具体px值
"selectedonclick = true"
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("delnum", "委托单号", 120, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Hospitalid", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("decmothed", "煎药方法", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("name", "患者姓名", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sex", "性别", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("age", "年龄", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("phone", "手机号码", 150, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("address", "地址", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("department", "科室", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("inpatientarea", "病区号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ward", "病房号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("sickbed", "病床号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("diagresult", "诊断结果", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takemethod", "服用方式", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takenum", "次数", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("decscheme", "煎药方案", 180, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("packagenum", "包装量", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dose", "贴数", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("oncetime", "煎药时间一", 80, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("twicetime", "煎药时间二", 80, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soakwater", "浸泡加水量", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("soaktime", "浸泡时间", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("labelnum", "标签数量", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("remark", "说明", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("doctor", "医生", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("footnote", "医生脚注", 120, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugtime", "取药时间", 120, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("getdrugnum", "取药号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ordertime", "下单时间", 120, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("curstate", "当前状态", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dotime", "接方时间", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbcompany", "配送公司", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbaddress", "配送地址", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbphone", "快递电话", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("dtbtype", "配送类型", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("takeway", "服用方法", 80, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RemarksA", "备注A", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RemarksB", "备注B", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridRecipe.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridRecipeDataHandler); //提供数据的方法
this.FlexGridDrug.InitConfig(
new string[] {
"title=药物信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=false", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=false", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=980" //宽度，可为auto或具体px值
},
//序号、委托单号、医院编号、医院名称、处方号、药品编号、药品名称、药品描述、药品位置、药品总数量、药品重量、贴数、说明、批发价格、零售价格
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("ID", "序号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
// new dotNetFlexGrid.FieldConfig("delnum","委托单号",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hnum", "医院编号", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("hname", "医院名称", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Hospitalid", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
new dotNetFlexGrid.FieldConfig("Pspnum", "处方号", 65, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Drugnum", "药品编号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Drugname", "药品名称", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugDescription", "脚注", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugPosition", "药品规格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugAllNum", "单剂量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("DrugWeight", "总剂量", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("TieNum", "贴数", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("Description", "说明", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("WholeSalePrice", "批发价格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RetailPrice", "零售价格", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
// new dotNetFlexGrid.FieldConfig("WholeSaleCost","批发费用",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
//new dotNetFlexGrid.FieldConfig("retailpricecost","零售费用",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
//new dotNetFlexGrid.FieldConfig("money","含税金额",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
//new dotNetFlexGrid.FieldConfig("Fee","扣率",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridDrug.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridFlexGridDrugDataHandler); //提供数据的方法
}
private static JObject CallMultipartFormClinicApi(string url, ApiHeader apiHeader, HospitalModel data)
{
var cultureCode = Thread.CurrentThread.CurrentCulture;
var clientHandler = new WebRequestHandler();
clientHandler.ClientCertificates.Add(new X509Certificate2());
var httpClient = new HttpClient();
if (apiHeader != null)
{
httpClient.DefaultRequestHeaders.Add("userId", apiHeader.UserId);
httpClient.DefaultRequestHeaders.Add("sessionId", apiHeader.SessionId);
}
if (!string.IsNullOrEmpty(apiHeader?.Lang))
{
httpClient.DefaultRequestHeaders.Add("lang", apiHeader.Lang);
}
else
{
httpClient.DefaultRequestHeaders.Add("lang", "en");
}
var multipart = new MultipartFormDataContent
{
{ new StringContent(string.IsNullOrEmpty(data.Id) ? "" : data.Id), "id" },
{ new StringContent(string.IsNullOrEmpty(data.ClinicName) ? "" : data.ClinicName), "name" },
{ new StringContent(string.IsNullOrEmpty(data.AddressLine1) ? "" : data.AddressLine1), "address" },
{ new StringContent(string.IsNullOrEmpty(data.AddressLine2) ? "" : data.AddressLine2), "address2" },
{ new StringContent(string.IsNullOrEmpty(data.PhoneNumber[0]) ? "" : data.PhoneNumber[0]), "phones" },
{ new StringContent(string.IsNullOrEmpty(data.Suburb) ? "" : data.Suburb), "suburb" },
{ new StringContent(string.IsNullOrEmpty(data.PostCode) ? "" : data.PostCode), "postCode" },
{ new StringContent(string.IsNullOrEmpty(data.SignUpStatus.ToString()) ? "" : data.SignUpStatus.ToString()), "signUpStatus" },
};
//if (!string.IsNullOrEmpty(data.FileName))
//{
// multipart.Add(new ByteArrayContent(data.imagefile), "file", data.FileName);
//}
var result = httpClient.PostAsync(new Uri(url), multipart).Result;
var response = JsonConvert.DeserializeObject <ApiResponse>(result.Content.ReadAsStringAsync().Result);
if (!response.Successed)
{
throw new ApiException(response.ErrorMessage, response.ErrorCode.ToString(), cultureCode.Name);
}
return(response.Result);
}
public static string submitDrugInfo(string hospitalid, string drugpspnum, string drugnum, string drugname
, string drugdescription, string drugposition, string drugallnum, string drugweight, string tienum
, string description, string wholesaleprice, string retailprice, string pid)
{
DrugInfo dinfo = new DrugInfo();
HospitalModel hm = new HospitalModel();
dinfo.nHospitalNum = Convert.ToInt16(hospitalid);
dinfo.strPspnum = drugpspnum;
dinfo.strDrugNum = drugnum;
dinfo.strDrugName = drugname;
if (drugdescription == "")
{
dinfo.strDrugDsp = "无";
}
else
{
dinfo.strDrugDsp = drugdescription;
}
dinfo.strDrugPosition = drugposition;
dinfo.nAllNum = Convert.ToInt32(drugallnum);
dinfo.dWeight = Convert.ToDouble(drugweight);
dinfo.nTieNum = Convert.ToInt32(tienum);
if (description == "")
{
dinfo.strDsp = "无";
}
else
{
dinfo.strDsp = description;
}
if (wholesaleprice != "")
{
dinfo.dWholeSalePrice = Convert.ToDouble(wholesaleprice);
}
else
{
}
if (retailprice != "")
{
dinfo.dRetailPrice = Convert.ToDouble(retailprice);
}
else
{
}
RecipeModel m = new RecipeModel();
DataTable table = m.findPrescriptionById(pid);
if (table.Rows.Count > 0)
{
if ("1".Equals(table.Rows[0]["confirmDrug"].ToString()))
{
return("该处方药品已录入完成,不可以在录入药品");
}
else
{
EnterDrug ed = new EnterDrug();
/**/
bool rn = ed.AddDrug(dinfo);
if (rn)
{
return("录入成功");
}
else
{
return("录入失败");
}
}
}
else
{
return("处方不存在");
}
}
public async Task <IActionResult> EditHospital(Guid Id)
{
hospital = await _hospitalAndWardService.FindHospitalAsync(Id);
return(View(hospital));
}
