public ActionResult EseInfo(EseInfoModels model, string viewEseCode)
{
//권한 체크===================================================
if (!chk.chkPermission("EseInfo", "PER_UPDATE"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
// 중복체크를 사용을 위해 act_key, schTxt2
model.act_key = 1;
model.schTxt2 = "updt";
if (model.Item.ESE_NAME == "")
{
model.act_key = 0;
model.schTxt2 = "ins";
}
string chkDupl = act.ChkUpdtEseInfo(model);
if (chkDupl != "")
{
return(RedirectToAction("EseInfo", new { msg = chkDupl }));
}
model.viewEseCode = (string)Session["ESE_CODE"];
string PublicPopupMsg = act.SetUpdtEseInfo(model);
return(RedirectToAction("EseInfo", new { msg = PublicPopupMsg }));
}
public ActionResult EseInfo(EseInfoModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("EseInfo", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
model = act.GetEseInfoList(model); //리스트 가져오기
if (TempData["PublicMsg"] != null)
{
ViewBag.PublicMsg = TempData["PublicMsg"].ToString();
}
ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기
//셀렉트박스
model.nationArray = act.GetNationCodeSelectBox();
model.stationArray = act.GetNationCodeSelectBox();
//model.senderArray = act.GetSenderSelectBox();
return(View(model));
}
public string ChkUpdtEseInfo(EseInfoModels model)
{
string errorStr = "";
string result = "";
string listQuery = " SELECT count(*) as cnt FROM est_sender WHERE ESE_NAME = '" + model.Item.ESE_NAME + "' ";
int reCnt = getQueryCnt(listQuery, out errorStr);
if (model.act_type != null && model.schTxt2 == "ins")
{
if (reCnt > 0 && model.Item.ESE_NAME != null)
{
result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_SenderName + "]";
}
else
{
listQuery = " SELECT count(*) as cnt FROM est_sender WHERE BIZNO = '" + model.Item.BIZNO + "' ";
reCnt = getQueryCnt(listQuery, out errorStr);
if (reCnt > 0)
{
result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_BIZNO + "]";
}
}
}
else if (model.act_type != null && model.schTxt2 == "updt")
{
if (reCnt > 1 && model.Item.ESE_NAME != null)
{
result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_SenderName + "]";
}
else
{
listQuery = " SELECT count(*) as cnt FROM est_sender WHERE BIZNO = '" + model.Item.BIZNO + "' ";
reCnt = getQueryCnt(listQuery, out errorStr);
if (reCnt > 1)
{
result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_BIZNO + "]";
}
}
}
return(result);
}
public string SetUpdtEseInfo(EseInfoModels model)
{
string result = "";
string errorStr = "";
string exeQueryStr = "";
if (model.act_type == "USER")
{
exeQueryStr = " UPDATE est_sender SET ";
exeQueryStr += " TASKMAN = '" + model.Item.TASKMAN + "' ";
exeQueryStr += ", TELNO_TASK = '" + model.Item.TELNO_TASK + "' ";
exeQueryStr += ", EMAIL_TASK = '" + model.Item.EMAIL_TASK + "' ";
exeQueryStr += " WHERE ESE_CODE = '" + model.viewEseCode + "' ";
}
if (model.act_type == "BASE")
{
exeQueryStr = " UPDATE est_sender SET ";
exeQueryStr += " ESE_NAME = '" + model.Item.ESE_NAME + "' ";
exeQueryStr += ", ZIPCODE = '" + model.Item.ZIPCODE + "' ";
exeQueryStr += ", ADDR = '" + model.Item.ADDR + "' ";
exeQueryStr += ", BIZNO = '" + model.Item.BIZNO + "' ";
exeQueryStr += ", REPRESENTATIVE = '" + model.Item.REPRESENTATIVE + "' ";
exeQueryStr += ", TELNO_REP = '" + model.Item.TELNO_REP + "' ";
exeQueryStr += ", EMAIL_REP = '" + model.Item.EMAIL_REP + "' ";
exeQueryStr += ", MEMO = '" + model.Item.MEMO + "' ";
exeQueryStr += ", HOMEPAGE = '" + model.Item.HOMEPAGE + "' ";
exeQueryStr += ", API_KEY = '" + model.Item.API_KEY + "' ";
exeQueryStr += " WHERE ESE_CODE = '" + model.viewEseCode + "' ";
}
if (exeQuery(exeQueryStr, out errorStr))
{
result = "성공.";
}
else
{
result = "실패.";
}
return(result);
}
// GET: Est EST STATION EST 정보 관리 뷰 팝업
public ActionResult EseInfoView(string msg, string eseCode)
{
//권한 체크===================================================
if (!chk.chkPermission("EseInfo", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EseInfoModels model = new EseInfoModels();
model.viewEseCode = eseCode;
return(View(model));
}
//WEB_ESE 계정관리 => 기본 정보
public EseInfoModels GetEseInfo(EseInfoModels getModel)
{
string errorStr = "";
EstSender model = new EstSender();
string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EseInfo) + " FROM est_sender WHERE ESE_CODE = '" + getModel.viewEseCode + "' ";
DataTable listDt = getQueryResult(listQuery, out errorStr);
if (listDt != null && listDt.Rows.Count != 0)
{
model.SEQNO = int.Parse(listDt.Rows[0]["SEQNO"].ToString().Trim());
model.EST_CODE = listDt.Rows[0]["EST_CODE"].ToString().Trim();
model.ESE_CODE = listDt.Rows[0]["ESE_CODE"].ToString().Trim();
model.ESE_NAME = listDt.Rows[0]["ESE_NAME"].ToString().Trim();
model.ZIPCODE = listDt.Rows[0]["ZIPCODE"].ToString().Trim();
model.ADDR = listDt.Rows[0]["ADDR"].ToString().Trim();
model.BIZNO = listDt.Rows[0]["BIZNO"].ToString().Trim();
model.REPRESENTATIVE = listDt.Rows[0]["REPRESENTATIVE"].ToString().Trim();
model.TELNO_REP = listDt.Rows[0]["TELNO_REP"].ToString().Trim();
model.EMAIL_REP = listDt.Rows[0]["EMAIL_REP"].ToString().Trim();
model.TASKMAN = listDt.Rows[0]["TASKMAN"].ToString().Trim();
model.TELNO_TASK = listDt.Rows[0]["TELNO_TASK"].ToString().Trim();
model.EMAIL_TASK = listDt.Rows[0]["EMAIL_TASK"].ToString().Trim();
model.MAR = double.Parse(listDt.Rows[0]["MAR"].ToString().Trim());
model.CREATEDATE = listDt.Rows[0]["CREATEDATE"].ToString().Trim();
model.STATUS = int.Parse(listDt.Rows[0]["STATUS"].ToString().Trim());
model.MEMO = listDt.Rows[0]["MEMO"].ToString().Trim();
model.HOMEPAGE = listDt.Rows[0]["HOMEPAGE"].ToString().Trim();
model.API_KEY = listDt.Rows[0]["API_KEY"].ToString().Trim();
getModel.Item = model;
}
return(getModel);
}
// GET: Ese SENDER ESE 정보 관리
public ActionResult EseInfo(string searchString, string msg, string NATION_CODE)
{
//권한 체크===================================================
if (!chk.chkPermission("EseInfo", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EseInfoModels model = new EseInfoModels();
//페이징 설정 초기화
model.Paging.page = 1;
model.Paging.pageNum = 10;
model.sortKey = "SEQNO";
//리스트 가져오기
model = act.GetEseInfoList(model);
ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기
//셀렉트박스
model.nationArray = act.GetNationCodeSelectBox();
model.Item.EST_CODE = model.station;
model.Item.ESE_CODE = model.sender;
model.stationArray = act.GetNationCodeSelectBox();
model.senderArray = act.GetSenderSelectBox(NATION_CODE);
return(View(model));
}
public EseInfoModels GetEseInfoList(EseInfoModels model)
{
string errorStr = "";
string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EseInfo);
string cntQuery = " SELECT count(*) as cnt ";
string baseQuery = " FROM ese_user WHERE 1=1 ";
if (!String.IsNullOrEmpty(model.schType)) //국가
{
baseQuery += " AND NATION_CODE = " + model.schType.Trim();
}
if (!String.IsNullOrEmpty(model.station)) //STATION
{
baseQuery += " AND EST_CODE = " + model.station.Trim();
}
if (!String.IsNullOrEmpty(model.station)) //SENDER
{
baseQuery += " AND ESE_CODE = " + model.station.Trim();
}
if (!String.IsNullOrEmpty(model.schSdt)) //생성날짜 (시작일)
{
baseQuery += " AND CREATETIME >= '" + model.schSdt.Trim() + "'";
}
if (!String.IsNullOrEmpty(model.schEdt)) //생성날짜 (종료일)
{
baseQuery += " AND CREATETIME <= '" + model.schEdt.Trim() + " 23:59:59'";
}
if (!String.IsNullOrEmpty(model.schTypeTxt) && !String.IsNullOrEmpty(model.schTxt)) //검색조건 검색어
{
baseQuery += " AND " + model.schTypeTxt.Trim() + " like '%" + model.schTxt.Trim() + "%' ";
}
string endQuery = " ORDER BY " + model.sortKey.ToString().Trim() + " DESC limit " + ((model.Paging.page - 1) * model.Paging.pageNum) + " , " + model.Paging.pageNum; //정렬
cntQuery += baseQuery; //토탈 카운트 쿼리
listQuery += baseQuery + endQuery; //리스트 쿼리
int totCnt = getQueryCnt(cntQuery, out errorStr); //전체 리스트 갯수 구하기
model.Paging.pageTotNum = (totCnt / model.Paging.pageNum) + 1; //총 페이징 갯수 구하기
DataTable listDt = getQueryResult(listQuery, out errorStr);
if (listDt != null && listDt.Rows.Count != 0)
{
for (int i = 0; i < listDt.Rows.Count; i++)
{
EseUser temp = new EseUser();
temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim());
temp.EST_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim();
temp.ESE_CODE = listDt.Rows[i]["ESE_CODE"].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.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());
//Comnation 에서 국가 목록을 다 긁어와서 넣어줘야 한다.
model.Items.Add(temp);
}
}
return(model);
}
