/// <summary>
/// 删除用户城市对应关系
/// danny-20150522
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DeleteAccountCityRelation(AccountCityRelation model)
{
string sql = @" DELETE FROM [AccountCityRelation] WHERE AccountId=@AccountId;";
var parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@AccountId", model.AccountId);
return(ParseHelper.ToInt(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm)) > 0);
}
/// <summary>
/// 添加用户城市对应关系
/// danny-20150522
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddAccountCityRelation(AccountCityRelation model)
{
string sql = @"
INSERT INTO [AccountCityRelation]
([AccountId]
,[CityId]
,[CreateBy]
,[UpdateBy])
VALUES
(@AccountId
,@CityId
,@CreateBy
,@UpdateBy);";
var parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@AccountId", model.AccountId);
parm.AddWithValue("@CityId", model.CityId);
parm.AddWithValue("@CreateBy", model.CreateBy);
parm.AddWithValue("@UpdateBy", model.UpdateBy);
return(ParseHelper.ToInt(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm)) > 0);
}
/// <summary>
/// 添加用户
/// danny-20150323
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public DealResultInfo AddAccount(AccountCriteria criteria)
{
var dealResultInfo = new DealResultInfo
{
DealFlag = false
};
var accountModel = new account
{
Id = criteria.Id,
UserName = criteria.UserName,
LoginName = criteria.LoginName,
Password = string.IsNullOrWhiteSpace(criteria.Password)?"":MD5Helper.MD5(criteria.Password),
GroupId = criteria.GroupId,
Status = criteria.Status,
AccountType = criteria.AccountType
};
var isHave = authoritySetDao.CheckHasAccountName(accountModel);
if (criteria.OptionType == "0")//添加用户
{
if (isHave)
{
dealResultInfo.DealMsg = "用户名已存在!";
return(dealResultInfo);
}
}
else//修改用户信息
{
if (!isHave)
{
dealResultInfo.DealMsg = "此用户不存在!";
return(dealResultInfo);
}
}
using (var tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS())
{
var accountCityRelation = new AccountCityRelation
{
AccountId = criteria.Id,
CreateBy = criteria.OptUserName,
UpdateBy = criteria.OptUserName,
};
if (criteria.OptionType == "0")//添加用户
{
accountCityRelation.AccountId = authoritySetDao.AddAccount(accountModel);
if (accountCityRelation.AccountId == 0)
{
dealResultInfo.DealMsg = "插入用户信息失败!";
return(dealResultInfo);
}
}
else//修改用户信息
{
if (!authoritySetDao.ModifyAccount(accountModel))
{
dealResultInfo.DealMsg = "修改用户信息失败!";
return(dealResultInfo);
}
}
if (!string.IsNullOrWhiteSpace(criteria.CityCodeList))
{
var cityCodeList = criteria.CityCodeList.Split(',');
authoritySetDao.DeleteAccountCityRelation(accountCityRelation);
foreach (var cityCode in cityCodeList)
{
accountCityRelation.CityId = ParseHelper.ToInt(cityCode);
if (!authoritySetDao.AddAccountCityRelation(accountCityRelation))
{
dealResultInfo.DealMsg = "插入用户和城市关联信息失败!";
return(dealResultInfo);
}
}
}
tran.Complete();
}
dealResultInfo.DealMsg = "用户信息提交成功！";
dealResultInfo.DealFlag = true;
return(dealResultInfo);
}
