/// <summary>
/// Export Site 1차 사이트 아이디로 찾기
/// </summary>
/// <param name="siteId"></param>
/// <returns></returns>
public List<ExportSecondSite> ExportSecondSiteListId(string siteId)
{
List<ExportSecondSite> list = new List<ExportSecondSite>();
QueryComplete param = Query.EQ("siteId", ObjectId.Parse(siteId));
ExportSite ex = new CommonDac().GetExportSiteView(param);
if (ex.second_site.Count > 0)
{
list = ex.second_site;
}
return list;
}
/// <summary>
/// Export Site 1차 사이트 명으로 찾기
/// </summary>
/// <param name="siteName"></param>
/// <returns></returns>
public List<ExportSecondSite> ExportSecondSiteListName(string siteName)
{
List<ExportSecondSite> list = new List<ExportSecondSite>();
QueryComplete param = Query.EQ("site_name", siteName);
ExportSite ex = new CommonDac().GetExportSiteView(param);
if (ex.second_site.Count > 0)
{
list = ex.second_site;
}
return list;
}
private string ItemCompareSelItem(BsonArray arrSel_no, int sel_qty, int sel_price)
{
List<GEPItemGmarketVerifySelOptionT> list = new List<GEPItemGmarketVerifySelOptionT>();
foreach (var data in arrSel_no)
{
string sel_no = data.ToString();
GEPItemGmarketVerifySelOptionT selInfo = new CommonDac().GetCompareVerifySelItem(sel_no);
list.Add(selInfo);
}
bool boolcompareQty = false;
int comapreQty = sel_qty;
int comparePrice = sel_price;
foreach (var data in list)
{
if (data.Yn == "Y")
{
boolcompareQty = true;
if (comapreQty > data.Qty)
{
comapreQty = data.Qty;
}
}
comparePrice += data.Price;
}
// 재고 비교
if (boolcompareQty)
{
if (comapreQty != sel_qty)
{
if (comparePrice != sel_price)
{
return "F4";
}
else
{
return "F3";
}
}
else
{
if (comparePrice != sel_price)
{
return "F2";
}
else
{
return "S";
}
}
}
else
{
if (comparePrice != sel_price)
{
return "F2";
}
else
{
return "S";
}
}
}
private string ItemCompareDeliveryCondition(string gd_no, string feeCondition)
{
GmarketVerifyDeliveryFeeT deliveryFee = new CommonDac().GetCompareDeliveryCondition(gd_no);
if (feeCondition == deliveryFee.DeliveryFeeCondition)
{
return "S";
}
else
{
return "F9";
}
}
/// <summary>
/// Export site의 second site 조회 MVC SelectBox용
/// </summary>
/// <param name="exportSite">Export Site</param>
/// <returns>Export site login ID List</returns>
public IEnumerable<SelectListItem> GetSecondSites(string exportSite)
{
List <SelectListItem> SecondSites = new List<SelectListItem>();
ExportSite site = new CommonDac().GetExportSiteView(Query.EQ("site_name",exportSite));
if (site != null && site.second_site != null)
{
SecondSites = (from s in site.second_site where s.use_yn == true select new SelectListItem { Text = s.second_site_name, Value = s.second_siteId.ToString() }).ToList<SelectListItem>();
SecondSites.Insert(0, new SelectListItem{Text="-- All --", Value="-1"});
}
return SecondSites;
}
/// <summary>
/// Export 사이트 리스트
/// </summary>
/// <returns></returns>
public IEnumerable<SelectListItem> GetExportSites()
{
IQueryable<ExportSite> sites = new CommonDac().GetExportSite();
return (from s in sites select new SelectListItem { Text = s.site_name, Value=s._id.ToString()});
}
/// <summary>
/// Export Site 2차 사이트 아이디로 찾기
/// </summary>
/// <param name="siteId"></param>
/// <returns></returns>
public ExportSecondSite ExportSecondSiteView(int siteId)
{
ExportSecondSite returnSite = null;
QueryComplete param = Query.EQ("second_site.second_siteId", siteId);
List<ExportSecondSite> list = new CommonDac().GetExportSiteView(param).second_site;
if (list.Count > 0)
{
returnSite = list[0];
}
return returnSite;
}