/// <summary>
/// 更新员工信息
/// </summary>
/// <param name="staff"></param>
/// <returns></returns>
public Tuple <bool, string> UpdateStoreStaff(StoreStaffParam staff)
{
var count = helper.QueryScalar($@"select Count(1) from [User] where Phone='{staff.Phone}' and Id not in ({staff.Id})");
if (Convert.ToInt32(count) > 0)
{
return(Tuple.Create(false, "该手机号已经存在"));
}
var temp = helper.QueryScalar($@"select [Password] from [User] where Id={staff.Id}");
if (temp == null)
{
return(Tuple.Create(false, "异常参数"));
}
string password = temp.ToString();
if (password != staff.Password)
{
password = Util.MD5Encrypt(staff.Password);
}
helper.Execute($@"update StoreDetailInfo set StoreName='{staff.StaffName}' where UserId={staff.Id}");
string sql = $@"update [User] set StaffName='{staff.StaffName}',Phone='{staff.Phone}',Password='******',
StoreManage='{staff.StoreManage}',SongManage='{staff.SongManage}',UserManage='{staff.UserManage}' where Id={staff.Id}";
return(Tuple.Create(helper.Execute(sql) > 0 ? true : false, string.Empty));
}
/// <summary>
/// 添加员工
/// </summary>
/// <param name="token"></param>
/// <param name="staff"></param>
/// <returns></returns>
public Tuple <bool, string> AddStoreStaff(string token, StoreStaffParam staff)
{
var temp = helper.QueryScalar($@"select Count(1) from [User] where Phone='{staff.Phone}'");
if (Convert.ToInt32(temp) > 0)
{
return(Tuple.Create(false, "该手机号已经存在，无法添加"));
}
// 先根据token，Id,再获取，获取 StoreCode，然后再添加Staff
string storeCode = helper.QueryScalar($@"select StoreCode from UserAccessToken a left join [User] b on a.UserId=b.Id where TokenId='{token}'").ToString();
if (string.IsNullOrWhiteSpace(storeCode))
{
return(Tuple.Create(false, "该账号无法添加员工"));
}
// string sql = $@"insert into [User] (StoreCode,StaffName,Phone,Password,StoreManage,SongManage,UserManage,Enable,Status,UserType,IsMain)
//values ('{storeCode}','{staff.StaffName}','{staff.Phone}','{Util.MD5Encrypt(staff.Password)}',
//'{staff.StoreManage}','{staff.SongManage}','{staff.UserManage}',{1},{1},{2},{0})";
//同时向StoreDeatilInfo表添加数据，为了管理员工播放列表
var p = new DynamicParameters();
p.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = helper.Execute($@"insert into [User] (StoreCode,StaffName,Phone,Password,StoreManage,SongManage,UserManage,Enable,Status,UserType,IsMain)
values ('{storeCode}','{staff.StaffName}','{staff.Phone}','{Util.MD5Encrypt(staff.Password)}',
'{staff.StoreManage}','{staff.SongManage}','{staff.UserManage}',{1},{1},{2},{0}); SELECT @Id=SCOPE_IDENTITY()", p);
var id = p.Get <int>("@Id");
string sql = $@"insert into StoreDetailInfo (UserId,StoreName,Enabled,CreateTime)
values ({id},'{staff.StaffName}',{1},'{DateTime.Now}')";
return(Tuple.Create(helper.Execute(sql) > 0 ? true : false, string.Empty));
}
public ResponseResultDto <bool> UpdateStaff(StoreStaffParam storeStaffParam)
{
if (!Util.ValidateMobilePhone(storeStaffParam.Phone))
{
return(new ResponseResultDto <bool>
{
IsSuccess = false,
ErrorMessage = "手机号格式不正确",
Result = false
});
}
var result = storeStaffApiRepository.UpdateStoreStaff(storeStaffParam);
return(new ResponseResultDto <bool>
{
IsSuccess = result.Item1,
ErrorMessage = result.Item2,
Result = result.Item1
});
}
public ResponseResultDto <bool> AddStaff(StoreStaffParam storeStaffParam)
{
if (!Util.ValidateMobilePhone(storeStaffParam.Phone))
{
return(new ResponseResultDto <bool>
{
IsSuccess = false,
ErrorMessage = "手机号格式不正确",
Result = false
});
}
HttpRequest request = HttpContext.Current.Request;
string token = request.Headers.GetValues("Access-Token").FirstOrDefault();
var result = storeStaffApiRepository.AddStoreStaff(token, storeStaffParam);
return(new ResponseResultDto <bool>
{
IsSuccess = result.Item1,
ErrorMessage = result.Item2,
Result = result.Item1
});
}