public static string findtisanemachineInfo(string tisanenum, string StartTime, string EndTime)
{
TeModel tm = new TeModel();
DataTable table = tm.findtisanemachineInfo(Convert.ToInt32(tisanenum), StartTime, EndTime);
return(DataTableToJson.ToJson(table));
}
//导出数据
protected void Button1_Click(object sender, EventArgs e)
{
string tisanetime1 = "";
string STime1 = "";
string ETime1 = "";
string tisanestatus1 = "";
STime1 = STime.Value;
ETime1 = ETime.Value;
if (tisanestatus.Value == "")
{
tisanestatus1 = "2";
}
else
{
tisanestatus1 = tisanestatus.Value;
}
string tisanemethod1 = tisanemethod.Value;
string tisaneman1 = tisaneman.Value;
string tisaneid1 = "";
if (tisaneid.Value == "")
{
tisaneid1 = "0";
}
else
{
tisaneid1 = tisaneid.Value;
}
if (tisaneid1 == "")
{
tisaneid1 = "0";
}
if (tisaneman1 == "")
{
tisaneman1 = "0";
}
TeModel tm = new TeModel();
// DataBaseLayer db = new DataBaseLayer();
// string str = "select * from lossiInfor where type ='" + type + "'";
DataTable dt = tm.queryTisaneInfoDao(Convert.ToInt32(tisaneid1), tisaneman1, Convert.ToInt32(tisanestatus1), Convert.ToInt32(tisanemethod1), STime1, ETime1);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "煎药查询功能" + now);
}
public static string updateGlobalInfo(int id)
{
string result = "1";
TeModel tm = new TeModel();
int a = Convert.ToInt32(id);
SqlDataReader sdr1 = tm.findTisaneAllbyId(a);
// if (sdr1.Read())
// {
// teid.Text = sdr1["tisaneunitid"].ToString();
// testatus1.Text = sdr1["tisaneunitname"].ToString();
/// teroomid.Text = sdr1["machineroomid"].ToString();
// testatus2.Text = sdr1["healthstatus"].ToString();
// }
// else
//{
// testatus1.Text = "无";
// teroomid.Text = "无";
// testatus2.Text = "无";
// }
if (sdr1.Read())
{
result = sdr1["disinfectionstatus"].ToString() + "," + sdr1["roomnum"] + "," + sdr1["healthstatus"] + "," + sdr1["status"] + "," + sdr1["usingstatus"];
}
return(result);
}
public static bool deleteTisaneById(string strRowIds)
{
int a = 0;
bool result;
string[] strRowsId = strRowIds.Split(',');
for (int i = 0; i < strRowsId.Length; i++)
{
//RecipeModel rm = new RecipeModel();
//Bubbleinfo bi = new Bubbleinfo();
TeModel tm = new TeModel();
a = tm.deleteTisaneinfoById(Convert.ToInt32(strRowsId[i]));
//bi.deleteRecipeInfo(Convert.ToInt16(strRowsId[i]));
// a = bi.deleteBubbleInfo(Convert.ToInt32(strRowsId[i]));
}
if (a == 0)
{
result = false;
}
else
{
result = true;
}
return(result);
}
//导出数据
protected void Button1_Click(object sender, EventArgs e)
{
string packnum1 = packnum.Value;
string StartTime1 = StartTime.Value;
string EndTime1 = EndTime.Value;
if (packnum1 == "")
{
packnum1 = "0";
}
if (StartTime1 == "")
{
StartTime1 = "0";
}
if (EndTime1 == "")
{
EndTime1 = "0";
}
TeModel tm = new TeModel();
// result.table = tm.findtisanemachineInfo(Convert.ToInt32(tisanenum), StartTime, EndTime);
DataTable dt = tm.findpackmachineInfo(Convert.ToInt32(packnum1), StartTime1, EndTime1);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "包装机工作量统计" + now);
}
//导出数据
protected void Button1_Click(object sender, EventArgs e)
{
string employname1 = employname.Value;
string employcode1 = employcode.Value;
string EndTime1 = EndTime.Value;
string StartTime1 = StartTime.Value;
if (employname1 == "")
{
employname1 = "0";
}
if (employcode1 == "")
{
employcode1 = "0";
}
if (StartTime1 == "")
{
StartTime1 = "0";
}
if (EndTime1 == "")
{
EndTime1 = "0";
}
TeModel tm = new TeModel();
DataTable dt = tm.EmployeeInfoout(employname1, employcode1, StartTime1, EndTime1);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "员工工作量统计" + now);
}
//提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid3DataHandler(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);
string packnum = "0";
if (p.extParam.ContainsKey("packnum"))
{
packnum = p.extParam["packnum"];
}
if (packnum == "")
{
packnum = "0";
}
string StartTime = "0";
if (p.extParam.ContainsKey("StartTime"))
{
StartTime = p.extParam["StartTime"];
}
if (StartTime == "")
{
StartTime = "0";
}
string EndTime = "0";
if (p.extParam.ContainsKey("EndTime"))
{
EndTime = p.extParam["EndTime"];
}
if (EndTime == "")
{
EndTime = "0";
}
TeModel tm = new TeModel();
// result.table = tm.findtisanemachineInfo(Convert.ToInt32(tisanenum), StartTime, EndTime);
result.table = tm.findpackmachineInfo(Convert.ToInt32(packnum), StartTime, EndTime);
return(result);
}
public static string getWarning()
{
//报警
TeModel bi = new TeModel();
string warningid = bi.deliverywarning();
return(warningid);
}
public static string getpcwarning()
{
TeModel tm = new TeModel();
string warningid = tm.adjustwarning();
return(warningid);
}
public static string gettempertureById(string tid)
{
TeModel am = new TeModel();
DataTable dt = am.gettemperture(tid);
string chartData = DataTableToJson.ToJson(dt);
return(chartData);
}
public dotNetFlexGrid.DataHandlerResult FlexGridDrugDataHandler(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);//调用演示的数据生成函数产生模拟数据
TeModel tm = new TeModel();
string PackMachine = "0";
if (p.extParam.ContainsKey("PackMachine"))
{
PackMachine = p.extParam["PackMachine"];
}
result.table = tm.getPackingMachineInfobyid(Convert.ToInt32(PackMachine));
//如果传递的参数包含排序设置的话，通过DataView.Sort功能模拟进行当页排序
//if (p.sortname.Length > 0 && p.sortorder.Length > 0)
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.Sort = (p.sortname + " " + p.sortorder);
// result.table = dv.ToTable();
//}
////处理默认查询，即Button1_Click中指定的DefaultSearch查询参数
//if (p.defaultSearch.ContainsKey("String1"))
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.RowFilter = "String1 Like '%" + p.defaultSearch["String1"] + "%'";
// result.table = dv.ToTable();
//}
////如果传递的参数包含附加参数的话，再来模拟查询，原谅我真的很懒。
//if (p.extParam.ContainsKey("String1"))
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.RowFilter = "String1 Like '%" + p.extParam["String1"] + "%'";
// result.table = dv.ToTable();
//}
////如果传递的参数包含快速查询参数，则进行快速查询
//if (p.qop != dotNetFlexGrid.SerchParamConfigOperater.None && p.qtype.Length > 0 && p.query.Length > 0)
//{
// System.Data.DataView dv = result.table.DefaultView;
// if (p.qop == dotNetFlexGrid.SerchParamConfigOperater.Like)
// dv.RowFilter = p.qtype + " Like '%" + p.query + "%'";
// else
// dv.RowFilter = p.qtype + " = '" + p.query + "'";
// result.table = dv.ToTable();
//}
return(result);
}
public static string getWarning()
{
//报警
TeModel tm = new TeModel();
string warningid = tm.tisanewarning();
return(warningid);
}
public static int addtisaneinfo(string tisanebarcode, string tisaneperson, string mark)
{
// Bubbleinfo bi = new Bubbleinfo();
TeModel tm = new TeModel();
//int sdr = bi.addbubble(tisanebarcode);
int sdr = tm.addtisaneinfo(tisanebarcode, tisaneperson, mark);
return(sdr);
}
protected void Page_Load(object sender, EventArgs e)
{
TeModel tm = new TeModel();
SqlDataReader sdr = tm.findTisaneAll();
if (sdr != null)
{
while (sdr.Read())
{
this.tisanenum.Items.Add(new ListItem(sdr["machinename"].ToString(), sdr["id"].ToString()));
}
}
//teid.Text = "nihao";
// testatus1.Text = "空闲";
// teroomid.Text = "1号机房";
// testatus2.Text ="良好";
int a = Convert.ToInt32(tisanenum.Value);
SqlDataReader sdr1 = tm.findTisaneAllbyId(a);
if (sdr1.Read())
{
// teid.Text = sdr1["tisaneunitid"].ToString();
}
else
{
tehealthstatus.Text = "无";
teroomid.Text = "无";
texiaodustatus.Text = "无";
status.Text = "无";
usingstatus.Text = "无";
}
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum.Value = Request.QueryString["id"].ToString();
}
Bubbleinfo bi = new Bubbleinfo();
string machineid = bi.distributionmachine();
SqlDataReader sdr2 = tm.findmachinenamebyid(Convert.ToInt32(machineid));
if (sdr2.Read())
{
recommend.Text = sdr2["machinename"].ToString();
}
}
public static string getpcwarning()
{
TeModel tm = new TeModel();
string pcwarning = tm.checkwarning();
return(pcwarning);
}
protected void Page_Load(object sender, EventArgs e)
{
TeModel tm = new TeModel();
SqlDataReader sdr = tm.findTisaneAll();
if (sdr != null)
{
while (sdr.Read())
{
this.tisanenum.Items.Add(new ListItem(sdr["machinename"].ToString(), sdr["id"].ToString()));
}
}
this.FlexGrid2.InitConfig(
new string[] {
"title=煎药机工作量统计", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=814" //宽度，可为auto或具体px值
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("hao", "煎药机号", 183, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workdate", "日期", 190, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workcontent", "工作内容", 190, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workload", "工作量", 190, false, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGrid2.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid2DataHandler);
TeModel tml = new TeModel();
DataTable dt = tml.findtisanemachineInfo(0, "0", "0");
this.chartData.Value = DataTableToJson.ToJson(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
TeModel tm = new TeModel();
SqlDataReader sdr = tm.findpackmachine();
if (sdr != null)
{
while (sdr.Read())
{
this.packnum.Items.Add(new ListItem(sdr["machinename"].ToString(), sdr["id"].ToString()));
}
}
this.FlexGrid3.InitConfig(
new string[] {
"title=包装机工作量统计", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=814" //宽度，可为auto或具体px值
},
// 序号、委托单号、医院编号、医院名称、处方号、煎药方式、姓名、性别、年龄、电话、地址、科室、病区号、
//病房号、病床号、诊断结果、剂数、服用方式、次数、包装量、服用方法、煎药方案、一煎时间、二煎时间、
//浸泡加水量、浸泡时间、标签数量、备注信息、医生、医生脚注、取药时间、取药序号、下单时间、当前状态、
//操作时间、操作人员、配送公司、配送地址、联系电话、快件类型
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("bao", "包装机号", 183, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workdate", "日期", 190, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workcontent", "工作内容", 190, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workload", "工作量", 190, false, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGrid3.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid3DataHandler);
TeModel tml = new TeModel();
DataTable dt = tml.packmachineInfo();
this.chartData.Value = DataTableToJson.ToJson(dt);
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
string pspnum = "";
if (p.extParam.ContainsKey("PspNum"))
{
pspnum = p.extParam["PspNum"];
}
TeModel tm = new TeModel();
result.table = tm.searchTisaneClass(pspnum);//调用演示的数据生成函数产生模拟数据
dotNetFlexGrid.FieldFormatorHandle proca = delegate(DataRow dr)
{
string z = "";
if (dr["bs"].ToString() == "")
{
String az = dr["bs"].ToString();
az = "3";
if (az == "3")
{
z = "无";
}
}
else
{
int az = Convert.ToInt32(dr["bs"].ToString());
if (az == 1)
{
z = "泡药完成";
}
}
return(z);
};
result.FieldFormator.Register("bs", proca);
return(result);
}
public static string tisaneinfoupdate(int id, string tisaneman, string machinename, string tisanestatus)
{
TeModel tm = new TeModel();
int result = tm.updateTisaneinfo(id, tisaneman, Convert.ToInt32(machinename), Convert.ToInt32(tisanestatus));
string end = "";
if (result == 0)
{
end = "0";
}
else
{
end = "1";
}
return(end);
}
public static string addunit(int id, string tisaneid, string tisaneman, string ps)
{
string result = "";
TeModel tm = new TeModel();
int sdr = tm.addunit(id, tisaneid, tisaneman, ps);
if (sdr == 0)
{
result = "0";
}
else
{
result = "1";
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum.Value = Request.QueryString["id"].ToString();
}
if (!IsPostBack)
{
TeModel tm = new TeModel();
SqlDataReader sdr = tm.findNameAll();
if (sdr != null)
{
while (sdr.Read())
{
this.tisaneperson.Items.Add(new ListItem(sdr["EmNumAName"].ToString()));
// this.SwapPer.Items.Add(new ListItem(sdr["JobNum"].ToString()));
}
}
DataBaseLayer db = new DataBaseLayer();
if (Session["userNamebar"] != null)
{
string name = Session["userNamebar"].ToString();
string sq1 = "select EmNumAName from Employee where jobnum ='" + name + "' ";
SqlDataReader sr = db.get_Reader(sq1);
if (sr.Read())
{
tisaneperson.Value = sr["EmNumAName"].ToString();
}
}
else
{
Response.Write("<script>alert('用户名已失效');window.parent.loginview();</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
TeModel tm = new TeModel();
SqlDataReader sdr = tm.findTisaneAll();
this.FlexGrid1.InitConfig(
new string[] {
"title=员工工作量统计", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=814" //宽度，可为auto或具体px值
},
// 序号、委托单号、医院编号、医院名称、处方号、煎药方式、姓名、性别、年龄、电话、地址、科室、病区号、
//病房号、病床号、诊断结果、剂数、服用方式、次数、包装量、服用方法、煎药方案、一煎时间、二煎时间、
//浸泡加水量、浸泡时间、标签数量、备注信息、医生、医生脚注、取药时间、取药序号、下单时间、当前状态、
//操作时间、操作人员、配送公司、配送地址、联系电话、快件类型
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("workman", "员工姓名", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workmannum", "员工工号", 170, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workdate", "日期", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workcontent", "工作内容", 170, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("workload", "工作量", 120, false, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGrid1.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler);
TeModel tml = new TeModel();
DataTable dt = tml.EmployeeInfoCountAll("0", "0", "0", "0", "0");
this.chartData.Value = DataTableToJson.ToJson(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
this.tisanestatus.Items.Add(new ListItem("已完成", "1"));
this.tisanestatus.Items.Add(new ListItem("待煎药", "2"));
this.tisanestatus.Items.Add(new ListItem("正在煎药", "3"));
TeModel tm = new TeModel();
SqlDataReader sdr1 = tm.getTisaneMachinInfo();
if (sdr1 != null)
{
while (sdr1.Read())
{
this.machinename.Items.Add(new ListItem(sdr1["machinename"].ToString(), sdr1["id"].ToString()));
}
}
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum.Value = Request.QueryString["id"].ToString();
SqlDataReader sr = tm.findTisaneinfoByid(id);
if (sr.Read())
{
tisaneperson.Value = sr["tisaneman"].ToString();
machinename.Value = sr["machineid"].ToString();
tisanestatus.Value = sr["tisanestatus"].ToString();
}
}
// TeModel tm = new TeModel();
//tm.findTisaneinfoByid();
}
public dotNetFlexGrid.DataHandlerResult FlexGridDrugDataHandler(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);//调用演示的数据生成函数产生模拟数据
string tisanenum = "0";
if (p.extParam.ContainsKey("tisanenum"))
{
tisanenum = p.extParam["tisanenum"];
}
TeModel tm = new TeModel();
result.table = tm.getTisaneInfoByTisanenum(tisanenum);
//如果传递的参数包含排序设置的话，通过DataView.Sort功能模拟进行当页排序
//if (p.sortname.Length > 0 && p.sortorder.Length > 0)
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.Sort = (p.sortname + " " + p.sortorder);
// result.table = dv.ToTable();
//}
////处理默认查询，即Button1_Click中指定的DefaultSearch查询参数
//if (p.defaultSearch.ContainsKey("String1"))
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.RowFilter = "String1 Like '%" + p.defaultSearch["String1"] + "%'";
// result.table = dv.ToTable();
//}
////如果传递的参数包含附加参数的话，再来模拟查询，原谅我真的很懒。
//if (p.extParam.ContainsKey("String1"))
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.RowFilter = "String1 Like '%" + p.extParam["String1"] + "%'";
// result.table = dv.ToTable();
//}
////如果传递的参数包含快速查询参数，则进行快速查询
//if (p.qop != dotNetFlexGrid.SerchParamConfigOperater.None && p.qtype.Length > 0 && p.query.Length > 0)
//{
// System.Data.DataView dv = result.table.DefaultView;
// if (p.qop == dotNetFlexGrid.SerchParamConfigOperater.Like)
// dv.RowFilter = p.qtype + " Like '%" + p.query + "%'";
// else
// dv.RowFilter = p.qtype + " = '" + p.query + "'";
// result.table = dv.ToTable();
//}
dotNetFlexGrid.FieldFormatorHandle proc = delegate(DataRow dr)
{
string a = "";
int tstatus = Convert.ToInt32(dr["tisanestatus"].ToString());
if (tstatus == 0)
{
a = "开始煎药";
}
else if (tstatus == 1)
{
a = "煎药完成";
}
/* else
* {
* a = "煎药";
* }*/
return(a);
};
result.FieldFormator.Register("tisanestatus", proc);
return(result);
}
public dotNetFlexGrid.DataHandlerResult FlexGridRecipeDataHandler(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);//调用演示的数据生成函数产生模拟数据
string tisaneid = "0";
if (p.extParam.ContainsKey("tisaneid"))
{
tisaneid = p.extParam["tisaneid"];
}
if (tisaneid == "")
{
tisaneid = "0";
}
TeModel tm = new TeModel();
result.table = tm.getPreBytisaneid(Convert.ToInt32(tisaneid));
dotNetFlexGrid.FieldFormatorHandle proc = delegate(DataRow dr)
{
string a = "";
int tstatus = Convert.ToInt32(dr["tisanestatus"].ToString());
if (tstatus == 0)
{
a = "开始煎药";
}
else if (tstatus == 1)
{
a = "煎药完成";
}
/* else
* {
* a = "煎药";
* }*/
return(a);
};
result.FieldFormator.Register("tisanestatus", proc);
//如果传递的参数包含排序设置的话，通过DataView.Sort功能模拟进行当页排序
//if (p.sortname.Length > 0 && p.sortorder.Length > 0)
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.Sort = (p.sortname + " " + p.sortorder);
// result.table = dv.ToTable();
//}
////处理默认查询，即Button1_Click中指定的DefaultSearch查询参数
//if (p.defaultSearch.ContainsKey("String1"))
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.RowFilter = "String1 Like '%" + p.defaultSearch["String1"] + "%'";
// result.table = dv.ToTable();
//}
////如果传递的参数包含附加参数的话，再来模拟查询，原谅我真的很懒。
//if (p.extParam.ContainsKey("String1"))
//{
// System.Data.DataView dv = result.table.DefaultView;
// dv.RowFilter = "String1 Like '%" + p.extParam["String1"] + "%'";
// result.table = dv.ToTable();
//}
////如果传递的参数包含快速查询参数，则进行快速查询
//if (p.qop != dotNetFlexGrid.SerchParamConfigOperater.None && p.qtype.Length > 0 && p.query.Length > 0)
//{
// System.Data.DataView dv = result.table.DefaultView;
// if (p.qop == dotNetFlexGrid.SerchParamConfigOperater.Like)
// dv.RowFilter = p.qtype + " Like '%" + p.query + "%'";
// else
// dv.RowFilter = p.qtype + " = '" + p.query + "'";
// result.table = dv.ToTable();
//}
dotNetFlexGrid.FieldFormatorHandle proc2 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["sex"].ToString());
if (a == 1)
{
return("男");
}
else
{
return("女");
}
};
result.FieldFormator.Register("sex", proc2);
dotNetFlexGrid.FieldFormatorHandle proc3 = delegate(DataRow dr)
{
int b = Convert.ToInt32(dr["decscheme"].ToString());
if (b == 1)
{
return("微压（密闭）解表（15min）");
}
else if (b == 2)
{
return("微压（密闭）汤药（15min）");
}
else if (b == 3)
{
return("微压（密闭）补药（15min）");
}
else if (b == 4)
{
return("常压解表（10min，10min）");
}
else if (b == 5)
{
return("常压汤药（20min，15min）");
}
else if (b == 6)
{
return("常压补药（25min，20min）");
}
else if (b == 20)
{
return("先煎解表（10min，10min，10min）");
}
else if (b == 21)
{
return("先煎汤药（10min，20min，15min）");
}
else if (b == 22)
{
return("先煎补药（10min，25min，20min）");
}
else if (b == 36)
{
return("后下解表（10min（3：7），10min）");
}
else if (b == 37)
{
return("后下汤药（20min（13：7），15min）");
}
else if (b == 38)
{
return("后下补药（25min（18：7），20min）");
}
else if (b == 81)
{
return("微压自定义");
}
else if (b == 82)
{
return("常压自定义");
}
else if (b == 83)
{
return("先煎自定义");
}
else
{
return("后下自定义");
}
};
result.FieldFormator.Register("decscheme", proc3);
dotNetFlexGrid.FieldFormatorHandle proc4 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["decmothed"].ToString());
if (a == 1)
{
return("先煎");
}
else if (a == 2)
{
return("后下");
}
else
{
return("加糖加蜜");
}
};
result.FieldFormator.Register("decmothed", proc4);
dotNetFlexGrid.FieldFormatorHandle proc6 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["takeway"].ToString());
if (a == 1)
{
return("水煎餐后");
}
else
{
return("");
}
};
result.FieldFormator.Register("takeway", proc6);
dotNetFlexGrid.FieldFormatorHandle proc5 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["dtbtype"].ToString());
if (a == 1)
{
return("顺丰");
}
else if (a == 2)
{
return("圆通");
}
else
{
return("中通");
}
};
result.FieldFormator.Register("dtbtype", proc5);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
TeModel tm = new TeModel();
SqlDataReader sdr = tm.findTisaneAll();
if (sdr != null)
{
while (sdr.Read())
{
this.tisanenum.Items.Add(new ListItem(sdr["machinename"].ToString(), sdr["id"].ToString()));
}
}
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("tisaneman","煎药人员",60,true,dotNetFlexGrid.FieldConfigAlign.Center),
//new dotNetFlexGrid.FieldConfig("tisanestatus","煎药状态",60,true,dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("starttime", "开始时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("endDate", "完成时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("machineid", "煎药机号", 60, false, 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("Pspnum", "处方号", 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("waterYield", "实际加水量", 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("tisanestatus", "当前状态", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
//new dotNetFlexGrid.FieldConfig("dotime","处理时间",60,true,dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("tisaneman", "操作人员", 60, false, 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("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=1000" //宽度，可为auto或具体px值
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("pid", "煎药单号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("ps", "处方号", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("tisaneman", "煎药人员", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("tisanestatus", "煎药状态", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("starttime", "开始时间", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("machineid", "煎药机号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
// new dotNetFlexGrid.FieldConfig("tisanemethod","煎药方案",60,false,dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridDrug.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridDrugDataHandler); //提供数据的方法
}
protected void Page_Load(object sender, EventArgs e)
{
String type = Request.QueryString["type"].ToString();
if ("save".Equals(type))
{
try
{
string imgbase64 = Request.Form["imgbase64"]; //图片
string tisaneNum = Request.Form["tisaneNum"]; //煎药单号
string userNum = Request.Form["userNum"]; //员工号
string barcode = Request.Form["barcode"]; //条形码
string waterYield = Request.Form["waterYield"]; //水量
string userName = Request.Form["userName"]; //员工姓名
string imgname = null;
string nowDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (imgbase64 != null && imgbase64.Trim().Length > 0)
{
imgbase64 = imgbase64.Replace(' ', '+');
Byte[] bimg = Convert.FromBase64String(imgbase64);
//D:\\项目\\煎药厂\\src\\web\\upload\\
String path = System.AppDomain.CurrentDomain.BaseDirectory.ToString() + "upload\\";
imgname = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".png";
FileBinaryConvertHelper.Bytes2File(bimg, path + imgname);
}
TeModel tm = new TeModel();
Bubbleinfo bl = new Bubbleinfo();
DataTable dt = tm.findTisaneinfoBybarcode(tisaneNum);
int result = 0;
string machine = "[]";
string tisaneunit = "[]";
string flag = "0";
if (dt.Rows.Count > 0)
{
if ("1".Equals(dt.Rows[0]["tisanestatus"].ToString()))
{
result = 0;
}
else
{
flag = "1";
result = tm.updateTisaneinfo(Convert.ToInt32(dt.Rows[0]["id"].ToString()), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), tisaneNum, dt.Rows[0]["starttime"].ToString());
}
}
else
{
RecipeModel rem = new RecipeModel();
DataTable dtable = rem.findBubbleFinish(Convert.ToInt32(tisaneNum));
if (dtable.Rows.Count > 0)
{
DataTable table = bl.findMachineByStartAndFree();
if (table.Rows.Count > 0)
{
machine = DataTableToJson.ToJson(table);
}
DataTable tisaneunits = bl.findTisaneunitByPid(Convert.ToInt32(tisaneNum));
if (tisaneunits.Rows.Count > 0)
{
tisaneunit = DataTableToJson.ToJson(tisaneunits);
}
result = 1;
}
else
{
result = 0;
}
}
if (result > 0)
{
Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\",\"machine\":" + machine + ",\"tisaneunit\":" + tisaneunit + ",\"flag\":" + flag + "}");
}
else
{
Response.Write("{\"code\":\"1\",\"msg\":\"操作失败\"}");
}
}
catch (Exception e1)
{
Response.Write("{\"code\":\"1\",\"msg\":\"操作失败\"}");
}
}
else if ("get".Equals(type))
{
String id = Request.QueryString["id"].ToString();
TeModel tm = new TeModel();
RecipeModel rm = new RecipeModel();
string warningid = rm.getRetentionWarning(4);
DataTable dataTable = tm.getPreBytisaneid(Convert.ToInt32(id), DateTime.Now.ToString("yyyy-MM-dd"));
Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\",\"data\":" + DataTableToJson.ToJson(dataTable) + ",\"warning\":\"" + warningid + "\"}");
}
else if ("updateMachine".Equals(type))
{
string imgbase64 = Request.Form["imgbase64"]; //图片
string tisaneNum = Request.Form["tisaneNum"]; //煎药单号
string userNum = Request.Form["userNum"]; //员工号
string barcode = Request.Form["barcode"]; //条形码
string waterYield = Request.Form["waterYield"]; //水量
string userName = Request.Form["userName"]; //员工姓名
string imgname = null;
string nowDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (imgbase64 != null && imgbase64.Trim().Length > 0)
{
imgbase64 = imgbase64.Replace(' ', '+');
Byte[] bimg = Convert.FromBase64String(imgbase64);
//D:\\项目\\煎药厂\\src\\web\\upload\\
String path = System.AppDomain.CurrentDomain.BaseDirectory.ToString() + "upload\\";
imgname = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".png";
FileBinaryConvertHelper.Bytes2File(bimg, path + imgname);
}
Bubbleinfo bi = new Bubbleinfo();
string tid = Request.Form["tid"]; //分配机组记录id
string machineid = Request.Form["machineid"]; //煎药机id
bi.updateTisaneunitByMachineid(Convert.ToInt32(tid), Convert.ToInt32(machineid));
TeModel tm = new TeModel();
tm.addTisaneinfo(Convert.ToInt32(userNum), nowDate, barcode, "煎药", tisaneNum, imgname, waterYield, userName);
Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\"}");
}
}
//提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
string employname = "0";
if (p.extParam.ContainsKey("employname"))
{
employname = p.extParam["employname"];
}
if (employname == "")
{
employname = "0";
}
string employcode = "0";
if (p.extParam.ContainsKey("employcode"))
{
employcode = p.extParam["employcode"];
}
if (employcode == "")
{
employcode = "0";
}
string StartTime = "0";
if (p.extParam.ContainsKey("StartTime"))
{
StartTime = p.extParam["StartTime"];
}
if (StartTime == "")
{
StartTime = "0";
}
string EndTime = "0";
if (p.extParam.ContainsKey("EndTime"))
{
EndTime = p.extParam["EndTime"];
}
if (EndTime == "")
{
EndTime = "0";
}
string workcontent = "0";
if (p.extParam.ContainsKey("workcontent"))
{
workcontent = p.extParam["workcontent"];
}
if (workcontent == "")
{
workcontent = "0";
}
TeModel tm = new TeModel();
result.table = tm.EmployeeInfo(employname, employcode, StartTime, EndTime, workcontent);
return(result);
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(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);//调用演示的数据生成函数产生模拟数据
//如果传递的参数包含排序设置的话，通过DataView.Sort功能模拟进行当页排序
string tisaneid = "0";
if (p.extParam.ContainsKey("tisaneid"))
{
tisaneid = p.extParam["tisaneid"];
}
string tisaneman = "0";
if (p.extParam.ContainsKey("tisaneman"))
{
tisaneman = p.extParam["tisaneman"];
}
string STime = "";
if (p.extParam.ContainsKey("STime"))
{
STime = p.extParam["STime"];
}
string ETime = "";
if (p.extParam.ContainsKey("ETime"))
{
ETime = p.extParam["ETime"];
}
string tisanestatus = "0";
if (p.extParam.ContainsKey("tisanestatus"))
{
tisanestatus = p.extParam["tisanestatus"];
}
string tisanemethod = "0";
if (p.extParam.ContainsKey("tisanemethod"))
{
tisanemethod = p.extParam["tisanemethod"];
}
if (tisaneid == "")
{
tisaneid = "0";
}
if (tisaneman == "")
{
tisaneman = "0";
}
TeModel tm = new TeModel();
// result.table = tm.queryTisaneInfo(Convert.ToInt32(tisaneid), tisaneman, tisanestatus, tisanemethod, tisanetime);
result.table = tm.queryTisaneInfo(Convert.ToInt32(tisaneid), tisaneman, Convert.ToInt32(tisanestatus), Convert.ToInt32(tisanemethod), STime, ETime);
dotNetFlexGrid.FieldFormatorHandle proc = delegate(DataRow dr)
{
string a = "";
int tstatus = Convert.ToInt32(dr["tisanestatus"].ToString());
if (tstatus == 0)
{
a = "开始煎药";
}
else if (tstatus == 1)
{
a = "煎药完成";
}
return(a);
};
result.FieldFormator.Register("tisanestatus", proc);
dotNetFlexGrid.FieldFormatorHandle proc1 = delegate(DataRow dr)
{
int bstatus = Convert.ToInt32(dr["bubblestatus"].ToString());
if (bstatus == 1)
{
return("泡药完成");
}
else
{
return("开始泡药");
}
};
//
dotNetFlexGrid.FieldFormatorHandle proc1a = delegate(DataRow dr)
{
string z = "";
int bstatus = Convert.ToInt32(dr["tisanestatus"].ToString());
string start = dr["starttime"].ToString();
if (bstatus == 0)
{
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string strtime = currentTime.ToString("yyyy-MM-dd HH:mm:ss"); //
DateTime d1 = Convert.ToDateTime(strtime); //当前时间
DateTime d2 = Convert.ToDateTime(start); //开始时间
TimeSpan d3 = d1.Subtract(d2); //泡药时间
int dT = Convert.ToInt32(d3.Days.ToString()) * 24 * 60 + Convert.ToInt32(d3.Hours.ToString()) * 60 + Convert.ToInt32(d3.Minutes.ToString()); //转化为分钟数
string dt = dT.ToString();
z = dt;
}
else
{
z = dr["tisanetime"].ToString();
}
return(z);
};
result.FieldFormator.Register("tisanetime", proc1a);
dotNetFlexGrid.FieldFormatorHandle proc2 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["sex"].ToString());
if (a == 1)
{
return("男");
}
else
{
return("女");
}
};
result.FieldFormator.Register("sex", proc2);
dotNetFlexGrid.FieldFormatorHandle proc3 = delegate(DataRow dr)
{
int b = Convert.ToInt32(dr["decscheme"].ToString());
if (b == 1)
{
return("微压（密闭）解表（15min）");
}
else if (b == 2)
{
return("微压（密闭）汤药（15min）");
}
else if (b == 3)
{
return("微压（密闭）补药（15min）");
}
else if (b == 4)
{
return("常压解表（10min，10min）");
}
else if (b == 5)
{
return("常压汤药（20min，15min）");
}
else if (b == 6)
{
return("常压补药（25min，20min）");
}
else if (b == 20)
{
return("先煎解表（10min，10min，10min）");
}
else if (b == 21)
{
return("先煎汤药（10min，20min，15min）");
}
else if (b == 22)
{
return("先煎补药（10min，25min，20min）");
}
else if (b == 36)
{
return("后下解表（10min（3：7），10min）");
}
else if (b == 37)
{
return("后下汤药（20min（13：7），15min）");
}
else if (b == 38)
{
return("后下补药（25min（18：7），20min）");
}
else if (b == 81)
{
return("微压自定义");
}
else if (b == 82)
{
return("常压自定义");
}
else if (b == 83)
{
return("先煎自定义");
}
else
{
return("后下自定义");
}
};
result.FieldFormator.Register("decscheme", proc3);
dotNetFlexGrid.FieldFormatorHandle proc4 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["decmothed"].ToString());
if (a == 1)
{
return("先煎");
}
else if (a == 2)
{
return("后下");
}
else
{
return("加糖加蜜");
}
};
result.FieldFormator.Register("decmothed", proc4);
dotNetFlexGrid.FieldFormatorHandle proc6 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["takeway"].ToString());
if (a == 1)
{
return("水煎餐后");
}
else
{
return("");
}
};
result.FieldFormator.Register("takeway", proc6);
dotNetFlexGrid.FieldFormatorHandle proc5 = delegate(DataRow dr)
{
int a = Convert.ToInt32(dr["dtbtype"].ToString());
if (a == 1)
{
return("顺丰");
}
else if (a == 2)
{
return("圆通");
}
else
{
return("中通");
}
};
result.FieldFormator.Register("dtbtype", proc5);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
TeModel tm = new TeModel();
SqlDataReader sdr1 = tm.getTisaneMachinInfo();
SqlDataReader sdr2 = tm.getPackingMachineInfo();
if (sdr1 != null)
{
while (sdr1.Read())
{
this.TisaneMachine.Items.Add(new ListItem(sdr1["machinename"].ToString(), sdr1["id"].ToString()));
}
}
if (sdr2 != null)
{
while (sdr2.Read())
{
this.PackMachine.Items.Add(new ListItem(sdr2["machinename"].ToString(), sdr2["id"].ToString()));
}
}
this.FlexGridRecipe.InitConfig(
new string[] {
"title=煎药机信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=true", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=585" //宽度，可为auto或具体px值
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("machinename", "煎药名称", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("roomnum", "机房号", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("usingstatus", "启用状态", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("status", "状态", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("healthstatus", "卫生状态", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("disinfectionstatus", "消毒状态", 90, false, 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=1000" //宽度，可为auto或具体px值
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("machinename", "包装机名称", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("roomnum", "机房号", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("usingstatus", "启用状态", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("status", "状态", 60, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("healthstatus", "卫生状态", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("disinfectionstatus", "消毒状态", 60, false, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridDrug.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(FlexGridDrugDataHandler); //提供数据的方法
}
