public dotNetFlexGrid.DataHandlerResult FlexGridFlexGridDrugDataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
DrugModel dm = new DrugModel();
string pid = "";
if (p.extParam.ContainsKey("pid"))
{
pid = p.extParam["pid"];
}
result.table = dm.findDrugByPspnum(pid);
return(result);
}
public dotNetFlexGrid.DataHandlerResult FlexGridFlexGridDrugDataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
DrugModel dm = new DrugModel();
string pspnum = "0";
string hospitalId = "";
// if (p.extParam.ContainsKey("drugpspnum"))
// {
// pspnum = p.extParam["drugpspnum"];
// }
// if (p.extParam.ContainsKey("hospitalId"))
// {
// hospitalId = p.extParam["hospitalId"];
// }
string pid = "";
if (p.extParam.ContainsKey("pid"))
{
pid = p.extParam["pid"];
}
// result.table = dm.findDrugByPspnum(pspnum, hospitalId);
result.table = dm.findDrugByPspnum(pid);
dotNetFlexGrid.FieldFormatorHandle proc1 = delegate(DataRow dr)
{
string drugname1 = "";
string drugname2 = "";
RecipeModel rm = new RecipeModel();
DataTable dt = rm.findspecialdrug2();
string z = "<span style='color:black'>" + dr["Drugname"].ToString() + "</span>";
for (int i = 0; i < dt.Rows.Count; i++)
{
drugname1 = dt.Rows[i][2].ToString();
drugname2 = dt.Rows[i][3].ToString();
SqlDataReader sdr = rm.finddrugnamebypid(pid, drugname1);
SqlDataReader sdr2 = rm.finddrugnamebypid(pid, drugname2);
if (sdr.Read() && sdr2.Read())
{
// z = "<span style='color:red'>"+dr["Drugname"].ToString()+"</span>";
if (dr["Drugname"].ToString() == drugname1 || dr["Drugname"].ToString() == drugname2)
{
z = "<span style='color:red'>" + dr["Drugname"].ToString() + "</span>";
}
break;
}
else
{
z = "<span style='color:black'>" + dr["Drugname"].ToString() + "</span>";
}
}
return(z);
};
result.FieldFormator.Register("Drugname", proc1);
dotNetFlexGrid.FieldFormatorHandle proc5 = delegate(DataRow dr)
{
string z = "";
string drugname = dr["Drugname"].ToString();
RecipeModel rm = new RecipeModel();
SqlDataReader sdr = rm.findspecialdrug(drugname);
if (sdr.Read())
{
if (sdr["type"].ToString() == "先煎药")
{
z = "<span style='color:red'>先煎</span>";
}
if (sdr["type"].ToString() == "后下")
{
z = "<span style='color:red'>后下</span>";
}
if (sdr["type"].ToString() == "另煎药")
{
z = "<span style='color:red'>另煎药</span>";
}
if (sdr["type"].ToString() == "冲服")
{
z = "<span style='color:red'>冲服</span>";
}
if (sdr["type"].ToString() == "烊化药")
{
z = "<span style='color:red'>烊化药</span>";
}
if (sdr["type"].ToString() == "禁用药")
{
z = "<span style='color:red'>（妊娠禁忌）禁用药</span>";
}
if (sdr["type"].ToString() == "慎用药")
{
z = "<span style='color:red'>（妊娠禁忌）慎用药</span>";
}
}
else
{
z = "<span style='color:black'>" + dr["DrugDescription"].ToString() + "</span>";
}
//dt.Rows[0]["hospitalid"].ToString();
// string z = "";
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// string specialdrugname = dt.Rows[i][2].ToString();
// string specialtype = dt.Rows[i][1].ToString();
// if (drugname == specialdrugname)
// {
// if (specialtype == "十八反" || specialtype == "十九畏" || specialtype == "禁用药" || specialtype == "慎用药")
// {
// z = "<span style='color:red'>" + drugname + "</span>";
// break;
// }
// if (specialtype == "先煎药" || specialtype == "后下" || specialtype == "另煎药" || specialtype == "冲服" || specialtype == "烊化药")
// {
// z = "<span style='color:red'>" + drugname + "</span>";
// break;
// }
// }
// else
// {
// }
// }
// z = "<span style='color:black'>" + drugname + "</span>";
return(z);
};
result.FieldFormator.Register("DrugDescription", proc5);
// result.table = dotNetFlexGrid.DemoMemoryTable(p.page * 100, p.rp);//调用演示的数据生成函数产生模拟数据
//如果传递的参数包含排序设置的话 ，通过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);
}
//表2方法
public dotNetFlexGrid.DataHandlerResult FlexGridFlexGridDrugDataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
DrugModel dm = new DrugModel();
string pspnum = "0";
string hospitalId = "";
/* if (p.extParam.ContainsKey("drugpspnum"))
* {
* pspnum = p.extParam["drugpspnum"];
* }
* if (p.extParam.ContainsKey("Hospitalid"))
* {
* hospitalId = p.extParam["Hospitalid"];
* }*/
string pid = "";
if (p.extParam.ContainsKey("pid"))
{
pid = p.extParam["pid"];
}
//result.table = dm.findDrugByPspnum(pspnum, hospitalId);
result.table = dm.findDrugByPspnum(pid);
// result.table = dotNetFlexGrid.DemoMemoryTable(p.page * 100, p.rp);//调用演示的数据生成函数产生模拟数据
//如果传递的参数包含排序设置的话，通过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);
}