/// <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));
}
}
