public MemberVO FindMemberById(MemberContext ctx, int id)
{
MemberVO member = new MemberVO();
try
{
var query = (from mem in ctx.Member
join rol in ctx.Role on mem.RoleId equals rol.Id
where mem.Id == id
select new
{
mem.Username,
mem.Id,
mem.DefaultCultrure,
rol.Name
}).Single();
member.Username = FillItemForDatabase.FillItem(query.Username);
member.Id = FillItemForDatabase.FillItem(query.Id);
member.DefaultCultrure = FillItemForDatabase.FillItem(query.DefaultCultrure);
member.Role = new RoleVO();
member.Role.Name = FillItemForDatabase.FillItem(query.Name);
}
catch
{
throw;
}
return(member);
}
// GET: MyPage
public JsonResult update(string memberid, string memberpwd, string membername, string email, string telephone)
{
string result = string.Empty;
//dao
Member member = new Member();
//vo
MemberVO mv = new MemberVO();
mv.MemberID = memberid;
mv.MemberPWD = memberpwd;
mv.MemberName = membername;
mv.Email = email;
mv.Telephone = telephone;
Boolean check = member.update(mv);
if (check)
{
result = "OK";
}
else
{
result = "FAIL";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public MemberVO FindMemberByUserName(MemberContext ctx, string username)
{
MemberVO member = new MemberVO();
try
{
var query = (from m in ctx.Member
where m.Username == username
select new
{
m.Password,
m.Id,
m.RoleId,
m.DefaultCultrure,
m.PersonId,
m.UrlId
}).Single();
member.Id = FillItemForDatabase.FillItem(query.Id);
member.Username = username;
member.Password = FillItemForDatabase.FillItem(query.Password);
member.RoleId = FillItemForDatabase.FillItem(query.RoleId);
member.DefaultCultrure = FillItemForDatabase.FillItem(query.DefaultCultrure);
member.PersonId = FillItemForDatabase.FillItem(query.PersonId);
member.UrlId = FillItemForDatabase.FillItem(query.UrlId);
}
catch (Exception ex)
{
throw ex;
}
return(member);
}
public HttpResponseMessage Delete(string id)
{
int memberId;
if (!string.IsNullOrWhiteSpace(id) && int.TryParse(id, out memberId))
{
try
{
MemberVO oldMemberVO = m_MemberService.GetMemberById(memberId);
if (oldMemberVO != null)
{
oldMemberVO.NeedUpdate = false;
oldMemberVO.Status = "0";
oldMemberVO.UpdateId = "系統API";
m_MemberService.UpdateMember(oldMemberVO);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Gone));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.NoContent, ex.ToString()));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
}
//private string GetPic(string fileName)
//{
// return "<img src='../../upload/" + fileName + "' width='145' height='108' border='0'>";
//}
protected void gvList_RowCommand1(object sender, GridViewCommandEventArgs e)
{
string cmdName = e.CommandName;
int memberId = int.Parse(e.CommandArgument.ToString());
MemberVO memberVO = m_MemberService.GetMemberById(memberId);
switch (cmdName)
{
case "myModify":
ClearUI();
m_Mode = memberId;
InitDDL();
UIHelper.FillUI(pnlContent, memberVO);
ShowMode();
ddlProject1.SelectedValue = memberVO.Project1;
ddlProject2.SelectedValue = memberVO.Project2;
ddlProject3.SelectedValue = memberVO.Project3;
pnlContent.Visible = true;
break;
//case "myDel":
// postVO.Flag = 0;
// m_PostService.UpdatePost(postVO);
// m_WebLogService.AddSystemLog(MsgVO.Action.刪除, postVO, "", string.Format("單號:{0}", postVO.PostId));
// break;
default:
break;
}
fillGridView();
}
public ActionResult Entry()
{
MemberVO member = new MemberVO();
ViewBag.EmailPattern = "/^[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*@[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*.[a-zA-Z]{2,3}$/";
return(View(member));
}
public ActionResult Register()
{
MemberVO member = new MemberVO();
ViewBag.SelectCountry = new SelectList(GetCountryDictionary().OrderBy(X => X.Value), "Key", "Value");
return(View(member));
}
public ActionResult Register(MemberVO member)
{
try
{
if (ModelState.IsValid)
{
member.Person.Email = new EmailBL().ConvertAddressToModel(member.Person.Email.Address, member.Person.Email);
member.Person.Mobile.IsMobile = true;
member.Person.Phone.Phone = member.Person.Phone.Phone.Replace("-", "");
member.Person.Mobile.Phone = member.Person.Mobile.Phone.Replace("-", "");
if (member.Person.Address.Country == "el")
{
member.Person.Phone.CodeCountry = "+31";
member.Person.Mobile.CodeCountry = "+31";
}
new MemberBL().AddAdminMember(member);
return(RedirectToAction("Index", "Home"));
}
member.Person.Addresses.Add(new AddressVO());
member.Person.Emails.Add(new EmailVO());
ViewBag.SelectCountry = new SelectList(GetCountryDictionary().OrderBy(X => X.Value), "Key", "Value");
}
catch (Exception ex)
{
member.Person.Addresses.Add(new AddressVO());
member.Person.Emails.Add(new EmailVO());
ViewBag.SelectCountry = new SelectList(GetCountryDictionary().OrderBy(X => X.Value), "Key", "Value");
TempData["UIMsg"] = new UIMessage(ex.Message, eUIMsgType.danger);
}
return(View(member));
}
protected void btnChange_Click(object sender, EventArgs e)
{
try
{
bool gender;
mem = new Member();
MemberVO memvo = new MemberVO();
memvo.MemberID = new Member().SelectByUserName(Session["User"].ToString()).MemberID;
memvo.RoleID = 2;
if (rdoMale.Checked)
{
memvo.Gender = true;
}
else
{
memvo.Gender = false;
}
memvo.Birthday = DateTime.Parse(txtDOB.Text);
memvo.Address = txtAddress.Text;
memvo.City = txtCity.Text;
memvo.PhoneNo = txtPhone.Text;
memvo.Email = txtEmail.Text;
string status = mem.ChangeProfile(memvo);
Utilties.Alert.Show(status);
}
catch (Exception ex)
{
Utilties.Alert.Show("Có lỗi xảy ra:" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
memVO = new MemberVO();
mem = new DAL.Member();
memVO = mem.SelectByUserName(Session["User"].ToString());
txtUserName.Text = memVO.Username;
txtFullName.Text = memVO.MemberName;
if (memVO.Gender == true)
{
rdoMale.Checked = true;
}
else
{
rdoFemale.Checked = true;
}
txtDOB.Text = memVO.Birthday.ToString();
txtAddress.Text = memVO.Address;
txtCity.Text = memVO.City;
txtPhone.Text = memVO.PhoneNo;
txtEmail.Text = memVO.Email;
}
if (Session["User"].ToString() == "")
{
Response.Redirect("Default.aspx");
}
}
public ActionResult Login(MemberVO member)
{
try
{
Login login = new Login();
Boolean result = login.login(member.MemberID, member.MemberPWD);
if (result)
{
MemberVO mv = login.session(member.MemberID);
Session["ID"] = mv.MemberID;
Session["Code"] = mv.Code.ToString();
ViewBag.Result = "OK";
}
else
{
ViewBag.Result = "FAIL";
}
}
catch (Exception e)
{
ViewBag.Result = "FAIL";
}
return(View(member));
}
//// GET api/<controller>/5
//public string Get(int id)
//{
// return "value";
//}
// POST api/<controller>
public HttpResponseMessage Post(MemberDto memberDto)
{
if (memberDto != null)
{
try
{
MemberVO memberVO = null;
memberVO = new MemberVO(memberDto);
memberVO.MemberId = 0;
memberVO.ServerId = 0;
memberVO.NeedUpdate = false;
memberVO.UpdateId = "系統API";
FixTimeZone(memberVO);
memberVO = m_MemberService.CreateMember(memberVO);
memberVO.ServerId = memberVO.MemberId;
//檢查是否有ServerId 有的話把狀態改成刪除, 重新建立一筆
if (memberDto.ServerId != 0)
{
MemberVO oldMemberVO = m_MemberService.GetMemberById(memberDto.ServerId);
if (oldMemberVO != null)
{
oldMemberVO.NeedUpdate = false;
oldMemberVO.Status = "0";
oldMemberVO.UpdateId = "系統API";
m_MemberService.UpdateMember(oldMemberVO);
//檢查庫存有沒有關聯這個memberid, 有的話庫存要更新memberid
Dictionary <string, string> conditions = new Dictionary <string, string>();
conditions.Add("Flag", "1");
conditions.Add("NodeId", "2");
conditions.Add("MemberId", memberVO.MemberId.ToString());
if (m_PostService.GetPostCount(conditions) > 0)
{
conditions.Add("PageIndex", "0");
conditions.Add("PageSize", "1");
IList <PostVO> postVOList = m_PostService.GetPostList(conditions);
PostVO postVO = m_PostService.GetPostById(postVOList[0].PostId);
postVO.MemberId = memberVO.MemberId.ToString();
m_PostService.UpdatePost(postVO);
}
}
}
return(Request.CreateResponse <MemberDto>(HttpStatusCode.Created, new MemberDto(memberVO)));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.NoContent, ex.ToString()));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
}
public MemberDto(MemberVO memberVO)
{
this.MemberId = memberVO.MemberId;
this.LoginId = memberVO.LoginId;
this.Password = memberVO.Password;
this.Name = memberVO.Name;
this.Company = memberVO.Company;
this.CompanyNo = memberVO.CompanyNo;
this.Dept = memberVO.Dept;
this.JobTitle = memberVO.JobTitle;
this.Phone = memberVO.Phone;
this.Mobile = memberVO.Mobile;
this.Fax = memberVO.Fax;
this.Email = memberVO.Email;
this.CreatedDate = memberVO.CreatedDate;
this.UpdatedDate = memberVO.UpdatedDate;
this.CreateIP = memberVO.CreateIP;
this.Sex = memberVO.Sex;
this.Status = memberVO.Status;
this.UserConfirm = memberVO.UserConfirm;
this.Token = memberVO.Token;
this.ApplyDate = memberVO.ApplyDate;
this.DueDate = memberVO.DueDate;
this.Birthday = memberVO.Birthday;
this.BirthdayYear = memberVO.BirthdayYear;
this.BirthdayMonth = memberVO.BirthdayMonth;
this.BirthdayDay = memberVO.BirthdayDay;
this.Project = memberVO.Project;
this.Product = memberVO.Product;
this.PhoneSer = memberVO.PhoneSer;
this.PhonePrice = memberVO.PhonePrice;
this.PhoneSellPrice = memberVO.PhoneSellPrice;
this.Commission = memberVO.Commission;
this.ReturnCommission = memberVO.ReturnCommission;
this.BreakMoney = memberVO.BreakMoney;
this.Compensation = memberVO.Compensation;
this.ContractMonths = memberVO.ContractMonths;
this.Sales = memberVO.Sales;
this.Note = memberVO.Note;
this.WarrantySuppliers = memberVO.WarrantySuppliers;
this.MobileWholesalers = memberVO.MobileWholesalers;
this.ApplyDate2 = memberVO.ApplyDate2;
this.PID = memberVO.PID;
this.Store = memberVO.Store;
this.OnlineWholesalers = memberVO.OnlineWholesalers;
this.SimNo = memberVO.SimNo;
this.Project1 = memberVO.Project1;
this.Project2 = memberVO.Project2;
this.Project3 = memberVO.Project3;
this.GetCommission = memberVO.GetCommission;
this.Prepayment = memberVO.Prepayment;
this.SelfPrepayment = memberVO.SelfPrepayment;
this.ServerId = memberVO.ServerId;
this.NeedUpdate = memberVO.NeedUpdate;
this.UpdateId = memberVO.UpdateId;
this.CreatedBy = memberVO.CreatedBy;
this.UpdatedBy = memberVO.UpdatedBy;
}
private void CalculateFranchiseesCommission()
{
if (m_ConfigHelper.ShowFranchiseesCommission)
{
MemberVO memberVO = new MemberVO();
UIHelper.FillVO(pnlContent, memberVO);
lblCommissionToBoss.Text = memberVO.CommissionToBoss.ToString();
lblFranchiseesCommission.Text = memberVO.FranchiseesCommission.ToString();
}
}
void GetPosExistMemberInfo()
{
MemberVO memberVO = new MemberVO();
memberVO.phone = "18258224036";
PosExistMemberInfo posExistMemberInfo = new PosExistMemberInfo();
posExistMemberInfo.getPosExistMemberInfo(memberVO);
}
private MemberState SetRole(MemberState state, MemberVO member)
{
if (member.Role.Name == (string)eRole.Admin.Value)
{
state.IsAdmin = true;
}
else if (member.Role.Name == (string)eRole.SuperAdmin.Value)
{
state.IsSuperUser = true;
}
return(state);
}
public ActionResult MyPage()
{
string s = Session["ID"].ToString();
Member member = new Member();
MemberVO mv = member.select(s);
ViewBag.MemberID = mv.MemberID;
ViewBag.MemberPWD = mv.MemberPWD;
ViewBag.MemberName = mv.MemberName;
ViewBag.Email = mv.Email;
ViewBag.Telephone = mv.Telephone;
return(View(mv));
}
void GetRegister()
{
//if (string.IsNullOrEmpty(this.phone.Value.ToString()))
//{
// Response.Write("手机还没填呢！");
//}
////if (string.IsNullOrEmpty(Request.Form["USER_AGE"]))
////{
//// Response.Write("生日还没填呢！");
////}
//if (string.IsNullOrEmpty(this.USER_AGE.Value))
//{
// Response.Write("生日还没填呢！");
//}
//if (string.IsNullOrEmpty(this.name.Value))
//{
// Response.Write("姓名(会员名)还没填呢！");
//}
MemberVO memberVO = new MemberVO();
memberVO.phone = Request.Form["phone"];
memberVO.gender = Request.Form["sex1"] == null ? Request.Form["sex2"] : Request.Form["sex1"];
// memberVO.gender = Request.Form["sex1"];
memberVO.memName = Request.Form["name"];
// memberVO.idx = "2016071800001";
memberVO.idx = DateTime.Now.ToString();
memberVO.birthday = Request.Form["USER_AGE"];
int data = Register.GetRegister(memberVO);
if (data == 1223)
{
Response.Write("卡面号重复!");
}
else if (data == 1221)
{
Response.Write("手机号已存在，请登陆!");
}
else if (data == 1222)
{
Response.Write("证件号重复!");
}
else if (data == 0)
{
Response.Redirect("index.aspx");
}
}
public static int GetRegister(string phone, string memName, string birthday, string gender)
{
MemberVO memberVO = new MemberVO();
memberVO.phone = phone;
memberVO.gender = gender;
memberVO.memName = memName;
// memberVO.idx = "2016071800001";
memberVO.idx = DateTime.Now.ToString();
memberVO.birthday = birthday;
return(APIManage.Register.GetRegister(memberVO));
}
private string GenMailContent(MemberVO memberVO)
{
StringBuilder sbContent = new StringBuilder();
sbContent.Append(string.Format("時 間：{0}<br />", memberVO.CreatedDate.Value.ToString()));
sbContent.Append(string.Format("姓 名：{0}<br />", memberVO.Name));
sbContent.Append(string.Format("電 話：{0}<br />", memberVO.Phone));
sbContent.Append(string.Format("性 別：{0}<br />", memberVO.Sex));
sbContent.Append(string.Format("電子信箱：{0}<br />", memberVO.Email));
sbContent.Append(string.Format("<a href='{0}/memberConfirm.aspx?id={1}&token={2}'>請點此連結完成會員認證</a>"
, m_ConfigHelper.Host, memberVO.MemberId, memberVO.Token));
return(sbContent.ToString());
}
protected void btnlogin_Click(object sender, EventArgs e)
{
PosExistMemberInfo posExistMemberInfo = new PosExistMemberInfo();
MemberVO memberVO = new MemberVO();
memberVO.phone = account.Value;
string smg = posExistMemberInfo.getPosExistMemberInfo(memberVO);
if (string.IsNullOrEmpty(txtChkCode.Value))
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>show_err_msg('请填写验证码！');</script>");
return;
}
else
{
HttpSessionState Session = HttpContext.Current.Session;
if (Session["MobileYzm"] == null)
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>show_err_msg('请重新获取验证码！');</script>");
return;
}
if (Session["MobileYzm"].ToString() != txtChkCode.Value)
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>show_err_msg('验证码不正确，请重试！');</script>");
return;
}
}
if (string.IsNullOrEmpty(smg.Trim()))
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>show_err_msg('该手机还没注册，请注册！');</script>");
return;
}
else
{
HttpCookie cookie = new HttpCookie("cookiePhone");
cookie.Value = account.Value;
cookie.Expires = DateTime.MaxValue;
HttpContext.Current.Response.Cookies.Add(cookie);
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>sky('成功！');</script>");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
MemberVO memberVO = m_MemberService.GetMemberById(m_Mode);
memberVO.Status = "0";
memberVO.NeedUpdate = true;
memberVO.UpdatedBy = m_SessionHelper.LoginUser.FullNameInChinese;
memberVO.UpdatedDate = DateTime.Now;
m_MemberService.UpdateMember(memberVO);
new Thread(new ThreadStart(ApiUtil.UpdateMemberToServer)).Start();
m_WebLogService.AddSystemLog(MsgVO.Action.刪除, memberVO, "", string.Format("單號:{0}", memberVO.MemberId));
UpdateProductByPhoneSerWithDelete(memberVO.PhoneSer);
ClearUI();
fillGridView();
}
/// <summary>
/// 發確認信給會員
/// </summary>
/// <param name="messageVO"></param>
public void SendConfirmMail_ToMember(MemberVO memberVO)
{
try
{
SystemParamVO mailVO = m_SystemService.GetSystemParamByRoot();
MailService mailService = new MailService(mailVO.MailSmtp, int.Parse(mailVO.MailPort), mailVO.EnableSSL, mailVO.Account, mailVO.Password);
string mailTitle = "收到一封從網站的會員認證信。";
string mailContent = GenMailContent(memberVO);
mailService.SendMail(mailVO.SendEmail, memberVO.Email, mailTitle, mailContent);
}
catch (Exception ex)
{
m_Log.Error(ex);
}
}
private void FixTimeZone(MemberVO memberVO)
{
int addHours = m_ConfigHelper.AddHours;
if (memberVO.ApplyDate.HasValue)
{
memberVO.ApplyDate = memberVO.ApplyDate.Value.AddHours(addHours);
}
if (memberVO.ApplyDate2.HasValue)
{
memberVO.ApplyDate2 = memberVO.ApplyDate2.Value.AddHours(addHours);
}
if (memberVO.DueDate.HasValue)
{
memberVO.DueDate = memberVO.DueDate.Value.AddHours(addHours);
}
}
/// <summary>
/// Get Member by this id
/// </summary>
/// <param name="id">id to search member</param>
/// <returns></returns>
public MemberVO GetMemberById(int id)
{
MemberVO member = null;
try
{
using (var ctx = new MemberContext())
{
IMemberDA da = new MemberDA();
member = da.FindMemberById(ctx, id);
}
}
catch
{
throw;
}
return(member);
}
void GetPosPoint()
{
MemberVO memberVO = new MemberVO();
memberVO.phone = "18258224036";
memberVO.gender = "0";
memberVO.memName = "buwenqing";
// memberVO.idx = "2016071800001";
memberVO.idx = DateTime.Now.ToString();
memberVO.birthday = "1987-05-24";
PointVO pointVO = new PointVO();
pointVO.yyyy = "2016";
pointVO.mm = "07";
pointVO.bgnRowNum = "0";
pointVO.endRowNum = "10";
PosPoint.getPosPoint(memberVO, pointVO);
}
public ActionResult Entry(MemberVO member)
{
try
{
Member memberdao = new Member();
Boolean check = memberdao.insert(member.MemberID, member.MemberPWD, member.MemberName, member.Email, member.Telephone);
if (check)
{
ViewBag.Result = "OK";
}
ViewBag.EmailPattern = "/^[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*@[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*.[a-zA-Z]{2,3}$/";
}
catch (Exception e)
{
ViewBag.Result = "FAIL";
}
//return RedirectToAction("List","Member");
return(View(member));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
MemberVO memberVO = new MemberVO();
UIHelper.FillVO(pnlContent, memberVO);
//postVO.PicFileName = m_PicFileName;
memberVO.Status = "1";
memberVO.CreateIP = m_HttpHelper.GetUserIp(Context);
memberVO.NeedUpdate = true;
memberVO.CreatedBy = m_SessionHelper.LoginUser.FullNameInChinese;
memberVO.UpdatedBy = m_SessionHelper.LoginUser.FullNameInChinese;
memberVO.CreatedDate = DateTime.Now;
memberVO.UpdatedDate = DateTime.Now;
memberVO = m_MemberService.CreateMember(memberVO);
new Thread(new ThreadStart(ApiUtil.UpdateMemberToServer)).Start();
m_WebLogService.AddSystemLog(MsgVO.Action.新增, memberVO);
UpdateProductByPhoneSer(memberVO.MemberId);
ClearUI();
fillGridView();
}
public MemberVO RegisterMember(MemberContext ctx, MemberVO member)
{
try
{
ctx.Member.Add(member);
ctx.Cv.Add(new CvVO {
MemberId = member.Id
});
ctx.Person.Add(member.Person);
ctx.Addresses.Add(member.Person.Address);
ctx.Emails.Add(member.Person.Email);
ctx.Phones.Add(member.Person.Phone);
ctx.Phones.Add(member.Person.Mobile);
ctx.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(member);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
try
{
MemberVO memberVO = m_MemberService.GetMemberById(m_Mode);
UIHelper.FillVO(pnlContent, memberVO);
memberVO.NeedUpdate = true;
memberVO.UpdatedBy = m_SessionHelper.LoginUser.FullNameInChinese;
memberVO.UpdatedDate = DateTime.Now;
memberVO = m_MemberService.UpdateMember(memberVO);
m_WebLogService.AddSystemLog(MsgVO.Action.修改, memberVO, "", string.Format("單號:{0}", memberVO.MemberId));
new Thread(new ThreadStart(ApiUtil.UpdateMemberToServer)).Start();
UpdateProductByPhoneSer(memberVO.MemberId);
fillGridView();
ClearUI();
ShowMode();
}
catch (Exception ex)
{
m_Log.Error(ex);
lblMsg.Text = ex.ToString();
}
}
