private bool DeleteItem() { ResumeInfoDataContext db = new ResumeInfoDataContext(); string cond = ""; foreach (int id in ObjGrid.SelectedRows) { cond += "PKID == " + id + " || "; } cond = cond.Substring(0, cond.Length - 4); var item = db.GetTable((Type)ViewState["enuType"]).Where(cond); db.GetTable((Type)ViewState["enuType"]).DeleteAllOnSubmit(item); db.SubmitChanges(); return(true); }
private IQueryable GetRawQuery() { ResumeInfoDataContext db = new ResumeInfoDataContext(); IQueryable q = db.GetTable((Type)ViewState["enuType"]).OrderBy("DisOrder"); return(q); }
private IQueryable GetRawQuery() { IQueryable <int> Query = null; ResumeInfoDataContext db = new ResumeInfoDataContext(); //sb = WebHelper.SetSqlLog(db); Dictionary <Type, string> querylist = (Dictionary <Type, string>)ViewState["Query"]; foreach (Type tp in querylist.Keys) { if (Query == null) { Query = (IQueryable <int>)db.GetTable(tp).Where(querylist[tp]).Select("auid"); } else { Query = Query.Intersect((IQueryable <int>)db.GetTable(tp).Where(querylist[tp]).Select("auid")); } } var q = from b in db.BaseInfo where b.ModifyTime.HasValue && (!b.zfflag.Value || !b.zfflag.HasValue) select new { b.UserID, b.PName, b.PID, zc = b.enuZc.Label, b.ModifyTime, byyx = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().byyx, xl = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().enuJyjd.Label, zy = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().sxzy, ztLabel = b.enuZt.Label, }; if (Query != null) { q = q.Where(o => Query.Contains(o.UserID)); } return(q); }
private IQueryable GetRawQuery() { IQueryable <int> Query = null; ResumeInfoDataContext db = new ResumeInfoDataContext(); //sb = WebHelper.SetSqlLog(db); Dictionary <Type, string> querylist = (Dictionary <Type, string>)ViewState["Query"]; foreach (Type tp in querylist.Keys) { if (Query == null) { if (tp == typeof(Jiaoybj)) { IQueryable p = from m in db.Jiaoybj group new { m.UserID, m.byyx, m.sxzy, m.jyjd } by m.UserID into g orderby g.FirstOrDefault().jyjd select new { UserID = g.FirstOrDefault().UserID, byyx = g.FirstOrDefault().byyx, sxzy = g.FirstOrDefault().sxzy, jyjd = g.FirstOrDefault().jyjd } ; Query = (IQueryable <int>)p.Where(querylist[tp]).Select("UserID"); } else { Query = (IQueryable <int>)db.GetTable(tp).Where(querylist[tp]).Select("UserID"); } } else { if (tp == typeof(Jiaoybj)) { IQueryable p = from m in db.Jiaoybj group new { m.UserID, m.byyx, m.sxzy, m.jyjd } by m.UserID into g orderby g.FirstOrDefault().jyjd select new { UserID = g.FirstOrDefault().UserID, byyx = g.FirstOrDefault().byyx, sxzy = g.FirstOrDefault().sxzy, jyjd = g.FirstOrDefault().jyjd } ; Query = Query.Intersect((IQueryable <int>)p.Where(querylist[tp]).Select("UserID")); } else { Query = Query.Intersect((IQueryable <int>)db.GetTable(tp).Where(querylist[tp]).Select("UserID")); } } } var q = from b in db.BaseInfo where b.ModifyTime.HasValue && (!b.zfflag.Value || !b.zfflag.HasValue) select new { b.UserID, b.PName, b.PID, b.sj, b.ModifyTime, SexLabel = b.enuSex.Label, byyx = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().byyx, xl = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().enuJyjd.Label, zy = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().sxzy, b.csd, ztLabel = b.enuZt.Label, ypzly = b.enuLaiy.Label, }; if (Query != null) { q = q.Where(o => Query.Contains(o.UserID)); } return(q); }