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