public JResult GetUserInfo(BaseUserModel model)
{
return _baseservice.GetUserInfo(model);
}
/// <summary>
/// 编辑用户信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateUser(BaseUserModel model)
{
var sql = new StringBuilder("update `sys_user` set ");
sql.Append(Helper.CreateField(model).Trim().TrimEnd(','));
sql.Append(" where innerid = @innerid");
int result;
try
{
result = Helper.Execute(sql.ToString(), model);
}
catch (Exception ex)
{
result = 0;
}
return result;
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddUser(BaseUserModel model)
{
const string sql = @"INSERT INTO `sys_user`
(`innerid`,`no`, `username`, `loginname`, `password`, `mobile`, `telephone`, `email`, `status`, `createdtime`, `modifiedtime`,depid,`level`)
VALUES
(@innerid,@no, @username, @loginname, @password, @mobile, @telephone, @email, @status, now(), now(),@depid,@level);";
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
//生成编号
var obj = new
{
p_tablename = "sys_user",
p_columnname = "no",
p_prefix = "S",
p_length = 4,
p_hasdate = 0
};
var args = new DynamicParameters(obj);
args.Add("p_value", dbType: DbType.String, direction: ParameterDirection.Output);
args.Add("p_errmessage", dbType: DbType.String, direction: ParameterDirection.Output);
using (conn.QueryMultiple("sp_automaticnumbering", args, commandType: CommandType.StoredProcedure)) {}
model.no = args.Get<string>("p_value");
if (string.IsNullOrWhiteSpace(model.no))
{
var msg = args.Get<string>("p_errmessage");
LoggerFactories.CreateLogger().Write("销售编号生成失败：" + msg, TraceEventType.Error);
return -1;
}
conn.Execute(sql, model, tran);
tran.Commit();
return 1;
}
catch (Exception ex)
{
tran.Rollback();
return 0;
}
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable<BaseUserModel> GetUserInfo(BaseUserModel model)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"select * from sys_user where 1=1 ");
var sqlWhere = new StringBuilder();
//用户名
if (!string.IsNullOrWhiteSpace(model.loginname))
{
sqlWhere.AppendFormat(" and loginname ='{0}' ", model.loginname);
}
//部门
if (!string.IsNullOrWhiteSpace(model.depid))
{
sqlWhere.AppendFormat(" and depid ='{0}' ", model.depid);
}
//等级
if (model.level.HasValue)
{
sqlWhere.AppendFormat(" and level ={0} ", model.level);
}
sql.Append(sqlWhere.ToString());
var menuList = Helper.Query<BaseUserModel>(sql.ToString());
return menuList;
}
