Пример #1
0
        //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);
        }
Пример #2
0
 //모델 생성자
 public EseInfoModels()
 {
     this.Item = new EstSender();
 }