private void SetDefaultSetting(DbAccess.DbCRMContext db) { //初始化配置 var curUser = QWF.Framework.Web.UserContext.GetCurrentInfo(); var result = QWF.Framework.Web.ResultWebData.Default(); //用户已配置的字段 var qryUser = db.T_QCRM_UserQueryListSetting.AsNoTracking().Where(w => w.UserCode == curUser.CurrentUserCode).Select(s => s.QueryListId).ToList(); //遍历查找不存在数据,并插入默认值 db.T_QCRM_QueryList.AsNoTracking().Where(w => !qryUser.Contains(w.Id)).ToList().ForEach(item => { var dbModel = new DbAccess.T_QCRM_UserQueryListSetting(); dbModel.QueryListId = item.Id; dbModel.StyleWidth = item.StyleWidth; dbModel.SortId = item.SortId; dbModel.IsHide = item.Hide; dbModel.UserCode = curUser.CurrentUserCode; dbModel.CreateTime = DateTime.Now; dbModel.CreateUser = curUser.CurrentUserCode; db.T_QCRM_UserQueryListSetting.Add(dbModel); }); db.SaveChanges(); }
/// <summary> /// 创建新的实例 /// </summary> /// <param name="db"></param> /// <returns></returns> public static FormPagedUtils Create(DbAccess.DbCRMContext db) { return(new FormPagedUtils(db)); }
public FormPagedUtils(DbAccess.DbCRMContext db) { curUser = QWF.Framework.Web.UserContext.GetCurrentInfo(); this.dbCrmContext = db; }