/// <summary> /// 分类字典列表 /// </summary> public void SearchData(string id = "0") { var search = base.GetSearch(); try { if (!string.IsNullOrEmpty(id)) { search.AddCondition("ParentId='" + id + "'"); } if (!CurrentMaster.IsMain) { if (CurrentMaster.LookPower == (int)LookPowerEnum.查看自建) { search.AddCondition("CreaterId='" + CurrentMaster.Id + "'"); } } LogInsert(OperationTypeEnum.访问, "分类字典模块", "访问页面成功."); } catch (Exception ex) { LogInsert(OperationTypeEnum.异常, "分类字典模块", "查询列表错误消息:" + ex.Message.ToString()); } var jsonResult = new BllSysDirc().SearchData(search); WriteJsonToPage(jsonResult); }
public void SaveData(ModSysDirc t) { BllSysDirc bll = new BllSysDirc(); ModJsonResult json = new ModJsonResult(); if (!string.IsNullOrEmpty(Request["modify"])) //修改 { var model = bll.LoadData(t.Id); model.Name = t.Name; model.OrderNum = t.OrderNum; //判断名称是否存在 int count = 0; bool flag = bll.Exists("Sys_Group", " and CompanyId='" + t.CompanyId + "' and Name='" + t.Name + "' and Type=" + t.Type + " and Id<>'" + t.Id + "' and Status!=" + (int)StatusEnum.除, out count); if (flag) { json.success = false; json.msg = " 保存失败,该名称已经存在!"; } else { int result = bll.Update(model); if (result <= 0) { json.success = false; json.msg = "修改失败,请稍后再操作!"; } } } else { //判断名称是否存在 int count = 0; bool flag = bll.Exists("Sys_Dirc", " and Name='" + t.Name + "' and Type=" + t.Type + " and Status!=" + (int)StatusEnum.除, out count); if (flag) { json.success = false; json.msg = " 保存失败,该名称已经存在!"; } else { t.Id = Guid.NewGuid().ToString(); t.Status = (int)StatusEnum.正常; t.CreaterId = CurrentMaster.Id; t.CreateTime = DateTime.Now; t.CompanyId = CurrentMaster.Cid; t.ParentId = "0"; t.Type = int.Parse(Request["Type"]); int result = bll.Insert(t); if (result <= 0) { json.success = false; json.msg = " 保存失败,请稍后再操作!"; } } } WriteJsonToPage(json.ToString()); }
/// <summary> /// 删除 /// </summary> public void DeleteData(string id) { var msg = new ModJsonResult(); try { var SysDir = new BllSysDirc(); //判断字典类型是否被引用 var model = SysDir.LoadData(id); int count = 0; var flag = false; if (model != null) { switch (model.Type) { case 0: //仓库类别 flag = new BllContractInOut().Exists("H_OrderIn", " and StoreId='" + id + "' and Status!=" + (int)StatusEnum.除, out count); if (flag == false) { flag = new BllContractInOut().Exists("H_Purchase", " and StoreId='" + id + "' and Status!=" + (int)StatusEnum.除, out count); } break; case 1: //供应商类别 flag = new BllContractInOut().Exists("Sys_Company", " and Type='" + id + "' and Status!=" + (int)StatusEnum.除, out count); break; } } if (count > 0) { msg.success = false; msg.msg = "该字典项已被引用,不能直接进行删除。"; } else { int result = new BllSysDirc().DeleteStatus(id); if (result > 0) { msg.success = true; } else { msg.success = false; msg.msg = "删除失败."; } LogInsert(OperationTypeEnum.访问, "字典类型删除操作", "删除操作成功."); } } catch (Exception ex) { LogInsert(OperationTypeEnum.异常, "字典类型删除操作", "删除操作异常消息:" + ex.Message.ToString()); } WriteJsonToPage(msg.ToString()); }
public void GetTree() { string where = ""; string name = (Request["MasterName"] == null ? "" : Request["MasterName"]); //查询过滤条件 if (name != "") { where += " Name like '%" + name + "%'"; } string CompanyId = string.IsNullOrEmpty(Request["CompanyId"]) ? CurrentMaster.Cid : Request["CompanyId"]; DataTable mytab = new BllSysDirc().GetTreeList(where).Tables[0]; //获取所有树 GetTreeNode(mytab, CompanyId); Output = Output.Replace("check", "checked"); WriteJsonToPage(Output); }
public void GetTree() { string where = " Status=" + (int)StatusEnum.正常; string name = (Request["Name"] == null ? "" : Request["Name"]); //查询过滤条件 if (name != "") { where += "and Name like '%" + name + "%'"; } string CompanyId = string.IsNullOrEmpty(Request["CompanyId"]) ? CurrentMaster.Cid : Request["CompanyId"]; DataTable mytab = new BllSysDirc().GetTreeList(where).Tables[0]; //获取所有树 List <JsonFunTree> r = new List <JsonFunTree>(); getTree(r, mytab.Select("parentId='0'"), mytab); WriteJsonToPage(new JavaScriptSerializer().Serialize(r)); }
public void GetSysDicByType(int Type) { List <ModSysDirc> jsonlist = new BllSysDirc().QueryToAll().Where(p => p.Type == Type && p.Status == (int)StatusEnum.正常).ToList(); List <JsonFunTree> list = new List <JsonFunTree>(); for (int i = 0; i < jsonlist.Count; i++) { JsonFunTree model = new JsonFunTree(); model.id = jsonlist[i].Id; model.parentId = "0"; model.text = jsonlist[i].Name; model.Depth = 0; model.expanded = false; model.leaf = true; model.leaf = true; list.Add(model); } WriteJsonToPage(JsonHelper.ToJson(list)); }
public void SearchProvinceByTree() { string name = (Request["name"] == null ? "" : Request["name"]); //查询过滤条件 string where = "Status=" + (int)StatusEnum.正常 + " and Type=" + Request["Type"]; if (!string.IsNullOrEmpty(name.Trim())) { where += "(Name like '%" + name.Trim() + "%')"; } DataTable mytab = new BllSysDirc().GetTreeList(where).Tables[0]; //获取所有树 List <jsonSysBusinessCircle> list = new List <jsonSysBusinessCircle>(); if (mytab != null) { for (int b = 0; b < mytab.Rows.Count; b++) { jsonSysBusinessCircle model = new jsonSysBusinessCircle(); model.id = mytab.Rows[b]["id"].ToString(); model.text = mytab.Rows[b]["text"].ToString(); model.Code = ""; model.expanded = true; model.leaf = true; model.children = null; list.Add(model); } } list.Insert(0, new jsonSysBusinessCircle() { id = "0", text = "查询全部", expanded = true, leaf = true, children = null, }); WriteJsonToPage(new JavaScriptSerializer().Serialize(list)); }
/// <summary> /// 查询父节点 /// </summary> public void GetTreeNode(DataTable dt, string CompanyId) { List <Hashtable> hashList = new List <Hashtable>(); //获取当前单位选择的类别信息 DataSet ds = new BllSysDirc().GetList("Sys_Dirc", " and Id in(select ParentId from Sys_Group where CompanyId='" + CompanyId + "')", "*", 0); foreach (DataRow myrow in dt.Rows) { Hashtable ht = new Hashtable(); ht.Add("id", myrow["id"].ToString()); ht.Add("text", myrow["text"].ToString()); ht.Add("expanded", true); ht.Add("leaf", true); bool Has = false; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow[] dRow = ds.Tables[0].Select("Id='" + myrow["id"].ToString() + "'"); if (dRow.Count() > 0) { Has = true; break; } } if (Has == true) { ht.Add("check", true); } else { ht.Add("check", false); } hashList.Add(ht); } Output = new JavaScriptSerializer().Serialize(hashList); }
public void GetTree(string childId) { string output = ""; string _where = "1=1"; childId = (childId == "-1" ? "0" : childId); //获取 try { _where += " and Status=" + (int)StatusEnum.正常; DataSet ds = new BllSysDirc().GetTreeList(_where); output = JsonHelper.ToJson(new FunTreeCommon().GetCategoryNodes(ds)); } catch { var json = new ModJsonResult(); json.success = false; json.errorCode = (int)SystemError.正常错误; json.msg = "菜单树异常,无法进行操作"; output = JsonHelper.ToJson(json); } Response.Write(output); Response.End(); }
/// <summary> /// 删除 /// </summary> public void DeleteData(string id) { var msg = new ModJsonResult(); try { int result = new BllSysDirc().DeleteStatus(id); if (result > 0) { msg.success = true; } else { msg.success = false; msg.msg = "删除失败."; } LogInsert(OperationTypeEnum.访问, "字典设备类型删除操作", "删除操作成功."); } catch (Exception ex) { LogInsert(OperationTypeEnum.异常, "字典设备类型删除操作", "删除操作异常消息:" + ex.Message.ToString()); } WriteJsonToPage(msg.ToString()); }