/// <summary>
/// 根据值取下 一级所有的数据
/// </summary>
/// <param name="ValueName"></param>
/// <returns></returns>
public List <Sys_Dictionary> GetSonbyParentId(string ParentId)
{
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.ParentId.Equal(ParentId));
List <Sys_Dictionary> listAll = GetOwnList <Sys_Dictionary>(sql);
return(listAll);
}
public string GetSonDictionary(string ValueName)
{
HttpReSultMode resultMode = new HttpReSultMode();
try
{
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.ValueName.StartWith(ValueName));
List <Sys_Dictionary> listAll = OPBiz.GetOwnList <Sys_Dictionary>(sql);
if (listAll != null && listAll.Count > 0)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(listAll, true);
}
else
{
resultMode.Code = 0;
resultMode.Msg = "没有数据";
resultMode.Data = "[]";
}
}
catch (Exception ex)
{
resultMode.Code = -11;
resultMode.Data = ex.ToString();
}
string result = JsonHelper.ToJson(resultMode, true);
return(result);
}
public string GetJson()
{
var sql = Sys_DictionarySet.SelectAll();
List <Sys_Dictionary> listAll = DDBiz.GetOwnList <Sys_Dictionary>(sql);
string jsonstring = DDBiz.GetTree(listAll);
return(jsonstring);
}
public JsonResult GetInfo(string DicId)
{
var mql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicId.Equal(DicId));
Sys_Dictionary Rmodel = DDBiz.GetEntity(mql);
// groupsBiz.Add(rol);
return(Json(Rmodel, JsonRequestBehavior.AllowGet));
}
public string GetJson(string DicType)
{
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicTypeId.Equal(DicType).And(Sys_DictionarySet.isDeleted.Equal(0)));
List <Sys_Dictionary> listAll = OPBiz.GetOwnList <Sys_Dictionary>(sql);
string jsonstring = OPBiz.GetTree(listAll);
return(jsonstring);
}
public string GetSonDictionary(string DicNo)
{
string jsonstring = "[]";
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicNo.StartWith(DicNo).And(Sys_DictionarySet.isDeleted.Equal(0)).And(Sys_DictionarySet.isValid.Equal(1)));
List <Sys_Dictionary> listAll = OPBiz.GetOwnList <Sys_Dictionary>(sql);
jsonstring = OPBiz.GetCombotree(listAll);
return(jsonstring);
}
public string GetSonDictionary(string ValueName)
{
string jsonstring = "[]";
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.ValueName.StartWith(ValueName));
List <Sys_Dictionary> listAll = OPBiz.GetOwnList <Sys_Dictionary>(sql);
jsonstring = OPBiz.GetCombotree(listAll);
return(jsonstring);
}
public string GetDictionaryByDicType(string DicTypeId)
{
string jsonstring = "[]";
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicTypeId.Equal(DicTypeId).And(Sys_DictionarySet.isDeleted.Equal(0)).And(Sys_DictionarySet.isValid.Equal(1)));;
List <Sys_Dictionary> listAll = OPBiz.GetOwnList <Sys_Dictionary>(sql);
if (listAll != null && listAll.Count > 0)
{
jsonstring = OPBiz.GetCombotree(listAll);
}
return(jsonstring);
}
/// <summary>
/// 根据值 取所有的子集数据
/// </summary>
/// <param name="ValueName"></param>
/// <returns></returns>
public List <Sys_Dictionary> GetAllSonbyValueName(string DicNo)
{
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicNo.StartWith(DicNo));
List <Sys_Dictionary> listAll = GetOwnList <Sys_Dictionary>(sql);
if (listAll != null && listAll.Count > 0)
{
for (int i = 0; i < listAll.Count; i++)
{
if (listAll[i].DicNo.Equals(DicNo))//去除父级
{
listAll.Remove(listAll[i]);
break;
}
}
}
return(listAll);
}
public string GetSonDictionaryNo(string DicNo)
{
string jsonstring = "[]";
var sql = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicNo.StartWith(DicNo));
List <Sys_Dictionary> listAll = OPBiz.GetOwnList <Sys_Dictionary>(sql);
if (listAll != null && listAll.Count > 0)
{
for (int i = 0; i < listAll.Count; i++)
{
if (listAll[i].DicNo.Equals(DicNo))//去除父级
{
listAll.Remove(listAll[i]);
break;
}
}
jsonstring = OPBiz.GetCombotree(listAll);
}
return(jsonstring);
}
public JsonResult EditInfo(Sys_Dictionary EidModle)
{
HttpReSultMode ReSultMode = new HttpReSultMode();
var mql2 = Sys_DictionarySet.SelectAll().Where(Sys_DictionarySet.DicNo.Equal(EidModle.DicNo));
Sys_Dictionary Rmodel = OPBiz.GetEntity(mql2);
if (Rmodel != null && Rmodel.DicId != EidModle.DicId)
{
ReSultMode.Code = -13;
ReSultMode.Data = "";
ReSultMode.Msg = "已经存在相同的编号";
return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
}
bool IsAdd = false;
if (EidModle.ParentId == EidModle.DicId)//父级不能等于自已
{
EidModle.ParentId = 0;
}
if (EidModle.DicId == 0) //id为空，是添加
{
IsAdd = true;
EidModle.CreateTime = DateTime.Now;
EidModle.isValid = true;
EidModle.isDeleted = false;
}
if (IsAdd)
{
try
{
OPBiz.Add(EidModle);
ReSultMode.Code = 11;
ReSultMode.Data = EidModle.DicId.ToString();
ReSultMode.Msg = "添加成功";
}
catch (Exception e) {
ReSultMode.Code = -11;
ReSultMode.Data = e.ToString();
ReSultMode.Msg = "添加失败";
}
}
else
{
EidModle.WhereExpression = Sys_DictionarySet.DicId.Equal(EidModle.DicId);
string idfilec = "DicId";
EidModle.ChangedMap.Remove(idfilec.ToLower());//移除主键值
if (OPBiz.Update(EidModle) > 0)
{
ReSultMode.Code = 11;
ReSultMode.Data = "";
ReSultMode.Msg = "修改成功";
}
else
{
ReSultMode.Code = -13;
ReSultMode.Data = "";
ReSultMode.Msg = "修改失败";
}
}
return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
}
