/// <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());
}
