public bool ExistReference(StrObjectDict sod) { var id = sod.GetString("ID"); var nCount = DB.Count <NursingPlanDetails>(new { QuestionID = id }); return(nCount > 0); }
/// <summary> /// 根据删除人员信息 /// </summary> /// <returns></returns> public override ActionResult Delete() { StrObjectDict dict = GetParams(); string id = dict.GetString("ID"); #region 入参正确性校验 if (string.IsNullOrEmpty(id)) { return(this.MyJson(0, "参数为空:ID")); } #endregion int isOk = UserManager.Instance.Delete <PubUser>(id); if (isOk > 0) { return(this.MyJson(1, "保存成功")); } else { return(this.MyJson(0, "操作失败")); } }
/// <summary> /// 获取完整的主菜单和菜单操作 /// </summary> /// <returns>树形结构</returns> public ActionResult ListMenu() { StrObjectDict reqParam = GetParams(); string moduleCode = reqParam.GetString("ModuleCode"); IList <StrObjectDict> result = crudManager.List2 <Role>(new { ModuleCode = moduleCode }.toStrObjDict(), null); Tree tree = new Tree(); tree.datasList = result; tree.TransformTree("SuperID"); result = tree.data; //获取完整菜单 //Tree tree = TreeManager.Instance.GetTree("2ad0e672-aba8-432e-83d4-7a30a999", "SuperID", new { ModuleCode = moduleCode }.toStrObjDict()); ////获取所有菜单操作 //IList<MenuOption> menuOptions = crudManager.List2<MenuOption>(new StrObjectDict()); //foreach (var levelOne in tree.data) //{ // if (levelOne.ContainsKey("Children")) // { // List<StrObjectDict> levelTwos = (List<StrObjectDict>)levelOne.GetObject("Children"); // foreach (var levelTwo in levelTwos) // { // levelTwo.Add("MenuOptions", // from el in menuOptions // where el.MenuID.ToString() == levelTwo.GetString("ID") // select el); // } // } //} return(this.MyJson(1, tree.data)); }
public IList <StrObjectDict> DoService(StrObjectDict obj) { IList <object> list = new List <object>(); list.Add(new { ID = 13, ExtendValue = "13被修改了" }); list.Add(new { ID = 14, ExtendValue = "新增了14" }); list.Add(new { ID = 11, ExtendValue = "11被修改了" }); DB.Execute(new DBState { Name = "BatchExtendExecuteNoneQuery2", Param = list, Type = ESqlType.UPDATE }); return(null); }
public ActionResult Save() { StrObjectDict sod = GetParams(); int isOk = 0; if (sod.GetInt("Type") == 4 && sod.GetInt("IsLocalStorage") == 1 && sod.GetInt("IsRef") == 1) { if (!sod.ContainsKey("Reference") || sod["Reference"] == null) { return(this.MyJson(0, "该方式必须输入列对照")); } //使用数据源服务方式,需要保存列对照 isOk = DataServiceManager.Instance.SaveThirdServiceSqlType(sod); } else { sod["IsLocalStorage"] = 0; sod["IsRef"] = 0; sod["RefObject"] = null; isOk = DataServiceManager.Instance.InsertOrUpdate <DataService>(sod); } if (isOk > 0) { return(this.MyJson(1, "保存成功")); } return(this.MyJson(0, "操作失败")); }
public bool SaveBacklogDetails(StrObjectDict sod) { var backlogIds = sod.GetObject("BacklogIds") as object[]; if (backlogIds == null) { return(false); } var batchStates = backlogIds.Select(id => { var dic = id as Dictionary <string, object>; if (dic == null) { return(null); } return(new DBState() { Name = "INSERT_BacklogDetails", Param = new { ID = Utils.getGUID(), FormID = sod.GetString("FormID"), ObjectID = sod.GetString("ObjectID"), BacklogID = dic["eventId"], TargetID = dic["id"], Hander = sod.GetString("Hander") }.toStrObjDict(), Type = ESqlType.INSERT }); }).ToList(); return(batchStates.Count != 0 && DB.Execute(batchStates) > 0); }
/// <summary> /// 插入或者更新表 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dict"></param> /// <returns></returns> public virtual int InsertOrUpdate <T>(StrObjectDict dict) where T : BaseModel, new() { DBState state = null; T t = System.Activator.CreateInstance <T>(); if (!dict.ContainsKey("ID") || dict["ID"] == null) { dict["ID"] = Utils.getGUID(); state = new DBState { Name = t.MAP_INSERT, Param = dict, Type = ESqlType.INSERT }; } else { state = new DBState { Name = t.MAP_UPDATE, Param = dict, Type = ESqlType.UPDATE }; } return(DB.Execute(state)); }
public ActionResult GetEvaluateFile() { StrObjectDict dict = GetParams(); string patientID = dict.GetString("PatientID"); string type = dict.GetString("Type"); string departmentID = dict.GetString("DepartmentID"); if (string.IsNullOrEmpty(patientID)) { return(this.MyJson(0, "参数不能为空:PatientID")); } if (string.IsNullOrEmpty(type)) { return(this.MyJson(0, "参数不能为空:Type")); } if (string.IsNullOrEmpty(departmentID)) { return(this.MyJson(0, "参数不能为空:DepartmentID")); } IList <StrObjectDict> list = NursingAssessmentManager.Instance.GetEvaluateFile(dict); return(this.MyJson(1, list)); }
public ActionResult Client_GetForm() { StrObjectDict dict = GetParams(); dict["FormID"] = dict["ID"]; IList <StrObjectDict> result = FormManager.Instance.CheckVerCode(dict); try { if (string.IsNullOrEmpty(result[0]["VersionCode"].ToString())) { return(this.MyJson(0, "接口错误:请求最新版本号失败")); } } catch { return(this.MyJson(0, "接口错误:请求最新版本号失败")); } string versionCode = result[0]["VersionCode"].ToString(); string id = dict.GetString("ID"); IList <StrObjectDict> dicts = FormManager.Instance.Hns_GetForm(new { VersionCode = versionCode, FormID = id }.toStrObjDict(false)); dicts.Last().Add("Last", 1); return(this.MyJson(1, dicts)); }
/// <summary> /// 分页 /// </summary> /// <param name="obj"></param> /// <param name="p"></param> /// <returns></returns> public PageData <StrObjectDict> PagesCommCodeDetail(StrObjectDict obj, Page p) { object listcount = DB.Scalar("COUNT_CommonCodeDetail", obj); IList <StrObjectDict> listData = DB.ListSod("LISTSOD_CommonCodeDetail", obj, p.PageNumber, p.PageSize); return(new PageData <StrObjectDict>(listData, p.PageNumber, int.Parse(listcount.ToString()))); }
public static IThirdService CreateSoaService(string id, StrObjectDict obj) { string type = obj["Type"].ToString(); //1:ws,2:socket,3:存储过程.4:sql数据源 if (type == "1") { return(CreateProxy <SOAWS>(id, obj)); } else if (type == "2") { return(CreateProxy <SOASocket>(id, obj)); } else if (type == "3") { return(CreateProxy <SOAProc>(id, obj)); } else if (type == "4") { return(null); //return CreateProxy<SOASql>(id, obj); } else { return(null); } }
public ActionResult DeleteMsg() { StrObjectDict dict = GetParams(); #region 检查入参有效性 string id = dict.GetString("ID"); if (string.IsNullOrEmpty(id)) { return(this.MyJson(0, "参数错误:ID")); } #endregion //删除 int isOk = MsgManager.Instance.Delete <MessageLog>(id); if (isOk > 0) { return(this.MyJson(1, "删除成功")); } else { return(this.MyJson(0, "操作失败")); } }
public bool TargetDelete(StrObjectDict obj) { var id = obj.GetString("ID"); var batchStates = new DBState[] { new DBState() { Name = new NursingPlanTarget().MAP_DELETE, Param = new{ ID = id }, Type = ESqlType.DELETE }, new DBState() { Name = new NursingPlanDetails().MAP_DELETE, Param = new{ PlanTargetID = id }, Type = ESqlType.DELETE }, new DBState() { Name = new QuestionRelation().MAP_DELETE, Param = new{ FunID = id }, Type = ESqlType.DELETE } }; return(DB.ExecuteWithTransaction(batchStates) > 0); }
public bool ExistsFourElement(StrObjectDict sod) { var questionIds = sod.GetString("QuestionIds").Split(','); var lst = DB.ListSod("GetElementCount", new { QuestionIds = questionIds }.toStrObjDict()); //结果集包含4种元素,结果集长度最小为4 if (lst == null || lst.Count < 4) { return(false); } var grouping = lst.GroupBy(a => a.GetString("ID")); //通过ID分组后,如果与入参个数不一致,表示有护理问题下面没有包含元素 if (questionIds.Length != grouping.Count()) { return(false); } foreach (var item in grouping) { var cGrouping = item.GroupBy(a => a.GetString("Code")); if (cGrouping.Count() != 4) { return(false); } } return(true); }
public List <StrObjectDict> GetBacklogs(StrObjectDict sod) { //PatientID var lstByDetails = DB.ListSod("GetBacklogsByDetails", sod); var marks = DB.ListSod("GetTriggerResult", sod); var backlogIds = new List <string>(); foreach (var str in marks.Select(mark => mark.GetString("BacklogIds"))) { if (str.Contains(',')) { var ids = str.Split(','); backlogIds.AddRange(ids); } else { backlogIds.Add(str); } } var lstByMark = DB.ListSod("", sod); return(null); }
public ActionResult SetMobileStyle() { StrObjectDict dict = GetParams(); string MobileStyle = dict.GetString("MobileStyle"); string VersionCode = dict.GetString("VersionCode"); string Id = dict.GetString("ID"); if (string.IsNullOrEmpty(MobileStyle)) { return(this.MyJson(0, "参数不能为空:MobileStyle")); } if (string.IsNullOrEmpty(VersionCode)) { return(this.MyJson(0, "参数不能为空:VersionCode")); } if (string.IsNullOrEmpty(Id)) { return(this.MyJson(0, "参数不能为空:ID")); } int result = FormManager.Instance.SetMobileStyle(dict); if (result > 0) { return(this.MyJson(1, "设置成功")); } else { return(this.MyJson(0, "设置失败")); } }
/// <summary> /// 逻辑删除待办事项 /// </summary> /// <param name="sod"></param> /// <returns></returns> public bool RemoveBacklog(StrObjectDict sod) { var id = sod.GetString("ID"); //var batchStates = new DBState[] //{ // new DBState(){ // Name = "DELETE_Backlog", // Param = new {ID =id}, // Type = ESqlType.DELETE // }, // new DBState(){ // Name = "DELETE_BacklogDetails", // Param = new {BacklogID =id}, // Type = ESqlType.DELETE // } //}; //return DB.ExecuteWithTransaction(batchStates) > 0; return(DB.Execute(new DBState { Name = "UPDATE_Backlog", Param = sod, Type = ESqlType.UPDATE }) > 0); }
/// <summary> /// 列表信息(分页) /// </summary> /// <returns></returns> public virtual ActionResult Page() { //获取参数 StrObjectDict reqParam = GetParams(); StrObjectDict reqPage = GetPageInfo(); //获取实体类 Type t = this.getType(); if (t == null) { return(this.MyJson(0, this.NULL_MODEL_ERROR)); } //分页 Page page = new Page(); int pageNum = 0; int pageSize = 0; if (int.TryParse(reqPage.GetString("PageNum"), out pageNum) && int.TryParse(reqPage.GetString("PageSize"), out pageSize)) { page.PageNumber = pageNum; page.PageSize = pageSize; if (page.PageSize > 0 && page.PageNumber > 0) { object[] args = new object[] { reqParam, page }; var result = crudManager.GetType().GetMethod("List", new Type[] { typeof(IDictionary <string, object>), typeof(Page) }).MakeGenericMethod(t).Invoke(crudManager, args); return(this.MyJson(1, result.GetType().GetProperty("DataList").GetValue(result, null), result.GetType().GetProperty("PageInfo").GetValue(result, null))); } } return(this.MyJson(0, "参数错误!")); }
public IList <StrObjectDict> DoService(StrObjectDict obj) { if (OtherProperties != null) { object isAsync = OtherProperties["IsAsync"]; if ("1".Equals(isAsync.ToString())) { //异步访问 } else { //同步访问 string serverUrl = OtherProperties["ServiceUrl"].ToString(); string inputTemplate = OtherProperties["InputTemplate"].ToString(); string outputTemplate = OtherProperties["OutputTemplate"].ToString(); //通过入参对象生成实际入参内容 //加载模板 Template template = Template.Parse(inputTemplate); //用模板内容做为参数解析得到Template对象 string result = template.Render(Hash.FromDictionary(obj)); //用模板所需的元素做为参数呈现处理后的结果 } return(null); } else { return(null); } }
public ActionResult Analysis() { StrObjectDict dict = GetParams(); string sql = dict.GetString("SQL"); string datasource = dict.GetString("DataSource"); if (string.IsNullOrEmpty(sql)) { return(this.MyJson(0, "参数不能为空:SQL")); } sql = sql.ToUpper(); //string Table = sql.Substring(sql.LastIndexOf("FROM") + 4); //Table = Table.Trim(); if (sql.Contains("SELECT") && !sql.Contains("UPDATE") && !sql.Contains("INSERT") && !sql.Contains("DELETE") && !sql.Contains("DROP")) { IList <string> list = new List <string>(); try { list = ReportFormManager.Instance.SqlAnalysis(datasource, sql); } catch (Exception msg) { return(this.MyJson(0, msg.Message)); } return(this.MyJson(1, list)); } else { return(this.MyJson(0, "仅限执行SELECT语句")); } }
public PageData <StrObjectDict> ListSod(StrObjectDict obj, Page p) { object listcount = DB.Scalar("", obj); IList <StrObjectDict> listData = DB.ListSod("", obj, p.PageNumber, p.PageSize); return(new PageData <StrObjectDict>(listData, p.PageNumber, int.Parse(listcount.ToString()))); }
public ActionResult SourcesSave() { StrObjectDict dict = GetParams(); string Name = dict.GetString("Name"); if (string.IsNullOrEmpty(Name)) { return(this.MyJson(0, "参数不能为空:Name")); } if (dict.ContainsKey("ID")) { dict["UpdateUser"] = LoginSession.Current.NAME; dict["ModifyTime"] = DateTime.Now; } string result = ReportFormManager.Instance.SourcesInsertOrUpdate(dict); if (result != "Error") { StrObjectDict succeed = new StrObjectDict(); succeed["ID"] = result; return(this.MyJson(1, succeed)); } else { return(this.MyJson(0, "保存失败")); } }
/// <summary> /// 请求报表文件(分页) /// </summary> /// <param name="obj"></param> /// <param name="p"></param> /// <returns></returns> public PageData <StrObjectDict> FilePage(StrObjectDict obj, Page p) { object listcount = DB.Scalar("COUNT_ReportFormFile", obj); IList <StrObjectDict> listData = DB.ListSod("Info_ReportFormFile", obj, p.PageNumber, p.PageSize); return(new PageData <StrObjectDict>(listData, p.PageNumber, int.Parse(listcount.ToString()))); }
public ActionResult SqlExcute() { StrObjectDict dict = GetParams(); string sql = dict.GetString("SQL"); string datasource = dict.GetString("DataSource"); if (string.IsNullOrEmpty(sql)) { return(this.MyJson(0, "参数不能为空:SQL")); } var check = sql.ToUpper(); if (check.Contains("SELECT") && !check.Contains("UPDATE") && !check.Contains("INSERT") && !check.Contains("DELETE") && !check.Contains("DROP")) { IList <StrObjectDict> list = new List <StrObjectDict>(); try { list = ReportFormManager.Instance.SqlExcute(datasource, sql); } catch { return(this.MyJson(0, "查询失败")); } return(this.MyJson(1, list)); } else { return(this.MyJson(0, "仅限执行SELECT语句")); } }
/// <summary> /// 分页 /// </summary> /// <param name="obj"></param> /// <param name="p"></param> /// <returns></returns> public PageData <Function> Pages(StrObjectDict obj, Page p) { object listcount = DB.Scalar("COUNT_Function", obj); IList <Function> listData = DB.List <Function>(obj, p.PageNumber, p.PageSize); return(new PageData <Function>(listData, p.PageNumber, int.Parse(listcount.ToString()))); }
public ActionResult SetFormState() { StrObjectDict dict = GetParams(); string isInvalid = dict.GetString("IsInvalid"); string state; DateTime invalidTime = DateTime.Now; if (!string.IsNullOrEmpty(isInvalid)) { state = "0"; } else { state = "1"; } IList <StrObjectDict> dicts = NursingFormManager.Instance.Hns_SetFormState(new { State = state, IsInvalid = isInvalid, InvalidTime = invalidTime }.toStrObjDict(false)); return(this.MyJson(1, dicts)); }
/// <summary> /// 获取用户列表(分页) /// </summary> public override ActionResult Page() { StrObjectDict reqParam = GetParams(); StrObjectDict reqPage = GetPageInfo();; //分页 Page page = new Page(); int pageNum = 0; int pageSize = 0; if (int.TryParse(reqPage.GetString("PageNum"), out pageNum) && int.TryParse(reqPage.GetString("PageSize"), out pageSize)) { page.PageNumber = pageNum; page.PageSize = pageSize; if (page.PageSize > 0 && page.PageNumber > 0) { PageData <StrObjectDict> pd = UserManager.Instance.ListSod(reqParam, page); return(this.MyJson(1, pd)); } } return(this.MyJson(0, "参数不正确")); }
public bool CreateEvaluat(StrObjectDict sod, string user) { sod["Evaluator"] = user; sod["EvaluatTime"] = DateTime.Now; sod["IsInvalid"] = 0; return(this.InsertOrUpdate <NursingEvaluat>(sod) > 0); }
public ActionResult DelPower() { StrObjectDict dict = GetParams(); string roleID = dict.GetString("RoleGroupID"); #region 参数有效性检查 if (string.IsNullOrEmpty(roleID)) { return(this.MyJson(0, "参数错误:RoleGroupID")); } #endregion var delete = RoleManager.Instance.DeletePowers(dict); if (delete > 0) { return(this.MyJson(1, "删除成功.")); } else { return(this.MyJson(0, "删除失败.")); } }
//public ActionResult NameValue() //{ // StrObjectDict sod = GetParams(); // IList<StrObjectDict> list = DataSourceManager.Instance.NameValue<DataSource>(sod); // return this.MyJson(1, list); //} public override ActionResult Index() { StrObjectDict sod = GetParams(); IList <DataSource> list = DataSourceManager.Instance.List <DataSource>(sod); return(this.MyJson(1, list)); }