public ActionResult Create(Model.SubtMedicineDetail model)
{
bool result = false;
//model.ID = 1;
HTNResp.BLL.Program bllProgram = new BLL.Program();
HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
if (!String.IsNullOrEmpty(model.Name))
{
HTNResp.BLL.SubtMedicineDetail bll = new HTNResp.BLL.SubtMedicineDetail();
HTNResp.BLL.PermissionTable per = new BLL.PermissionTable();
var state = bll.Add(model);
if (state != 0)
{
result = true;
}
}
if (result)
{
return(this.Json(new { result = 1, data = "" }));
}
else
{
return(this.Json(new { result = 0, msg = "新建失败" }));
}
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
string strSql = "Status=1";
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
StringBuilder sb = new StringBuilder("", 100);
if (!string.IsNullOrEmpty(Request.Params["DecisionRule"])) //返回值是空，非空执行
{
strSql += " and DecisionRule like'%" + Request.Params["DecisionRule"] + "%'";
}
if (!string.IsNullOrEmpty(Request.Params["Name"]))
{
strSql += " and Name like'%" + Request.Params["Name"] + "%'";
}
if (!string.IsNullOrEmpty(Request.Params["Sex"]))
{
strSql += " and Sex ='" + Request.Params["Sex"] + "'";
}
if (!string.IsNullOrEmpty(Request.Params["starDescriptiont"]))
{
strSql += " and Description like'%" + Request.Params["stDescriptionart"] + "%'";
}
if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
{
strSql += " and EvalGuidId='" + Request.Params["EvalGuidId"] + "'";
}
sb.Append(strSql);
List <HTNResp.Model.DiagnoseList> list = bll.DataTableToList(bll.GetListByPage(strSql, "", start + 1, start + length).Tables[0]);
int total = bll.GetRecordCount("Status=1");
int totalFilter = bll.GetRecordCount(strSql);
BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = totalFilter,
data = list.Select(o => new
{
ID = o.ID,
DecisionRule = o.DecisionRule,
Name = o.Name,
Sex = o.Sex,
Description = o.Description,
EvalGuidId = o.EvalGuidId,
EvalGuid = bllEvalGuid.GetModel(o.EvalGuidId.Value).GuidName,
})
}
}));
}
public override ActionResult Index()
{
BLL.EvalGuid blLEvalGrid = new BLL.EvalGuid();
List <Model.EvalGuid> evalGridId = blLEvalGrid.GetModelList("");
ViewBag.EvalGridId = evalGridId;
return(View());
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
// todo: 读取数据库 获取分页数据
string strSql = " Status=1 ";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(Request.Params["DecisionRule"]))
{
sb.Append(" and DecisionRule like '%" + Request.Params["DecisionRule"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Contents"]))
{
sb.Append(" and Contents like '%" + Request.Params["Contents"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["SymptomName"]))
{
sb.Append(" and SymptomName like '%" + Request.Params["SymptomName"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
{
sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");
}
strSql += sb.ToString();
List <HTNResp.Model.SpecialPatientProcess> list = bll.DataTableToList(bll.GetListByPage(strSql, "", start + 1, start + length).Tables[0]);
int total = bll.GetRecordCount("");
int totalFilter = bll.GetRecordCount(strSql);
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = totalFilter,
data = list.Select(o => new
{
ID = o.ID,
DecisionRule = o.DecisionRule,
SymptomName = o.SymptomName,
Contents = o.Contents,
EvalGuidId = o.EvalGuidId,
EvalGuid = bllEvalGrid.GetModel(o.EvalGuidId.Value).GuidName,
})
}
}));
}
//获取方案分页
public override ActionResult ProjectDetail()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
string sqlString = "";
string level = Request.Params["level"];
string category = Request.Params["category"];
string search = Request.Params["search"];
sqlString += String.IsNullOrEmpty(level) ? "1 = 1" : ("BPLevel='" + level + "'");
sqlString += " AND ";
sqlString += String.IsNullOrEmpty(category) ? "1 = 1" : ("ProjectCode=" + category + "");
sqlString += " AND ";
sqlString += String.IsNullOrEmpty(search) ? "1 = 1" : ("ProjectContent Like ('%" + search + "%')");
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
List <HTNResp.Model.MedicineProject> list = bllMedicine.DataTableToList(bllMedicine.GetListByPage(sqlString, " ", start + 1, start + length).Tables[0]);
int filterTotal = bllMedicine.GetRecordCount(sqlString);
int total = bllMedicine.GetRecordCount("");
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
List <Model.EvalGuid> evalGridList = bllEvalGrid.GetModelList("");
Dictionary <int, string> evalDic = new Dictionary <int, string>();
foreach (Model.EvalGuid evalGrid in evalGridList)
{
evalDic.Add(evalGrid.ID, evalGrid.GuidName);
}
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = filterTotal,
data = list.Select(o => new
{
ID = o.ID,
BPLevel = o.BPLevel,
ProjectContent = o.ProjectContent,
ProjectCode = "类型" + o.ProjectCode,
EvalGuidId = evalDic[o.EvalGuidId.Value]
})
}
}));
}
public ActionResult Create(Model.UserTable model, string authIdsa)
{
bool result = false;
//model.ID = 1;
HTNResp.BLL.Program bllProgram = new BLL.Program();
HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
if (!String.IsNullOrEmpty(model.UserName) && !String.IsNullOrEmpty(model.UserCode) && !String.IsNullOrEmpty(model.Password))
{
HTNResp.BLL.UserTable bll = new HTNResp.BLL.UserTable();
HTNResp.BLL.PermissionTable per = new BLL.PermissionTable();
var state = bll.Add(model);
var list = authIdsa.Split(',');
if (state != 0)
{
if (string.IsNullOrEmpty(authIdsa))
{
list = new List <string>().ToArray();
}
foreach (var item in list)
{
if (per.Add(new Model.PermissionTable()
{
TableID = int.Parse(item),
UserID = state
}) != 0)
{
continue;
}
else
{
result = false;
break;
}
}
result = true;
}
}
if (result)
{
return(this.Json(new { result = 1, data = "" }));
}
else
{
return(this.Json(new { result = 0, msg = "新建失败" }));
}
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
string strSql = " 1=1 ";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(Request.Params["ProjectName"]))
{
sb.Append(" and ProjectName like '%" + Request.Params["ProjectName"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["ProjectCode"]))
{
sb.Append(" and ProjectCode like '%" + Request.Params["ProjectCode"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["ProjectType"]))
{
sb.Append(" and ProjectType like '%" + Request.Params["ProjectType"] + "%' ");
}
strSql += sb.ToString();
List <HTNResp.Model.ProjectDictionary> list = bll.DataTableToList(bll.GetListByPage(strSql, " ", start + 1, start + length).Tables[0]);
int total = bll.GetRecordCount(""); //总页数
int totalFilter = bll.GetRecordCount(strSql); //查到的页数
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
// 返回JSON结果，JSON统一格式为 { result = 1, data = new { } } 或 { result = 0, msg = "" }
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = totalFilter,
data = list
}
}));
}
public ActionResult Update(Model.PrevensionProject model)
{
bool result = false;
HTNResp.BLL.Program bllProgram = new BLL.Program();
HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
if (!String.IsNullOrEmpty(model.DecisionRule) && String.IsNullOrEmpty(bllProgram.testContent(model.DecisionRule)) && model.EvalGuidId.Value != null && bllEvalGuid.Exists(model.EvalGuidId.Value))
{
result = bll.Update(model);
}
if (result)
{
return(this.Json(new { result = 1, data = "" }));
}
else
{
return(this.Json(new { result = 0, msg = "修改失败" }));
}
}
public ActionResult Update(Model.AccessTable model)
{
bool result = false;
HTNResp.BLL.Program bllProgram = new BLL.Program();
HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
if (!String.IsNullOrEmpty(model.TableName) && String.IsNullOrEmpty(bllProgram.testContent(model.TableAdress)) && String.IsNullOrEmpty(bllProgram.testContent(model.TableName)))
{
result = bll.Update(model);
}
if (result)
{
return(this.Json(new { result = 1, data = "" }));
}
else
{
return(this.Json(new { result = 0, msg = "修改失败" }));
}
}
public ActionResult Create(Model.NonMedicineCure model)
{
bool result = false;
model.Status = 1;
HTNResp.BLL.Program bllProgram = new BLL.Program();
HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
if (!String.IsNullOrEmpty(model.DecisionRule) && String.IsNullOrEmpty(bllProgram.testContent(model.DecisionRule)) && model.EvalGuidId.Value != null && bllEvalGuid.Exists(model.EvalGuidId.Value))
{
if (bll.Add(model) != 0)
{
result = true;
}
}
if (result)
{
return(this.Json(new { result = 1, data = "" }));
}
else
{
return(this.Json(new { result = 0, msg = "新建失败" }));
}
}
public ActionResult Create(Model.AccessTable model)
{
bool result = false;
//model.ID = 1;
HTNResp.BLL.Program bllProgram = new BLL.Program();
HTNResp.BLL.EvalGuid bllEvalGuid = new BLL.EvalGuid();
if (!String.IsNullOrEmpty(model.TableName) && String.IsNullOrEmpty(bllProgram.testContent(model.TableName)) && model.TableAdress != null)
{
if (bll.Add(model) != 0)
{
result = true;
}
}
if (result)
{
return(this.Json(new { result = 1, data = "" }));
}
else
{
return(this.Json(new { result = 0, msg = "新建失败" }));
}
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
// todo: 读取数据库 获取分页数据
string strSql = " Status=1 ";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(Request.Params["ProjectName"]))
{
sb.Append(" and ProjectName like '%" + Request.Params["ProjectName"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["DangerousGroup"]))
{
sb.Append(" and DangerousGroup='" + Request.Params["DangerousGroup"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["DecisionRule"]))
{
sb.Append(" and DecisionRule like '%" + Request.Params["DecisionRule"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["AdaptScope"]))
{
sb.Append(" and AdaptScope like '%" + Request.Params["AdaptScope"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Measure"]))
{
sb.Append(" and Measure like '%" + Request.Params["Measure"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Aim"]))
{
sb.Append(" and Aim like '%" + Request.Params["Aim"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
{
sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");
}
strSql += sb.ToString();
List <HTNResp.Model.PrevensionProject> list = bll.DataTableToList(bll.GetListByPage(strSql, "", start + 1, start + length).Tables[0]);
int total = bll.GetRecordCount("Status=1");
int totalFilter = bll.GetRecordCount(strSql);
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
// 返回JSON结果
// JSON统一格式为 { result = 1, data = new { } } 或 { result = 0, msg = "" }
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = totalFilter,
data = list.Select(o => new
{
ID = o.ID,
ProjectName = o.ProjectName,
DangerousGroup = o.DangerousGroup,
DecisionRule = o.DecisionRule,
AdaptScope = o.AdaptScope,
Measure = o.Measure,
Aim = o.Aim,
EvalGuidId = o.EvalGuidId,
EvalGuid = bllEvalGrid.GetModel(o.EvalGuidId.Value).GuidName,
})
}
}));
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
string strSql = " 1=1 ";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
//strSql = "GroupName'" + GroupName + "' and GroupNameDetail'" + GroupNameDetail + "'";
if (!string.IsNullOrEmpty(Request.Params["GroupName"]))
{
sb.Append(" and GroupName='" + Request.Params["GroupName"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["GroupNameDetail"]))
{
sb.Append(" and GroupNameDetail='" + Request.Params["GroupNameDetail"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["Symptom"]))
{
sb.Append(" and Symptom like '%" + Request.Params["Symptom"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["SymptomType"]))
{
sb.Append(" and SymptomType='" + Request.Params["SymptomType"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
{
sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");
}
strSql += sb.ToString();
List <HTNResp.Model.AdaptMedicineUse> list = bll.DataTableToList(bll.GetListByPage(strSql, " ", start + 1, start + length).Tables[0]);
int total = bll.GetRecordCount(""); //总页数
int totalFilter = bll.GetRecordCount(strSql); //查到的页数
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
// 返回JSON结果，JSON统一格式为 { result = 1, data = new { } } 或 { result = 0, msg = "" }
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = totalFilter,
data = list.Select(o => new
{
ID = o.ID,
GroupName = o.GroupName,
GroupNameDetail = o.GroupNameDetail,
Symptom = o.Symptom,
SymptomType = o.SymptomType,
EvalGuidId = o.EvalGuidId,
EvalGuid = bllEvalGrid.GetModel(o.EvalGuidId.Value).GuidName,
})
}
}));
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
// todo: 读取数据库 获取分页数据
string strSql = " Status=1 ";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(Request.Params["DecisionRule"]))
{
sb.Append(" and DecisionRule like '%" + Request.Params["DecisionRule"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Contents"]))
{
sb.Append(" and Contents like '%" + Request.Params["Contents"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Sex"]))
{
sb.Append(" and Sex='" + Request.Params["Sex"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["Sort"]))
{
sb.Append(" and Sort='" + Request.Params["Sort"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["Separator"]))
{
sb.Append(" and Separator='" + Request.Params["Separator"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["TypeName"]))
{
sb.Append(" and TypeName='" + Request.Params["TypeName"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["Remark"]))
{
sb.Append(" and Remark like '%" + Request.Params["Remark"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
{
sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");
}
strSql += sb.ToString();
List <HTNResp.Model.EvaluationContent> list = bll.DataTableToList(bll.GetListByPage(strSql, "Sort", start + 1, start + length).Tables[0]);
int total = bll.GetRecordCount("Status=1");
int totalFilter = bll.GetRecordCount(strSql);
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
// 返回JSON结果
// JSON统一格式为 { result = 1, data = new { } } 或 { result = 0, msg = "" }
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = totalFilter,
data = list.Select(o => new
{
ID = o.ID,
DecisionRule = o.DecisionRule,
Contents = o.Contents,
Sex = o.Sex,
Sort = o.Sort,
Separator = o.Separator,
TypeName = o.TypeName,
Remark = o.Remark,
EvalGuidId = o.EvalGuidId,
EvalGuid = bllEvalGrid.GetModel(o.EvalGuidId.Value).GuidName,
})
}
}));
}
public override ActionResult AjaxList()
{
int start = 0; // 分页起始条目数
int length = 0; // 分页每页分页数
start = Convert.ToInt32(Request.Params["start"]);
length = Convert.ToInt32(Request.Params["length"]);
// todo: 读取数据库 获取分页数据
string strSql = "Status=1";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(Request.Params["DecisionRule"]))
{
sb.Append(" and DecisionRule like '%" + Request.Params["DecisionRule"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Contents"]))
{
sb.Append(" and Contents like '%" + Request.Params["Contents"] + "%' ");
}
if (!string.IsNullOrEmpty(Request.Params["Sex"]))
{
sb.Append(" and Sex='" + Request.Params["Sex"] + "' ");
}
if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
{
sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");
}
strSql += sb.ToString();
List <HTNResp.Model.AdaptSymptom> list = bll.DataTableToList(bll.GetListByPage(strSql, "", start + 1, start + length).Tables[0]);
int filterTotal = bll.GetRecordCount(strSql);
int total = bll.GetRecordCount("Status=1");
BLL.EvalGuid bllEvalGrid = new BLL.EvalGuid();
List <Model.EvalGuid> evalGridList = bllEvalGrid.GetModelList("");
Dictionary <int, string> evalDic = new Dictionary <int, string>();
foreach (Model.EvalGuid evalGrid in evalGridList)
{
evalDic.Add(evalGrid.ID, evalGrid.GuidName);
}
return(this.Json(new
{
result = 1,
data = new
{
draw = Request.Params["draw"],
recordsTotal = total,
recordsFiltered = filterTotal,
data = list.Select(o => new
{
ID = o.ID,
DecisionRule = o.DecisionRule,
Contents = o.Contents,
EvalGuidId = evalDic[o.EvalGuidId.Value]
})
}
}));
}
