/// <summary> /// MVC Model Binder for automatically binding the request parameters for a PagedList sort to an instance of /// SortOption /// </summary> /// <param name="controllerContext"></param> /// <param name="bindingContext"></param> /// <returns></returns> /// <example>public ActionResult Index(int? page, [ModelBinder(typeof(PagedListBinder))] SortOption? sort)</example> /// <see cref="SortOption"/> public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext) { //Does the request contain the minimum parameters for sortng a PagedList? if (!String.IsNullOrEmpty((string)controllerContext.HttpContext.Request.Params["Column"])) { //Yup - SortOption sort = new SortOption(); sort.Column = controllerContext.HttpContext.Request.Params["Column"]; if (Enum.IsDefined(typeof(SortOrder), controllerContext.HttpContext.Request.Params["Direction"])) { Enum.TryParse<SortOrder>(controllerContext.HttpContext.Request.Params["Direction"], out sort.Direction); } else { sort.Direction = SortOrder.ascending; } return sort; } else { //Nothing to bind to return null; } }
public static IEnumerable<string> Files(string directory, string pattern = "*.*", SearchOption searchOption = SearchOption.TopDirectoryOnly, SortOption sortOption = SortOption.Ascending) { var q = zDirectory.EnumerateFiles(directory, pattern, searchOption); if (sortOption == SortOption.Ascending) return q; else return q.OrderByDescending(file => file); }
public System.Data.DataTable ListAsDataTable(int BranchID = 0, long ProductID = 0, long MatrixID =0, string BarCode = "", string ProductCode = "", Int64 ProductGroupID = 0, Int64 ProductSubGroupID = 0, Int64 SupplierID = 0, ProductListFilterType clsProductListFilterType = ProductListFilterType.ShowActiveAndInactive, bool isQuantityGreaterThanZERO = false, Int32 Limit = 0, Int32 isSummary = 1, string ExpirationDate = Constants.C_DATE_MIN_VALUE_STRING, Int32 ForReorder = 0, Int32 OverStock = 0, string SortField = "", SortOption SortOrder = SortOption.Ascending, bool ShowOnlyWithInvalidUnitMatrix = false) { try { DateTime dteExpiration = Constants.C_DATE_MIN_VALUE; DateTime.TryParse(ExpirationDate, out dteExpiration); string SQL = "CALL procProductInventorySelect(@BranchID, @ProductID, @MatrixID, @BarCode, @ProductCode, @ProductGroupID, @ProductSubGroupID, @SupplierID, @ShowActiveAndInactive, @isQuantityGreaterThanZERO, @lngLimit, @isSummary, @dteExpiration, @ForReorder, @OverStock, @SortField, @SortOrder)"; // do an override if Only those with invalid unit matrix if (ShowOnlyWithInvalidUnitMatrix) SQL = "CALL procProductInventorySelectWithInvalidUnitMatrix(@BranchID, @ProductID, @MatrixID, @BarCode, @ProductCode, @ProductGroupID, @ProductSubGroupID, @SupplierID, @ShowActiveAndInactive, @isQuantityGreaterThanZERO, @lngLimit, @isSummary, @dteExpiration, @ForReorder, @OverStock, @SortField, @SortOrder)"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@BranchID", BranchID); cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.Parameters.AddWithValue("@MatrixID", MatrixID); cmd.Parameters.AddWithValue("@BarCode", BarCode); cmd.Parameters.AddWithValue("@ProductCode", ProductCode); cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID); cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID); cmd.Parameters.AddWithValue("@SupplierID", SupplierID); cmd.Parameters.AddWithValue("@ShowActiveAndInactive", clsProductListFilterType.ToString("d")); cmd.Parameters.AddWithValue("@isQuantityGreaterThanZERO", isQuantityGreaterThanZERO); cmd.Parameters.AddWithValue("@lngLimit", Limit); cmd.Parameters.AddWithValue("@isSummary", isSummary); cmd.Parameters.AddWithValue("@dteExpiration", dteExpiration.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@ForReorder", ForReorder); cmd.Parameters.AddWithValue("@OverStock", OverStock); cmd.Parameters.AddWithValue("@SortField", SortField); switch (SortOrder) { case SortOption.Ascending: cmd.Parameters.AddWithValue("@SortOrder", "ASC"); break; case SortOption.Desscending: cmd.Parameters.AddWithValue("@SortOrder", "DESC"); break; } string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception) { throw; } }
protected override void Sort(Tab tab, SortOption options) { if (options["Default"]) { sortJewls(tab, 11); } if (options["Dynamic"]) { int numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f); sortJewls(tab, numberOfColumns); } }
private static object Build(SortOption sortOption) { if (!sortOption.IgnoreUnmapped) return sortOption.Ascending ? (object)sortOption.Name : new JObject(new JProperty(sortOption.Name, "desc")); var properties = new List<JProperty> { new JProperty("ignore_unmapped", true) }; if (!sortOption.Ascending) properties.Add(new JProperty("order", "desc")); return new JObject(new JProperty(sortOption.Name, new JObject(properties))); }
protected override void Sort(Tab tab, SortOption options) { int numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f); if (options["Default"]) { numberOfColumns = 11; sortMaps(tab, numberOfColumns); } if (options["Full"]) { numberOfColumns = 12; sortMaps(tab, numberOfColumns); } if (options["1 Margin"]) { if (numberOfColumns <= 11) numberOfColumns = 11; sortMaps(tab, numberOfColumns); } if (options["2 Margin"]) { if (numberOfColumns <= 10) numberOfColumns = 10; sortMaps(tab, numberOfColumns); } if (options["3 Margin"]) { if (numberOfColumns <= 9) numberOfColumns = 9; sortMaps(tab, numberOfColumns); } if (options["Dynamic"]) { numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f); sortMaps(tab, numberOfColumns); } if (options["Dynamic + 1"]) { numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f) + 1; numberOfColumns = Mathf.Clamp(numberOfColumns, 0, 11); sortMaps(tab, numberOfColumns); } if (options["Dynamic + 2"]) { numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f) + 2; numberOfColumns = Mathf.Clamp(numberOfColumns, 0, 11); sortMaps(tab, numberOfColumns); } }
protected override void Sort(Tab tab, SortOption options) { IEnumerable<Item> gems = tab.Items; if (options["Sort by color then type"]) { SortEm( gems.Where(x => x.GemRequirement == GemRequirement.Str).OrderByDescending(x => x.GemType).ThenBy(x => x.FullItemName).ThenBy(x => x.Level), gems.Where(x => x.GemRequirement == GemRequirement.Dex).OrderByDescending(x => x.GemType).ThenBy(x => x.FullItemName).ThenBy(x => x.Level), gems.Where(x => x.GemRequirement == GemRequirement.Int).OrderByDescending(x => x.GemType).ThenBy(x => x.FullItemName).ThenBy(x => x.Level) ); } else if (options["Sort by type"]) { SortEm( gems.Where(x => x.GemType == GemType.Normal).OrderByDescending(x => x.FullItemName).ThenBy(x => x.LevelRequirement), gems.Where(x => x.GemType == GemType.Support).OrderByDescending(x => x.FullItemName).ThenBy(x => x.LevelRequirement), gems.Where(x => x.GemType == GemType.Aura).OrderByDescending(x => x.FullItemName).ThenBy(x => x.LevelRequirement) ); } else if (options["Sort by quality"]) { SortEm( gems.Where(x => x.GemRequirement == GemRequirement.Str).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName), gems.Where(x => x.GemRequirement == GemRequirement.Dex).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName), gems.Where(x => x.GemRequirement == GemRequirement.Int).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName) ); } else if (options["Find quality gems"]) { SortEm( gems.Where(x => x.Quality == 0).OrderByDescending(x => x.GemRequirement).ThenBy(x => x.GemType).ThenBy(x => x.FullItemName), gems.Where(x => x.LevelRequirement > 99999), // No middle gems.Where(x => x.Quality > 0).OrderByDescending(x => x.Quality).ThenBy(x => x.FullItemName) ); } else if (options["Sort by color then level"]) { SortEm( gems.Where(x => x.GemRequirement == GemRequirement.Str).OrderByDescending(x => x.Level).ThenBy(x => x.Quality), gems.Where(x => x.GemRequirement == GemRequirement.Dex).OrderByDescending(x => x.GemType).ThenBy(x => x.Quality), gems.Where(x => x.GemRequirement == GemRequirement.Int).OrderByDescending(x => x.GemType).ThenBy(x => x.Quality) ); } else if (options["Sort by level"]) { SortFromBottom(gems.OrderByDescending(x => x.LevelRequirement)); } }
protected override void Sort(Tab tab, SortOption options) { int numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f); int numberOfItems = tab.Items.Count(); if (options["Default"]) { numberOfColumns = 12; } if (options["1 Margin"]) { if (numberOfColumns <= 11) numberOfColumns = 11; } if (options["2 Margin"]) { if (numberOfColumns <= 10) numberOfColumns = 10; } if (options["Dynamic"]) { numberOfColumns = (int)Math.Ceiling(tab.Items.Count() / 12f); } int x = 11; int y = 11; int i = 0; int lastLevel = 0; bool maySkip = true; foreach (var item in tab.Items.OrderByDescending(xx => xx.Level).ThenBy(xx => xx.Icon).ThenBy(xx => xx.Quality)) { item.X = x; item.Y = y; i++; x--; bool canSkip = (lastLevel != item.Level && (numberOfItems - i) < numberOfColumns * y); if (maySkip && lastLevel != item.Level && ((numberOfItems - i) < numberOfColumns * y) == false) maySkip = false; if (x == 11 - numberOfColumns || canSkip && maySkip) { x = 11; y--; } lastLevel = item.Level; } }
public static IEnumerable<TaskModel> GetTasks(SortOption sortOption) { switch (sortOption) { case SortOption.Newest: return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderByDescending(t=>t.DateCreated); case SortOption.Oldest: return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderBy(t => t.DateCreated); case SortOption.TitleAscending: return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderBy(t => t.Task); case SortOption.TitleDescending: return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderByDescending(t => t.Task); } return DataLayer.TaskDatabase.GetItems<TaskModel>().OrderBy(t => t.DateCreated); }
public static StatData[] GetCurrentState(SortOption sortOption, int pageNumber, int pageSize) { var startPosition = pageSize*pageNumber; switch (sortOption) { case SortOption.None: return KeywordsDictionary.Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray(); case SortOption.Keyword: return KeywordsDictionary.OrderBy(pair => pair.Key).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray(); case SortOption.KeywordDecrease: return KeywordsDictionary.OrderByDescending(pair => pair.Key).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray(); case SortOption.KeywordCount: return KeywordsDictionary.OrderBy(pair => pair.Value).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray(); case SortOption.KeywordCountDecrease: return KeywordsDictionary.OrderByDescending(pair => pair.Value).Skip(startPosition).Take(pageSize).Select(kvp => new StatData(kvp.Key, kvp.Value)).ToArray(); } return new StatData[0]; }
public MySqlDataReader List(string SortField, SortOption SortOrder) { try { string SQL = SQLSelect() + "WHERE 1=1 ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; return base.ExecuteReader(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
private MySqlDataReader ListAccessTypes(string SortField, SortOption SortOrder) { try { string SQL = "SELECT TypeID, TypeName, Remarks " + "FROM sysAccessTypes " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; return base.ExecuteReader(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public MySqlDataReader Search(CreditMemoItemStatus CreditMemoItemstatus, string SearchKey, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID"; string SQL = SQLSelect() + "WHERE (ProductCode LIKE @SearchKey or BarCode LIKE @SearchKey or Description LIKE @SearchKey " + "or MatrixDescription LIKE @SearchKey or ProductGroup LIKE @SearchKey or ProductSubGroup LIKE @SearchKey " + "or Remarks LIKE @SearchKey) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus",MySqlDbType.Int16); prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d"); cmd.Parameters.Add(prmCreditMemoItemStatus); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); MySqlDataReader myReader = base.ExecuteReader(cmd); return myReader; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTableSimple(long SequenceNoStart, System.Data.SqlClient.SortOrder SequenceSortOrder, string SortField = "SequenceNo", SortOption SortOrder = SortOption.Ascending) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelectSimple() + "WHERE 1=1 "; if (SequenceNoStart != 0) { if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending) { SQL += "AND SequenceNo <= " + SequenceNoStart.ToString() + " "; } else { SQL += "AND SequenceNo >= " + SequenceNoStart.ToString() + " "; } } SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(long CreditMemoID = 0, string SortField = "CreditMemoItemID", SortOption SortOrder = SortOption.Ascending) { MySqlCommand cmd = new MySqlCommand(); string SQL = SQLSelect(); if (CreditMemoID != 0) { SQL += "WHERE CreditMemoID = @CreditMemoID "; MySqlParameter prmReturnID = new MySqlParameter("@CreditMemoID", MySqlDbType.Int64); prmReturnID.Value = CreditMemoID; cmd.Parameters.Add(prmReturnID); } SQL += "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; }
public static IEnumerable <string> Files(string directory, string pattern = "*.*", SearchOption searchOption = SearchOption.TopDirectoryOnly, SortOption sortOption = SortOption.Ascending) { var q = zDirectory.EnumerateFiles(directory, pattern, searchOption); if (sortOption == SortOption.Ascending) { return(q); } else { return(q.OrderByDescending(file => file)); } }
public MySqlDataReader Search(Int64 GroupID, string SearchKey, string SortField, SortOption SortOrder) { try { string SQL = "SELECT MatrixID, " + "GroupID, " + "Description, " + "a.UnitID, " + "UnitName, " + "a.Price, " + "a.PurchasePrice, " + "a.IncludeInSubtotalDiscount, " + "a.VAT, " + "a.EVAT, " + "a.LocalTax " + "FROM tblProductGroupBaseVariationsMatrix a INNER JOIN " + "tblUnit b ON a.UnitID = b.UnitID " + "WHERE GroupID = @GroupID " + "AND Description LIKE @SearchKey " + "ORDER BY MatrixID, " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int64); prmGroupID.Value = GroupID; cmd.Parameters.Add(prmGroupID); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); return(base.ExecuteReader(cmd)); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
private void LoadList() { Contacts clsContact = new Contacts(); DataClass clsDataClass = new DataClass(); ContactColumns clsContactColumns = new ContactColumns(); clsContactColumns.ContactID = true; clsContactColumns.ContactCode = true; clsContactColumns.ContactName = true; clsContactColumns.RewardDetails = true; ContactColumns clsSearchColumns = new ContactColumns(); clsSearchColumns.ContactCode = true; clsSearchColumns.ContactName = true; clsSearchColumns.RewardDetails = true; string SortField = "ContactID"; if (Request.QueryString["sortfield"] != null) { SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); } SortOption sortoption = SortOption.Ascending; if (Request.QueryString["sortoption"] != null) { sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); } string SearchKey = txtSearch.Text; string ContactGroupCode = ""; ContactGroupCode = cboGroup.SelectedIndex == 0 ? "" : cboGroup.SelectedItem.Text; DateTime dteBirthDateFrom = Constants.C_DATE_MIN_VALUE; DateTime dteBirthDateTo = Constants.C_DATE_MIN_VALUE; DateTime dteAnniversaryDateFrom = Constants.C_DATE_MIN_VALUE; DateTime dteAnniversaryDateTo = Constants.C_DATE_MIN_VALUE; dteBirthDateFrom = DateTime.TryParse(txtBirthStartDate.Text, out dteBirthDateFrom) ? dteBirthDateFrom : Constants.C_DATE_MIN_VALUE; dteBirthDateTo = DateTime.TryParse(txtBirthEndDate.Text, out dteBirthDateTo) ? dteBirthDateTo : Constants.C_DATE_MIN_VALUE; dteAnniversaryDateFrom = DateTime.TryParse(txtAnnivStartDate.Text, out dteAnniversaryDateFrom) ? dteAnniversaryDateFrom : Constants.C_DATE_MIN_VALUE; dteAnniversaryDateTo = DateTime.TryParse(txtAnnivEndDate.Text, out dteAnniversaryDateTo) ? dteAnniversaryDateTo : Constants.C_DATE_MIN_VALUE; //PageData.DataSource = clsContact.Customers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, SearchKey, 0, false, null, System.Data.SqlClient.SortOrder.Ascending).DefaultView; PageData.DataSource = clsContact.ListAsDataTable(ContactGroupCategory.CUSTOMER, ContactCode: SearchKey, ContactName: SearchKey, ContactGroupCode: ContactGroupCode, SortField: SortField, SortOrder: sortoption, BirthDateFrom: dteBirthDateFrom.ToString("yyyy-MM-dd"), BirthDateTo: dteBirthDateTo.ToString("yyyy-MM-dd"), AnniversaryDateFrom: dteAnniversaryDateFrom.ToString("yyyy-MM-dd"), AnniversaryDateTo: dteAnniversaryDateTo.ToString("yyyy-MM-dd"), BirthMonth: cboBirthMonth.SelectedIndex, AnniversaryMonth: cboAnniversaryMonth.SelectedIndex).DefaultView; //clsContact.CustomersDataTable(SearchKey, SortField: SortField, SortOrder: sortoption).DefaultView; clsContact.CommitAndDispose(); int iPageSize = Convert.ToInt16(Session["PageSize"]); PageData.AllowPaging = true; PageData.PageSize = iPageSize; try { PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1; lstItem.DataSource = PageData; lstItem.DataBind(); } catch { PageData.CurrentPageIndex = 1; lstItem.DataSource = PageData; lstItem.DataBind(); } cboCurrentPage.Items.Clear(); for (int i = 0; i < PageData.PageCount; i++) { int iValue = i + 1; cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString())); if (PageData.CurrentPageIndex == i) { cboCurrentPage.Items[i].Selected = true; } else { cboCurrentPage.Items[i].Selected = false; } } lblDataCount.Text = " of " + " " + PageData.PageCount; }
/// <summary>Builds up a String containing each property and value in the class decorated with the AuditAttribute. The String displays the property name, property friendly name and property value.</summary> /// <typeparam name="T">Class type.</typeparam> /// <param name="instance">The instance.</param> /// <param name="includeAllProperties">The include all properties.</param> /// <param name="sortOption">The sort option.</param> /// <param name="delimiter">The delimiter.</param> /// <param name="defaultValue"> /// If no class properties are decorated with the <see cref="AuditAttribute"/> and the defaultValue is not null or an empty string, then the default value will be returned. /// </param> /// <returns>A String containing each property name, friendly name and value, separated by the delimiter and sorted by AuditAttribute.AuditSequence and then property name.</returns> /// <exception cref="InvalidEnumArgumentException">Thrown when enum value includeAllProperties is not defined.</exception> /// <exception cref="InvalidEnumArgumentException">Thrown when enum value sortOption is not defined.</exception> /// <exception cref="ArgumentNullEmptyWhiteSpaceException">Thrown when delimiter is null, empty, or white space.</exception> /// <exception cref="InvalidEnumArgumentException">Thrown when enum value auditFormat is not defined.</exception> public String AuditToString <T>(IncludeAllProperties includeAllProperties, SortOption sortOption, String delimiter = Constants.DefaultAuditMessageDelimiter, AuditFormat auditFormat = AuditFormat.Compact, String defaultValue = Constants.AuditDefaultValue) { return(AuditMessageFactory.AuditToString(this, includeAllProperties, sortOption, delimiter, auditFormat, defaultValue)); }
public MySqlDataReader List(CreditMemoItemStatus CreditMemoItemstatus, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) { SortField = "CreditMemoItemID"; } string SQL = SQLSelect() + "WHERE ItemStatus = @ItemStatus " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus", MySqlDbType.Int16); prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d"); cmd.Parameters.Add(prmCreditMemoItemStatus); MySqlDataReader myReader = base.ExecuteReader(cmd); return(myReader); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public MySqlDataReader Search(string SearchKey, string SortField, SortOption SortOrder) { try { string SQL ="SELECT * FROM tblProductGroupUnitMatrix " + "WHERE GroupID LIKE @SearchKey " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); return base.ExecuteReader(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(ReceiptDetails ReceiptDetails, string SortField = "ReceiptID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (ReceiptDetails.ReceiptID != 0) { SQL += "AND ReceiptID = @ReceiptID) "; cmd.Parameters.AddWithValue("@ReceiptID", ReceiptDetails.ReceiptID); } if (!string.IsNullOrEmpty(ReceiptDetails.Module)) { SQL += "AND Module = @Module) "; cmd.Parameters.AddWithValue("@Module", ReceiptDetails.Module); } if (!string.IsNullOrEmpty(ReceiptDetails.Value)) { SQL += "AND Value = @Value) "; cmd.Parameters.AddWithValue("@Value", ReceiptDetails.Value); } SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(long CreditMemoID = 0, string SortField = "CreditMemoItemID", SortOption SortOrder = SortOption.Ascending) { MySqlCommand cmd = new MySqlCommand(); string SQL = SQLSelect(); if (CreditMemoID != 0) { SQL += "WHERE CreditMemoID = @CreditMemoID "; MySqlParameter prmReturnID = new MySqlParameter("@CreditMemoID", MySqlDbType.Int64); prmReturnID.Value = CreditMemoID; cmd.Parameters.Add(prmReturnID); } SQL += "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); }
public MySqlDataReader List(long TransferInID = 0, string SortField = "TransferInItemID", SortOption SortOrder = SortOption.Desscending) { try { MySqlCommand cmd = new MySqlCommand(); string SQL = SQLSelect(); if (TransferInID != 0) { SQL += "WHERE TransferInID = @TransferInID "; MySqlParameter prmTransferInID = new MySqlParameter("@TransferInID", MySqlDbType.Int64); prmTransferInID.Value = TransferInID; cmd.Parameters.Add(prmTransferInID); } SQL += "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlDataReader myReader = base.ExecuteReader(cmd); return(myReader); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void search() { buttonSearch.Enabled = false; listViewSearchResults.Items.Clear(); DirectoryEntry rootDSE = new DirectoryEntry("LDAP://RootDSE"); String defaultNamingContext = rootDSE.Properties["defaultNamingContext"].Value.ToString(); DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + defaultNamingContext); String sortField = "printername"; if (radioButtonPrinterLocation.Checked) { sortField = "location"; } SortOption sortOption = new SortOption(sortField, SortDirection.Ascending); DirectorySearcher searcher = new DirectorySearcher(searchRoot); string filter = ""; if (radioButtonPrinterName.Checked) { filter = "(&(objectcategory=printqueue)(printername=*" + textBox1.Text + "*))"; } else { filter = "(&(objectcategory=printqueue)(location=*" + textBox1.Text + "*))"; } searcher.ReferralChasing = ReferralChasingOption.All; searcher.PageSize = 1000; searcher.Filter = filter; searcher.SearchScope = SearchScope.Subtree; searcher.Sort = sortOption; try { SearchResultCollection colResults = searcher.FindAll(); foreach (SearchResult result in colResults) { String printername = ""; String location = ""; String driverName = ""; String uncname = ""; if ((result.Properties.Contains("printername")) && (result.Properties.Contains("uncname"))) { printername = result.Properties["printername"][0].ToString(); if (result.Properties.Contains("location")) { location = result.Properties["location"][0].ToString(); } if (result.Properties.Contains("driverName")) { driverName = result.Properties["driverName"][0].ToString(); } uncname = result.Properties["uncname"][0].ToString(); ListViewItem lvi = new ListViewItem(printername); lvi.SubItems.Add(location); lvi.SubItems.Add(driverName); lvi.SubItems.Add(uncname); listViewSearchResults.Items.Add(lvi); } } } catch (Exception e) { MessageBox.Show(e.Message, "Search Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } finally { buttonSearch.Enabled = true; } }
public async Task <IActionResult> Sort(IFormFile file, SortOption sortOption) { return(new OkResult()); }
public System.Data.DataTable ListClosedDataTable(Int32 BranchID, DateTime? TransactionDateFrom = null, DateTime? TransactionDateTo = null, string SortField = "TransactionDate", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { return ListAsDataTable(BranchID, TransactionDateFrom: TransactionDateFrom, TransactionDateTo: TransactionDateTo, TransactionStatus: TransactionStatus.Closed, SortField: SortField, SortOption: SortOrder, limit: limit); } catch (Exception ex) { throw base.ThrowException(ex); } }
public MySqlDataReader Search(Int64 ProductID, string SearchKey, string SortField, SortOption SortOrder) { try { string SQL = "SELECT a.ProductID,a.VariationID,b.VariationCode,b.VariationType " + "FROM tblProductVariations a " + "LEFT JOIN tblVariations b ON a.VariationID = b.VariationID " + "WHERE ProductID = @ProductID " + "AND VariationType LIKE @SearchKey " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC;"; else SQL += " DESC;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int64); prmProductID.Value = ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); return base.ExecuteReader(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(SalesTransactionDetails clsSearchKey, bool WithTF = false, string SortField = "", SortOption SortOption = SortOption.Ascending, Int32 limit = 0) { try { return ListAsDataTable(clsSearchKey.BranchID, clsSearchKey.TerminalNo, clsSearchKey.TransactionID, clsSearchKey.TransactionNo, clsSearchKey.TransactionDateFrom, clsSearchKey.TransactionDateTo, clsSearchKey.TransactionStatus, clsSearchKey.PaymentType, clsSearchKey.isConsignment, false, clsSearchKey.CustomerName, clsSearchKey.CustomerGroupName, clsSearchKey.CashierID, clsSearchKey.CashierName, clsSearchKey.AgentName, WithTF, false, SortField, SortOption, limit); ; } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable AvailableVariationsDataTable(Int64 ProductID, string SortField, SortOption SortOrder) { try { string SQL = "SELECT * FROM tblVariations " + "WHERE VariationID NOT IN (SELECT VariationID FROM tblProductVariations WHERE ProductID = @ProductID) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC;"; else SQL += " DESC;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@ProductID", ProductID); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
/// <summary>Populates the dictionary with property's name and value in the class for properties decorated with the <see cref="AuditAttribute"/>. If <c>IncludeAllProperties.Yes</c> then all properties will be included with or without the <c>AuditAttribute</c>.</summary> /// <param name="instance">The instance.</param> /// <param name="dictionary">Pass an IDictionary Object that needs to be populated. This could be the Data property of an exception Object that you want to populate, etc.</param> /// <param name="includeAllProperties">The include all properties.</param> /// <param name="sortOption">The sort option.</param> /// <param name="auditFormat">The audit format.</param> /// <param name="defaultValue"> /// If no class properties are decorated with the <see cref="AuditAttribute"/> and the defaultValue is not null or an empty string, then a single entry will be added to the dictionary that is named 'DefaultValue' and will have the value of defaultValue. /// </param> /// <returns>IDictionary populated with properties and values.</returns> /// <exception cref="ArgumentNullException">Thrown when dictionary is null.</exception> /// <exception cref="InvalidEnumArgumentException">Thrown when enum value includeAllProperties is not defined.</exception> /// <exception cref="InvalidEnumArgumentException">Thrown when enum value sortOption is not defined.</exception> /// <exception cref="InvalidEnumArgumentException">Thrown when enum value auditFormat is not defined.</exception> public IDictionary <String, String> AuditToIDictionary(IDictionary <String, String> dictionary, IncludeAllProperties includeAllProperties, SortOption sortOption, AuditFormat auditFormat = AuditFormat.Compact, String defaultValue = Constants.AuditDefaultValue) { return(AuditMessageFactory.AuditToIDictionary(this, dictionary, includeAllProperties, sortOption, auditFormat, defaultValue)); }
public System.Data.DataTable ListAsDataTable(CashCountDetails clsSearchKey, string SortField = "CashCountID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (clsSearchKey.CashierID != 0) { SQL += "AND CashierID = @CashierID "; cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID); } if (!string.IsNullOrEmpty(clsSearchKey.TerminalNo)) { SQL += "AND TerminalNo = @TerminalNo "; cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID); } if (!string.IsNullOrEmpty(clsSearchKey.CashierName)) { SQL += "AND CashierName = @CashierName "; cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID); } if (!string.IsNullOrEmpty(clsSearchKey.DenominationDetails.DenominationCode)) { SQL += "AND DenominationCode = @DenominationCode "; cmd.Parameters.AddWithValue("CashierID", clsSearchKey.CashierID); } SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void LoadList() { SO clsSO = new SO(); string SortField = "SOID"; if (Request.QueryString["sortfield"] != null) { SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); } SortOption sortoption = SortOption.Ascending; if (Request.QueryString["sortoption"] != null) { sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); } if (Request.QueryString["Search"] == null) { if (Request.QueryString["status"] == null) { PageData.DataSource = clsSO.ListAsDataTable(SOStatus.Open, SortField, sortoption).DefaultView; } else { SOStatus status = (SOStatus)Enum.Parse(typeof(SOStatus), Common.Decrypt((string)Request.QueryString["status"], Session.SessionID)); PageData.DataSource = clsSO.ListAsDataTable(status, SortField, sortoption).DefaultView; } } else { string SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID); if (Request.QueryString["status"] == null) { PageData.DataSource = clsSO.SearchAsDataTable(SOStatus.Open, SearchKey, SortField, sortoption).DefaultView; } else { SOStatus status = (SOStatus)Enum.Parse(typeof(SOStatus), Common.Decrypt((string)Request.QueryString["status"], Session.SessionID)); PageData.DataSource = clsSO.SearchAsDataTable(status, SearchKey, SortField, sortoption).DefaultView; } } clsSO.CommitAndDispose(); int iPageSize = Convert.ToInt16(Session["PageSize"]); PageData.AllowPaging = true; PageData.PageSize = iPageSize; try { PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1; lstItem.DataSource = PageData; lstItem.DataBind(); } catch { PageData.CurrentPageIndex = 1; lstItem.DataSource = PageData; lstItem.DataBind(); } cboCurrentPage.Items.Clear(); for (int i = 0; i < PageData.PageCount; i++) { int iValue = i + 1; cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString())); if (PageData.CurrentPageIndex == i) { cboCurrentPage.Items[i].Selected = true; } else { cboCurrentPage.Items[i].Selected = false; } } lblDataCount.Text = " of " + " " + PageData.PageCount; }
/// <summary> /// 初始化构造 /// </summary> /// <param name="startRows">开始行数</param> /// <param name="pageSize">每页大小</param> /// <param name="tableName">要查询的表名</param> /// <param name="strColumn">查询结果集中返回的列</param> /// <param name="sortColumn">用于排序的列</param> /// <param name="SortOption">排序方式</param> /// <param name="filter">查询时的过滤条件</param> public ListParameters(int startRows, int pageSize, string tableName, string strColumn, string sortColumn, SortOption SortOption, string filter) { this.m_StartRows = startRows; this.m_PageSize = pageSize; this.m_TableName = tableName; this.m_StrColumn = strColumn; this.m_SortColumn = sortColumn; this.m_SortOption = SortOption; this.m_Filter = filter; }
public MySqlDataReader List(Int64 MatrixID, string SortField, SortOption SortOrder) { try { string SQL = "SELECT " + "a.PackageID, " + "a.MatrixID, " + "Description, " + "a.UnitID, " + "c.UnitCode, " + "c.UnitName, " + "a.Price, " + "a.WSPrice, " + "a.PurchasePrice, " + "a.Quantity, " + "a.VAT, " + "a.EVAT, " + "a.LocalTax " + "FROM tblMatrixPackage a " + "INNER JOIN tblProductBaseVariationsMatrix b ON a.MatrixID = b.MatrixID " + "INNER JOIN tblUnit c ON a.UnitID = c.UnitID " + "WHERE 1=1 AND a.MatrixID = @MatrixID ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64); prmMatrixID.Value = MatrixID; cmd.Parameters.Add(prmMatrixID); return base.ExecuteReader(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public IEnumerable<string> Sort(Uri filePath, SortOption option) { return this.textSort.Sort(filePath, option); }
public System.Data.DataTable ListAsDataTable(Int64 ProductID = 0, DateTime?PurchaseDateFrom = null, string SortField = "PurchasePrice", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (ProductID != 0) { SQL += "AND a.ProductID = @ProductID "; cmd.Parameters.AddWithValue("@ProductID", ProductID); } if (PurchaseDateFrom.GetValueOrDefault() != DateTime.MinValue) { SQL += "AND a.PurchaseDate >= @PurchaseDateFrom "; cmd.Parameters.AddWithValue("@PurchaseDateFrom", PurchaseDateFrom.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : PurchaseDateFrom); } SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "PurchasePrice") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public IEnumerable <string> Sort(Uri filePath, SortOption option) { throw new NotImplementedException(); }
public MySqlDataReader Search(CreditMemoItemStatus CreditMemoItemstatus, string SearchKey, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) { SortField = "CreditMemoItemID"; } string SQL = SQLSelect() + "WHERE (ProductCode LIKE @SearchKey or BarCode LIKE @SearchKey or Description LIKE @SearchKey " + "or MatrixDescription LIKE @SearchKey or ProductGroup LIKE @SearchKey or ProductSubGroup LIKE @SearchKey " + "or Remarks LIKE @SearchKey) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus", MySqlDbType.Int16); prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d"); cmd.Parameters.Add(prmCreditMemoItemStatus); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); MySqlDataReader myReader = base.ExecuteReader(cmd); return(myReader); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListAstDataTable(PromoBySupplierDetails SearchKey, string SortField = "PromoBySupplierID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "SELECT " + "PromoBySupplierID, " + "PromoBySupplierCode, " + "PromoBySupplierName, " + "PromoLevel, " + "StartDate, " + "EndDate, " + "Status, " + "a.PromoTypeID, " + "PromoTypeCode, " + "PromoTypeName " + "FROM tblPromoBySupplier a INNER JOIN " + "tblPromoType b ON a.PromoTypeID = b.PromoTypeID " + "WHERE 1=1 "; if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierCode)) { SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierCode "; cmd.Parameters.AddWithValue("@PromoBySupplierCode", SearchKey.PromoBySupplierCode); } if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierName)) { SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierName "; cmd.Parameters.AddWithValue("@PromoBySupplierName", SearchKey.PromoBySupplierName); } if (!string.IsNullOrEmpty(SearchKey.PromoTypeCode)) { SQL += "AND PromoBySupplierCode LIKE @PromoTypeCode "; cmd.Parameters.AddWithValue("@PromoTypeCode", SearchKey.PromoTypeCode); } SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable BaseList(Int64 ProductID, string SortField, SortOption SortOrder, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "SELECT MatrixID, " + "ProductID, " + "Description, " + "a.UnitID, " + "UnitName, " + "a.IncludeInSubtotalDiscount " + "FROM tblProductBaseVariationsMatrix a INNER JOIN " + "tblUnit b ON a.UnitID = b.UnitID " + "WHERE ProductID = @ProductID ORDER BY MatrixID, " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public static extern void Everything_SetSort(SortOption dwSortType);
public MySqlDataReader AvailableVariations(Int64 ProductID, string SortField, SortOption SortOrder) { try { string SQL = "SELECT * FROM tblVariations " + "WHERE VariationID NOT IN (SELECT VariationID FROM tblProductVariations WHERE ProductID = @ProductID) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC;"; else SQL += " DESC;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int64); prmProductID.Value = ProductID; cmd.Parameters.Add(prmProductID); return base.ExecuteReader(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public static extern bool Everything_IsFastSort(SortOption dwSortType);
public MySqlDataReader List(string SortField, SortOption SortOrder, string MatrixIDs) { try { string SQL = "SELECT " + "a.PackageID, " + "a.MatrixID, " + "Description, " + "a.UnitID, " + "c.UnitCode, " + "c.UnitName, " + "a.Price, " + "a.WSPrice, " + "a.PurchasePrice, " + "a.Quantity, " + "a.VAT, " + "a.EVAT, " + "a.LocalTax " + "FROM tblMatrixPackage a " + "INNER JOIN tblProductBaseVariationsMatrix b ON a.MatrixID = b.MatrixID " + "INNER JOIN tblUnit c ON a.UnitID = c.UnitID " + "WHERE 1=1 "; if (MatrixIDs != "" && MatrixIDs != null) SQL += "AND a.MatrixID in (" + MatrixIDs + ") "; SQL += "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; return base.ExecuteReader(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable List(DateTime StartChangeDate, DateTime EndChangeDate, long ProductID = 0, string SortField = "ChangeDate", SortOption SortOrder = SortOption.Ascending) { try { string SQL = "CALL procProductPriceHistorySelect(@StartChangeDate, @EndChangeDate, @ProductID, @SortField, @SortOrder)"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@StartChangeDate", StartChangeDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@EndChangeDate", EndChangeDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.Parameters.AddWithValue("@SortField", SortField); switch (SortOrder) { case SortOption.Ascending: cmd.Parameters.AddWithValue("@SortOrder", "ASC"); break; case SortOption.Desscending: cmd.Parameters.AddWithValue("@SortOrder", "DESC"); break; } string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(Int64 MatrixID, string SortField, SortOption SortOrder) { try { string SQL = SQLSelect() + "WHERE 1=1 AND a.MatrixID = @MatrixID ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.Connection = GetConnection(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@MatrixID", MatrixID); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(string SearchKey = null, string SortField = "DiscountCode", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + " "; if (!string.IsNullOrEmpty(SearchKey)) { SQL += "WHERE DiscountType LIKE @SearchKey "; cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%"); } SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "DiscountCode") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public static IEnumerable<ClearedTaskModel> GetClearedTasks(SortOption sortOption) { return DataLayer.TaskDatabase.GetItems<ClearedTaskModel>().OrderByDescending(t => t.DateCompleted); }
//public MySqlDataReader Search(string SearchKey, string SortField, SortOption SortOrder) //{ // try // { // string SQL = SQLSelect() + "(TransactionNo LIKE @SearchKey " + // "OR StockTypeCode LIKE @SearchKey " + // "OR a.Remarks LIKE @SearchKey) " + // "ORDER BY " + SortField; // if (SortOrder == SortOption.Ascending) // SQL += " ASC"; // else // SQL += " DESC"; // MySqlCommand cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String); // prmSearchKey.Value = "%" + SearchKey + "%"; // cmd.Parameters.Add(prmSearchKey); // return base.ExecuteReader(cmd); // } // catch (Exception ex) // { // { // } // throw base.ThrowException(ex); // } //} //public MySqlDataReader List(string SortField, SortOption SortOrder) //{ // try // { // string SQL = SQLSelect() + "ORDER BY " + SortField; // if (SortOrder == SortOption.Ascending) // SQL += " ASC"; // else // SQL += " DESC"; // MySqlCommand cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // return base.ExecuteReader(cmd); // } // catch (Exception ex) // { // { // } // throw base.ThrowException(ex); // } //} public System.Data.DataTable ListAsDataTableActiveInactive(TransactionListFilterType clsTransactionListFilterType, string SearchKey = null, string SortField = "StockID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (clsTransactionListFilterType == TransactionListFilterType.ShowActiveOnly) { SQL += "AND a.Active = 1 "; } else if (clsTransactionListFilterType == TransactionListFilterType.ShowInactiveOnly) { SQL += "AND a.Active = 0 "; } if (!string.IsNullOrEmpty(SearchKey)) { SQL += "AND (TransactionNo LIKE @SearchKey " + "OR StockTypeCode LIKE @SearchKey " + "OR a.Remarks LIKE @SearchKey) "; cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%"); } SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "StockID") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public MySqlDataReader List(string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID"; string SQL = SQLSelect() + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlDataReader myReader = base.ExecuteReader(cmd); return myReader; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(Int64 MatrixID, string SortField, SortOption SortOrder) { try { string SQL = SQLSelect() + "WHERE 1=1 AND a.MatrixID = @MatrixID ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } MySqlCommand cmd = new MySqlCommand(); cmd.Connection = GetConnection(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@MatrixID", MatrixID); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public MySqlDataReader List(CreditMemoItemStatus CreditMemoItemstatus, string SortField, SortOption SortOrder) { try { if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID"; string SQL = SQLSelect() + "WHERE ItemStatus = @ItemStatus " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) SQL += " ASC"; else SQL += " DESC"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmCreditMemoItemStatus = new MySqlParameter("@ItemStatus",MySqlDbType.Int16); prmCreditMemoItemStatus.Value = CreditMemoItemstatus.ToString("d"); cmd.Parameters.Add(prmCreditMemoItemStatus); MySqlDataReader myReader = base.ExecuteReader(cmd); return myReader; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public MySqlDataReader Search(long GJournalID, string SearchKey, string SortField, SortOption SortOrder) { try { string SQL = "SELECT " + "GJournalDebitID, " + "GJournalID, " + "a.ChartOfAccountID, " + "ChartOfAccountCode, " + "ChartOfAccountName, " + "Amount " + "FROM tblGJournalDebit a INNER JOIN tblChartOfAccount b " + "ON a.ChartOfAccountID = b.ChartOfAccountID " + "WHERE GJournalID = @GJournalID " + "AND (ChartOfAccountCode LIKE @SearchKey " + "or ChartOfAccountName LIKE @SearchKey) " + "ORDER BY " + SortField; if (SortOrder == SortOption.Ascending) { SQL += " ASC"; } else { SQL += " DESC"; } MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64); prmGJournalID.Value = GJournalID; cmd.Parameters.Add(prmGJournalID); MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String); prmSearchKey.Value = "%" + SearchKey + "%"; cmd.Parameters.Add(prmSearchKey); MySqlDataReader myReader = base.ExecuteReader(cmd); return(myReader); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public System.Data.DataTable ListSuspendedDataTable(Int32 BranchID, string TerminalNo, Int64 CashierID = 0, bool isPacked = false, string SortField = "TransactionDate", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { return ListAsDataTable(BranchID, TerminalNo, CashierID: CashierID, isPacked: isPacked, ShowSuspendedOnly: true, SortField: SortField, SortOption: SortOrder, limit: limit); //MySqlCommand cmd = new MySqlCommand(); //cmd.CommandType = System.Data.CommandType.Text; //SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns(); //clsSalesTransactionsColumns.TransactionNo = true; //clsSalesTransactionsColumns.CustomerName = true; //clsSalesTransactionsColumns.DateSuspended = true; //string SQL = SQLSelect(clsSalesTransactionsColumns) + "WHERE tblTransactions.TransactionStatus = @TransactionStatus "; //cmd.Parameters.AddWithValue("@TransactionStatus", TransactionStatus.Suspended.ToString("d")); //if (BranchID != 0) //{ // SQL += "AND tblTransactions.BranchID = @BranchID "; // cmd.Parameters.AddWithValue("@BranchID", BranchID); //} //if (TerminalNo != string.Empty && TerminalNo != null) //{ // SQL += "AND tblTransactions.TerminalNo = @TerminalNo "; // cmd.Parameters.AddWithValue("@TerminalNo", TerminalNo); //} //if (CashierID != 0) //{ // SQL += "AND tblTransactions.CashierID = @CashierID "; // cmd.Parameters.AddWithValue("@CashierID", CashierID); //} //SQL += !isPacked ? "" : "AND Packed = 1 "; //SQL += "ORDER BY " + SortField + " "; //SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; //SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; //cmd.CommandText = SQL; //string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); //base.MySqlDataAdapterFill(cmd, dt); //return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(long POID = 0, string SortField = "POItemID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect(); if (POID != 0) { SQL += "WHERE POID = @POID "; cmd.Parameters.AddWithValue("@POID", POID); } SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "POItemID") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); }
public System.Data.DataTable ListAsDataTable(Int32 BranchID, string TerminalNo = "", Int64 TransactionID = 0, string TransactionNo = "", DateTime? TransactionDateFrom = null, DateTime? TransactionDateTo = null, TransactionStatus TransactionStatus = TransactionStatus.NotYetApplied, PaymentTypes PaymentType = PaymentTypes.NotYetAssigned, bool isConsignment = false, bool isPacked = false, string CustomerName = "", string CustomerGroupName = "", Int64 CashierID = 0, string CashierName = "", string AgentName = "", bool WithTF = false, bool ShowSuspendedOnly = false, string SortField = "", SortOption SortOption = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procTransactionsSelect(@BranchID, @TerminalNo, @TransactionID, @TransactionNo, @TransactionDateFrom, " + "@TransactionDateTo, @TransactionStatus, @PaymentType, @isConsignment, @isPacked, @CustomerName, " + "@CustomerGroupName, @CashierID, @CashierName, @AgentName, @WithTF, @ShowSuspended, " + "@SortField, @SortOption, @Limit);"; cmd.Parameters.AddWithValue("BranchID", BranchID); cmd.Parameters.AddWithValue("TerminalNo", TerminalNo); cmd.Parameters.AddWithValue("TransactionID", TransactionID); cmd.Parameters.AddWithValue("TransactionNo", TransactionNo); cmd.Parameters.AddWithValue("TransactionDateFrom", TransactionDateFrom.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : TransactionDateFrom); cmd.Parameters.AddWithValue("TransactionDateTo", TransactionDateTo.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : TransactionDateTo); cmd.Parameters.AddWithValue("TransactionStatus", TransactionStatus.ToString("d")); cmd.Parameters.AddWithValue("PaymentType", PaymentType.ToString("d")); cmd.Parameters.AddWithValue("isConsignment", isConsignment); cmd.Parameters.AddWithValue("isPacked", isPacked); cmd.Parameters.AddWithValue("CustomerName", CustomerName); cmd.Parameters.AddWithValue("CustomerGroupName", CustomerGroupName); cmd.Parameters.AddWithValue("CashierID", CashierID); cmd.Parameters.AddWithValue("CashierName", CashierName); cmd.Parameters.AddWithValue("AgentName", AgentName); cmd.Parameters.AddWithValue("WithTF", WithTF); cmd.Parameters.AddWithValue("ShowSuspended", ShowSuspendedOnly); cmd.Parameters.AddWithValue("SortField", SortField); cmd.Parameters.AddWithValue("SortOption", SortOption==SortOption.Ascending ? "ASC" : "DESC"); cmd.Parameters.AddWithValue("Limit", limit); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public GetProductsQuery(SortOption sortOption) { SortOption = sortOption; }
public System.Data.DataTable ListAsDataTable(Int64 ParkingRateID, long ProductID, string DayOfWeek, string StartTime = "", string EndTime = "", string SortField = "DayOfWeek", SortOption SortOrder = SortOption.Ascending) { try { string SQL = "CALL procParkingRateSelect(@ParkingRateID, @ProductID, @DayOfWeek, @StartTime, @EndTime, @SortField, @SortOrder)"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@ParkingRateID", ParkingRateID); cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.Parameters.AddWithValue("@DayOfWeek", DayOfWeek); cmd.Parameters.AddWithValue("@StartTime", StartTime); cmd.Parameters.AddWithValue("@EndTime", EndTime); cmd.Parameters.AddWithValue("@SortField", SortField); cmd.Parameters.AddWithValue("@SortOrder", SortOrder == SortOption.Ascending ? "ASC" : "DESC"); string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(Int64 MainProductID, string SortField = "CompositionID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE MainProductID = @MainProductID "; cmd.Parameters.AddWithValue("@MainProductID", MainProductID); SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }