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