public PagedList <ORG_STORE_EX> QueryAllStoreDateEx(StoreSearch search, PageView view)
{
string sql = @"A.[ID],A.[STORE_NO],A.[ORG_ID],B.[ORG_NAME],A.[NAME],A.[TYPE],A.[BRAND],A.[PROVINCE],A.[CITY],A.[REGION]
,A.[ADDRESS],A.[MANAGER],A.[TELEPHONE],A.[OPEN_DATE],A.[CLOSE_DATE],A.[STATUS]";
string sqlWhere = "";
if (!string.IsNullOrEmpty(search.SNAME))
{
sqlWhere += " AND A.[NAME] LIKE '%" + search.SNAME + "%'";
}
if (!string.IsNullOrEmpty(search.STYPE))
{
sqlWhere += " AND A.[TYPE] = '" + search.STYPE + "'";
}
if (!string.IsNullOrEmpty(search.SSTATUS))
{
sqlWhere += " AND A.[STATUS] = '" + search.SSTATUS + "'";
}
//if (search.REGION_ID != -1 && search.ORG_ID != search.REGION_ID)
//{
// sqlWhere += " AND A.[REGION_ID] = " + search.REGION_ID;
//}
return(base.PageGet <ORG_STORE_EX>(view, sql, "[ORG_STORE] A left join ORG_INFO B on A.REGION_ID=B.ID ",
sqlWhere, "A.[ID] Desc", ""));
}
public Search()
{
this.InitializeComponent();
SearchModel = new StoreSearch();
// datacontext set in xaml
DataContext = SearchModel;
//Loaded += (s, e) => NavigateToRememberedPosition();
}
public void CollectStoreData(Store store)
{
_currentSearch = new StoreSearch()
{
Categories = new List <string>(), Created = DateTime.Now, Store = store
};
_parser = new VerkkokauppaParser();
_parser.ProductParsed += new EventHandler <ParserEventArgs>(_parser_ProductParsed);
_browser = new StoreBrowser();
_browser.BrowseStore(_parser, store);
}
private void Search()
{
ResultsWindow.Controls.Clear();
Pages.Controls.Clear();
sw.Start();
searchTerm = TxtSearch1.Text;
searchresultlist = Querier.Search(TxtSearch1.Text);
searchresults = DivideIntoPages(searchresultlist);
SearchTime.Text = ((double)sw.ElapsedMilliseconds) + "ms";
sw.Reset();
DisplayPages(0);
currentPage = 0;
StoreSearch.Stop();
StoreSearch.Start();
}
public JsonResult QueryStoreList(FormCollection form)
{
//string colkey = form["colkey"];
//string colsinfo = form["colsinfo"];
//var stores = _ss.GetStores(CurrentMerchants.ID);
//JsonQTable fdata = JsonQTable.ConvertFromList<WXStore>(stores, colkey, colsinfo.Split(','));
//return Json(fdata);
StoreSearch search = new StoreSearch();
search.ORG_ID = base.CurrentUserOrgId;
//search.REGION_ID = Int32.Parse(form["REGION_ID1"].ToString());
//search.STYPE = form["STYPE"].ToString();
//search.SSTATUS = form["SSTATUS"].ToString();
//search.SNAME = form["SNAME"].ToString();
PageView view = new PageView(form);
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
PagedList <ORG_STORE_EX> pList = _ss.QueryAllStoreDate(search, view);
JsonQTable fdata = JsonQTable.ConvertFromPagedList <ORG_STORE_EX>(pList, colkey, colsinfo.Split(','));
return(Json(fdata));
}
public IEnumerable <StoreModels> GetPagedData(StoreSearch search, int pageSize, int pageIndex, out int recordCount, bool showNotIssued = true)
{
List <string> where = new List <string>();
Dictionary <string, object> param = new Dictionary <string, object>();
string whereClause = where.Count > 0 ? $" WHERE {string.Join(" AND ", where)} " : "";
string orderClause = " order by Sort, ID DESC ";
string sql = "";
sql = $@" SELECT *
FROM Store
{whereClause} ";
using (var conn = new SqlConnection(WebInfo.Conn))
{
IEnumerable <StoreModels> retValue = GetPagedData(sql, pageSize, pageIndex, out recordCount, null, orderClause);
if (retValue != null && retValue.Count() > 0)
{
var items = retValue.ToList();
return(items);
}
return(retValue);
}
}
public PagedList <ORG_STORE_EX> QueryAllStoreDateEx(StoreSearch search, PageView view)
{
return(sReponsitory.QueryAllStoreDateEx(search, view));
}
public PagedList <ORG_STORE_EX> QueryAllStoreDate(StoreSearch search, PageView view)
{
search.SNAME = Utility.ClearSafeStringParma(search.SNAME);
return(sReponsitory.QueryAllStoreDate(search, view));
}
private void StoreSearch_Tick(object sender, EventArgs e)
{
Querier.Invt.Samantha.TrieWord(TxtSearch1.Text.Trim().ToLower());
StoreSearch.Stop();
}
