public static bool InsertCrawlerRestartLog(SqlHelper dbHelper, string xlogMessage, Int32 xCrawlerSeq, Int32 xCrawlerMonitorSeq , Int32 xChannelSeq, Int32 xAuthoritySeq, string xIssueDate) { try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xlogMessage", xlogMessage); argdic.Add("xCrawlerSeq", xCrawlerSeq.ToString()); argdic.Add("xCrawlerMonitorSeq", xCrawlerMonitorSeq.ToString()); argdic.Add("xChannelSeq", xChannelSeq.ToString()); argdic.Add("xAuthoritySeq", xAuthoritySeq.ToString()); argdic.Add("xIssueDate", xIssueDate); MySqlDataReader datareader = dbHelper.call_proc("spNewCrawlerInsertLog", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
public static bool InsertCrawlerMonitorInfo(SqlHelper dbHelper, string xIpAddress, Int32 xPort, ref Int32 MonitorSeq) { MonitorSeq = 0; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xIpAddress", xIpAddress); argdic.Add("xPort", xPort.ToString()); MySqlDataReader datareader = dbHelper.call_proc("spNewInsertCrawlerMonitor", argdic); while (datareader.Read()) { MonitorSeq = Convert.ToInt32(datareader["MonitorSeq"]); break; } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } if (MonitorSeq == 0) return false; return true; }
// 크롤러 모니터 삭제 public static bool DeleteCrawlerMonitorInfo(SqlHelper dbHelper, Int32 xMonitorSeq) { try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xMonitorSeq", xMonitorSeq); MySqlDataReader datareader = dbHelper.call_proc("spNewDeleteCrawlerMonitorInfo", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
public static bool Update_CancelOrderInfo(SqlHelper dbHelper, Int32 xOrderSeq, string xChannelOrderCode) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xOrderSeq", xOrderSeq); argdic.Add("xChannelOrderCode", xChannelOrderCode); MySqlDataReader datareader = dbHelper.call_proc("sp_update_OrderCancel", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { LogManager.Instance.Log(ex.Message); bResult = false; } return bResult; }
// 권리사 로그인 정보 로딩 public static bool GetAuthorityLoginList(SqlHelper dbHelper) { try { AuthorityLoginManager.Instance.InitList(); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectAuthorityLogin", null); Int32 ComboBoxIndex = 1; while (datareader.Read()) { AuthorityLoginInfoData pAuthorityLoginInfoData = new AuthorityLoginInfoData(); if (datareader["seq"] != DBNull.Value) pAuthorityLoginInfoData.seq_ = Convert.ToInt32(datareader["seq"]); if (datareader["ChannelSeq"] != DBNull.Value) pAuthorityLoginInfoData.ChannelSeq_ = Convert.ToInt32(datareader["ChannelSeq"]); if (datareader["ChannelName"] != DBNull.Value) pAuthorityLoginInfoData.ChannelName_ = Convert.ToString(datareader["ChannelName"]); if (datareader["PartnerSeq"] != DBNull.Value) pAuthorityLoginInfoData.PartnerSeq_ = Convert.ToInt32(datareader["PartnerSeq"]); if (datareader["AuthorityName"] != DBNull.Value) pAuthorityLoginInfoData.AuthorityName_ = Convert.ToString(datareader["AuthorityName"]); if (datareader["Name"] != DBNull.Value) pAuthorityLoginInfoData.Name_ = Convert.ToString(datareader["Name"]); pAuthorityLoginInfoData.ComboIndex_ = ComboBoxIndex++; AuthorityLoginManager.Instance.GetList().Add(pAuthorityLoginInfoData.seq_, pAuthorityLoginInfoData); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
public static bool Select_tblOrder_With_UID(SqlHelper dbHelper, Int32 xchannelSeq, Int32 xGoodsSeq , /*string sDate, string eDate,*/ref Dictionary<string, COrderData> pList) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xChannelSeq", xchannelSeq); //argdic.Add("xAuthorityLoginSeq", xGoodsSeq); argdic.Add("xGoodsSeq", xGoodsSeq); //argdic.Add("xSDate", sDate); //argdic.Add("xEDate", eDate); //\MySqlDataReader datareader = dbHelper.call_proc("spNewTestSelectOrderInfo", argdic); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectOrderInfo", argdic); while (datareader.Read()) { COrderData pOrderData = new COrderData(); pOrderData.seq_ = Convert.ToInt64(datareader["seq"]); pOrderData.goodsSeq_ = Convert.ToInt32(datareader["goodsSeq"]); pOrderData.memberSeq_ = Convert.ToInt32(datareader["memberSeq"]); pOrderData.channelSeq_ = Convert.ToInt32(datareader["channelSeq"]); pOrderData.channelOrderCode_ = Convert.ToString(datareader["channelOrderCode"]); pOrderData.orderReserveCode_ = Convert.ToString(datareader["orderCode"]); pOrderData.orderID_ = Convert.ToString(datareader["orderId"]); pOrderData.goodsCode_ = Convert.ToString(datareader["ChGoodsCode"]); pOrderData.orderSettlePrice_ = Convert.ToInt32(datareader["orderSettlePrice"]); pOrderData.orderName_ = Convert.ToString(datareader["orderName"]); pOrderData.orderPhone_ = Convert.ToString(datareader["orderPhone"]); //pOrderData.orderMethod_ = Convert.ToString(datareader["orderMethod"]); pOrderData.State_ = Convert.ToString(datareader["State"]); if (pList.ContainsKey(pOrderData.channelOrderCode_) == false) { pList.Add(pOrderData.channelOrderCode_, pOrderData); } else { NewLogManager2.Instance.Log(string.Format("Error Select_tblOrder_With_UID Same OrderCode {0}", pOrderData.channelOrderCode_)); } } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool Select_tblOrder_With_UID - {0}", ex.Message)); bResult = false; } return bResult; }
public static bool Insert_tblOrder_test(SqlHelper dbHelper, Int32 GoodsSeq, Int32 channelSeq, string channelCode, float OrderPrice , Int32 OrderCount, string UserId, string UserName, string UserPhone, string State, string goodsNickName, string goodsOrgName , string RegDate, ref Int32 OrderSeq, ref string pin_m_num) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xchannelSeq", channelSeq); argdic.Add("xchannelCode", channelCode); argdic.Add("xOrderPrice", OrderPrice); argdic.Add("xOrderCount", OrderCount); argdic.Add("xUserId", UserId); argdic.Add("xUserName", UserName); argdic.Add("xUserPhone", UserPhone); argdic.Add("xState", State); argdic.Add("xGoodsSeq", GoodsSeq); argdic.Add("xgoodsNickName", goodsNickName); argdic.Add("xgoodsOrgName", goodsOrgName); argdic.Add("xRegDate", RegDate); MySqlDataReader datareader = dbHelper.call_proc("spNewInsert_chOrder_Free", argdic); string strSeq = ""; while (datareader.Read()) { strSeq = Convert.ToString(datareader["OrderSeq"]); OrderSeq = Convert.ToInt32(strSeq); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool Insert_tblOrder - {0}", ex.Message)); bResult = false; } return bResult; }
// 크롤링 정보 로드 하기 public static bool GetCrawlerInfo(SqlHelper dbHelper, Int32 nChannelIdx, Int32 PartnerIdx, ref LQCrawlerInfo pLQCrawlerInfo) { bool bResult = false; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xChannelIdx", nChannelIdx.ToString()); argdic.Add("xPartnerIdx", PartnerIdx.ToString()); MySqlDataReader datareader = dbHelper.call_proc("sp_select_Crawler_Info", argdic); while (datareader.Read()) { bResult = true; pLQCrawlerInfo = new LQCrawlerInfo(); pLQCrawlerInfo.nIdx_ = Convert.ToInt32(datareader["idx"]); pLQCrawlerInfo.Channel_Idx_ = Convert.ToInt32(datareader["Channel_Idx"]); pLQCrawlerInfo.ChannelName_ = Convert.ToString(datareader["AuthorityName"]); pLQCrawlerInfo.PartnerSeq_ = Convert.ToInt32(datareader["PartnerSeq"]); pLQCrawlerInfo.PartnerName_ = Convert.ToString(datareader["PartnerName"]); pLQCrawlerInfo.MainUrl_ = Convert.ToString(datareader["MainUrl"]); // 메인 URL pLQCrawlerInfo.LoginIDTAG_ = Convert.ToString(datareader["LoginIDTAG"]); pLQCrawlerInfo.LoginPWTAG_ = Convert.ToString(datareader["LoginPWTAG"]); pLQCrawlerInfo.LoginUrl_ = Convert.ToString(datareader["LoginUrl"]); pLQCrawlerInfo.LoginParam_ = Convert.ToString(datareader["LoginParam"]); // 로그인 셋팅값 pLQCrawlerInfo.LoginID_ = Convert.ToString(datareader["LoginID"]); // 로그인 아이디 pLQCrawlerInfo.LoginPW_ = Convert.ToString(datareader["LoginPW"]); // 로그인 암호 pLQCrawlerInfo.LoginMethod_ = Convert.ToString(datareader["LoginMethod"]); // 로그인 방식 pLQCrawlerInfo.LoginEvent_ = Convert.ToString(datareader["LoginEvent"]); // 로그인 버튼 이벤트 pLQCrawlerInfo.LoginCheck_ = Convert.ToString(datareader["LoginCheck"]); pLQCrawlerInfo.LoginType_ = Convert.ToChar(datareader["LoginType"]); pLQCrawlerInfo.ExcelDownUrl_ = Convert.ToString(datareader["ExcelDownUrl"]); // 엑셀 다운로드 URL pLQCrawlerInfo.ExcelDownParameter_ = Convert.ToString(datareader["ExcelDownParameter"]); pLQCrawlerInfo.ExcelDownMethod_ = Convert.ToString(datareader["ExcelDownMethod"]); // 엑셀 다운로드 방식 pLQCrawlerInfo.ExcelDownRule_ = Convert.ToString(datareader["ExcelDownRule"]); pLQCrawlerInfo.UseGoodsUrl_ = Convert.ToString(datareader["UseGoodsUrl"]); pLQCrawlerInfo.UseGoodsParam_ = Convert.ToString(datareader["UseGoodsParam"]); pLQCrawlerInfo.UseGoodsCheck_ = Convert.ToString(datareader["UseGoodsCheck"]); pLQCrawlerInfo.UseGoodsRule_ = Convert.ToString(datareader["UseGoodsRule"]); pLQCrawlerInfo.UseUserUrl_ = Convert.ToString(datareader["UseUserUrl"]); pLQCrawlerInfo.UseUserParam_ = Convert.ToString(datareader["UseUserParam"]); pLQCrawlerInfo.UseUserCheck_ = Convert.ToString(datareader["UseUserCheck"]); pLQCrawlerInfo.NUseGoodsUrl_ = Convert.ToString(datareader["NUseGoodsUrl"]); pLQCrawlerInfo.NUseGoodsParam_ = Convert.ToString(datareader["NUseGoodsParam"]); pLQCrawlerInfo.NUseGoodsCheck_ = Convert.ToString(datareader["NUseGoodsCheck"]); pLQCrawlerInfo.NUseGoodsRule_ = Convert.ToString(datareader["NUseGoodsRule"]); pLQCrawlerInfo.NUseUserUrl_ = Convert.ToString(datareader["NUseUserUrl"]); pLQCrawlerInfo.NUseUserParam_ = Convert.ToString(datareader["NUseUserParam"]); pLQCrawlerInfo.NUseUserCheck_ = Convert.ToString(datareader["NUseUserCheck"]); pLQCrawlerInfo.RUseUserUrl_ = Convert.ToString(datareader["RUseUserUrl"]); pLQCrawlerInfo.RUseUserParam_ = Convert.ToString(datareader["RUseUserParam"]); pLQCrawlerInfo.RUseUserCheck_ = Convert.ToString(datareader["RUseUserCheck"]); pLQCrawlerInfo.ExData_Start_ = Convert.ToInt32(datareader["ExData_Start"]); pLQCrawlerInfo.ExData_Coupncode_ = Convert.ToInt32(datareader["ExData_Coupncode"]); pLQCrawlerInfo.ExData_Buydate_ = Convert.ToInt32(datareader["ExData_Buydate"]); pLQCrawlerInfo.ExData_Option_ = Convert.ToInt32(datareader["ExData_Option"]); pLQCrawlerInfo.ExData_Cancel_ = Convert.ToInt32(datareader["ExData_Cancel"]); pLQCrawlerInfo.ExData_Count_ = Convert.ToInt32(datareader["ExData_Count"]); pLQCrawlerInfo.ExData_Use_ = Convert.ToInt32(datareader["ExData_Use"]); pLQCrawlerInfo.ExData_Buyer_ = Convert.ToInt32(datareader["ExData_Buyer"]); pLQCrawlerInfo.ExData_Buyphone_ = Convert.ToInt32(datareader["ExData_Buyphone"]); pLQCrawlerInfo.ExData_Price_ = Convert.ToInt32(datareader["ExData_Price"]); pLQCrawlerInfo.ExData_UseCheck_ = Convert.ToString(datareader["ExData_UseCheck"]); pLQCrawlerInfo.ExData_CancelCheck_ = Convert.ToString(datareader["ExData_CancelCheck"]); break; } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool GetCrawlerInfo - {0}", ex.Message)); bResult = false; } return bResult; }
// 모든 크롤러 정보 로드 하기 public bool SelectAllChannelInfos() { try { SqlHelper pMySqlDB = new SqlHelper(); pMySqlDB.Connect(CrawlerInfoManager.Instance.method_, CrawlerInfoManager.Instance.dbip_, CrawlerInfoManager.Instance.dbport_, CrawlerInfoManager.Instance.dbname_ , CrawlerInfoManager.Instance.dbaccount_, CrawlerInfoManager.Instance.dbpw_, CrawlerInfoManager.Instance.sshhostname_, CrawlerInfoManager.Instance.sshuser_ , CrawlerInfoManager.Instance.sshpw_); MySqlDataReader datareader = pMySqlDB.call_proc("sp_select_All_Crawler_Info", null); while (datareader.Read()) { LQCrawlerInfo pInfo = new LQCrawlerInfo(); pInfo.nIdx_ = Convert.ToInt32(datareader["idx"]); pInfo.Channel_Idx_ = Convert.ToInt32(datareader["Channel_Idx"]); pInfo.ChannelName_ = Convert.ToString(datareader["Channel_Name"]); pInfo.PartnerSeq_ = Convert.ToInt32(datareader["PartnerSeq"]); pInfo.PartnerName_ = Convert.ToString(datareader["PartnerName"]); // 권리사 (2014-07-30) . 추가 pInfo.AuthoritySeq_ = Convert.ToInt32(datareader["AuthoritySeq"]); pInfo.AuthoriryName_ = Convert.ToString(datareader["AuthorityName"]); pInfo.MainUrl_ = Convert.ToString(datareader["MainUrl"]); // 메인 URL pInfo.LoginIDTAG_ = Convert.ToString(datareader["LoginIDTAG"]); pInfo.LoginPWTAG_ = Convert.ToString(datareader["LoginPWTAG"]); pInfo.LoginUrl_ = Convert.ToString(datareader["LoginUrl"]); pInfo.LoginParam_ = Convert.ToString(datareader["LoginParam"]); // 로그인 셋팅값 pInfo.LoginID_ = Convert.ToString(datareader["LoginID"]); // 로그인 아이디 pInfo.LoginPW_ = Convert.ToString(datareader["LoginPW"]); // 로그인 암호 pInfo.LoginMethod_ = Convert.ToString(datareader["LoginMethod"]); // 로그인 방식 pInfo.LoginEvent_ = Convert.ToString(datareader["LoginEvent"]); // 로그인 버튼 이벤트 pInfo.LoginCheck_ = Convert.ToString(datareader["LoginCheck"]); pInfo.LoginType_ = Convert.ToChar(datareader["LoginType"]); pInfo.ExcelDownUrl_ = Convert.ToString(datareader["ExcelDownUrl"]); // 엑셀 다운로드 URL pInfo.ExcelDownParameter_ = Convert.ToString(datareader["ExcelDownParameter"]); pInfo.ExcelDownMethod_ = Convert.ToString(datareader["ExcelDownMethod"]); // 엑셀 다운로드 방식 pInfo.ExcelDownRule_ = Convert.ToString(datareader["ExcelDownRule"]); pInfo.UseGoodsUrl_ = Convert.ToString(datareader["UseGoodsUrl"]); pInfo.UseGoodsParam_ = Convert.ToString(datareader["UseGoodsParam"]); pInfo.UseGoodsCheck_ = Convert.ToString(datareader["UseGoodsCheck"]); pInfo.UseGoodsRule_ = Convert.ToString(datareader["UseGoodsRule"]); pInfo.UseUserUrl_ = Convert.ToString(datareader["UseUserUrl"]); pInfo.UseUserParam_ = Convert.ToString(datareader["UseUserParam"]); pInfo.UseUserCheck_ = Convert.ToString(datareader["UseUserCheck"]); pInfo.NUseGoodsUrl_ = Convert.ToString(datareader["NUseGoodsUrl"]); pInfo.NUseGoodsParam_ = Convert.ToString(datareader["NUseGoodsParam"]); pInfo.NUseGoodsCheck_ = Convert.ToString(datareader["NUseGoodsCheck"]); pInfo.NUseGoodsRule_ = Convert.ToString(datareader["NUseGoodsRule"]); pInfo.NUseUserUrl_ = Convert.ToString(datareader["NUseUserUrl"]); pInfo.NUseUserParam_ = Convert.ToString(datareader["NUseUserParam"]); pInfo.NUseUserCheck_ = Convert.ToString(datareader["NUseUserCheck"]); pInfo.RUseUserUrl_ = Convert.ToString(datareader["RUseUserUrl"]); pInfo.RUseUserParam_ = Convert.ToString(datareader["RUseUserParam"]); pInfo.RUseUserCheck_ = Convert.ToString(datareader["RUseUserCheck"]); pInfo.ExData_Start_ = Convert.ToInt32(datareader["ExData_Start"]); pInfo.ExData_Coupncode_ = Convert.ToInt32(datareader["ExData_Coupncode"]); pInfo.ExData_Buydate_ = Convert.ToInt32(datareader["ExData_Buydate"]); pInfo.ExData_Option_ = Convert.ToInt32(datareader["ExData_Option"]); pInfo.ExData_Cancel_ = Convert.ToInt32(datareader["ExData_Cancel"]); pInfo.ExData_Use_ = Convert.ToInt32(datareader["ExData_Use"]); pInfo.ExData_Buyer_ = Convert.ToInt32(datareader["ExData_Buyer"]); pInfo.ExData_Count_ = Convert.ToInt32(datareader["ExData_Count"]); pInfo.ExData_Buyphone_ = Convert.ToInt32(datareader["ExData_Buyphone"]); pInfo.ExData_Price_ = Convert.ToInt32(datareader["ExData_Price"]); pInfo.ExData_UseCheck_ = Convert.ToString(datareader["ExData_UseCheck"]); pInfo.ExData_CancelCheck_ = Convert.ToString(datareader["ExData_CancelCheck"]); CrawlerInfoList_.Add(pInfo.AuthoritySeq_, pInfo); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { LogManager.Instance.Log(string.Format("채널정보 로드 실패 {0}",ex.Message)); return false; } return true; }
// 상품 옵션명, 옵션 닉네임 변경 public static bool UpdateGoodsNickName(SqlHelper dbHelper, Int32 xGoodsSeq, string xGoodsNickName, string xGoodsOptionNickName) { try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xGoodsSeq", xGoodsSeq.ToString()); argdic.Add("xGoodsNickName", xGoodsNickName); argdic.Add("xGoodsOptionNickName", xGoodsOptionNickName); MySqlDataReader datareader = dbHelper.call_proc("spNewUpdateGoodsNickName", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
// 모니터 정보 변경 public static bool UpdateCrawlerMonitorInfo(SqlHelper dbHelper, Int32 xMonitorSeq, string xCrawlerName, Int32 xChannelSeq, string xChannelName , Int32 xAuthoritySeq, string xAuthorityName, Int32 xCrawlerSeq, Int32 xMode, string xCrawler_OnOff, string xCrawler_location, Int32 xCrawlerCheckTime , Int32 xDBUpdateTime, string xMemo, Int32 xAuthorityLoginSeq, string xAuthorityLoginName) { try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xMonitorSeq", xMonitorSeq.ToString()); argdic.Add("xCrawlerName", xCrawlerName); argdic.Add("xChannelSeq", xChannelSeq.ToString()); argdic.Add("xChannelName", xChannelName); argdic.Add("xAuthoritySeq", xAuthoritySeq.ToString()); argdic.Add("xAuthorityName", xAuthorityName); argdic.Add("xAuthorityLoginSeq", xAuthorityLoginSeq.ToString()); argdic.Add("xAuthorityLoginName", xAuthorityLoginName); argdic.Add("xCrawlerSeq", xCrawlerSeq.ToString()); argdic.Add("xMode", xMode.ToString()); argdic.Add("xCrawler_OnOff", xCrawler_OnOff.ToString()); argdic.Add("xCrawler_location", xCrawler_location); argdic.Add("xCrawlerCheckTime", xCrawlerCheckTime.ToString()); argdic.Add("xDBUpdateTime", xDBUpdateTime.ToString()); argdic.Add("xMemo", xMemo); MySqlDataReader datareader = dbHelper.call_proc("spNewUpdateCrawlerMonitorInfo", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
// 크롤링 정보 로드 public static bool GetAllCrawlerMonitor(SqlHelper dbHelper) { try { CInfoManager.Instance.InitList(); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectCrawlerMonitor", null); while (datareader.Read()) { CrawlerData pCrawlerData = new CrawlerData(); if (datareader["seq"] != null) pCrawlerData.seq_ = Convert.ToInt32(datareader["seq"]); if (datareader["CrawlerName"] != null && datareader["CrawlerName"] != DBNull.Value) pCrawlerData.CrawlerName_ = Convert.ToString(datareader["CrawlerName"]); if (datareader["ChannelSeq"] != null && datareader["ChannelSeq"] != DBNull.Value) pCrawlerData.ChannelSeq_ = Convert.ToInt32(datareader["ChannelSeq"]); if (datareader["ChannelName"] != null && datareader["ChannelName"] != DBNull.Value) pCrawlerData.ChannelName_ = Convert.ToString(datareader["ChannelName"]); if (datareader["AuthoritySeq"] != null && datareader["AuthoritySeq"] != DBNull.Value) pCrawlerData.AuthoritySeq_ = Convert.ToInt32(datareader["AuthoritySeq"]); if (datareader["AuthorityName"] != null && datareader["AuthorityName"] != DBNull.Value) pCrawlerData.AuthorityName_ = Convert.ToString(datareader["AuthorityName"]); if (datareader["AuthorityLoginSeq"] != null && datareader["AuthorityLoginSeq"] != DBNull.Value) pCrawlerData.AuthorityLoginSeq_ = Convert.ToInt32(datareader["AuthorityLoginSeq"]); if (datareader["AuthorityLoginName"] != null && datareader["AuthorityLoginName"] != DBNull.Value) pCrawlerData.AuthorityLoginName_ = Convert.ToString(datareader["AuthorityLoginName"]); if (datareader["CrawlerSeq"] != null && datareader["CrawlerSeq"] != DBNull.Value) pCrawlerData.CrawlerSeq_ = Convert.ToInt32(datareader["CrawlerSeq"]); if (datareader["Mode"] != null && datareader["Mode"] != DBNull.Value) pCrawlerData.Mode_ = Convert.ToInt32(datareader["Mode"]); if (datareader["Memo"] != null && datareader["Memo"] != DBNull.Value) pCrawlerData.Memo_ = Convert.ToString(datareader["Memo"]); if (datareader["IP"] != null && datareader["IP"] != DBNull.Value) pCrawlerData.IP_ = Convert.ToString(datareader["IP"]); if (datareader["CrawlerState"] != null && datareader["CrawlerState"] != DBNull.Value) pCrawlerData.CrawlerState_ = Convert.ToString(datareader["CrawlerState"]); if (datareader["UpdateDate"] != null && datareader["UpdateDate"] != DBNull.Value) pCrawlerData.UpdateDate_ = Convert.ToString(datareader["UpdateDate"]); CInfoManager.Instance.GetList().Add(pCrawlerData.seq_, pCrawlerData); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
// 매니저 로그인 public static bool LoginManager(SqlHelper dbHelper, string id, string pw) { Int32 SelectCount = 0; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xAdminId", id); argdic.Add("xAdminPw", pw); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectAdminLogin", argdic); while (datareader.Read()) { CInfoManager.Instance.AdminInfoData_.Seq_ = Convert.ToInt32(datareader["Seq"]); CInfoManager.Instance.AdminInfoData_.adminName_ = Convert.ToString(datareader["adminName"]); CInfoManager.Instance.AdminInfoData_.Mobile_ = Convert.ToString(datareader["Mobile"]); SelectCount++; break; } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } if (SelectCount == 0) return false; return true; }
// 상품 정보 로드하기 public static bool GetGoodsTable(SqlHelper dbHelper) { try { GoodsManager.Instance.InitList(); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectGoods", null); while (datareader.Read()) { CGoodsData pCGoodsData = new CGoodsData(); if (datareader["seq"] != DBNull.Value) pCGoodsData.Seq_ = Convert.ToInt32(datareader["seq"]); if (datareader["GoodsCode"] != DBNull.Value) pCGoodsData.Goods_Code_ = Convert.ToString(datareader["GoodsCode"]); if (datareader["GoodsName"] != DBNull.Value) pCGoodsData.GoodsName_ = Convert.ToString(datareader["GoodsName"]); if (datareader["GoodsNick"] != DBNull.Value) pCGoodsData.GoodsNickName_ = Convert.ToString(datareader["GoodsNick"]); if (datareader["GoodsOptionName"] != DBNull.Value) pCGoodsData.OptionName_ = Convert.ToString(datareader["GoodsOptionName"]); if (datareader["GoodsNickName"] != DBNull.Value) pCGoodsData.OptionNickName_ = Convert.ToString(datareader["GoodsNickName"]); if (datareader["ChannelSeq"] != DBNull.Value) pCGoodsData.ChannelSeq_ = Convert.ToInt32(datareader["ChannelSeq"]); if (datareader["AuthoritySeq"] != DBNull.Value) pCGoodsData.AuthoritySeq_ = Convert.ToInt32(datareader["AuthoritySeq"]); if (datareader["AuthorityLoginSeq"] != DBNull.Value) pCGoodsData.AuthorityLoginSeq_ = Convert.ToInt32(datareader["AuthorityLoginSeq"]); if (datareader["CrawlerSeq"] != DBNull.Value) pCGoodsData.CrawlerSeq_ = Convert.ToInt32(datareader["CrawlerSeq"]); if (datareader["State"] != DBNull.Value) pCGoodsData.State_ = Convert.ToString(datareader["State"]); GoodsManager.Instance.GetList().Add(pCGoodsData.Seq_, pCGoodsData); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
// 채널 정보 로드 public static bool GetChannelList(SqlHelper dbHelper) { try { ChannelManager.Instance.InitList(); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectChannel", null); Int32 ComboIndex = 1; while (datareader.Read()) { ChannelInfoData pChannelInfoData = new ChannelInfoData(); if (datareader["seq"] != DBNull.Value) pChannelInfoData.seq_ = Convert.ToInt32(datareader["seq"]); if (datareader["ChannelCode"] != DBNull.Value) pChannelInfoData.ChannelCode_ = Convert.ToString(datareader["ChannelCode"]); if (datareader["ChannelName"] != DBNull.Value) pChannelInfoData.ChannelName_ = Convert.ToString(datareader["ChannelName"]); pChannelInfoData.ComboIndex_ = ComboIndex++; // 콤보 박스에서 사용되는 인덱스 ChannelManager.Instance.GetList().Add(pChannelInfoData.seq_, pChannelInfoData); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
public static bool UpdateCrawlerMonitorInfo(SqlHelper dbHelper, Int32 xMonitorSeq, string xIpAddress, Int32 xPort, string xCrawlerState , ref Int32 Result, ref Int32 ChannelSeq, ref Int32 AuthoritySeq, ref Int32 Mode, ref Int32 CrawlerSeq) { Result = 0; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xMonitorSeq", xMonitorSeq.ToString()); argdic.Add("xIpAddress", xIpAddress); argdic.Add("xPort", xPort.ToString()); argdic.Add("xCrawlerState", xCrawlerState); MySqlDataReader datareader = dbHelper.call_proc("spNewUpdateCrawlerMonitor", argdic); while (datareader.Read()) { Result = Convert.ToInt32(datareader["RESULT"]); if (Result == 0) { break; } if (datareader["AuthoritySeq"] != DBNull.Value) AuthoritySeq = Convert.ToInt32(datareader["AuthoritySeq"]); if (datareader["ChannelSeq"] != DBNull.Value) ChannelSeq = Convert.ToInt32(datareader["ChannelSeq"]); if (datareader["Mode"] != DBNull.Value) Mode = Convert.ToInt32(datareader["Mode"]); if (datareader["CrawlerSeq"] != DBNull.Value) CrawlerSeq = Convert.ToInt32(datareader["CrawlerSeq"]); break; } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { return false; } return true; }
// DB 에서 상품 코드 읽어오기 public static bool GetGoodsTableWithUID(SqlHelper dbHelper, Int32 nChannelIdx, Int32 nAuthorityIdx, Int32 nUID, ref Dictionary<Int32, ChannelGoodInfo> pInfoList) { pInfoList.Clear(); bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xChannelSeq", nChannelIdx.ToString()); argdic.Add("xAuthoritySeq", nAuthorityIdx.ToString()); argdic.Add("xCrawlerSeq", nUID.ToString()); MySqlDataReader datareader = dbHelper.call_proc("spNewSelectGoodsInfo", argdic); string availableData = ""; while (datareader.Read()) { ChannelGoodInfo pGoodInfo = new ChannelGoodInfo(); pGoodInfo.Idx_ = Convert.ToInt32(datareader["seq"]); pGoodInfo.Goods_Code_ = Convert.ToString(datareader["ChGoodsCode"]); pGoodInfo.GoodsName_ = Convert.ToString(datareader["GoodsName"]); pGoodInfo.GoodsNickName_ = Convert.ToString(datareader["GoodsNick"]); pGoodInfo.GoodsPassType_ = Convert.ToString(datareader["GoodsPassType"]); pGoodInfo.GoodsSendType_ = Convert.ToInt32(datareader["GoodsSendType"]); pGoodInfo.sDate_ = Convert.ToString(datareader["GoodsSdate"]); pGoodInfo.eDateFormat_ = Convert.ToString(datareader["GoodsEdateFormat"]); availableData = Convert.ToString(datareader["AvailableDate"]); pGoodInfo.OptionName_ = Convert.ToString(datareader["GoodsOptionName"]); pGoodInfo.OptionNickName_ = Convert.ToString(datareader["GoodsNickName"]); pGoodInfo.GoodsAttrType_ = Convert.ToInt32(datareader["GoodsAttrType"]); if (string.IsNullOrEmpty(pGoodInfo.Goods_Code_) == true) { string LogMessage = string.Format("bool GetGoodsTable 상품코드가 지정되어 있지 않아서 상품은 건너 뜁니다.{0}/{1}" , pGoodInfo.Goods_Code_, pGoodInfo.GoodsName_); NewLogManager2.Instance.Log(LogMessage); continue; } if (string.IsNullOrEmpty(pGoodInfo.OptionNickName_) == true) { string LogMessage = string.Format("bool GetGoodsTable 상품 옵션명이 지정되지 않아서 이 상품은 건너 뜁니다.{0}/{1}" , pGoodInfo.Goods_Code_, pGoodInfo.OptionNickName_); NewLogManager2.Instance.Log(LogMessage); continue; } if (string.IsNullOrEmpty(availableData) == false) { if (Regex.IsMatch(availableData, @"^(19|20)\d{2}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[0-1])$") == true) { pGoodInfo.availableDateTime_ = Convert.ToDateTime(availableData); pGoodInfo.Expired_ = true; } } pInfoList.Add(pGoodInfo.Idx_, pGoodInfo); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool GetGoodsTableWithUID - {0}", ex.Message)); bResult = false; } return bResult; }
public static bool Insert_SMS(SqlHelper dbHelper, Int32 xSOrderSeq, Int32 xEOrderSeq) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xSOrderSeq", xSOrderSeq); argdic.Add("xEOrderSeq", xEOrderSeq); MySqlDataReader datareader = dbHelper.call_proc("sp_insert_Sms", argdic); //string strSeq = ""; //while (datareader.Read()) //{ // strSeq = Convert.ToString(datareader["OrderSeq"]); //} datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { LogManager.Instance.Log(ex.Message); bResult = false; } return bResult; }
public static bool Insert_SMS(SqlHelper dbHelper, Int32 xSOrderSeq, Int32 xEOrderSeq) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xSOrderSeq", xSOrderSeq); argdic.Add("xEOrderSeq", xEOrderSeq); //MySqlDataReader datareader = dbHelper.call_proc("sp_insert_BARCODE", argdic); MySqlDataReader datareader = dbHelper.call_proc("sp_insert_Sms", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool Insert_SMS - {0}", ex.Message)); bResult = false; } return bResult; }
// 쿠폰 정보 입력. public static bool Insert_tblWrongOrder(SqlHelper dbHelper, Int32 xchannelSeq, string xchannelOrderCode, float xorderSettlePrice , string xorderName, string xorderOptionName, Int32 xorderCount, string xorderPhone, string xstate) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xchannelSeq", xchannelSeq); argdic.Add("xchannelOrderCode", xchannelOrderCode); argdic.Add("xorderSettlePrice", xorderSettlePrice); argdic.Add("xorderName", xorderName); argdic.Add("xorderOptionName", xorderOptionName); argdic.Add("xorderPhone", xorderPhone); argdic.Add("xorderCount", xorderCount); argdic.Add("xstate", xstate); MySqlDataReader datareader = dbHelper.call_proc("sp_insert_tblWrongOrder", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { LogManager.Instance.Log(ex.Message); bResult = false; } return bResult; }
// 각각의 상태 정보 로드 public static bool SelectStateTable(SqlHelper dbHelper) { DealStateManager.Instance.Init(); bool bResult = true; try { MySqlDataReader datareader = dbHelper.call_proc("sp_select_StateTable", null); while (datareader.Read()) { Int32 nStateType = Convert.ToInt32(datareader["StateType"]); string strStateName = Convert.ToString(datareader["StateName"]); string strExplain = Convert.ToString(datareader["Explain"]); DealStateManager.Instance.Add(nStateType, strStateName, strExplain); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool SelectStateTable - {0}", ex.Message)); bResult = false; } return bResult; }
// DB에서 사용처리 해야하는 테이블 로드 public static bool Select_tblOrder(SqlHelper dbHelper, Int32 xchannelSeq) { bool bResult = true; try { // 2014.06.05 Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xChannelIdx", xchannelSeq); MySqlDataReader datareader = dbHelper.call_proc("sp_select_OrderInfo", argdic); while (datareader.Read()) { tblOrderData pOrderData = new tblOrderData(); pOrderData.NeedDBProc_ = tblOrderData.NeedDBProc.None; pOrderData.seq_ = Convert.ToInt64(datareader["seq"]); pOrderData.goodsSeq_ = Convert.ToInt32(datareader["goodsSeq"]); pOrderData.memberSeq_ = Convert.ToInt32(datareader["memberSeq"]); pOrderData.channelSeq_ = Convert.ToInt32(datareader["channelSeq"]); pOrderData.channelOrderCode_ = Convert.ToString(datareader["channelOrderCode"]); pOrderData.orderReserveCode_ = Convert.ToString(datareader["orderCode"]); pOrderData.orderID_ = Convert.ToString(datareader["orderId"]); pOrderData.orderSettlePrice_ = Convert.ToInt32(datareader["orderSettlePrice"]); pOrderData.orderName_ = Convert.ToString(datareader["orderName"]); pOrderData.orderPhone_ = Convert.ToString(datareader["orderPhone"]); //pOrderData.orderMethod_ = Convert.ToString(datareader["orderMethod"]); pOrderData.State_ = Convert.ToString(datareader["State"]); OrderManager.Instance.AddOrderData(pOrderData); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { LogManager.Instance.Log(ex.Message); bResult = false; } return bResult; }
// 사용처리 원래대로 되돌리는 프로시저 public static bool Update_OrderInfo_FixUP(SqlHelper dbHelper, Int32 xOrderSeq, string xState) { bool bResult = true; try { Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xOrderSeq", xOrderSeq); argdic.Add("xState", xState); MySqlDataReader datareader = dbHelper.call_proc("spNewUpdateSyncOrderInfo", argdic); datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { NewLogManager2.Instance.Log(string.Format("Error bool Update_OrderInfo_FixUP - {0}", ex.Message)); bResult = false; } return bResult; }
public static bool Select_tblOrderWr(SqlHelper dbHelper, Int32 xchannelSeq) { bool bResult = true; try { // 2014.06.05 Dictionary<string, object> argdic = new Dictionary<string, object>(); argdic.Add("xChannelIdx", xchannelSeq); MySqlDataReader datareader = dbHelper.call_proc("sp_select_OrderWrInfo", argdic); while (datareader.Read()) { tblOrderData pOrderData = new tblOrderData(); pOrderData.channelOrderCode_ = Convert.ToString(datareader["channelOrderCode"]); pOrderData.NeedDBProc_ = tblOrderData.NeedDBProc.None; OrderManager.Instance.AddWrongData(pOrderData); } datareader.Close(); datareader.Dispose(); datareader = null; } catch (System.Exception ex) { LogManager.Instance.Log(ex.Message); bResult = false; } return bResult; }