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