public EsmUser GetEsmAccountView(EsmAccountModels getModel) { string errorStr = ""; EsmUser model = new EsmUser(); string listQuery = " SELECT SEQNO, EMAIL, PASSWD, USERNAME, TELNO, GROUP_ID, CREATETIME, DEPARTMENT, POSITION, MEMO, STATUS FROM esm_user WHERE SEQNO = " + getModel.act_key; DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { model.SEQNO = int.Parse(listDt.Rows[0]["SEQNO"].ToString().Trim()); model.EMAIL = listDt.Rows[0]["EMAIL"].ToString().Trim(); model.PASSWD = listDt.Rows[0]["PASSWD"].ToString().Trim(); model.USERNAME = listDt.Rows[0]["USERNAME"].ToString().Trim(); model.TELNO = listDt.Rows[0]["TELNO"].ToString().Trim(); model.GROUP_ID = int.Parse(listDt.Rows[0]["GROUP_ID"].ToString().Trim()); model.CREATETIME = listDt.Rows[0]["CREATETIME"].ToString().Trim(); model.DEPARTMENT = listDt.Rows[0]["DEPARTMENT"].ToString().Trim(); model.POSITION = listDt.Rows[0]["POSITION"].ToString().Trim(); model.MEMO = listDt.Rows[0]["MEMO"].ToString().Trim(); model.STATUS = int.Parse(listDt.Rows[0]["STATUS"].ToString().Trim()); } return(model); }
public EsmAccountModels GetEsmAccountList(EsmAccountModels model) { string errorStr = ""; string listQuery = " SELECT SEQNO, EMAIL,PASSWD,USERNAME,TELNO,eu.GROUP_ID,eg.GROUP_NAME,CREATETIME,DEPARTMENT,POSITION,MEMO,STATUS FROM esm_user eu left outer join esm_group eg on eu.GROUP_ID = eg.GROUP_ID ORDER BY SEQNO "; DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { EsmUser temp = new EsmUser(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); temp.EMAIL = listDt.Rows[i]["EMAIL"].ToString().Trim(); temp.PASSWD = listDt.Rows[i]["PASSWD"].ToString().Trim(); temp.USERNAME = listDt.Rows[i]["USERNAME"].ToString().Trim(); temp.TELNO = listDt.Rows[i]["TELNO"].ToString().Trim(); temp.GROUP_ID = int.Parse(listDt.Rows[i]["GROUP_ID"].ToString().Trim()); temp.GROUP_NAME = listDt.Rows[i]["GROUP_NAME"].ToString().Trim(); temp.CREATETIME = listDt.Rows[i]["CREATETIME"].ToString().Trim(); temp.DEPARTMENT = listDt.Rows[i]["DEPARTMENT"].ToString().Trim(); temp.POSITION = listDt.Rows[i]["POSITION"].ToString().Trim(); temp.MEMO = listDt.Rows[i]["MEMO"].ToString().Trim(); temp.STATUS = int.Parse(listDt.Rows[i]["STATUS"].ToString().Trim()); model.Items.Add(temp); } } return(model); }
public ActionResult Login(AccountLoginModel viewModel) { if (!ModelState.IsValid) { return(View(viewModel)); } string resultStr = ""; AccountDbModels act = new AccountDbModels(); EsmUser model = new EsmUser(); model = act.loginChk(viewModel); //로그인 체크 if (model == null) //아이디 페스워드 체크 { resultStr = "이메일 또는 비밀번호를 확인해 주시기 바랍니다."; ViewBag.PublicMsg = resultStr; return(View(viewModel)); } if (model.STATUS == 0) //사용 여부 체크 { resultStr = "사용이 정지된 계정입니다."; ViewBag.PublicMsg = resultStr; return(View(viewModel)); } FormsAuthentication.SetAuthCookie(viewModel.Email, false); Session["MANAGE_NO"] = model.SEQNO; Session["MANAGE_GRADE"] = model.GROUP_ID; Session["CURRENT_LOGIN_EMAIL"] = model.EMAIL; //로그인 기록 데이터 세팅 CommLoginLog clh = new CommLoginLog(); clh.EMAIL = viewModel.Email; clh.IPADDR = Request.UserHostAddress; act.loginHis(clh); //로그인 로그 기록 return(RedirectToAction("Index", "Home")); }
public EsmUser loginChk(AccountLoginModel loginModel) { string sqlQuery = " SELECT SEQNO,EMAIL,USERNAME,GROUP_ID,STATUS FROM esm_user WHERE EMAIL = '" + loginModel.Email + "' AND PASSWD = '" + loginModel.Password + "' "; string resultStr = ""; DataTable dt = GetDataTableMySQL(sqlQuery, out resultStr); EsmUser model = new EsmUser(); if (dt != null && dt.Rows.Count != 0) { model.SEQNO = int.Parse(dt.Rows[0]["SEQNO"].ToString().Trim()); model.EMAIL = dt.Rows[0]["EMAIL"].ToString().Trim(); model.USERNAME = dt.Rows[0]["USERNAME"].ToString().Trim(); model.GROUP_ID = int.Parse(dt.Rows[0]["GROUP_ID"].ToString().Trim()); model.STATUS = int.Parse(dt.Rows[0]["STATUS"].ToString().Trim()); } return(model); }