/// <summary> /// 新增或更新用户角色信息 /// </summary> /// <param name="info"></param> /// <param name="mode"></param> /// <returns></returns> public static bool AddOrUpdateUserRoleInfo(UserRole info, EnumAddOrUpdate mode) { bool ret = false; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IUserRole dp = DataProvider.DbUserRoleDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; ret = dp.AddOrUpdateUserRoleInfo(cmd, info, mode); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("AddOrUpdateUserRoleInfo()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(ret); }
public bool AddOrUpdateUserRoleInfo(IDbCommand icmd, UserRole info, EnumAddOrUpdate mode) { icmd.Parameters.Clear(); MySqlCommand cmd = icmd as MySqlCommand; cmd.CommandType = CommandType.Text; if (mode == EnumAddOrUpdate.Add) { string sql = @"insert into t_user_role(id,uid,rid,updatetime) values('{0}','{1}','{2}','{3}')"; cmd.CommandText = string.Format(sql, info.id, info.uid, info.rid, info.updatetime); } else if (mode == EnumAddOrUpdate.Update) { string sql = @"update t_user_role set uid = '{0}',rid = '{1}',updatetime = '{2}' where id = '{3}'"; cmd.CommandText = string.Format(sql, info.uid, info.rid, info.updatetime, info.id); } cmd.ExecuteNonQuery(); return(true); }
public bool AddOrUpdateRoleInfo(IDbCommand icmd, RoleInfo info, EnumAddOrUpdate mode) { icmd.Parameters.Clear(); MySqlCommand cmd = icmd as MySqlCommand; cmd.CommandType = CommandType.Text; if (mode == EnumAddOrUpdate.Add) { string sql = @"insert into t_role_info(id,name,description,updatetime,status) values('{0}','{1}','{2}','{3}','{4}')"; cmd.CommandText = string.Format(sql, info.id, info.name, info.description, info.updatetime, info.status); } else if (mode == EnumAddOrUpdate.Update) { string sql = @"update t_role_info set name = '{0}',description = '{1}',updatetime = '{2}',status = '{3}' where id = '{4}'"; cmd.CommandText = string.Format(sql, info.name, info.description, info.updatetime, info.status, info.id); } cmd.ExecuteNonQuery(); return(true); }
public bool AddOrUpdateUserLoginInfo(IDbCommand icmd, UserLogin info, EnumAddOrUpdate mode) { icmd.Parameters.Clear(); MySqlCommand cmd = icmd as MySqlCommand; cmd.CommandType = CommandType.Text; if (mode == EnumAddOrUpdate.Add) { string sql = @"insert into t_user_login(id,login_name,password,cellphone,email,last_login_ip,last_login_time,create_user_id,createtime,is_authentication,prop1,prop2,prop3,status) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')"; cmd.CommandText = string.Format(sql, info.id, info.loginName, info.password, info.cellphone, info.email, info.lastLoginIP, info.lastLoginTime, info.createUserId, info.createtime, info.isAuthentication, info.prop1, info.prop2, info.prop3, info.status); } else if (mode == EnumAddOrUpdate.Update) { string sql = @"update t_user_login set login_name = '{0}',password = '******',cellphone = '{2}',email = '{3}',last_login_ip = '{4}',last_login_time = '{5}', create_user_id = '{6}',createtime = '{7}',is_authentication = '{8}',prop1 = '{9}',prop2 = '{10}',prop3 = '{11}',status = '{12}' where id = '{13}'"; cmd.CommandText = string.Format(sql, info.loginName, info.password, info.cellphone, info.email, info.lastLoginIP, info.lastLoginTime, info.createUserId, info.createtime, info.isAuthentication, info.prop1, info.prop2, info.prop3, info.status, info.id); } cmd.ExecuteNonQuery(); return(true); }
public bool AddOrUpdateGroupPermissionInfo(IDbCommand icmd, GroupPermission info, EnumAddOrUpdate mode) { icmd.Parameters.Clear(); MySqlCommand cmd = icmd as MySqlCommand; cmd.CommandType = CommandType.Text; if (mode == EnumAddOrUpdate.Add) { string sql = @"insert into t_group_permission(id,gid,pid,updatetime) values('{0}','{1}','{2}','{3}')"; cmd.CommandText = string.Format(sql, info.id, info.gid, info.pid, info.updatetime); } else if (mode == EnumAddOrUpdate.Update) { string sql = @"update t_group_permission set gid = '{0}',pid = '{1}',updatetime = '{2}' where id = '{3}'"; cmd.CommandText = string.Format(sql, info.gid, info.pid, info.updatetime, info.id); } cmd.ExecuteNonQuery(); return(true); }