public static bool updatewarninginfoById(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();
//bi.deleteRecipeInfo(Convert.ToInt16(strRowsId[i]));
meRoomModel rm = new meRoomModel();
a = rm.updatewarningstatus(strRowsId[i]);
// a = hm.deletewarninginfo(strRowsId[i]);
}
if (a == 0)
{
result = false;
}
else
{
result = true;
}
return(result);
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
meRoomModel rm = new meRoomModel();
string unitnum = "";
if (p.extParam.ContainsKey("unitnum"))
{
unitnum = p.extParam["unitnum"];
}
string roomnum = "";
if (p.extParam.ContainsKey("roomnum"))
{
roomnum = p.extParam["roomnum"];
}
result.table = rm.DecoctingMonitoring(unitnum, roomnum);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
meRoomModel hm = new meRoomModel();
SqlDataReader sdr = hm.findunitnumbymachine();
unitnum.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr != null)
{
while (sdr.Read())
{
this.unitnum.Items.Add(new ListItem(sdr["unitnum"].ToString()));
}
}
meRoomModel hm1 = new meRoomModel();
SqlDataReader sdr1 = hm1.findroomnumbymachine();
roomnum.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr1 != null)
{
while (sdr1.Read())
{
this.roomnum.Items.Add(new ListItem(sdr1["meRoomName"].ToString()));
}
}
}
this.FlexGridDecoctingMonitoring.InitConfig(
new string[] {
"title=煎药机监控信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=false", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=600" //宽度，可为auto或具体px值
},
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("id", "序号", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("unitnum", "煎药机组编号", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("machinename", "煎药机编号", 90, false, 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),
new dotNetFlexGrid.FieldConfig("CurrentTemp", "当前温度", 90, false, dotNetFlexGrid.FieldConfigAlign.Center),
},
null
,
null
);
this.FlexGridDecoctingMonitoring.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler);//提供数据的方法
}
public dotNetFlexGrid.DataHandlerResult FlexGridClearingpartyDataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
meRoomModel rm = new meRoomModel();
result.table = rm.findmeRoomInfo();
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
meRoomModel mrm = new meRoomModel();
SqlDataReader sdr = mrm.findmachineroom();
if (sdr != null)
{
while (sdr.Read())
{
this.meRoomName.Items.Add(new ListItem(sdr["meRoomName"].ToString(), sdr["id"].ToString()));
}
}
if (!IsPostBack)
{
this.typemachine.Items.Add(new ListItem("煎药机", "0"));
this.typemachine.Items.Add(new ListItem("包装机", "1"));
}
if (Request.QueryString["id"] != null)
{
string roomid = "0";
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum.Value = Request.QueryString["id"].ToString();
meRoomModel mrm1 = new meRoomModel();
DataTable dt = mrm1.findmachienInfobyid(id);
SqlDataReader sdr2 = mrm1.findmachineroomidbymachineroom(dt.Rows[0]["roomnum"].ToString());
if (sdr2.Read())
{
roomid = sdr2["id"].ToString();
}
//hospitalname.Value = dt.Rows[0]["hname"].ToString();
meRoomName.Value = roomid;
unitnum.Value = dt.Rows[0]["unitnum"].ToString();
typemachine.Value = dt.Rows[0]["mark"].ToString();
machinenum.Value = dt.Rows[0]["machinename"].ToString();
macaddresss.Value = dt.Rows[0]["macaddress"].ToString();
status.Value = dt.Rows[0]["status"].ToString();
openstatus.Value = dt.Rows[0]["usingstatus"].ToString();
healthystatus.Value = dt.Rows[0]["healthstatus"].ToString();
disinfectionstatus.Value = dt.Rows[0]["disinfectionstatus"].ToString();
checkman.Value = dt.Rows[0]["checkman"].ToString();
checktime.Value = dt.Rows[0]["checktime"].ToString();
equipmenttype.Value = dt.Rows[0]["equipmenttype"].ToString();
}
}
//导出数据
protected void Button1_Click(object sender, EventArgs e)
{
string unitnum1 = unitnum.Value;
string roomnum1 = roomnum.Value;
meRoomModel rm = new meRoomModel();
DataTable dt = rm.DecoctingMonitoring(unitnum1, roomnum1);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "煎药机监控" + now);
}
public static string updateMachineinfo(string meRoomName, string unitnum, string machinenum, string macaddresss, string typeofmachine, string idnum, string status, string openstatus, string disinfectionstatus, string healthystatus, string checkman, string checktime, string equipmenttype)
{
string result = "0";
meRoomModel rm = new meRoomModel();
DataTable machienInfo = rm.findmachienInfobyid(Convert.ToInt32(idnum));
if (machienInfo.Rows.Count > 0)
{
if (machienInfo.Rows[0]["unitnum"].ToString() != unitnum && typeofmachine == "1")
{
DataTable machienInfos = rm.findMachineByMarkAndUnitnum("1", unitnum);
if (machienInfos.Rows.Count > 0)
{
return("4");
}
else
{
int sdr = rm.updatemachineinfo(meRoomName, unitnum, typeofmachine, machinenum, macaddresss, idnum, status, openstatus, disinfectionstatus, healthystatus, checkman, checktime, equipmenttype);
if (sdr == 2)
{
result = "2";
}
else
{
result = "1";
}
}
}
else
{
int sdr = rm.updatemachineinfo(meRoomName, unitnum, typeofmachine, machinenum, macaddresss, idnum, status, openstatus, disinfectionstatus, healthystatus, checkman, checktime, equipmenttype);
if (sdr == 2)
{
result = "2";
}
else
{
result = "1";
}
}
}
else
{
result = "3";
}
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();
meRoomModel rm = new meRoomModel();
DataTable dt = rm.findmachineroombyid1(id);
meRoomName.Value = dt.Rows[0]["meRoomName"].ToString();
meRoomNum.Value = dt.Rows[0]["meRoomNum"].ToString();
Remarks.Value = dt.Rows[0]["Remarks"].ToString();
}
}
public static string addMachineinfo(string meRoomName, string unitnum, string machinenum, string macaddresss, string typeofmachine, string status, string openstatus, string healthystatus, string disinfectionstatus, string checkman, string checktime, string equipmenttype)
{
string result = "0";
meRoomModel rm = new meRoomModel();
int sdr = rm.addmachineinfo(meRoomName, unitnum, typeofmachine, machinenum, macaddresss, status, openstatus, healthystatus, disinfectionstatus, checkman, checktime, equipmenttype);
if (sdr == 1)
{
result = "1";
}
else
{
result = "2";
}
return(result);
}
public static string addMeRoom(string meRoomName, string meRoomNum, string Remarks)
{
string result = "";
meRoomModel rm = new meRoomModel();
int sdr = rm.AddmeRoom(meRoomNum, meRoomName, Remarks);
if (sdr == 0)
{
result = "0";
}
else
{
result = "1";
}
return(result);
}
public static string updateDeliveryInfo(int id, string meRoomName, string meRoomNum, string Remarks)
{
meRoomModel dm = new meRoomModel();
int result = dm.updatemeRoom(id, meRoomName, meRoomNum, Remarks);
string str = null;
if (result == 0)
{
str = "0";
}
else
{
str = "1";
}
return(str);
}
protected void Page_Load(object sender, EventArgs e)
{
meRoomModel mrm = new meRoomModel();
SqlDataReader sdr = mrm.findmachineroom();
if (sdr != null)
{
while (sdr.Read())
{
this.meRoomName.Items.Add(new ListItem(sdr["meRoomName"].ToString(), sdr["id"].ToString()));
}
}
if (!IsPostBack)
{
this.typemachine.Items.Add(new ListItem("煎药机", "0"));
this.typemachine.Items.Add(new ListItem("包装机", "1"));
}
}
public static bool deleteMeRoomById(string strRowIds)
{
int a = 0;
bool result;
string[] strRows1Id = strRowIds.Split(',');
for (int i = 0; i < strRows1Id.Length; i++)
{
meRoomModel winfo = new meRoomModel();
a = winfo.deleteMeRoomInfo(Convert.ToInt32(strRows1Id[i]));
}
if (a == 0)
{
result = false;
}
else
{
result = true;
}
return(result);
}
public static bool deletemachineById(string strRowIds)
{
int a = 0;
bool result;
string[] strRows1Id = strRowIds.Split(',');
for (int i = 0; i < strRows1Id.Length; i++)
{
meRoomModel rm = new meRoomModel();
a = rm.deletemachineinfo(strRows1Id[i]);
}
if (a == 0)
{
result = false;
}
else
{
result = true;
}
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);//调用演示的数据生成函数产生模拟数据
string typeofmachine = "3";
if (p.extParam.ContainsKey("typeofmachine"))
{
typeofmachine = p.extParam["typeofmachine"];
}
if (typeofmachine == "")
{
typeofmachine = "3";
}
meRoomModel mrm = new meRoomModel();
result.table = mrm.findallmachineinfo(typeofmachine);
dotNetFlexGrid.FieldFormatorHandle proc1 = delegate(DataRow dr)
{
int bstatus = Convert.ToInt32(dr["mark"].ToString());
if (bstatus == 0)
{
return("煎药机");
}
else
{
return("包装机");
}
};
result.FieldFormator.Register("mark", proc1);
dotNetFlexGrid.FieldFormatorHandle proc = delegate(DataRow dr)
{
if (dr["usingstatus"].ToString() == "启用")
{
return("<span style='color:red'>启用</span>");
}
else
{
return("<span style='color:black'>停用</span>");
}
};
result.FieldFormator.Register("usingstatus", 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();
//}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
meRoomModel hm = new meRoomModel();
SqlDataReader sdr = hm.findunitnumbymachine1();
unitnum.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr != null)
{
while (sdr.Read())
{
this.unitnum.Items.Add(new ListItem(sdr["unitnum"].ToString()));
}
}
meRoomModel hm1 = new meRoomModel();
SqlDataReader sdr1 = hm1.findroomnumbymachine();
roomnum.Items.Add(new ListItem(" 全部 ", "0"));
if (sdr1 != null)
{
while (sdr1.Read())
{
this.roomnum.Items.Add(new ListItem(sdr1["meRoomName"].ToString()));
}
}
}
this.FlexGridDecoctingMonitoring.InitConfig(
new string[] {
"title=包装机监控信息", //标题
"striped=true", //是否显示行交替色
"selectedonclick=true", //是否点击行自动选中checkbox
"usepager=false", //使用分页器
"showcheckbox=false", //显示复选框
"height=300", //高度，可为auto或具体px值
"width=600" //宽度，可为auto或具体px值
},
// 序号、委托单号、医院编号、医院名称、处方号、煎药方式、姓名、性别、年龄、电话、地址、科室、病区号、
//病房号、病床号、诊断结果、剂数、服用方式、次数、包装量、服用方法、煎药方案、一煎时间、二煎时间、
//浸泡加水量、浸泡时间、标签数量、备注信息、医生、医生脚注、取药时间、取药序号、下单时间、当前状态、
//操作时间、操作人员、配送公司、配送地址、联系电话、快件类型
new dotNetFlexGrid.FieldConfig[] {
new dotNetFlexGrid.FieldConfig("id", "序号", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("unitnum", "包装机组编号", 90, true, dotNetFlexGrid.FieldConfigAlign.Center),
new dotNetFlexGrid.FieldConfig("machinename", "包装机编号", 60, 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.FlexGridDecoctingMonitoring.DataHandler = new dotNetFlexGrid.DataHandlerDelegate(DotNetFlexGrid1DataHandler);
} //提供数据的方法
