protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
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()));
}
}
}
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum.Value = Request.QueryString["id"].ToString();
WorkrecordQuInfo wm = new WorkrecordQuInfo();
DataTable dt = wm.getWorkrecordqueryInfo(id);
hospitalSelect.Value = dt.Rows[0]["hospitalid"].ToString();
pspnum.Value = dt.Rows[0]["pspnum"].ToString();
}
}
public static string getpcwarning()
{
WorkrecordQuInfo wq = new WorkrecordQuInfo();
string warningid = wq.recheckwarning();
return(warningid);
}
public static string updateWorkrecordqueryInfo(int id, string hospitalSelect, string pspnum)
{
WorkrecordQuInfo winfo = new WorkrecordQuInfo();
int result = winfo.updateWorkrecordqueryInfo(id, Convert.ToInt32(hospitalSelect), pspnum);
string str = null;
if (result == 0)
{
str = "0";
}
else
{
str = "1";
}
return(str);
}
public static string addWorkrecordqueryinfo(string DecoctingNum)
{
string result = "";
//string str2 = str1.TrimStart('0');
WorkrecordQuInfo wr = new WorkrecordQuInfo();
string str1 = DecoctingNum.Substring(4, 10);
int sdr = wr.AddWorkrecordQuInfo(Convert.ToInt64(str1));
if (sdr == 0)
{
result = "0";
}
else
{
result = "1";
}
return(result);
}
public static bool deleteWorkrecordqueryById(string strRowIds)
{
int a = 0;
bool result;
string[] strRows1Id = strRowIds.Split(',');
for (int i = 0; i < strRows1Id.Length; i++)
{
WorkrecordQuInfo winfo = new WorkrecordQuInfo();
a = winfo.deleteWorkrecordQuInfo(Convert.ToInt32(strRows1Id[i]));
}
if (a == 0)
{
result = false;
}
else
{
result = true;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
Statistics sc = new Statistics();
string str = sc.countall();
String[] strArr = str.Split(',');
//count.Text = "统计: 已录入: " + strArr[9] + " 已审核: " + strArr[8] + " 已打印: " + strArr[7] + " 未打印: " + strArr[10] + " 已匹配: " + strArr[6] + " 未匹配: " + strArr[11] + " 已调剂: " + strArr[5] + " 已复核: " + strArr[4] + " 已泡药: " + strArr[0] + " 已煎药: " + strArr[1] + " 已包装：" + strArr[2] + " 已发货：" + strArr[3] + " ";
// count.Text = "统计：已接方: " + strArr[9] + " 已审核: " + strArr[8] + " 未匹配: " + strArr[11] + " 调剂: " + strArr[5] + " 复核: " + strArr[4] + " 泡药: " + strArr[0] + " 煎药: " + strArr[1] + " 包装：" + strArr[2] + " 发货：" + strArr[3] + " ";
//报警
WorkrecordQuInfo wq = new WorkrecordQuInfo();
string warningid = wq.recheckwarning();
// warning.Value = warningid;
this.dotNetFlexGrid5.InitConfig(
new string[] {
"title=处方信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=false", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=1000" //宽度，可为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("Hospitalid", "医院ID", 60, true, dotNetFlexGrid.FieldConfigAlign.Center, false, true, false),
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("RemarksA", "备注A", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("RemarksB", "备注B", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.dotNetFlexGrid5.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler); //提供数据的方法
}