///----------------------------------------------------------------------------------
/// <summary>
/// 상품 조회, 2019-09-19
/// </summary>
/// <param name="intSeqNo"></param>
/// <param name="strModuleName"></param>
/// <param name="pl_objDT"></param>
/// <param name="pl_strErrMsg"></param>
/// <returns></returns>
///----------------------------------------------------------------------------------
public static int GetProductList(string strStoreCode, string strCashAttrCode, int intProductTypeCode, out DataTable objDT, out string strErrMsg)
{
int pl_intRetVal = 0;
IDas pl_objDas = null;
strErrMsg = "OK";
objDT = null;
try
{
pl_objDas = new IDas();
pl_objDas.Open(UserGlobal.BOQ_HOST_DAS);
pl_objDas.CommandType = CommandType.StoredProcedure;
pl_objDas.CodePage = 0;
pl_objDas.AddParam("@pi_strStoreCode", DBType.adVarChar, strStoreCode, 50, ParameterDirection.Input);
pl_objDas.AddParam("@pi_strCashAttrCode", DBType.adVarChar, strCashAttrCode, 15, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intProductTypeCode", DBType.adTinyInt, intProductTypeCode, 0, ParameterDirection.Input);
pl_objDas.AddParam("@po_strErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
pl_objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
pl_objDas.AddParam("@po_strDBErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
pl_objDas.AddParam("@po_intDBRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
pl_objDas.SetQuery("dbo.UP_POS_PRODUCT_UR_LST");
if (!pl_objDas.LastErrorCode.Equals(0))
{
pl_intRetVal = pl_objDas.LastErrorCode;
strErrMsg = pl_objDas.LastErrorMessage;
return(pl_intRetVal);
}
objDT = new DataTable();
objDT = pl_objDas.objDT;
}
catch (Exception pl_objEx)
{
pl_intRetVal = -15701;
strErrMsg = "상품 목록 조회 실패";
UtilLog.WriteExceptionLog(pl_objEx.Message, pl_objEx.StackTrace);
}
finally
{
if (pl_objDas != null)
{
pl_objDas.Close();
pl_objDas = null;
}
}
return(pl_intRetVal);
}
//이벤트 입력
private int InsFamilyEventJoin(int intUserNo, Int64 intFamilyEventNo, out string strErrMsg)
{
int pl_intRetVal = 0;
IDas pl_objDas = null;
strErrMsg = string.Empty;
try
{
//사용자 정보 조회
pl_objDas = new IDas();
pl_objDas.Open(UserGlobal.BOQ_HOST_DAS);
pl_objDas.CommandType = CommandType.StoredProcedure;
pl_objDas.CodePage = 0;
pl_objDas.AddParam("@pi_intUserNo", DBType.adInteger, intUserNo, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intFamilyEventNo", DBType.adBigInt, intFamilyEventNo, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intUserRole", DBType.adTinyInt, 3, 0, ParameterDirection.Input);
pl_objDas.AddParam("@po_strErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
pl_objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 4, ParameterDirection.Output);
pl_objDas.AddParam("@po_strDBErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
pl_objDas.AddParam("@po_intDBRetVal", DBType.adInteger, DBNull.Value, 4, ParameterDirection.Output);
pl_objDas.SetQuery("dbo.UP_FAMILY_EVENT_JOIN_TX_INS");
pl_intRetVal = Convert.ToInt32(pl_objDas.GetParam("@po_intRetVal"));
strErrMsg = Convert.ToString(pl_objDas.GetParam("@po_strErrMsg"));
}
catch (Exception pl_objEx)
{
pl_intRetVal = -15213;
strErrMsg = pl_objEx.Message + pl_objEx.StackTrace;
UtilLog.WriteExceptionLog(pl_objEx.Message, pl_objEx.StackTrace);
}
finally
{
if (pl_objDas != null)
{
pl_objDas.Close();
pl_objDas = null;
}
if (!pl_intRetVal.Equals(0))
{
UtilLog.WriteLog("GetUserCurrentPwd", pl_intRetVal, strErrMsg);
}
}
return(pl_intRetVal);
}
///================================================================================
/// Name : PrintProductTypeDDLB
/// Description : <summary>일반 구매 시 사용되는 상품 타입 리스트 박스를 정의한다.</summary>
/// Author : [email protected], 2019-11-21
/// Modify History : Just Created.
///================================================================================
public static string PrintProductTypeDDLB(bool boolDefault, HtmlType objHtmlType = HtmlType.freeItemProductType)
{
IDas pl_objDAS = null;
StringBuilder pl_objSb = null;
try
{
pl_objSb = new StringBuilder();
pl_objDAS = new IDas();
pl_objDAS.Open(UserGlobal.BOQ_HOST_DAS);
pl_objDAS.CommandType = CommandType.StoredProcedure;
pl_objDAS.CodePage = 0;
pl_objDAS.AddParam("@pi_strDisplayFlag", DBType.adChar, 'Y', 1, ParameterDirection.Input);
pl_objDAS.SetQuery("dbo.UP_PRODUCT_TYPE_UR_LST");
if (boolDefault)
{
pl_objSb.Append(MakeOption("0", "전체", objHtmlType));
}
while (pl_objDAS.Read())
{
pl_objSb.Append(MakeOption(pl_objDAS.GetString("PRODUCTTYPECODE"), pl_objDAS.GetString("PRODUCTTYPEDESC"), objHtmlType));
}
pl_objDAS.CloseTable();
}
finally
{
if (pl_objDAS != null)
{
pl_objDAS.Close();
}
pl_objDAS = null;
}
return(pl_objSb.ToString());
}
public int InsPGPayLog(out string strErrMsg)
{
int pl_intRetVal = 0;
string pl_strCashReceiptNo = string.Empty;
IDas pl_objDas = null;
strErrMsg = string.Empty;
try
{
pl_objDas = new IDas();
pl_objDas.Open(UserGlobal.BOQ_HOST_DAS);
pl_objDas.CommandType = CommandType.StoredProcedure;
pl_objDas.CodePage = 0;
pl_objDas.AddParam("@pi_intFamilyEventNo", DBType.adBigInt, pb_intEventNo, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intJoinMstCategory", DBType.adTinyInt, pb_intJoinMstCategory, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intJoinSubCategory", DBType.adTinyInt, pb_intJoinSubCategory, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intUserNo", DBType.adInteger, objSes.intUserNo, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intPayAmt", DBType.adDouble, pb_intPayAmt, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_strPGCode", DBType.adVarChar, pb_strPGCode, 50, ParameterDirection.Input);
pl_objDas.AddParam("@pi_intPayTool", DBType.adTinyInt, pb_intPaytool, 0, ParameterDirection.Input);
pl_objDas.AddParam("@pi_strPayToolName", DBType.adVarChar, pb_strPaytoolName, 50, ParameterDirection.Input);
pl_objDas.AddParam("@po_strErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
pl_objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
pl_objDas.AddParam("@po_strDBErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
pl_objDas.AddParam("@po_intDBRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
pl_objDas.SetQuery("dbo.UP_PAYMENT_TX_INS");
if (!pl_objDas.LastErrorCode.Equals(0))
{
pl_intRetVal = pl_objDas.LastErrorCode;
strErrMsg = pl_objDas.LastErrorMessage;
return(pl_intRetVal);
}
strErrMsg = pl_objDas.GetParam("@po_strErrMsg");
pl_intRetVal = Convert.ToInt32(pl_objDas.GetParam("@po_intRetVal"));
if (!pl_intRetVal.Equals(0))
{
return(pl_intRetVal);
}
}
catch (Exception pl_objEx)
{
pl_intRetVal = -15705;
strErrMsg = pl_objEx.Message + pl_objEx.StackTrace;
UtilLog.WriteExceptionLog(pl_objEx.Message, pl_objEx.StackTrace);
}
finally
{
if (pl_objDas != null)
{
pl_objDas.Close();
pl_objDas = null;
}
}
return(pl_intRetVal);
}