public void List_DoloadData(BuyleadAction action)
{
ViewBag.PageSize = 19;
var svBuylead = new BuyleadService();
sqlSelect = "BuyleadID,BuyleadName,BuyleadIMGPath,Remark,RowFlag,CompID,CateLV1,CateLV2,CateLV3,RowVersion";
sqlWhere = svBuylead.CreateWhereAction(action) + " AND ListNo = 0 ";
sqlOrderBy = " ModifiedDate DESC ";
#region DoWhereCause
sqlWhere += svBuylead.CreateWhereCause(LogonCompID, ViewBag.TextSearch, (int)ViewBag.PStatus,
(int)ViewBag.CateLevel, (int)ViewBag.CateID);
if (!string.IsNullOrEmpty(ViewBag.Period))
{
sqlWhere += SQLWhereDateTimeFromPeriod(ViewBag.Period, "ModifiedDate");
}
#endregion
var Buyleads = svBuylead.SelectData <b2bBuylead>(sqlSelect, sqlWhere, sqlOrderBy, (int)ViewBag.PageIndex, (int)ViewBag.PageSize);
ViewBag.Buyleads = Buyleads;
ViewBag.LogonCompID = LogonCompID;
ViewBag.TotalRow = svBuylead.TotalRow;
ViewBag.TotalPage = svBuylead.TotalPage;
}
//
// GET: /Admin/ApproveBuylead/
public void List_DoloadData(BuyleadAction action)
{
var svBuylead = new BuyleadService();
string sqlSelect, sqlWhere, sqlOrderBy = "";
sqlSelect = "BuyleadID,BuyleadName,BuyleadEmail,RowFlag,CompID,CompName,RowVersion,Remark,CateLV1,CateLV2,CateLV3,Modifieddate,CreatedDate,AdminCode,CompCode,CreatedBy,ModifiedBy,CategoryType";
sqlWhere = svBuylead.CreateWhereAction(action) + " ";
sqlOrderBy = " CreatedDate DESC ";
#region DoWhereCause
sqlWhere += svBuylead.CreateWhereCause(0, "", (int)ViewBag.PStatus);
sqlWhere += svBuylead.CreateWhereSearchBy(ViewBag.TextSearch, ViewBag.SearchType);
if (!string.IsNullOrEmpty(ViewBag.Period))
{
sqlWhere += SQLWhereDateTimeFromPeriod(ViewBag.Period, "CreatedDate");
}
#endregion
var Buyleads = svBuylead.SelectData <view_SearchBuylead>(sqlSelect, sqlWhere, sqlOrderBy, (int)ViewBag.PageIndex, (int)ViewBag.PageSize);
ViewBag.Buyleads = Buyleads;
ViewBag.LogonCompID = LogonCompID;
ViewBag.TotalRow = svBuylead.TotalRow;
ViewBag.TotalPage = svBuylead.TotalPage;
}
//
// GET: /Admin/ApproveBuylead/
public void List_DoloadData(BuyleadAction action)
{
var svOrder = new OrderService();
string sqlWhere, sqlOrderBy = "";
sqlWhere = "IsDelete = 0 ";
sqlOrderBy = " CreatedDate DESC ";
#region DoWhereCause
sqlWhere += svOrder.CreateWhereCause("", ViewBag.PStatus, ViewBag.PSType);
sqlWhere += svOrder.CreateWhereSearchBy(ViewBag.TextSearch, ViewBag.SearchType);
if (!string.IsNullOrEmpty(ViewBag.Period))
{
sqlWhere += SQLWhereDateTimeFromPeriod(ViewBag.Period, "CreatedDate");
}
#endregion
var OrderComp = svOrder.SelectData <view_OrderDetailComp>("*", sqlWhere, sqlOrderBy, (int)ViewBag.PageIndex, (int)ViewBag.PageSize);
ViewBag.OrderComp = OrderComp;
ViewBag.LogonCompID = LogonCompID;
ViewBag.TotalRow = svOrder.TotalRow;
ViewBag.TotalPage = svOrder.TotalPage;
}
public string CreateWhereAction(BuyleadAction action, int?CompID = 0)
{
var sqlWhere = string.Empty;
#region Condition
if (action == BuyleadAction.All)
{
sqlWhere = "( IsDelete = 0 ) ";
}
else if (action == BuyleadAction.FrontEnd)
{
//comprowflag มาจาก b2bcompany.rowflag
sqlWhere = "( IsDelete = 0 AND RowFlag IN (4)) AND ( IsShow = 1 AND IsJunk = 0 )";
}
else if (action == BuyleadAction.BackEnd)
{
sqlWhere = "( IsDelete = 0 AND ( RowFlag >= 2 AND RowFlag <=6 ) AND IsJunk = 0 ) ";
}
else if (action == BuyleadAction.Junk)
{
sqlWhere = "( IsDelete = 0 AND ( RowFlag >= 2 AND RowFlag <=6 ) AND IsJunk = 1 ) ";
}
else if (action == BuyleadAction.Admin)
{
sqlWhere = "( IsDelete = 0 AND ( RowFlag >= 2 AND RowFlag <=6 ) AND IsJunk = 0 ) ";
}
else if (action == BuyleadAction.WebSite)
{
sqlWhere = "( IsDelete = 0 AND RowFlag IN (2,4,5,6) ) AND ( IsShow = 1 AND IsJunk = 0 ) ";
}
else if (action == BuyleadAction.Recommend)
{
sqlWhere = "( IsDelete = 0 AND RowFlag IN (4,5,6)) AND ( IsShow = 1 AND IsJunk = 0 ) AND (ListNo > 0)";
}
if (CompID > 0)
{
sqlWhere += "AND (CompID = " + CompID + ")";
}
#endregion
return(sqlWhere);
}
public void List_DoloadData(BuyleadAction action)
{
ViewBag.Title = res.Product.lblBuyleadList;
string sqlSelect, sqlWhere, sqlOrderBy = "";
var svBuylead = new BuyleadService();
sqlSelect = "BuyleadID,Qty,QtyUnit,ModifiedDate,BuyleadName,BuyleadNameEng,BuyleadExpDate,BuyleadType,CompBuyleadCount,CompID,CompName,CompLevel,BizTypeName,BizTypeOther,BuyleadImgPath,CateLV3,CategoryName,LogoImgPath";
#region DoWhereCause
sqlWhere = svBuylead.CreateWhereAction(action);
sqlWhere += svBuylead.CreateWhereCause(0, ViewBag.txtSearch, 0, 1, (int)ViewBag.CateID, (int)ViewBag.BuyleadType, 0, (int)ViewBag.ProvinceID);
//var sqlwherein = "";
//switch (res.Common.lblWebsite)
//{
// case "B2BThai": sqlwherein = " AND CategoryType IN (1,2)"; break;
// case "AntCart": sqlwherein = " AND CategoryType IN (3)"; break;
// case "myOtopThai": sqlwherein = " AND CategoryType IN (5)"; break;
// case "AppstoreThai": sqlwherein = " AND CategoryType IN (6) "; break;
// default: sqlwherein = ""; break;
//}
//sqlWhere += sqlwherein;
if (ViewBag.BuyleadExpDate != 0)
{
sqlWhere += " ";
}
else if (ViewBag.BuyleadNotExpDate != 0)
{
sqlWhere += " AND (convert(nvarchar(20), BuyleadExpDate,112) > '" + DateTime.Today.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US")) + "')";
}
#endregion
#region Order By
if (ViewBag.BuyleadNotExpDate != 0)
{
sqlOrderBy = "CreatedDate DESC";
}
else
{
sqlOrderBy = "BuyleadExpDate DESC";
}
//if (ViewBag.CreatedDate != 0)
// if (ViewBag.CreatedDate == 1)
// sqlOrderBy = "CreatedDate DESC";
#endregion
#region query
var Buyleads = svBuylead.SelectData <view_BuyLead>(sqlSelect, sqlWhere, sqlOrderBy, (int)ViewBag.PageIndex, (int)ViewBag.PageSize);
ViewBag.Buyleads = Buyleads;
if (ViewBag.txtSearch != "")
{
ViewBag.Title += ViewBag.txtSearch;
}
if (svBuylead.TotalRow > 0)
{
if ((int)ViewBag.CateID > 0)
{
ViewBag.Title += " | " + Buyleads.First().CategoryName;
}
if ((int)ViewBag.ProvinceID > 0)
{
ViewBag.Title += " | " + Buyleads.First().ProvinceName;
}
}
ViewBag.Title += " | " + res.Common.lblDomainShortName;
ViewBag.MetaKeyword = ViewBag.Title;
ViewBag.MetaDescription = ViewBag.Title;
ViewBag.TotalRow = svBuylead.TotalRow;
//if (svBuylead.TotalRow.ToString().Length > 2)
// ViewBag.TotalRow = String.Format("{0:0,0}", svBuylead.TotalRow);
ViewBag.TotalPage = svBuylead.TotalPage;
if (svBuylead.TotalPage.ToString().Length > 2)
{
ViewBag.TotalPage = String.Format("{0:0,0}", svBuylead.TotalPage);
}
#endregion
//#region Buyer
//string CateLV3 = string.Empty;
//if (ViewBag.Buyleads != null)
//{
// if (Buyleads.Count > 0)
// {
// for (int x = 0; x < Buyleads.Count; x++)
// {
// CateLV3 += Buyleads[x].CateLV3 + ",";
// }
// CateLV3 = CateLV3.Substring(0, CateLV3.Length - 1);
// var Buyer = svBuylead.SelectData<view_PurchaseComp>("*", "CateLV3 IN (" + CateLV3 + ") AND RowFlag IN(2,4) AND ProductCount > 0 ", "CompID",0,0);
// ViewBag.Buyer = Buyer;
// }
//}
//#endregion
}
