public EstUser GetEstUserView(EstUserModels getModel) { string errorStr = ""; EstUser model = new EstUser(); string listQuery = " SELECT SEQNO, EST_CODE, EMAIL, PASSWD, USERNAME, TELNO, GROUP_ID, CREATETIME, DEPARTMENT, POSITION, MEMO, STATUS FROM est_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.EST_CODE = listDt.Rows[0]["EST_CODE"].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); }
//EST STATION EST 정보 관리 -> 계정 관리 public EstUserModels GetEstUserList(EstUserModels model) { string errorStr = ""; //string listQuery = " SELECT SEQNO, EST_CODE, EMAIL, PASSWD, USERNAME, TELNO, GROUP_ID, CREATETIME, DEPARTMENT, POSITION, MEMO, STATUS FROM est_user order by SEQNO "; string listQuery = " SELECT SEQNO, EMAIL,PASSWD,USERNAME,TELNO,eu.GROUP_ID,eg.GROUP_NAME,CREATETIME,DEPARTMENT,POSITION,MEMO,STATUS FROM est_user eu left outer join est_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++) { EstUser temp = new EstUser(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); //temp.EST_CODE = listDt.Rows[i]["EST_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.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); }