/// <summary>
/// 비밀번호를 변경합니다.
/// </summary>
/// <param name="keyCode"></param>
/// <param name="userID"></param>
/// <param name="macAddress"></param>
/// <param name="allowKeyCount"></param>
/// <returns></returns>
public static void UpdateChangePassword(string userID, string password)
{
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@USERID", userID);
param.Add("@PASSWORD", password);
string procedureName = "SP_PASSWORD_UPDATE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
da.ExecuteNonQuery(command);
}
catch (Exception ex)
{
WriteTextLog("UpdateChangePassword", ex.Message.ToString() + ex.StackTrace.ToString());
}
finally
{
DisConnect(ref da);
}
}
/// <summary>
/// KeyWord 정보를 추가합니다.
/// </summary>
/// <param name="userid"></param>
/// <param name="password"></param>
/// <param name="macAddress"></param>
/// <param name="authCode"></param>
/// <returns></returns>
public static string DeleteUserAgent(string userAgent)
{
string result = "001";
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@USER_AGENT", userAgent);
string procedureName = "SP_USER_AGENT_DELETE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
result = da.GetSingleValue(command).ToString();
}
catch (Exception ex)
{
WriteTextLog("DeleteUserAgent", ex.Message.ToString());
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="createKeyCodeCount">생성할 건수</param>
/// <param name="saleType">판매타입</param>
public static int CreateProductINfo(int createKeyCodeCount, SaleType saleType)
{
int result = createKeyCodeCount;
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@SALE_TYPE", saleType.ToString().ToUpper());
param.Add("@KEYCODE_COUNT", createKeyCodeCount);
string procedureName = "SP_KEY_CODE_CREATE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
da.ExecuteNonQuery(command);
}
catch (Exception ex)
{
WriteTextLog("CreateProductINfo", ex.Message.ToString());
result = 0;
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
/// 상품정보를 업데이트 합니다.
/// </summary>
/// <param name="keyCode"></param>
/// <param name="userID"></param>
/// <param name="macAddress"></param>
/// <param name="allowKeyCount"></param>
/// <returns></returns>
public static string DeleteProductInfo(string keyCode)
{
string result = "001";
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@KEY_CODE", keyCode);
string procedureName = "SP_PRODUCT_INFO_DELETE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
result = da.GetSingleValue(command).ToString();
}
catch (Exception ex)
{
WriteTextLog("DeleteProductInfo", ex.Message.ToString());
result = "005";
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static DataTable UserAgentList()
{
DataTable dt = new DataTable();
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
string procedureName = "SP_USER_AGENT_LIST";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
dt = da.GetData(command);
}
catch (Exception ex)
{
}
finally
{
DisConnect(ref da);
}
return(dt);
}
/// <summary>
/// 사용자 정보를 가져옵니다.
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static DataTable GetProductList(SaleType saleType, SearchType searchType, string keyword, string searchCount)
{
DataTable dt = new DataTable();
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
string procedureName = "SP_GET_PRODUCT_LIST";
ParameterEngine param = ParameterEngine.New(da);
param.Add("@SEARCH_TYPE", searchType.ToString().ToUpper());
param.Add("@SALE_TYPE", saleType.ToString().ToUpper());
param.Add("@KEY_WORD", keyword);
param.Add("@SEARCH_COUNT", searchCount);
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
dt = da.GetData(command);
}
catch (Exception ex)
{
WriteTextLog("GetUserList", ex.Message.ToString());
}
finally
{
DisConnect(ref da);
}
return(dt);
}
/// <summary>
/// 사용자정보를 추가합니다.
/// </summary>
/// <param name="userid"></param>
/// <param name="password"></param>
/// <param name="macAddress"></param>
/// <param name="authCode"></param>
/// <returns></returns>
public static int DeleteUserInfo(string userid, string keyCode)
{
int result = -1;
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@USERID", userid);
param.Add("@KEY_CODE", keyCode);
string procedureName = "SP_USERINFO_DELETE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
result = da.ExecuteNonQuery(command);
}
catch (Exception ex)
{
WriteTextLog("DeleteUserInfo", ex.Message.ToString());
result = -1;
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
/// 사용자정보를 추가합니다.
/// </summary>
/// <param name="userid"></param>
/// <param name="password"></param>
/// <param name="macAddress"></param>
/// <param name="authCode"></param>
/// <returns></returns>
public static string UpdateUserInfo(string userid, string password, string authCode)
{
string result = "001";
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@USERID", userid);
param.Add("@PASSWORD", password);
param.Add("@KEY_CODE", authCode);
string procedureName = "SP_USERINFO_UPDATE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
result = da.GetSingleValue(command).ToString();
}
catch (Exception ex)
{
WriteTextLog("UpdateUserInfo", ex.Message.ToString());
result = "005";
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
/// KeyWord 정보를 추가합니다.
/// </summary>
/// <param name="userid"></param>
/// <param name="password"></param>
/// <param name="macAddress"></param>
/// <param name="authCode"></param>
/// <returns></returns>
public static void UpdateIPChangFlage(string userid, string flag)
{
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@USERID", userid);
param.Add("@FLAG", flag);
string procedureName = "SP_UPDATE_IPCHANGE_FLAG";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
da.ExecuteNonQuery(command);
}
catch (Exception ex)
{
WriteTextLog("InsertKeyWordInfo", ex.Message.ToString());
}
finally
{
DisConnect(ref da);
}
}
/// <summary>
/// 상품정보를 업데이트 합니다.
/// </summary>
/// <param name="keyCode"></param>
/// <param name="userID"></param>
/// <param name="macAddress"></param>
/// <param name="allowKeyCount"></param>
/// <returns></returns>
public static void UpdateProductInfo(string keyCode, string userID, string macAddress, int allowKeyCount)
{
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@KEY_CODE", keyCode);
param.Add("@USERID", userID);
param.Add("@MACADDRESS", macAddress);
param.Add("@ALLOW_KEYWORD_CNT", allowKeyCount);
string procedureName = "SP_PRODUCT_INFO_UPDATE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
da.ExecuteNonQuery(command);
}
catch (Exception ex)
{
WriteTextLog("UpdateProductInfo", ex.Message.ToString() + ex.StackTrace.ToString());
}
finally
{
DisConnect(ref da);
}
}
/// <summary>
/// KeyWord 정보를 추가합니다.
/// </summary>
/// <param name="userid"></param>
/// <param name="password"></param>
/// <param name="macAddress"></param>
/// <param name="authCode"></param>
/// <returns></returns>
public static string InsertKeyWordInfo(string keycode, string keyword, string url, int maxpage, int delaytimest, int delaytimeet)
{
string result = "001";
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@KEY_CODE", keycode);
param.Add("@KEYWORD", keyword);
param.Add("@URL", url);
param.Add("@MAXPAGE", maxpage);
param.Add("@DELAYTIME_ST", delaytimest);
param.Add("@DELAYTIME_ET", delaytimeet);
string procedureName = "SP_KEYWORDINFO_INSERT";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
result = da.GetSingleValue(command).ToString();
}
catch (Exception ex)
{
result = "004";
WriteTextLog("InsertKeyWordInfo", ex.Message.ToString());
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
/// 상품정보를 업데이트 합니다.
/// </summary>
/// <param name="keyCode"></param>
/// <param name="userID"></param>
/// <param name="macAddress"></param>
/// <param name="allowKeyCount"></param>
/// <returns></returns>
public static string UpdateProductInfo(string userID, string password, string keyCode, string macAddress, int allowKeyCount, string fromDt, string toDt, string saleCode, string saleDate, string dealCode)
{
string result = "001";
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@KEY_CODE", keyCode);
param.Add("@USERID", userID);
param.Add("@PWD", password);
param.Add("@MACADDRESS", macAddress);
param.Add("@ALLOW_KEYWORD_CNT", allowKeyCount);
param.Add("@FROM_DT", fromDt);
param.Add("@TO_DT", toDt);
param.Add("@SALE_CODE", saleCode);
param.Add("@SALE_DATE", saleDate);
param.Add("@DEAL_CODE", dealCode);
string procedureName = "SP_PRODUCT_INFO_ALL_UPDATE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
result = da.GetSingleValue(command).ToString();
}
catch (Exception ex)
{
WriteTextLog("UpdateProductInfo", ex.Message.ToString());
result = "005";
}
finally
{
DisConnect(ref da);
}
return(result);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <string> UserAgentList()
{
List <string> result = new List <string>();
DataTable dt = new DataTable();
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
string procedureName = "SP_USER_AGENT_LIST";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
dt = da.GetData(command);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
result.Add(dr["USER_AGENT"].ToString());
}
}
}
catch (Exception ex)
{
}
finally
{
DisConnect(ref da);
}
return(result);
}
