public IQueryable<Item> ItemGetByClass(IQueryable<Item> items, ClassM classm)
{
return from cly in yikuData.T_Classify
where items.Contains(cly.Item) && cly.CID == classm.CID
orderby cly.IID
select cly.Item;
}
public ClassM ClassCreate(string className, int classFatherID)
{
ClassM classm = new ClassM();
classm.Name = className;
classm.FatherID = classFatherID;
yikuData.ClassMs.AddObject(classm);
return classm;
}
public ClassM ClassCreateAsRoot(string className)
{
ClassM classm = new ClassM();
classm.Name = className;
classm.FatherID = null;
yikuData.ClassMs.AddObject(classm);
return classm;
}
public T_Classify AddClassify(Item item, ClassM classm)
{
T_Classify tcl = GetT_Classify(item, classm);
if (tcl == null) tcl = new T_Classify();
else return tcl;
tcl.CID = classm.CID;
tcl.IID = item.IID;
Add(tcl);
return tcl;
}
public ActionResult Classes(FormCollection value)
{
ViewData["ErrorMessage"] = "";
if(!string.IsNullOrEmpty(Request.Form["cName"]) ){
ClassM classm = new ClassM();
classm.Name = Request.Form["cName"];
if(!string.IsNullOrEmpty(Request.Form["cFatherID"]) ){
try { classm.FatherID = Convert.ToInt32(Request.Form["cFatherID"]); }
catch { }
}
yikuData.Add(classm);
yikuData.Save();
}
int eID = -1;
try{ eID = Convert.ToInt32(Request.Form["eID"]);}
catch{; }
if(eID > 0){
ClassM classm = yikuData.GetClass(eID);
if (classm != null)
{
if (!string.IsNullOrEmpty(Request.Form["eName"]))
classm.Name = Request.Form["eName"];
if (!string.IsNullOrEmpty(Request.Form["eFatherID"]))
{
try { classm.FatherID = Convert.ToInt32(Request.Form["eFatherID"]); }
catch { }
}
yikuData.Save();
}
}
return View(yikuData.GetClasses());
}
/// <summary>
/// 用于向 ClassMs EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToClassMs(ClassM classM)
{
base.AddObject("ClassMs", classM);
}
public IQueryable<Item> ItemGetByClass(ClassM classm)
{
return ItemGetByClass(yikuData.Items, classm);
}
public IQueryable<Item> GetItems(ClassM classm)
{
return from tcl in yikuData.T_Classify
where tcl.CID == classm.CID
select tcl.Item;
}
public IQueryable<T_Classify> GetT_Classifys(ClassM classm)
{
return from tcl in yikuData.T_Classify
where tcl.CID == classm.CID
select tcl;
}
public T_Classify GetT_Classify(Item item, ClassM classm)
{
return yikuData.T_Classify.SingleOrDefault(tcl => tcl.IID == item.IID && tcl.CID == classm.CID);
}
public void DeleteClassify(Item item, ClassM classm)
{
T_Classify tcl = GetT_Classify(item, classm);
if (tcl != null)
Delete(tcl);
}
/// <summary>
/// 创建新的 ClassM 对象。
/// </summary>
/// <param name="cID">CID 属性的初始值。</param>
/// <param name="name">Name 属性的初始值。</param>
public static ClassM CreateClassM(global::System.Int32 cID, global::System.String name)
{
ClassM classM = new ClassM();
classM.CID = cID;
classM.Name = name;
return classM;
}
public IQueryable<ClassM> sonClasses(ClassM classm)
{
return yikuData.ClassGetSons(classm);
}
public bool ClassRoot(ClassM classm)
{
if (classm.FatherID == null || classm.FatherID == 1) return true;
return false;
}
public IQueryable<ClassM> ClassGetSons(ClassM classm)
{
return from c in yikuData.ClassMs
where c.FatherID == classm.CID
select c;
}
public ClassM ClassGetFather(ClassM classm)
{
return yikuData.ClassMs.SingleOrDefault(cl => cl.CID == classm.FatherID);
}
public bool ClassExist(ClassM classm)
{
ClassM c = yikuData.ClassMs.SingleOrDefault(cl => cl == classm);
if (c != null) return true;
return false;
}