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