public override bool Update(Hospital model)
{
int count = 0;
using (var db = new DBEntities())
{
using (db.BeginTransaction())
{
//更新下级
if (string.IsNullOrEmpty(model.ParentID))
{
db.Database.ExecuteSqlCommand("update Hospitals set IsUseWisdom={0}, ChannelID={1} where ParentID={2}", new object[] { model.IsUseWisdom, (object)model.ChannelID ?? DBNull.Value, model.HospitalID });
}
else//获取父级设置
{
var parent = db.Hospitals.Where(q => q.HospitalID == model.ParentID).FirstOrDefault();
if (parent != null)
{
model.IsUseWisdom = parent.IsUseWisdom;
model.ChannelID = parent.ChannelID;
}
}
db.Entry <Hospital>(model).State = System.Data.Entity.EntityState.Modified;
count = db.SaveChanges();
db.Commit();
}
}
return(count > 0);
}
/// <summary>
/// 设置默认成员
/// </summary>
/// <param name="memberID"></param>
/// <param name="userID"></param>
/// <returns></returns>
public bool SetDefaultMember(string memberID, string userID)
{
using (var db = new DBEntities())
{
using (db.BeginTransaction())
{
db.UserMembers.Where(a => a.UserID == userID && a.MemberID != memberID).Update(a => new UserMember()
{
IsDefault = false,
ModifyTime = DateTime.Now,
ModifyUserID = userID
});
db.UserMembers.Where(a => a.UserID == userID && a.MemberID == memberID).Update(a => new UserMember()
{
IsDefault = true,
ModifyTime = DateTime.Now,
ModifyUserID = userID
});
db.Commit();
var userMemberMapCacheKey = new XuHos.Common.Cache.Keys.EntityListCacheKey <UserMember>(XuHos.Common.Cache.Keys.StringCacheKeyType.User_Member, memberID);
userMemberMapCacheKey.RemoveCache();
}
return(true);
}
}
/// <summary>
/// 更新会员信息
/// 日期：2017年4月15日
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public EnumApiStatus UpdateMemberInfo(BLL.User.DTOs.Request.RequestUserMemberDTO request)
{
using (DBEntities db = new DBEntities())
{
using (db.BeginTransaction())
{
var model = db.UserMembers.Where(q => q.UserID == request.MemberID && q.MemberID == request.MemberID && q.IsDeleted == false).FirstOrDefault();
if (model == null)
{
return(EnumApiStatus.BizError);
}
// 当前用户不能有相同身份证的就诊人 add by lrj 2017-7-20
if (!string.IsNullOrEmpty(request.IDNumber))
{
var mid = db.UserMembers.Where(q => q.IDNumber == request.IDNumber && q.MemberID != model.MemberID &&
q.IsDeleted == false).Select(q => q.MemberID).FirstOrDefault();
}
#region 必填参数
model.MemberName = request.MemberName;
// model.Relation = request.Relation;
model.Gender = request.Gender;
model.Marriage = request.Marriage;
model.IDType = request.IDType;
model.MemberName = request.MemberName;
#endregion
#region 可选参数(有值才修改)
if (request.Birthday != null)
{
model.Birthday = request.Birthday;
}
if (request.Mobile != null)
{
model.Mobile = request.Mobile;
}
if (request.IDNumber != null)
{
model.IDNumber = request.IDNumber;
}
if (request.Nationality != null)
{
model.Nationality = request.Nationality;
}
if (request.Province != null)
{
model.Province = request.Province;
}
if (request.ProvinceRegionID != null)
{
model.ProvinceRegionID = request.ProvinceRegionID;
}
if (request.City != null)
{
model.City = request.City;
}
if (request.CityRegionID != null)
{
model.CityRegionID = request.CityRegionID;
}
if (request.District != null)
{
model.District = request.District;
}
if (request.DistrictRegionID != null)
{
model.DistrictRegionID = request.DistrictRegionID;
}
if (request.Town != null)
{
model.Town = request.Town;
}
if (request.TownRegionID != null)
{
model.TownRegionID = request.TownRegionID;
}
if (request.Village != null)
{
model.Village = request.Village;
}
if (request.VillageRegionID != null)
{
model.VillageRegionID = request.VillageRegionID;
}
if (request.Address != null)
{
model.Address = request.Address;
}
if (request.Email != null)
{
model.Email = request.Email;
}
if (request.PostCode != null)
{
model.PostCode = request.PostCode;
}
#endregion
#region 是否已经存在本人关系的就诊人
if (request.Relation == EnumUserRelation.MySelf)
{
var members = GetMemberList(request.UserID);
//本人关系已经存在
if (members.Any(a => a.Relation == EnumUserRelation.MySelf && a.MemberID != model.MemberID))
{
return(EnumApiStatus.BizUserMemberRejectUpdateMySelfExists);
}
}
#endregion
#region 通过身份证号码获取性别和身份证号码
if (model.IDType == EnumUserCardType.IDCard && !string.IsNullOrEmpty(model.IDNumber))
{
string birthday, sex;
var res = ToolHelper.GetBirthdaySexFromIdCard(model.IDNumber, out birthday, out sex);
//身份证号码正确
if (res)
{
model.Birthday = birthday;
model.Gender = sex == "0" ? EnumUserGender.Male : EnumUserGender.Female;
}
else
{
//身份证号码格式错误
return(EnumApiStatus.BizUserMemberRejectInsertUpdateIDNumberFormatError);
}
}
#endregion
model.Relation = request.Relation;
if (request.IsDefault.HasValue && request.IsDefault == true)
{
model.IsDefault = true;
}
else if (request.IsDefault.HasValue && request.IsDefault == false)
{
model.IsDefault = false;
}
if (request.Relation == EnumUserRelation.MySelf)
{
var user = db.Users.Where(a => a.UserID == request.UserID).FirstOrDefault();
user.UserCNName = model.MemberName;
user.UserENName = model.MemberName;
}
if (db.SaveChanges() > 0)
{
db.Commit();
var userMemberCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserMemberDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User_Member, model.MemberID);
userMemberCacheKey.RemoveCache();
var User_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User, request.UserID);
User_CacheKey.RemoveCache();
}
}
//设置默认
if (request.IsDefault.HasValue && request.IsDefault.Value)
{
SetDefaultMember(request.MemberID, request.UserID);
}
return(EnumApiStatus.BizOK);
}
}
/// <summary>
/// 新增成员
/// 日期：2017年4月15日
/// </summary>
/// <param name="userMemberEntity"></param>
/// <returns></returns>
public ApiResult InsertMemberInfo(BLL.User.DTOs.Request.RequestUserMemberDTO request)
{
ApiResult result = new ApiResult();
string memberid = string.Empty;
#region 身份证号码格式校验
if (!string.IsNullOrEmpty(request.IDNumber) && request.IDType == EnumUserCardType.IDCard)
{
string birthday, sex;
var res = ToolHelper.GetBirthdaySexFromIdCard(request.IDNumber, out birthday, out sex);
//身份证号码正确
if (res)
{
request.Birthday = birthday;
request.Gender = sex == "0" ? EnumUserGender.Male : EnumUserGender.Female;
}
else
{
result.Status = EnumApiStatus.BizUserMemberRejectInsertUpdateIDNumberFormatError;
result.Msg = result.Status.GetEnumDescript();
return(result);
}
}
#endregion
using (DBEntities db = new DBEntities())
{
using (db.BeginTransaction())
{
db.Configuration.AutoDetectChangesEnabled = true;
bool isAdd = false;
UserMember userMemberEntity = null;
if (!string.IsNullOrEmpty(request.IDNumber))
{
userMemberEntity = (from q in db.UserMembers
where q.IDNumber == request.IDNumber && q.MemberName == request.MemberName && q.IsDeleted == false
orderby q.ModifyTime descending, q.CreateTime descending, q.MemberID
select q).FirstOrDefault();
}
if (userMemberEntity == null)
{
isAdd = true;
#region 可选参数（默认值）
if (request.Birthday == null)
{
request.Birthday = "";
}
if (request.Mobile == null)
{
request.Mobile = "";
}
if (request.IDNumber == null)
{
request.IDNumber = "";
}
if (request.Nationality == null)
{
request.Nationality = "";
}
if (request.Province == null)
{
request.Province = "";
}
if (request.ProvinceRegionID == null)
{
request.ProvinceRegionID = "";
}
if (request.City == null)
{
request.City = "";
}
if (request.CityRegionID == null)
{
request.CityRegionID = "";
}
if (request.District == null)
{
request.District = "";
}
if (request.DistrictRegionID == null)
{
request.DistrictRegionID = "";
}
if (request.Town == null)
{
request.Town = "";
}
if (request.TownRegionID == null)
{
request.TownRegionID = "";
}
if (request.Village == null)
{
request.Village = "";
}
if (request.VillageRegionID == null)
{
request.VillageRegionID = "";
}
if (request.Address == null)
{
request.Address = "";
}
if (request.Email == null)
{
request.Email = "";
}
if (request.PostCode == null)
{
request.PostCode = "";
}
if (request.IsDefault == null || !request.IsDefault.HasValue)
{
request.IsDefault = false;
}
#endregion
userMemberEntity = request.Map <RequestUserMemberDTO, Entity.UserMember>();
userMemberEntity.MemberID = Guid.NewGuid().ToString("N");
userMemberEntity.CreateTime = DateTime.Now;
userMemberEntity.CreateUserID = request.UserID;
}
//默认成员
var defaultMemberEntity = GetDefaultMemberInfo(request.UserID).Map <ResponseUserMemberDTO, Entity.UserMember>();
memberid = userMemberEntity.MemberID;
//默认成员不存在
if (defaultMemberEntity == null)
{
//当前成员为默认
userMemberEntity.IsDefault = true;
}
if (request.Relation == EnumUserRelation.MySelf)
{
var userEntity = db.Users.Where(a => a.UserID == request.UserID).FirstOrDefault();
userEntity.UserCNName = request.MemberName;
userEntity.UserENName = request.MemberName;
var mySelfMember = (from m in db.UserMembers
where m.UserID == request.UserID && m.Relation == EnumUserRelation.MySelf &&
m.IsDeleted == false && m.IsDeleted == false
select m).FirstOrDefault();
//如果默认成员已经存在则更新默认成员
if (mySelfMember != null)
{
//兼容bat 服务站，新增自己关系是，要是原来的自己关系信息不完整（身份证号为空），则覆盖
//身份证不为空，且操作机构不为网络医院
var webapiConfig = SysConfigService.Get <XuHos.Common.Config.Sections.Api>();
if (string.IsNullOrEmpty(mySelfMember.IDNumber) && request.OrgID != webapiConfig.OrgID)
{
mySelfMember.Gender = request.Gender;
mySelfMember.Marriage = request.Marriage;
mySelfMember.MemberName = request.MemberName;
#region 可选参数(有值才修改)
if (request.Birthday != null)
{
mySelfMember.Birthday = request.Birthday;
}
if (request.Mobile != null)
{
mySelfMember.Mobile = request.Mobile;
}
if (request.IDNumber != null)
{
mySelfMember.IDNumber = request.IDNumber;
}
if (request.Nationality != null)
{
mySelfMember.Nationality = request.Nationality;
}
if (request.Province != null)
{
mySelfMember.Province = request.Province;
}
if (request.ProvinceRegionID != null)
{
mySelfMember.ProvinceRegionID = request.ProvinceRegionID;
}
if (request.City != null)
{
mySelfMember.City = request.City;
}
if (request.CityRegionID != null)
{
mySelfMember.CityRegionID = request.CityRegionID;
}
if (request.District != null)
{
mySelfMember.District = request.District;
}
if (request.DistrictRegionID != null)
{
mySelfMember.DistrictRegionID = request.DistrictRegionID;
}
if (request.Town != null)
{
mySelfMember.Town = request.Town;
}
if (request.TownRegionID != null)
{
mySelfMember.TownRegionID = request.TownRegionID;
}
if (request.Village != null)
{
mySelfMember.Village = request.Village;
}
if (request.VillageRegionID != null)
{
mySelfMember.VillageRegionID = request.VillageRegionID;
}
if (request.Address != null)
{
mySelfMember.Address = request.Address;
}
if (request.Email != null)
{
mySelfMember.Email = request.Email;
}
if (request.PostCode != null)
{
mySelfMember.PostCode = request.PostCode;
}
#endregion
memberid = mySelfMember.MemberID;
db.Update(mySelfMember);
}
else
{
result.Status = EnumApiStatus.BizUserMemberRejectUpdateMySelfExists;
result.Msg = result.Status.GetEnumDescript();
return(result);
}
}
}
if (isAdd)
{
db.UserMembers.Add(userMemberEntity);
}
//db.Update(userEntity);
var count = db.SaveChanges();
db.Commit();
if (count > 0)
{
var userMemberCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserMemberDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User_Member, userMemberEntity.MemberID);
userMemberCacheKey.RemoveCache();
var User_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User, request.UserID);
User_CacheKey.RemoveCache();
result.Status = EnumApiStatus.BizOK;
}
else
{
result.Status = EnumApiStatus.BizError;
}
}
//设置默认
if (request.IsDefault.HasValue && request.IsDefault.Value)
{
SetDefaultMember(memberid, request.UserID);
}
result.Data = memberid;
result.Msg = result.Status.GetEnumDescript();
return(result);
}
}