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