/// <summary> /// Shift 목록 가져오는 메서드 /// </summary> /// <returns></returns> public List <SHIFTList_VO> GetShiftList() { List <SHIFTList_VO> list = null; try { using (SqlCommand cmd = new SqlCommand()) { AESSalt salt = new AESSalt(); cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = $@"select f.FCLTS_CODE ,FCLTS_NAME ,SHIFT_CODE , SHIFT_STARTTIME , SHIFT_ENDTIME , CONVERT(CHAR(10), [SHIFT_APPLY_STARTTIME], 23) SHIFT_APPLY_STARTTIME ,CONVERT(CHAR(10), [SHIFT_APPLY_ENDTIME], 23) SHIFT_APPLY_ENDTIME , SHIFT_PERSON_DIR , SHIFT_USE_YN , SHIFT_REMARK , SHIFT_TYP from dbo.FACILITY f inner join [SHIFT] s on f.FCLTS_CODE = s.FCLTS_CODE "; cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); list = Helper.DataReaderMapToList <SHIFTList_VO>(reader); cmd.Connection.Close(); } } catch (Exception err) { return(list); } return(list); }
public List <ITEM_VO> GetSearchItem(ITEM_VO vo) { List <ITEM_VO> list = default; try { using (SqlCommand cmd = new SqlCommand()) { AESSalt salt = new AESSalt(); cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = "SP_GetSearchItem"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@P_ITEM_NAME", vo.ITEM_NAME); cmd.Parameters.AddWithValue("@P_ITEM_STND", vo.ITEM_STND); cmd.Parameters.AddWithValue("@P_ITEM_COM_REORDER", vo.ITEM_COM_REORDER); cmd.Parameters.AddWithValue("@P_ITEM_COM_DLVR", vo.ITEM_COM_DLVR); cmd.Parameters.AddWithValue("@P_ITEM_WRHS_IN", vo.ITEM_WRHS_IN); cmd.Parameters.AddWithValue("@P_ITEM_WRHS_OUT", vo.ITEM_WRHS_OUT); cmd.Parameters.AddWithValue("@P_ITEM_MANAGER", vo.ITEM_MANAGER); cmd.Parameters.AddWithValue("@P_ITEM_TYP", vo.ITEM_TYP); cmd.Parameters.AddWithValue("@P_ITEM_USE_YN", vo.ITEM_USE_YN); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); list = Helper.DataReaderMapToList <ITEM_VO>(reader); cmd.Connection.Close(); return(list); } } catch (Exception err) { return(list); } }
/// <summary> /// DB에서 로그인 ID와 비밀번호 확인하는 메서드 /// </summary> /// <param name="userID">사용자ID</param> /// <param name="password">사용자 비밀번호</param> /// <returns></returns> public bool CheckLoginInfo(string userID, string password) { int iCnt = default; try { AESSalt aes = new AESSalt(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = $@"select COUNT(MANAGER_ID) from MANAGER where MANAGER_ID = @MANAGER_ID AND MANAGER_PSWD = @MANAGER_PSWD "; cmd.Parameters.AddWithValue("@MANAGER_ID", userID); cmd.Parameters.AddWithValue("@MANAGER_PSWD", aes.Encrypt(password)); cmd.Connection.Open(); iCnt = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Connection.Close(); } } catch (Exception err) { string msg = err.Message; } return(iCnt > 0 ? true : false); }
public List <ITEM_VO> AllITEM() { List <ITEM_VO> list = default; try { using (SqlCommand cmd = new SqlCommand()) { AESSalt salt = new AESSalt(); cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = @"select ROW_NUMBER() OVER(ORDER BY(SELECT 1)) idx,ITEM_CODE, ITEM_NAME, ITEM_STND, ITEM_UNIT, ITEM_QTY_UNIT, ITEM_TYP, ITEM_INCOME_YN, ITEM_PROCS_YN, ITEM_XPORT_YN, ITEM_FREE_YN, ITEM_COM_DLVR, ITEM_COM_REORDER, ITEM_WRHS_IN, ITEM_WRHS_OUT, ITEM_LEADTIME, ITEM_QTY_REORDER_MIN, ITEM_QTY_STND, ITEM_QTY_SAFE, ITEM_MANAGE_LEVEL, ITEM_MANAGER, ITEM_UNIT_CNVR, ITEM_QTY_CNVR, ITEM_LAST_MDFR, CONVERT(CHAR(10), ITEM_LAST_MDFY, 23)ITEM_LAST_MDFY, ITEM_USE_YN, ITEM_DSCN_YN, ITEM_REORDER_TYP, ITEM_REMARK from ITEM"; cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); list = Helper.DataReaderMapToList <ITEM_VO>(reader); cmd.Connection.Close(); return(list); } } catch (Exception err) { return(list); } }
public Message InsertOrUpdateManager(MANAGER_VO mv) { try { string sql = "SP_SaveUser"; AESSalt aes = new AESSalt(); using (SqlConnection conn = new SqlConnection(this.ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@P_MANAGER_ID", mv.MANAGER_ID); cmd.Parameters.AddWithValue("@P_MANAGER_NAME", mv.MANAGER_NAME); cmd.Parameters.AddWithValue("@P_MANAGER_PSWD", aes.Encrypt(mv.MANAGER_PSWD)); cmd.Parameters.AddWithValue("@P_MANAGER_EML", mv.MANAGER_EML); cmd.Parameters.AddWithValue("@P_MANAGER_DEP", mv.MANAGER_DEP); cmd.Parameters.Add(new SqlParameter("@P_MANAGER_ID", System.Data.SqlDbType.NVarChar, 20)); cmd.Parameters["@P_MANAGER_ID"].Value = mv.MANAGER_ID; cmd.Parameters["@P_MANAGER_ID"].Direction = System.Data.ParameterDirection.Input; cmd.Parameters.Add(new SqlParameter("@P_ReturnCode", System.Data.SqlDbType.NVarChar, 5)); cmd.Parameters["@P_ReturnCode"].Direction = System.Data.ParameterDirection.Output; cmd.ExecuteNonQuery(); conn.Close(); string result = cmd.Parameters["@P_ReturnCode"].Value.ToString(); Message message = new Message(); if (result == "M01") { message.IsSuccess = true; message.ResultMessage = "성공적으로 등록되었습니다."; } else if (result == "M02") { message.IsSuccess = true; message.ResultMessage = "성공적으로 수정되었습니다."; } else if (result == "M03") { message.IsSuccess = false; message.ResultMessage = "이미 등록된 ID 입니다."; } else if (result == "M04") { message.IsSuccess = false; message.ResultMessage = "이미 등록된 EMAIL 입니다."; } return(message); } } } catch (Exception err) { return(new Message(err)); } }