/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="memberInfo">待更新的实体对象</param> public int UpdateMemberInfo(MemberInfoEntity entity) { string sql = @" UPDATE dbo.[MemberInfo] SET [MemId]=@MemId,[Nickname]=@Nickname,[MemName]=@MemName,[IdentityNo]=@IdentityNo,[IdentityNoCheck]=@IdentityNoCheck,[Sex]=@Sex,[Birthday]=@Birthday,[Telephone]=@Telephone,[MobilePhone]=@MobilePhone,[MobilePhoneCheck]=@MobilePhoneCheck,[Email]=@Email,[EmailCheck]=@EmailCheck,[QQ]=@QQ,[QQCheck]=@QQCheck,[IdentityPre]=@IdentityPre,[IdentityBeh]=@IdentityBeh,[IdentityAutoName]=@IdentityAutoName,[IdentityAutoNo]=@IdentityAutoNo,[HeadPicUrl]=@HeadPicUrl WHERE [Id]=@id"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); db.AddInParameter(cmd, "@MemId", DbType.Int32, entity.MemId); db.AddInParameter(cmd, "@Nickname", DbType.String, entity.Nickname); db.AddInParameter(cmd, "@MemName", DbType.String, entity.MemName); db.AddInParameter(cmd, "@IdentityNo", DbType.String, entity.IdentityNo); db.AddInParameter(cmd, "@IdentityNoCheck", DbType.Int32, entity.IdentityNoCheck); db.AddInParameter(cmd, "@Sex", DbType.Int32, entity.Sex); db.AddInParameter(cmd, "@Birthday", DbType.DateTime, (entity.Birthday == null || entity.Birthday < DateTime.Now.AddYears(-100))?"1901-01-01": entity.Birthday.ToString()); db.AddInParameter(cmd, "@Telephone", DbType.String, entity.Telephone); db.AddInParameter(cmd, "@MobilePhone", DbType.String, entity.MobilePhone); db.AddInParameter(cmd, "@MobilePhoneCheck", DbType.Int32, entity.MobilePhoneCheck); db.AddInParameter(cmd, "@Email", DbType.String, entity.Email); db.AddInParameter(cmd, "@EmailCheck", DbType.Int32, entity.EmailCheck); db.AddInParameter(cmd, "@QQ", DbType.String, entity.QQ); db.AddInParameter(cmd, "@QQCheck", DbType.Int32, entity.QQCheck); db.AddInParameter(cmd, "@IdentityPre", DbType.String, entity.IdentityPre); db.AddInParameter(cmd, "@IdentityBeh", DbType.String, entity.IdentityBeh); db.AddInParameter(cmd, "@IdentityAutoName", DbType.String, entity.IdentityAutoName); db.AddInParameter(cmd, "@IdentityAutoNo", DbType.String, entity.IdentityAutoNo); db.AddInParameter(cmd, "@HeadPicUrl", DbType.String, entity.HeadPicUrl); return(db.ExecuteNonQuery(cmd)); }
/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(MemberInfoEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[MemberInfo] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { where = where + " (MemName=@MemName) "; where = where + " (IdentityAutoName=@IdentityAutoName) "; } else { where = where + " id<>@Id and (MemName=@MemName) "; where = where + " id<>@Id and (IdentityAutoName=@IdentityAutoName) "; } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } db.AddInParameter(cmd, "@MemName", DbType.String, entity.MemName); db.AddInParameter(cmd, "@IdentityAutoName", DbType.String, entity.IdentityAutoName); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
public string GetNickNameByMemId(int memid, bool iscache = false) { string nickname = ""; if (iscache) { string _cachekey = "GetNickNameByMemId" + memid;// SysCacheKey.MemberInfoListKey; object obj = MemCache.GetCache(_cachekey); if (obj == null) { MemberInfoEntity entity = null; entity = MemberInfoDA.Instance.GetMemberInfoByMemId(memid); nickname = entity.Nickname; MemCache.AddCache(_cachekey, nickname); } else { nickname = obj.ToString(); } } else { MemberInfoEntity entity = null; entity = MemberInfoDA.Instance.GetMemberInfoByMemId(memid); nickname = entity.Nickname; } return(nickname); }
/// <summary> /// 上传证件 /// </summary> /// <returns></returns> public ActionResult Reg2() { int _memId = QueryString.IntSafeQ("memId"); if (_memId == 0) { _memId = CookieBLL.GetRegisterCookie(); } if (_memId > 0) { MemberInfoEntity enti = MemberInfoBLL.Instance.GetMemberInfoByMemId(_memId); if (enti != null && enti.Id > 0) { ViewBag.LegalIdentityPre = enti.IdentityPre; ViewBag.LegalIdentityBeh = enti.IdentityBeh; } ViewBag.MemId = _memId; } else { RedirectToAction("Reg"); } return(View()); }
/// <summary> /// 插入一条记录到表MemberInfo,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="memberInfo">待插入的实体对象</param> public int AddMemberInfo(MemberInfoEntity entity) { string sql = @"insert into MemberInfo( [MemId],[Nickname],[MemName],[IdentityNo],[IdentityNoCheck],[Sex],[Birthday],[Telephone],[MobilePhone],[MobilePhoneCheck],[Email],[EmailCheck],[QQ],[QQCheck], [IdentityPre],[IdentityBeh],[IdentityAutoName],[IdentityAutoNo])VALUES ( @MemId,@Nickname,@MemName,@IdentityNo,@IdentityNoCheck,@Sex,@Birthday,@Telephone,@MobilePhone,@MobilePhoneCheck,@Email,@EmailCheck,@QQ,@QQCheck, @IdentityPre,@IdentityBeh,@IdentityAutoName,@IdentityAutoNo); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@MemId", DbType.Int32, entity.MemId); db.AddInParameter(cmd, "@Nickname", DbType.String, entity.Nickname); db.AddInParameter(cmd, "@MemName", DbType.String, entity.MemName); db.AddInParameter(cmd, "@IdentityNo", DbType.String, entity.IdentityNo); db.AddInParameter(cmd, "@IdentityNoCheck", DbType.Int32, entity.IdentityNoCheck); db.AddInParameter(cmd, "@Sex", DbType.Int32, entity.Sex); db.AddInParameter(cmd, "@Birthday", DbType.DateTime, (entity.Birthday == null || entity.Birthday < DateTime.Now.AddYears(-100)) ? "1901-01-01" : entity.Birthday.ToString()); db.AddInParameter(cmd, "@Telephone", DbType.String, entity.Telephone); db.AddInParameter(cmd, "@MobilePhone", DbType.String, entity.MobilePhone); db.AddInParameter(cmd, "@MobilePhoneCheck", DbType.Int32, entity.MobilePhoneCheck); db.AddInParameter(cmd, "@Email", DbType.String, entity.Email); db.AddInParameter(cmd, "@EmailCheck", DbType.Int32, entity.EmailCheck); db.AddInParameter(cmd, "@QQ", DbType.String, entity.QQ); db.AddInParameter(cmd, "@QQCheck", DbType.Int32, entity.QQCheck); db.AddInParameter(cmd, "@IdentityPre", DbType.String, entity.IdentityPre); db.AddInParameter(cmd, "@IdentityBeh", DbType.String, entity.IdentityBeh); db.AddInParameter(cmd, "@IdentityAutoName", DbType.String, entity.IdentityAutoName); db.AddInParameter(cmd, "@IdentityAutoNo", DbType.String, entity.IdentityAutoNo); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 更新一条MemberInfo记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="memberInfo">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateMemberInfo(MemberInfoEntity memberInfo) { if (memberInfo.Id == 0) { return(AddMemberInfo(memberInfo)); } return(MemberInfoDA.Instance.UpdateMemberInfo(memberInfo)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <MemberInfoEntity> GetMemberInfoList(int pagesize, int pageindex, ref int recordCount) { string sql = @"SELECT [Id],[MemId],[Nickname],[MemName],[IdentityNo],[IdentityNoCheck],[Sex],[Birthday],[Telephone],[MobilePhone],[MobilePhoneCheck],[Email],[EmailCheck],[QQ],[QQCheck], [IdentityPre],[IdentityBeh],[IdentityAutoName],[IdentityAutoNo] FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER, [Id],[MemId],[Nickname],[MemName],[IdentityNo],[IdentityNoCheck],[Sex],[Birthday],[Telephone],[MobilePhone],[MobilePhoneCheck],[Email],[EmailCheck],[QQ],[QQCheck], [IdentityPre],[IdentityBeh],[IdentityAutoName],[IdentityAutoNo] from dbo.[MemberInfo] WITH(NOLOCK) WHERE 1=1 ) as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[MemberInfo] with (nolock) "; IList <MemberInfoEntity> entityList = new List <MemberInfoEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { MemberInfoEntity entity = new MemberInfoEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.Nickname = StringUtils.GetDbString(reader["Nickname"]); entity.MemName = StringUtils.GetDbString(reader["MemName"]); entity.IdentityNo = StringUtils.GetDbString(reader["IdentityNo"]); entity.IdentityNoCheck = StringUtils.GetDbInt(reader["IdentityNoCheck"]); entity.Sex = StringUtils.GetDbInt(reader["Sex"]); entity.Birthday = StringUtils.GetDbDateTime(reader["Birthday"]); entity.Telephone = StringUtils.GetDbString(reader["Telephone"]); entity.MobilePhone = StringUtils.GetDbString(reader["MobilePhone"]); entity.MobilePhoneCheck = StringUtils.GetDbInt(reader["MobilePhoneCheck"]); entity.Email = StringUtils.GetDbString(reader["Email"]); entity.EmailCheck = StringUtils.GetDbInt(reader["EmailCheck"]); entity.QQ = StringUtils.GetDbString(reader["QQ"]); entity.QQCheck = StringUtils.GetDbInt(reader["QQCheck"]); entity.IdentityPre = StringUtils.GetDbString(reader["IdentityPre"]); entity.IdentityBeh = StringUtils.GetDbString(reader["IdentityBeh"]); entity.IdentityAutoName = StringUtils.GetDbString(reader["IdentityAutoName"]); entity.IdentityAutoNo = StringUtils.GetDbString(reader["IdentityAutoNo"]); entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { recordCount = StringUtils.GetDbInt(reader[0]); } else { recordCount = 0; } } return(entityList); }
/// <summary> /// 更新一个实体信息 /// </summary> /// <param name="Entity"></param> /// <returns></returns> public async Task <int> UpdateAsync(MemberInfoEntity PEntity) { if (PEntity == null) { return(0); } PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsMembers.Update(PEntity); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
// <summary> /// 根据Id删除一个实体信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public async Task <int> DeleteAsync(string Id) { if (Id == null) { return(0); } MemberInfoEntity tempPlan = _GhDbContext.dsMembers.Find(Id); _GhDbContext.dsMembers.Remove(tempPlan); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
/// <summary> /// 插入一条记录到表MemberInfo,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="memberInfo">要添加的MemberInfo数据实体对象</param> public int AddMemberInfo(MemberInfoEntity memberInfo) { if (memberInfo.Id > 0) { return(UpdateMemberInfo(memberInfo)); } else { return(MemberInfoDA.Instance.AddMemberInfo(memberInfo)); } }
public string Reg2Submit() { ResultObj _obj = new ResultObj(); string useraccount = FormString.SafeQ("useraccount"); string mobile = FormString.SafeQ("mobile"); string stamp = FormString.SafeQ("stamp"); string companyname = FormString.SafeQ("companyname"); int province = FormString.IntSafeQ("province"); int city = FormString.IntSafeQ("city"); int comtype = FormString.IntSafeQ("comtype"); string contractmanname = FormString.SafeQ("contractmanname"); string address = FormString.SafeQ("address", 300); MemberEntity mem = MemberBLL.Instance.GetMemByMethod(mobile, LoginMethodEnum.MobilePhone); if (mem.Status != (int)MemberStatus.Register1) { _obj.Status = (int)CommonStatus.RegisterNoModify; return(JsonJC.ObjectToJson(_obj)); } if (!(mem.TimeStampTab == stamp && CookieBLL.GetRegisterCookie() == mem.Id)) { _obj.Status = (int)CommonStatus.RegisterFail; } else { mem.MemCode = useraccount; MemberInfoEntity _meminfo = MemberInfoBLL.Instance.GetMemberInfoByMemId(mem.Id); _meminfo.MemId = mem.Id; _meminfo.Nickname = contractmanname; _meminfo.MemName = contractmanname; _meminfo.MobilePhone = mobile; MemberInfoBLL.Instance.AddMemberInfo(_meminfo); MemStoreEntity _store = new MemStoreEntity(); _store.Address = address; _store.CityId = city; _store.CompanyName = companyname; _store.ContactsManName = contractmanname; _store.CreateTime = DateTime.Now; _store.ProvinceId = province; _store.Status = (int)MemberStatus.WaitCheck; _store.StoreType = mem.StoreType; _store.MobilePhone = mobile; _store.MemId = mem.Id; ResultObj _loginentity = MemberLoginBLL.Instance.Register2(mem, _meminfo, _store); //if (_loginentity.Status == (int)CommonStatus.Success) //{ // CookieBLL.SetRegisterCookie(StringUtils.GetDbInt(_loginentity.Obj)); //} _obj = _loginentity; } return(JsonJC.ObjectToJson(_obj)); }
public async Task <string> UpdateEntity([FromBody] MemberInfoEntity PEntity) { ExcuteResult actResult = new ExcuteResult(); if (await _MemberRepository.UpdateAsync(PEntity).ConfigureAwait(false) > 0) { actResult.SetValues(0, "更新成功"); } else { actResult.SetValues(1, "更新失败"); } return(JsonConvert.SerializeObject(actResult)); }
/// <summary> /// 注册第一步 /// </summary> /// <param name="_mem"></param> /// <returns></returns> public ResultObj Register2(MemberEntity _mem, MemberInfoEntity _meminfo, MemStoreEntity _store) { ResultObj _returnentity = new ResultObj(); if (_mem.Status == (int)MemberStatus.Register1) { int result = MemberBLL.Instance.RegisterProc(_mem, _meminfo, _store); if (result > 0) { _returnentity.Status = (int)CommonStatus.Success; _returnentity.Obj = MemberBLL.Instance.GetMember(_mem.Id); return(_returnentity); } } _returnentity.Status = (int)CommonStatus.Fail; return(_returnentity); }
/// <summary> /// 身份证图片上传 /// </summary> /// <returns></returns> public int IDImagesSubmit() { int _memId = FormString.IntSafeQ("MemId"); string _IDPre = FormString.SafeQ("IDPre"); string _IDBeh = FormString.SafeQ("IDBeh"); MemberInfoEntity _entity = new MemberInfoEntity(); _entity.MemId = _memId; _entity.IdentityPre = _IDPre; _entity.IdentityBeh = _IDBeh; int _result = 0; _result = MemberInfoBLL.Instance.AddMemberInfo(_entity); return(_result); }
/// <summary> /// 新增或更新一个实体。 /// </summary> /// <param name="P_Entity"></param> /// <returns></returns> public async Task <int> AddOrUpdateAsync(MemberInfoEntity PEntity) { //此记录的Id为员工的身份证号码,必须输入 if (PEntity == null || PEntity.Id == null || PEntity.Name == null) { return(0); } bool IsExist = await _GhDbContext.dsMembers.AnyAsync(e => e.Id == PEntity.Id).ConfigureAwait(false); if (IsExist) { return(await UpdateAsync(PEntity).ConfigureAwait(false)); } else { PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsMembers.Add(PEntity); } return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
public MemberInfoEntity GetMemberInfoByMemId(int memid) { string sql = @"SELECT [Id],[MemId],[Nickname],[MemName],[IdentityNo],[IdentityNoCheck],[Sex],[Birthday],[Telephone],[MobilePhone],[MobilePhoneCheck],[Email],[EmailCheck],[QQ],[QQCheck],[WebChart],[WebChartCheck],[IdentityPre],[IdentityBeh],[IdentityAutoName],[IdentityAutoNo],HeadPicUrl FROM dbo.[MemberInfo] WITH(NOLOCK) WHERE [MemId]=@MemId" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@MemId", DbType.Int32, memid); MemberInfoEntity entity = new MemberInfoEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.Nickname = StringUtils.GetDbString(reader["Nickname"]); entity.MemName = StringUtils.GetDbString(reader["MemName"]); entity.IdentityNo = StringUtils.GetDbString(reader["IdentityNo"]); entity.IdentityNoCheck = StringUtils.GetDbInt(reader["IdentityNoCheck"]); entity.Sex = StringUtils.GetDbInt(reader["Sex"]); entity.Birthday = StringUtils.GetDbDateTime(reader["Birthday"]); entity.Telephone = StringUtils.GetDbString(reader["Telephone"]); entity.MobilePhone = StringUtils.GetDbString(reader["MobilePhone"]); entity.MobilePhoneCheck = StringUtils.GetDbInt(reader["MobilePhoneCheck"]); entity.Email = StringUtils.GetDbString(reader["Email"]); entity.EmailCheck = StringUtils.GetDbInt(reader["EmailCheck"]); entity.QQ = StringUtils.GetDbString(reader["QQ"]); entity.QQCheck = StringUtils.GetDbInt(reader["QQCheck"]); entity.WebChart = StringUtils.GetDbString(reader["WebChart"]); entity.WebChartCheck = StringUtils.GetDbInt(reader["WebChartCheck"]); entity.IdentityPre = StringUtils.GetDbString(reader["IdentityPre"]); entity.IdentityBeh = StringUtils.GetDbString(reader["IdentityBeh"]); entity.IdentityAutoName = StringUtils.GetDbString(reader["IdentityAutoName"]); entity.IdentityAutoNo = StringUtils.GetDbString(reader["IdentityAutoNo"]); entity.HeadPicUrl = StringUtils.GetDbString(reader["HeadPicUrl"]); } } return(entity); }
/// <summary> /// 企业申请信息详情 /// </summary> /// <returns></returns> public ActionResult SupplierDetail() { int _memid = QueryString.IntSafeQ("MemId", 0); MemberEntity _mementity = MemberBLL.Instance.GetMember(_memid); MemberInfoEntity _meminfoentity = MemberInfoBLL.Instance.GetMemberInfoByMemId(_memid); MemBillVATEntity _membill = MemBillVATBLL.Instance.GetMemBillVATByMemId(_memid); MemStoreEntity _storeentity = StoreBLL.Instance.GetStoreByMemId(_memid); string _provinceName = GYProvinceBLL.Instance.GetGYProvince(_storeentity.ProvinceId).Name; string _cityName = GYCityBLL.Instance.GetGYCityByCode(_storeentity.CityId.ToString()).Name; ViewBag.AddressofStore = _provinceName + _cityName; _provinceName = GYProvinceBLL.Instance.GetGYProvince(_membill.ReceiverProvince).Name; _cityName = GYCityBLL.Instance.GetGYCityByCode(_membill.ReceiverCity.ToString()).Name; ViewBag.AddressofBill = _provinceName + _cityName; ViewBag.mementity = _mementity; ViewBag.meninfoentity = _meminfoentity; ViewBag.membill = _membill; ViewBag.storentity = _storeentity; return(View()); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <MemberInfoEntity> GetMemberInfoAll() { string sql = @"SELECT [Id],[MemId],[Nickname],[MemName],[IdentityNo],[IdentityNoCheck],[Sex],[Birthday],[Telephone],[MobilePhone],[MobilePhoneCheck],[Email],[EmailCheck],[QQ],[QQCheck],[WebChart],[WebChartCheck],[IdentityPre],[IdentityBeh],[IdentityAutoName],[IdentityAutoNo] from dbo.[MemberInfo] WITH(NOLOCK) "; IList <MemberInfoEntity> entityList = new List <MemberInfoEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { MemberInfoEntity entity = new MemberInfoEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.Nickname = StringUtils.GetDbString(reader["Nickname"]); entity.MemName = StringUtils.GetDbString(reader["MemName"]); entity.IdentityNo = StringUtils.GetDbString(reader["IdentityNo"]); entity.IdentityNoCheck = StringUtils.GetDbInt(reader["IdentityNoCheck"]); entity.Sex = StringUtils.GetDbInt(reader["Sex"]); entity.Birthday = StringUtils.GetDbDateTime(reader["Birthday"]); entity.Telephone = StringUtils.GetDbString(reader["Telephone"]); entity.MobilePhone = StringUtils.GetDbString(reader["MobilePhone"]); entity.MobilePhoneCheck = StringUtils.GetDbInt(reader["MobilePhoneCheck"]); entity.Email = StringUtils.GetDbString(reader["Email"]); entity.EmailCheck = StringUtils.GetDbInt(reader["EmailCheck"]); entity.QQ = StringUtils.GetDbString(reader["QQ"]); entity.QQCheck = StringUtils.GetDbInt(reader["QQCheck"]); entity.WebChart = StringUtils.GetDbString(reader["WebChart"]); entity.WebChartCheck = StringUtils.GetDbInt(reader["WebChartCheck"]); entity.IdentityPre = StringUtils.GetDbString(reader["IdentityPre"]); entity.IdentityBeh = StringUtils.GetDbString(reader["IdentityBeh"]); entity.IdentityAutoName = StringUtils.GetDbString(reader["IdentityAutoName"]); entity.IdentityAutoNo = StringUtils.GetDbString(reader["IdentityAutoNo"]); entityList.Add(entity); } } return(entityList); }
public string MemSimpleAddSubmit() { ResultObj _obj = new ResultObj(); string useraccount = FormString.SafeQ("useraccount"); string mobile = FormString.SafeQ("mobile"); string companyname = FormString.SafeQ("companyname"); int province = FormString.IntSafeQ("province"); int city = FormString.IntSafeQ("city"); int issysuser = FormString.IntSafeQ("issysuser"); int issupplier = FormString.IntSafeQ("issupplier"); int isstore = FormString.IntSafeQ("isstore"); int comtype = FormString.IntSafeQ("comtype"); string contractmanname = FormString.SafeQ("contractmanname"); string address = FormString.SafeQ("address", 300); MemberEntity mem = MemberBLL.Instance.GetMemByMethod(mobile, LoginMethodEnum.MobilePhone); if (mem.Id == 0) { mem.MemCode = "xl" + mobile; mem.MobilePhone = mobile; mem.IsSysUser = issysuser; mem.IsSupplier = issupplier; mem.IsStore = isstore; mem.Status = (int)MemberStatus.Active; mem.CreateTime = DateTime.Now; mem.PassWord = DateTime.Now.ToShortDateString(); mem.Id = MemberBLL.Instance.AddMember(mem); } else { mem.MobilePhone = mobile; mem.IsSysUser = issysuser; mem.IsSupplier = issupplier; mem.IsStore = isstore; MemberBLL.Instance.UpdateMember(mem); } if (mem.Id > 0) { MemberInfoEntity _meminfo = MemberInfoBLL.Instance.GetMemberInfoByMemId(mem.Id); if (_meminfo.Id == 0) { _meminfo.MemId = mem.Id; _meminfo.Nickname = contractmanname; _meminfo.MemName = contractmanname; _meminfo.MobilePhone = mobile; MemberInfoBLL.Instance.AddMemberInfo(_meminfo); } MemStoreEntity _store = StoreBLL.Instance.GetStoreByMemId(mem.Id); _store.Address = address; _store.CityId = city; _store.CompanyName = companyname; _store.ContactsManName = contractmanname; _store.CreateTime = DateTime.Now; _store.ProvinceId = province; _store.StoreType = mem.StoreType; _store.MobilePhone = mobile; _store.MemId = mem.Id; if (_store.Id == 0) { _store.Status = (int)MemberStatus.Active; StoreBLL.Instance.AddStore(_store); } else { StoreBLL.Instance.UpdateStore(_store); } _obj.Status = (int)CommonStatus.Success; _obj.Obj = mem.MobilePhone; } return(JsonJC.ObjectToJson(_obj)); }
public int RegisterProc(MemberEntity mem, MemberInfoEntity meminfo, MemStoreEntity store) { return(MemberDA.Instance.RegisterProc(mem, meminfo, store)); }
/// <summary> /// 判断对象是否存在 /// </summary> /// <param name="dicEnum"></param> /// <returns></returns> public bool IsExist(MemberInfoEntity memberInfo) { return(MemberInfoDA.Instance.ExistNum(memberInfo) > 0); }
/// <summary> /// 根据Id获取一个对象 Dto /// </summary> /// <param name="P_Id"></param> /// <returns></returns> public async Task <MemberInfoDto> GetMemberInfoDtoAsync(string Id) { MemberInfoEntity RecordEntity = await _GhDbContext.dsMembers.FindAsync(Id).ConfigureAwait(false); return(_Imapper.Map <MemberInfoDto>(RecordEntity)); }