/// <summary>
/// 新建分类
/// </summary>
/// <param name="type">分类名</param>
/// <param name="father">分类名</param>
/// <param name="userId">用户</param>
/// <param name="db"></param>
/// <returns></returns>
public bool insertResType(string type, string father, string userId, JSZX_ResourceEntities db)
{
try
{
T_Res_Type rt = new T_Res_Type();
rt.ID = Guid.NewGuid().ToString();
if (father != "-1")
{
rt.BELONG_ID = father;
}
rt.NAME = type;
rt.CREATEID = userId;
rt.CREATETIME = DateTime.Now;
db.T_Res_Type.Add(rt);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "insertResType", ex.Message);
return(false);
}
}
public Boolean AddType(T_Res_Type newType, JSZX_ResourceEntities db)
{
try
{
db.T_Res_Type.Add(newType);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog(clsName, "AddType", ex.Message);
return(false);
}
}
/// <summary>
/// 根据id获取分类
/// </summary>
/// <param name="id">分类id</param>
/// <param name="db"></param>
/// <returns></returns>
public T_Res_Type GetTypeById(string id, JSZX_ResourceEntities db)
{
T_Res_Type type = new T_Res_Type();
var query = from t in db.T_Res_Type where t.ID == id select t;
List <T_Res_Type> typeList = query.ToList();
if (typeList != null)
{
type = typeList[0];
}
return(type);
}
private void DelTypeList(string id, JSZX_ResourceEntities db)
{
T_Res_Type model = db.T_Res_Type.FirstOrDefault(m => m.ID == id);
if (model != null)
{
List <T_Res_Type> list = new List <T_Res_Type>();
var query = from t in db.T_Res_Type where t.BELONG_ID == id select t;
list = query.ToList();
foreach (T_Res_Type type in list)
{
DelTypeList(type.ID, db);
}
db.T_Res_Type.Remove(model);
}
}
