spc-kiosk-pb/Service/BsvBasic/EtcInEmp.cs

450 lines
18 KiB
C#
Raw Permalink Normal View History

2019-06-16 05:12:09 +00:00
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Cosmos.Common;
using Cosmos.UserFrame;
using Cosmos.CommonManager;
using Cosmos.ServiceProvider;
/*-----------------------------------------------------------------------------------------------*/
// 설 명 : 직원방문등록
// 작 성 자 :
// 변경 이력 :
/*-----------------------------------------------------------------------------------------------*/
namespace Cosmos.Service
{
class EtcInEmp : IDataServiceUs
{
private SManager sManager = new SManager(); // 이 객체를 통해 업무 Service 호출
private PosStatus m_cPosStatus = new PosStatus(); //기본정보 참조
private DeviceStatus m_cDevStatus = new DeviceStatus(); // 디바이스 관리
private StateServer StateObject = (StateServer)StateServer.GetInstance(); // StateObject : StateServer Object (객체)
private ISvr2Tran m_cSvr2Tran = null; // 서버시간 동기화
private IDatabaseSQL m_cSqlDbService = null; // 데이터베이스 관리
public EtcInEmp()
{
m_cPosStatus = (PosStatus)StateObject.POS; // POS 기본정보
//m_cTrnStatus = (TranStatus)StateObject.TRAN; // POS 거래정보
m_cDevStatus = (DeviceStatus)StateObject.DEVICE;
m_cSqlDbService = (IDatabaseSQL)sManager.InitServiceInstance(ServiceLists.AGENT_DATABASE.DLL, ServiceLists.AGENT_DATABASE.DATABASE_MSSQL);
m_cSvr2Tran = (ISvr2Tran)sManager.InitServiceInstance(ServiceLists.BSV_SALE.DLL, ServiceLists.BSV_SALE.SVR2TRAN);
}
/// <summary>
/// 직원방문등록 조회
/// </summary>
/// <returns></returns>
public object GetData(string[] aParam)
{
string sQuery = "";
DataTable dt = null;
try
{
if (aParam[0] == "List")
{
sQuery += " SELECT ";
sQuery += " MNG_CARD_NO";
sQuery += " , SUBSTRING(VISIT_START_HOUR,9,2) +':'+SUBSTRING(VISIT_START_HOUR,11,2) +':'+SUBSTRING(VISIT_START_HOUR,13,2) ";
sQuery += " , SUBSTRING(VISIT_FNSH_HOUR,9,2) +':'+SUBSTRING(VISIT_FNSH_HOUR,11,2) +':'+SUBSTRING(VISIT_FNSH_HOUR,13,2) ";
//#20170828 직원방문등록 시 고객센터전화요망 팝업 쿼리문에 VISIT_DT 필드가 없음 start
//#20170829 직원방문등록에 방문시간 표시 날짜로 되어 쿼리 순서 변경
sQuery += " , VISIT_DT";
//#20170828 직원방문등록 시 고객센터전화요망 팝업 쿼리문에 VISIT_DT 필드가 없음 end
sQuery += " FROM POSLOG..TR_STORE_VISIT ";
sQuery += " WHERE CMP_CD = '" + m_cPosStatus.Base.CmpCd + "'";
sQuery += " AND VISIT_DT = '" + aParam[1] + "'";
sQuery += " AND STOR_CD = '" + m_cPosStatus.Base.StoreNo + "'";
sQuery += " AND POS_NO = '" + m_cPosStatus.Base.PosNo + "'";
if (aParam[2] != "")
{
sQuery += " AND MNG_CARD_NO = '" + aParam[2] + "'";
}
sQuery += " ORDER BY UPD_DATE DESC ";
}
else if (aParam[0] == "Time")
{
sQuery = string.Format(" SELECT DATEDIFF(SECOND,CONVERT(DATETIME,'{0}'),GETDATE()) AS IGAP", aParam[1]);
}
if (sQuery != "")
{
int iRet = m_cSqlDbService.DBSelect(sQuery, out dt);
if (iRet == 1) return dt;
}
}
catch (Exception ex)
{
WinManager.ExceptionMessage(System.Reflection.Assembly.GetExecutingAssembly().ManifestModule.Name,
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name + "()", ex.Message);
}
return null;
}
/// <summary>
/// 없음!
/// </summary>
/// <param name="oParam"></param>
/// <returns></returns>
public string SetData(object oParam)
{
throw new NotImplementedException();
}
/// <summary>
/// 직원 방문 및 제조기사 등록 저장
/// </summary>
/// <param name="aParam"></param>
/// <returns></returns>
public string Execute(string[] aParam)
{
string sQuery = "";
string sRet = UserCom.RST_ERR;
string sVisitDate = "";
string sCardNo = "";
string sInputData = "";
try
{
aParam[0] = aParam[0].Replace("\n", "");
if (InputDataCheck(aParam[0], ref sCardNo, ref aParam[3]) == true)
{
if (sCardNo != "")
aParam[0] = sCardNo;
if (aParam[0].Length > 16)
aParam[0] = CmUtil.MidH(aParam[0], 0, 16);
}
else
{
return sRet;
}
//#20171103 제조기사 출/퇴근조건 수정 start,phj
//기존
/*
//DateTime.Now.ToString("yyyyMMdd")
//00 ~ 05시 사이면 이전 일자 체크
int iTime = CmUtil.IntParse(DateTime.Now.ToString("HHmm"));
if (iTime >= 0 && iTime <= 500)
{
//이전일자
DataTable dt = (DataTable)GetData(new string[] { "List", DateTime.Now.AddDays(-1).ToString("yyyyMMdd"), aParam[0] });
if (dt == null || dt.Rows.Count == 0)
{
sVisitDate = DateTime.Now.ToString("yyyyMMdd");
}
else
{
sVisitDate = dt.Rows[0]["VISIT_DT"].ToString();
}
}
else
{
sVisitDate = DateTime.Now.ToString("yyyyMMdd");
}
*/
//변경
//출근찍고, 퇴근안찍고, 다음 날 출근 시 퇴근처리 됨.
//날짜가 다르면 출근 처리하도록 수정.
sVisitDate = DateTime.Now.ToString("yyyyMMdd");
//#20171103 제조기사 출/퇴근조건 수정 end,phj
//0:관리 카드 번호, 1:방문시간, 2:종료시간, 3:MSR구분, 4: 원바코드 번호
string sRegDateTime = DateTime.Now.ToString("yyyyMMddHHmmss");
sQuery = " UPDATE POSLOG.dbo.TR_STORE_VISIT SET ";
sQuery += " VISIT_FNSH_HOUR = '{6}' , SEND_YN = '0', UPD_DATE = '{13}' ";
sQuery += " WHERE CMP_CD = '{0}'";
sQuery += " AND STOR_CD = '{1}'";
sQuery += " AND VISIT_DT = '{2}'";
sQuery += " AND POS_NO = '{3}'";
sQuery += " AND MNG_CARD_NO = '{4}'";
sQuery += " AND VISIT_FNSH_HOUR = '' ";
sQuery += " IF @@ROWCOUNT = 0 ";
sQuery += " BEGIN ";
sQuery += " INSERT INTO POSLOG.dbo.TR_STORE_VISIT( ";
sQuery += " CMP_CD ,STOR_CD ,VISIT_DT ,POS_NO ,MNG_CARD_NO ,VISIT_START_HOUR ,VISIT_FNSH_HOUR ,VISIT_USER_ID ,JOB_TYPE ,PCSMM_SEND_YN ";
sQuery += " ,MSR_DIV ,ORG_BAR_CD_NO ,SEND_YN ,REG_DATE ,UPD_DATE ";
sQuery += " ) VALUES ( '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '', '{7}', '{8}' , '{9}', ";
sQuery += " '{10}','{11}', '{12}', '{13}', '{14}' )";
sQuery += " END ";
sQuery = string.Format(sQuery
, m_cPosStatus.Base.CmpCd // CMP_CD
, m_cPosStatus.Base.StoreNo // STOR_CD
// Mod, 2017.08.30, VISIT_DT 조회오류 수정
//, DateTime.Now.ToString("yyyyMMdd") // SALE_DT
, sVisitDate // SALE_DT
, m_cPosStatus.Base.PosNo // POS_NO
, aParam[0] // MNG_CARD_NO
, aParam[1] // VISIT_START_HOUR
, aParam[2] // VISIT_FNSH_HOUR
, "" // VISIT_USER_ID
, "" // JOB_TYPE
, "0" // PCSMM_SEND_YN
, aParam[3] // MSR_DIV
, aParam[4] // ORG_BAR_CD_NO
, "0" // SEND_YN
, sRegDateTime // REG_DATE
, sRegDateTime // UPD_DATE
);
if (m_cSqlDbService.DBExecuteNonQuery(new string[] { sQuery }) == UserCom.OK) return UserCom.RST_OK;
}
catch (Exception ex)
{
WinManager.ExceptionMessage(System.Reflection.Assembly.GetExecutingAssembly().ManifestModule.Name,
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name + "()", ex.Message);
}
return sRet;
}
/// <summary>
/// 입력 번호 체크
/// </summary>
/// <param name="sInData"></param>
/// <param name="sCard"></param>
/// <param name="sInType"></param>
/// <returns></returns>
private bool InputDataCheck(string sInData, ref string sCard, ref string sInType)
{
bool bRet = false;
int iDefualtLen = 0;
int iDefualtGap = 0;
string sAddNum = "";
try
{
SetServerSysDateTime();
if (m_cDevStatus.Msr.STX != "" && sInData.StartsWith(m_cDevStatus.Msr.STX)) sInData = sInData.Substring(1);
int iLastEtx = sInData.LastIndexOf(m_cDevStatus.Msr.ETX);
if (m_cDevStatus.Msr.ETX != "" && iLastEtx > 0) sInData = CmUtil.MidH(sInData, 0, iLastEtx);
if (m_cPosStatus.Mst.CorpDiv == ItemConst.CORP_DIV.PC &&
(m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.KR || m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.CN ||
m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.US || m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.VN) //PC(한국, 중국, 미국, 베트남)
)
{
if (m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.KR) //한국
{
iDefualtLen = 22;
iDefualtGap = 30;
}
else
{
iDefualtLen = 19;
iDefualtGap = 60;
}
if (sInData.Length == iDefualtLen)
{
sAddNum = CmUtil.MidH(sInData, 19, 3).Replace("A", " ").Trim();
//#20170803 제조기사 바코드에 'ㅁ' 들어오는 경우 공백 처리 start
sAddNum = sAddNum.Replace("ㅁ", " ").Trim();
//#20170803 제조기사 바코드에 'ㅁ' 들어오는 경우 공백 처리 end
char[] uchars = sInData.ToCharArray();
sCard = string.Format("{0}{1}{2}{3}{4}{5}{6}{7}"
, uchars[0], uchars[3], uchars[6], uchars[9], uchars[12], uchars[15], uchars[18], m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.KR ? sAddNum : "");
string sTimeCheck = string.Format("20{0}{1}-{2}{3}-{4}{5} {6}{7}:{8}{9}:{10}{11}"
, uchars[1], uchars[2], uchars[4], uchars[5], uchars[7], uchars[8], uchars[10], uchars[11]
, uchars[13], uchars[14], uchars[16], uchars[17]);
DataTable dt = null;
DateTime tmpDt;
bool bDateFlag = DateTime.TryParse(sTimeCheck, out tmpDt);
if (bDateFlag == true)
{
dt = (DataTable)GetData(new string[] { "Time", sTimeCheck });
}
int iGap = 0;
if (dt == null || dt.Rows.Count == 0)
{
// 유효하지 않은 바코드
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0328));
// Add, 2017.08.30
return bRet = false;
}
else
{
iGap = CmUtil.IntParse(dt.Rows[0]["IGAP"].ToString());
}
if (iGap > iDefualtGap)
{
//유효기간이 만료 되었습니다.
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0329));
}
else if (iGap < 0)
{
// 유효하지 않은 바코드
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0328));
}
else
{
//정상!
sInType = ItemConst.EMP_VISIT_DIV.MOBILE;
bRet = true;
}
}
else
{
////국내일땐 에러!
//if (m_cPosStatus.Base.CmpCd == "PCKR")
//{
// WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0328));
//}
//else
//{
// 입력 데이터 그대로 입력!
sCard = sInData;
sInType = ItemConst.EMP_VISIT_DIV.MSR;
bRet = true;
//}
}
}
else if (m_cPosStatus.Mst.CorpDiv == ItemConst.CORP_DIV.BR) //BRK
{
if (sInData.Contains("=") == true)
{
bRet = sInData.StartsWith("8231");
if (bRet == true)
{
sCard = sInData;
sInType = ItemConst.EMP_VISIT_DIV.MSR;
}
else
{
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0330));
}
}
else
{
if (sInData.Length != 17)
{
//에러
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0328));
}
else
{
bRet = CmUtil.CheckHappyMobileCard(sInData);
if (bRet == false)
{
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0328));
}
else
{
sCard = sInData;
sInType = ItemConst.EMP_VISIT_DIV.MOBILE;
}
}
}
}
else if (m_cPosStatus.Mst.CorpDiv == ItemConst.CORP_DIV.SL ||
(m_cPosStatus.Mst.CorpDiv == ItemConst.CORP_DIV.PC && (m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.SG || m_cPosStatus.Mst.CntryDiv == ItemConst.CNTRY_DIV.FR))
) //삼립, PC싱가포르, PC프랑스
{
if (sInData.Length == 7 || sInData.Length == 16)
{
//정상!
sInType = ItemConst.EMP_VISIT_DIV.MSR;
bRet = true;
}
else
{
//정확한 직원카드를 입력하세요.
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0330));
}
}
else
{
//해당 없음!
WinManager.ErrorMessage(MessageManager.GetErrorMessage(POS_MESSAGE.ERROR.MSG_0331));
}
}
catch (Exception ex)
{
WinManager.ExceptionMessage(System.Reflection.Assembly.GetExecutingAssembly().ManifestModule.Name,
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name + "()", ex.Message);
}
return bRet;
}
/// <summary>
/// 서버 시간 동기화
/// </summary>
private void SetServerSysDateTime()
{
try
{
// 서버 시간 동기화
string sRet = m_cSvr2Tran.ServerSysDateTime();
}
catch (Exception ex)
{
WinManager.ExceptionMessage(System.Reflection.Assembly.GetExecutingAssembly().ManifestModule.Name,
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name + "()", ex.Message);
}
}
}
}