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;
}
