//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);
}
//모델 생성자
public EseInfoModels()
{
this.Item = new EstSender();
}