public virtual bool Exists(KeyValuePair <string, object> parameter, object id) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id))); }
/// <summary> /// 是否合法的用户 /// 若有用户的Id,这个可以走索引,效率会很高,若没有Id会是全表扫描了。 /// </summary> /// <param name="userId">用户主键</param> /// <param name="openId">Key</param> /// <param name="systemCode">独立子系统</param> /// <returns>合法</returns> public bool ValidateOpenId(string userId, string openId, string systemCode = null) { bool result = false; if (string.IsNullOrEmpty(systemCode)) { systemCode = string.Empty; } // 这个是独立业务系统 if (systemCode.Equals("PDA")) { this.CurrentTableName = "PDAUserLogOn"; } List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); if (!string.IsNullOrWhiteSpace(userId)) { parameters.Add(new KeyValuePair <string, object>(BaseUserLogOnEntity.FieldId, userId)); } parameters.Add(new KeyValuePair <string, object>(BaseUserLogOnEntity.FieldOpenId, openId)); result = DbLogic.Exists(DbHelper, this.CurrentTableName, parameters); return(result); }
public virtual bool Exists(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, KeyValuePair <string, object> parameter) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter1); parameters.Add(parameter2); return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, parameter)); }
public virtual bool Exists(params KeyValuePair <string, object>[] parameters) { List <KeyValuePair <string, object> > parametersList = new List <KeyValuePair <string, object> >(); for (int i = 0; i < parameters.Length; i++) { parametersList.Add(parameters[i]); } return(DbLogic.Exists(DbHelper, this.CurrentTableName, parametersList)); }
public virtual bool Exists(List <KeyValuePair <string, object> > parameters, object id = null) { bool result = false; if (id != null) { result = DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id)); } else { result = DbLogic.Exists(DbHelper, this.CurrentTableName, parameters); } return(result); }
/// <summary> /// 用户添加之前执行的方法 /// </summary> /// <param name="entity">用户实体</param> public void BeforeAdd(BaseUserEntity entity) { // 检测成功,可以添加用户 this.StatusCode = Status.OKAdd.ToString(); if (!string.IsNullOrEmpty(entity.UserName) && this.Exists(new KeyValuePair <string, object>(BaseUserEntity.FieldUserName, entity.UserName) , new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0))) { // 用户名已重复 this.StatusCode = Status.ErrorNameExist.ToString(); } else { // 检查编号是否重复 if (!string.IsNullOrEmpty(entity.Code) && this.Exists(new KeyValuePair <string, object>(BaseUserEntity.FieldCode, entity.Code) , new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0))) { // 编号已重复 this.StatusCode = Status.ErrorCodeExist.ToString(); } if (entity.IsStaff == 1) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldUserName, entity.UserName)); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldDeletionStateCode, 0)); if (DbLogic.Exists(DbHelper, BaseStaffEntity.TableName, parameters)) { // 编号已重复 this.StatusCode = Status.ErrorNameExist.ToString(); } if (!string.IsNullOrEmpty(entity.Code)) { parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldCode, entity.Code)); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldDeletionStateCode, 0)); if (DbLogic.Exists(DbHelper, BaseStaffEntity.TableName, parameters)) { // 编号已重复 this.StatusCode = Status.ErrorCodeExist.ToString(); } } } } }
/// <summary> /// 判断用户是否有有相应的权限 /// </summary> /// <param name="userId">用户主键</param> /// <param name="permissionItemCode">权限编号</param> /// <returns>有权限</returns> public bool CheckPermission(string userId, string permissionItemCode) { BasePermissionItemManager permissionItemManager = new BasePermissionItemManager(DbHelper); string permissionItemId = permissionItemManager.GetIdByCode(permissionItemCode); // 没有找到相应的权限 if (String.IsNullOrEmpty(permissionItemId)) { return(false); } List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceCategory, BaseUserEntity.TableName)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceId, userId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldEnabled, "1")); return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters)); }
/// <summary> /// 创建数据表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">表名</param> /// <param name="statusCode">状态返回码</param> /// <param name="statusMessage">状态返回信息</param> public void CreateTable(BaseUserInfo userInfo, string tableName, out string statusCode, out string statusMessage) { string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessBusinessDb(userInfo, parameter, (dbHelper) => { if (!DbLogic.Exists(dbHelper, tableName)) { var manager = new BaseItemsManager(dbHelper, userInfo); // 创建表结构 manager.CreateTable(tableName, out returnCode); returnMessage = manager.GetStateMessage(returnCode); } }); statusCode = returnCode; statusMessage = returnMessage; }
/// <summary> /// 创建数据表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">表名</param> /// <param name="statusCode">状态返回码</param> /// <param name="statusMessage">状态返回信息</param> public void CreateTable(BaseUserInfo userInfo, string tableName, out string statusCode, out string statusMessage) { string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { // 20130602 JiRiGaLa 改进是否表存在 if (!DbLogic.Exists(dbHelper, tableName)) { BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo); // 创建表结构 itemsManager.CreateTable(tableName, out returnCode); returnMessage = itemsManager.GetStateMessage(returnCode); } }); statusCode = returnCode; statusMessage = returnMessage; }
public virtual bool Exists(List <KeyValuePair <string, object> > parameters, object id = null) { return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id))); }