}//End InsertLogMemberAccessSys
/// <summary>
/// 取得登入者的帳密
/// </summary>
public static SE_MemberModel GetLoginInfo(string strEMail)
{
SE_MemberModel data = null;
try
{
if (!String.IsNullOrEmpty(strEMail))
{
DataAccess da = new DataAccess(sqlXmlFileName, true);
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@strEMail", strEMail));
DataTable dt = da.RunQuery("GetLoginInfo", param.ToArray());
data = (from p in dt.Select()
select new SE_MemberModel()
{
strMemberID = p["strMemberID"].ToString(),
strEMail = p["strEMail"].ToString(),
strPassword = p["strPassword"].ToString(),
strGender = p["strGender"].ToString(),
strName = p["strName"].ToString(),
strDisplayName = p["strName"].ToString(),
ysnActive = Convert.ToBoolean(p["ysnActive"].ToString()),
ysnActivate = Convert.ToBoolean(p["ysnActivate"].ToString())
}).FirstOrDefault();
}
}
catch (Exception ex)
{
logger.Error("GetLoginInfo " + ex.Message); // Error log
} // catch: all exception
return(data);
}
} // GetMemberByMemberID()
/// <summary>
/// 取得Member info by EMail
/// </summary>
public static SE_MemberModel GetMemberByEmail(String strEMail)
{
SE_MemberModel member = new SE_MemberModel();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@strEMail", strEMail));
DataAccess da = new DataAccess(sqlXmlFileName, true);
try
{
DataTable dt = da.RunQuery("GetMemberByEmail", param.ToArray());
if (dt.Rows.Count > 0)
{
member = (from p in dt.Select()
select new SE_MemberModel()
{
strMemberID = p["strMemberID"].ToString(),
strFacebookID = p["strFacebookID"].ToString(),
strEMail = p["strEMail"].ToString(),
strPassword = p["strPassword"].ToString(),
strName = p["strName"].ToString(),
strDisplayName = p["strDisplayName"].ToString(),
strMobile = p["strMobile"].ToString(),
strPhoneCity = p["strPhoneCity"].ToString(),
strPhone = p["strPhone"].ToString(),
dtmBirth = DateTime.Parse(p["dtmBirth"].ToString()),
strGender = p["strGender"].ToString(),
intZipCode = Convert.ToInt32(p["intZipCode"]),
strCity = p["strCity"].ToString(),
strZone = p["strZone"].ToString(),
strAddress = p["strAddress"].ToString(),
strActivateCode = p["strActivateCode"].ToString(),
ysnActivate = bool.Parse(p["ysnActivate"].ToString()),
ysnActive = bool.Parse(p["ysnActive"].ToString())
}).First();
} // if: has data
} // try
catch (Exception e)
{
logger.Error("GetMemberByEmail " + e.Message); // Error log
} // catch: all exception
return(member);
} // GetMemberByEMail()
/// <summary>
/// 取得Member info by MemberID
/// </summary>
public static SE_MemberModel GetMemberByMemberID(String strMemberID)
{
SE_MemberModel member = new SE_MemberModel();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@strMemberID", strMemberID));
DataAccess da = new DataAccess(sqlXmlFileName, true);
try
{
DataTable dt = da.RunQuery("GetMemberByMemberID", param.ToArray());
if (dt.Rows.Count > 0)
{
member = (from p in dt.Select()
select new SE_MemberModel()
{
strContactID = p["strContactID"].ToString(),
ysnPolicy = bool.Parse(p["ysnPolicy"].ToString()),
strJoinTypeCode = p["strJoinTypeCode"].ToString(),
strJoinListCode = p["strJoinListCode"].ToString(),
strPicture = p["strPicture"].ToString(),
strMemberType = p["strMemberType"].ToString(),
dtmActivated = DateTime.Parse(p["dtmActivated"].ToString()),
dtmExpired = DateTime.Parse(p["dtmExpired"].ToString()),
dtmVIPDate = DateTime.Parse(p["dtmVIPDate"].ToString()),
ysnDM = bool.Parse(p["ysnDM"].ToString()),
ysnFax = bool.Parse(p["ysnFax"].ToString()),
ysnEmail = bool.Parse(p["ysnEmail"].ToString()),
ysnSMS = bool.Parse(p["ysnSMS"].ToString()),
ysnTel = bool.Parse(p["ysnTel"].ToString()),
strMemo = p["strMemo"].ToString(),
dtmCreate = DateTime.Parse(p["dtmCreate"].ToString()),
strWHO = p["strWHO"].ToString(),
dtmUpdate = DateTime.Parse(p["dtmUpdate"].ToString()),
intSeqNo = Convert.ToInt32(p["intSeqNo"]),
strMemberID = p["strMemberID"].ToString(),
strFacebookID = p["strFacebookID"].ToString(),
strEMail = p["strEMail"].ToString(),
strPassword = p["strPassword"].ToString(),
strName = p["strName"].ToString(),
strDisplayName = p["strDisplayName"].ToString(),
strMobile = p["strMobile"].ToString(),
strPhoneCity = p["strPhoneCity"].ToString(),
strPhone = p["strPhone"].ToString(),
dtmBirth = DateTime.Parse(p["dtmBirth"].ToString()),
strGender = p["strGender"].ToString(),
intZipCode = Convert.ToInt32(p["intZipCode"]),
strCity = p["strCity"].ToString(),
strZone = p["strZone"].ToString(),
strAddress = p["strAddress"].ToString(),
strActivateCode = p["strActivateCode"].ToString(),
ysnActivate = bool.Parse(p["ysnActivate"].ToString()),
ysnActive = bool.Parse(p["ysnActive"].ToString())
}).First();
} // if: has data
} // try
catch (Exception e)
{
logger.Error("GetMemberByMemberID " + e.Message); // Error log
} // catch: all exception
return(member);
} // GetMemberByMemberID()
