Exemplo n.º 1
0
 public void UpdateBrandCategoryDisplaySequence(int brandId, SortAction action)
 {
     System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_BrandCategory_DisplaySequence");
     this.database.AddInParameter(storedProcCommand, "BrandId", System.Data.DbType.Int32, brandId);
     this.database.AddInParameter(storedProcCommand, "Sort", System.Data.DbType.Int32, action);
     this.database.ExecuteNonQuery(storedProcCommand);
 }
Exemplo n.º 2
0
        static string BuildTopQuery(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields)
        {
            string        str     = string.IsNullOrEmpty(sortBy) ? pk : sortBy;
            string        str2    = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);
            string        str3    = string.IsNullOrEmpty(filter) ? "" : ("AND " + filter);
            StringBuilder builder = new StringBuilder();

            builder.AppendFormat("SELECT TOP {0} {1} FROM {2} ", pageSize.ToString(CultureInfo.InvariantCulture), selectFields, table);
            if (pageIndex == 1)
            {
                builder.AppendFormat("{0} ORDER BY {1} {2}", str2, str, sortOrder.ToString());
            }
            else
            {
                int num = (pageIndex - 1) * pageSize;
                if (sortOrder == SortAction.Asc)
                {
                    builder.AppendFormat("WHERE {0} > (SELECT MAX({0}) FROM (SELECT TOP {1} {0} FROM {2} {3} ORDER BY {0} ASC) AS TMP) {4} ORDER BY {0} ASC", new object[] { str, num, table, str2, str3 });
                }
                else
                {
                    builder.AppendFormat("WHERE {0} < (SELECT MIN({0}) FROM (SELECT TOP {1} {0} FROM {2} {3} ORDER BY {0} DESC) AS TMP) {4} ORDER BY {0} DESC", new object[] { str, num, table, str2, str3 });
                }
            }
            if (isCount)
            {
                builder.AppendFormat(";SELECT COUNT({0}) FROM {1} {2}", str, table, str2);
            }
            return(builder.ToString());
        }
Exemplo n.º 3
0
        public static string BuildRownumberQuery(string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
        {
            StringBuilder stringBuilder = new StringBuilder();
            string        text          = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);

            if (partitionSize > 0)
            {
                stringBuilder.AppendFormat("SELECT TOP {0} {1}, ROW_NUMBER() OVER (ORDER BY ", partitionSize.ToString(CultureInfo.InvariantCulture), selectFields);
            }
            else
            {
                stringBuilder.AppendFormat("SELECT {0} , ROW_NUMBER() OVER (ORDER BY ", selectFields);
            }
            stringBuilder.AppendFormat("{0} {1}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, sortOrder.ToString());
            stringBuilder.AppendFormat(") AS RowNumber FROM {0} {1}", table, text);
            stringBuilder.Insert(0, "SELECT * FROM (").Append(") T WHERE T.RowNumber BETWEEN @StartNumber AND @EndNumber");
            string text2 = "";

            if (!string.IsNullOrEmpty(sortBy))
            {
                if (sortBy.IndexOf(",") > 0)
                {
                    text2 = sortBy.Substring(0, sortBy.IndexOf(","));
                }
                else
                {
                    text2 = sortBy;
                }
            }
            if (isCount && partitionSize == 0)
            {
                stringBuilder.AppendFormat(";SELECT COUNT(0) FROM {1} {2}", string.IsNullOrEmpty(text2) ? pk : text2, table, text);
            }
            return(stringBuilder.ToString());
        }
Exemplo n.º 4
0
        private bool LoadPreviousTags()
        {
            const bool EMPTY_CURRENT_TAGS = false;

            for (int i = 0; i < doneActions.Count; i++)
            {
                SortAction action = doneActions.ElementAt(i);

                //Search through doneActions for the most recent "Move" action that will have the previously used tags in it.
                if (action.GetType() == typeof(Move))
                {
                    if (EMPTY_CURRENT_TAGS)
                    {
                        while (EnabledTags.Count > 0)
                        {
                            EnabledTags.Clear();
                        }
                    }

                    /*for (int t = 0; t < (action as Move).tags.Length; t++)
                     * {
                     *  EnabledTags.Add((action as Move).tags[t]);
                     * }*/

                    EnabledTags.AddRange((action as Move).tags);

                    // The most recent move action was found and the tags were loaded.
                    return(true);
                }
            }

            // No recent move action was found and no tags were loaded.
            return(false);
        }
Exemplo n.º 5
0
        private static string BuildRownumberQuery(string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize, bool isAdmin)
        {
            if (!isAdmin)
            {
                if (!String.IsNullOrEmpty(sortBy))
                {
                    if (sortBy.Equals("DisplaySequence") && table.Equals("vw_Ecshop_BrowseProductList p"))
                    {
                        sortBy = "Fraction";
                    }
                }
            }
            StringBuilder stringBuilder = new StringBuilder();
            string        text          = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);

            if (partitionSize > 0)
            {
                stringBuilder.AppendFormat("SELECT TOP {0} {1}, ROW_NUMBER() OVER (ORDER BY ", partitionSize.ToString(CultureInfo.InvariantCulture), selectFields);
            }
            else
            {
                stringBuilder.AppendFormat("SELECT {0} , ROW_NUMBER() OVER (ORDER BY ", selectFields);
            }
            stringBuilder.AppendFormat("{0} {1}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, sortOrder.ToString());
            stringBuilder.AppendFormat(") AS RowNumber FROM {0} {1}", table, text);
            stringBuilder.Insert(0, "SELECT * FROM (").Append(") T WHERE T.RowNumber BETWEEN @StartNumber AND @EndNumber");
            if (isCount && partitionSize == 0)
            {
                stringBuilder.AppendFormat(";SELECT COUNT({0}) FROM {1} {2}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, table, text);
            }
            return(stringBuilder.ToString());
        }
Exemplo n.º 6
0
    public void SortSubFolders(SortAction sortAction, ref PGFolderComparer defaultcomparer)
    {
        PGFolderComparer comparer = PGFolderComparer.GetComparerBySortAction(sortAction, defaultcomparer);

        SubFolders.Sort(comparer);
        defaultcomparer = comparer;
    }
Exemplo n.º 7
0
        private static string CteRownumberQuery(string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
        {
            StringBuilder builder = new StringBuilder();
            string        str     = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);

            if (partitionSize > 0)
            {
                builder.AppendFormat("SELECT TOP {0} {1}, ROW_NUMBER() OVER (ORDER BY ", partitionSize.ToString(CultureInfo.InvariantCulture), selectFields);
            }
            else
            {
                builder.AppendFormat("SELECT {0} , ROW_NUMBER() OVER (ORDER BY ", selectFields);
            }
            builder.AppendFormat("{0} {1}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, sortOrder.ToString());
            builder.AppendFormat(") AS RowNumber FROM {0} {1}", table, str);
            builder.Insert(0, "SELECT * FROM (").Append(") T WHERE T.RowNumber BETWEEN @StartNumber AND @EndNumber ORDER BY sortStr");
            if (isCount && (partitionSize == 0))
            {
                builder.AppendFormat(@";with cte as(select convert(nvarchar(50), UserID) as sortStr,* from vw_aspnet_Chanels 
                                        where ParentID=0 or ParentID is null union
                                         all select convert(nvarchar(50),convert(nvarchar(6), isnull(a.ParentID,0))+'-'+convert(nvarchar(6),isnull(a.UserID,0))) as sortStr,a.* 
                                         from vw_aspnet_Chanels a join cte b on a.ParentID=b.UserID) SELECT COUNT({0}) FROM cte {1}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, str);
            }
            return(builder.ToString());
        }
Exemplo n.º 8
0
        /// <summary>
        /// 初始化绑定商品数据
        /// </summary>
        /// <param name="sortBy"></param>
        /// <param name="sortOrder"></param>
        private void BindProducts(string sortBy, SortAction sortOrder)
        {
            this.LoadParameters();
            PurchaseOrderItemQuery purchaseOrderItemQuery = new PurchaseOrderItemQuery
            {
                POId        = this.POId,
                PageSize    = this.pager.PageSize,
                PageIndex   = this.pager.PageIndex,
                SortOrder   = sortOrder,
                SortBy      = sortBy,
                ProductName = this.productsName,
                BarCode     = this.barCode,
            };


            Globals.EntityCoding(purchaseOrderItemQuery, true);
            DbQueryResult purchaseOrder = PurchaseOrderHelper.GetPurchaseOrderItemList(purchaseOrderItemQuery);

            this.rpPOItem.DataSource = purchaseOrder.Data;
            this.rpPOItem.DataBind();
            //获取采购单总数量,采购单总金额(最上面或者最底下加整个明细的加总)
            DataSet ds = PurchaseOrderHelper.GetPOTotalQuyAndAmount(this.POId);

            //ExpectQuantity,OriginalCurrencyTotalPrice,TotalSalePrice
            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                lblTotal.Text = string.Format("合计:采购单总数量:{0};    采购单原币总金额:{1};    采购单销售总金额:{2};", ds.Tables[0].Rows[0][0], ds.Tables[0].Rows[0][1], ds.Tables[0].Rows[0][2]);
            }
            this.pager1.TotalRecords = (this.pager.TotalRecords = purchaseOrder.TotalRecords);
        }
Exemplo n.º 9
0
    public static PGFolderComparer GetComparerBySortAction(SortAction sortAction, PGFolderComparer inheritComparer)
    {
        PGFolderComparer comparer = new PGFolderComparer();

        if (sortAction == SortAction.NameASC)
        {
            comparer = new PGFolderNameASCComparer();
        }
        else if (sortAction == SortAction.NameDESC)
        {
            comparer = new PGFolderNameDESCComparer();
        }
        else if (sortAction == SortAction.DateTimeASC)
        {
            comparer = new PGFolderDateASCComparer();
        }
        else if (sortAction == SortAction.DateTimeDESC)
        {
            comparer = new PGFolderDateDESCComparer();
        }
        else if (sortAction == SortAction.CustomOrderProperty)
        {
            comparer = new PGFolderOrderComparer();
        }
        else if (sortAction == SortAction.Inherit)
        {
            comparer = inheritComparer;
        }
        else
        {
            throw new Exception("Comparer not found");
        }

        return(comparer);
    }
Exemplo n.º 10
0
		public SortSettings()
		{
			this.AutoSortByPrimaryKey = true;
			this.InitialSortColumn = "";
			this.InitialSortDirection = SortDirection.Asc;
			this.SortIconsPosition = SortIconsPosition.Vertical;
			this.SortAction = SortAction.ClickOnHeader;
		}
Exemplo n.º 11
0
        public void SortPaymentMode(int modeId, SortAction action)
        {
            DbCommand storedProcCommand = this.database.GetStoredProcCommand("sp_Pay_PaymentMode_Sequence");

            this.database.AddInParameter(storedProcCommand, "ModeId", DbType.Int32, modeId);
            this.database.AddInParameter(storedProcCommand, "Sort", DbType.Int32, (int)action);
            this.database.ExecuteNonQuery(storedProcCommand);
        }
Exemplo n.º 12
0
 public SortSettings()
 {
     this.AutoSortByPrimaryKey = true;
     this.InitialSortColumn    = "";
     this.InitialSortDirection = SortDirection.Asc;
     this.SortIconsPosition    = SortIconsPosition.Vertical;
     this.SortAction           = SortAction.ClickOnHeader;
 }
Exemplo n.º 13
0
        private void DoAction(SortAction action)
        {
            action.Do();
            doneActions.Push(action);
            undoneActions.Clear();

            form.ValidateChildren();
        }
Exemplo n.º 14
0
        /// <summary>
        /// 初始化绑定商品数据
        /// </summary>
        /// <param name="sortBy"></param>
        /// <param name="sortOrder"></param>
        private void BindProducts(string sortBy, SortAction sortOrder)
        {
            DbQueryResult purchaseOrder = this.GetData(sortBy, sortOrder);

            this.rpPO.DataSource = purchaseOrder.Data;
            this.rpPO.DataBind();

            this.pager1.TotalRecords = (this.pager.TotalRecords = purchaseOrder.TotalRecords);
        }
Exemplo n.º 15
0
        public void UpdateBrandCategoryDisplaySequence(int brandId, SortAction action)
        {
            // not found "cp_BrandCategory_DisplaySequence" store procedure
            DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_BrandCategory_DisplaySequence");

            this.database.AddInParameter(storedProcCommand, "BrandId", DbType.Int32, brandId);
            this.database.AddInParameter(storedProcCommand, "Sort", DbType.Int32, action);
            this.database.ExecuteNonQuery(storedProcCommand);
        }
Exemplo n.º 16
0
        private void BindData(string creTime, SortAction sortAction)
        {
            DbQueryResult purchaseOrder = this.GetData(creTime, sortAction);

            this.rpPO.DataSource = purchaseOrder.Data;
            this.rpPO.DataBind();

            this.pager1.TotalRecords = (this.pager.TotalRecords = purchaseOrder.TotalRecords);
        }
Exemplo n.º 17
0
 public void SortPaymentMode(int modeId, SortAction action)
 {
     //MySqlParameter[] parameters = {
     //                            new MySqlParameter("?ModeId",MySqlDbType.Int32),
     //                            new MySqlParameter("?Sort",MySqlDbType.Int32)
     //                            };
     //parameters[0].Value = modeId;
     //parameters[1].Value = (int)action;
     //DbHelperMySQL.RunProcedure("sp_Pay_PaymentMode_Sequence", parameters);
 }
Exemplo n.º 18
0
 public void SortPaymentMode(int modeId, SortAction action)
 {
     //SqlParameter[] parameters = {
     //                            new SqlParameter("@ModeId",SqlDbType.Int),
     //                            new SqlParameter("@Sort",SqlDbType.Int)
     //                            };
     //parameters[0].Value = modeId;
     //parameters[1].Value = (int)action;
     //DBHelper.DefaultDBHelper.RunProcedure("sp_Pay_PaymentMode_Sequence", parameters);
 }
Exemplo n.º 19
0
        public virtual IList <T> Gets <T>(string sortBy, SortAction sortOrder, int?maxNum = default(int?)) where T : new()
        {
            Type               typeFromHandle     = typeof(T);
            List <T>           list               = new List <T>();
            TableNameAttribute tableNameAttribute = (TableNameAttribute)Attribute.GetCustomAttribute(typeFromHandle, typeof(TableNameAttribute));
            string             text               = "SELECT";

            if (maxNum.HasValue)
            {
                text = text + " TOP " + maxNum.Value;
            }
            text = text + " * FROM " + tableNameAttribute.TableName + " ORDER BY " + sortBy + " " + sortOrder.ToString();
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(text);

            using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
            {
                while (dataReader.Read())
                {
                    T   val        = new T();
                    int fieldCount = dataReader.FieldCount;
                    for (int i = 0; i < fieldCount; i++)
                    {
                        if (((IDataRecord)dataReader)[i] != DBNull.Value)
                        {
                            PropertyInfo property = typeFromHandle.GetProperty(dataReader.GetName(i), BindingFlags.IgnoreCase | BindingFlags.Instance | BindingFlags.Public | BindingFlags.GetProperty);
                            if (property != (PropertyInfo)null)
                            {
                                Type type = property.PropertyType;
                                if (type.IsGenericType && type.GetGenericTypeDefinition().Equals(typeof(Nullable <>)))
                                {
                                    NullableConverter nullableConverter = new NullableConverter(type);
                                    type = nullableConverter.UnderlyingType;
                                }
                                if (type.IsEnum)
                                {
                                    object value = Enum.ToObject(type, ((IDataRecord)dataReader)[i]);
                                    property.SetValue(val, value, null);
                                }
                                else
                                {
                                    object obj = Convert.ChangeType(((IDataRecord)dataReader)[i], type);
                                    if (type.Equals(typeof(string)) && obj == null)
                                    {
                                        obj = string.Empty;
                                    }
                                    property.SetValue(val, obj, null);
                                }
                            }
                        }
                    }
                    list.Add(val);
                }
            }
            return(list);
        }
Exemplo n.º 20
0
        public IList <ShippersInfo> GetShippersBySupplierId(int supplierId, SortAction sortOrder)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.AppendFormat("SELECT * FROM Hishop_Shippers where SupplierId={0} ", supplierId);
            stringBuilder.AppendFormat(" ORDER BY ShipperId {0}", sortOrder);
            DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());

            using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
            {
                return(DataHelper.ReaderToList <ShippersInfo>(objReader));
            }
        }
Exemplo n.º 21
0
        void grdProducts_Sorting(object sender, GridViewSortEventArgs e)
        {
            string     sort      = e.SortExpression;
            SortAction sortOrder = grdProducts.SortOrder.ToLower() == "asc" ? SortAction.Asc : SortAction.Desc;

            this.sortBy             = sort;
            this.sortOrder          = grdProducts.SortOrder;
            this.hidSortOrder.Value = this.sortOrder;
            this.hidSortBy.Value    = this.sortBy;
            this.ReloadProductOnSales(true);
            //绑定排序数据
            //this.BindProducts(sort, sortOrder);
        }
Exemplo n.º 22
0
        private void BindProducts(string sortBy, SortAction sortOrder)
        {
            this.LoadParameters();
            ProductQuery productQuery = new ProductQuery
            {
                Keywords       = this.productName,
                ProductCode    = this.productCode,
                CategoryId     = this.categoryId,
                PageSize       = this.pager.PageSize,
                PageIndex      = this.pager.PageIndex,
                SortOrder      = sortOrder,
                SortBy         = sortBy,
                StartDate      = this.startDate,
                BrandId        = this.dropBrandList.SelectedValue.HasValue ? this.dropBrandList.SelectedValue : null,
                TagId          = this.dropTagList.SelectedValue.HasValue ? this.dropTagList.SelectedValue : null,
                TypeId         = this.typeId,
                SaleStatus     = this.saleStatus,
                EndDate        = this.endDate,
                ImportSourceId = this.ddlImportSourceType.SelectedValue.HasValue ? this.ddlImportSourceType.SelectedValue : null,
                SupplierId     = this.ddlSupplier.SelectedValue.HasValue ? this.ddlSupplier.SelectedValue : null,
                TemplateId     = this.ddlShipping.SelectedValue.HasValue ? this.ddlShipping.SelectedValue : null,
                IsApproved     = this.IsApproved
            };

            if (this.categoryId.HasValue)
            {
                productQuery.MaiCategoryPath = CatalogHelper.GetCategory(this.categoryId.Value).Path;
            }
            Globals.EntityCoding(productQuery, true);
            DbQueryResult products = ProductHelper.GetProductsAdmin(productQuery);

            this.grdProducts.DataSource = products.Data;
            this.grdProducts.DataBind();
            // this.grdProducts.SortDirection = SortDirection.Ascending;
            this.txtSearchText.Text                = productQuery.Keywords;
            this.txtSKU.Text                       = productQuery.ProductCode;
            this.dropCategories.SelectedValue      = productQuery.CategoryId;
            this.dropType.SelectedValue            = productQuery.TypeId;
            this.ddlImportSourceType.SelectedValue = productQuery.ImportSourceId;
            this.ddlSupplier.SelectedValue         = productQuery.SupplierId;
            this.ddlShipping.SelectedValue         = productQuery.TemplateId;
            if (productQuery.IsApproved.HasValue)
            {
                this.dropIsApproved.SelectedValue = productQuery.IsApproved.Value.ToString();
            }
            this.pager1.TotalRecords = (this.pager.TotalRecords = products.TotalRecords);
        }
Exemplo n.º 23
0
        /// <summary>
        /// 排序并返回列表。
        /// </summary>
        public System.Collections.Generic.List <DatabaseSchemaHandler> Sort()
        {
            System.Collections.Generic.List <DatabaseSchemaHandler> list = new System.Collections.Generic.List <DatabaseSchemaHandler>();
            //foreach(AssemblyRef
            System.Collections.Generic.Dictionary <string, SortEntry> refOrders = new System.Collections.Generic.Dictionary <string, SortEntry>();
            System.Collections.Generic.List <AssemblyRef>             all       = LinqHelper.ToList(_refs.Values);

            SortAction action = null; action = (p1, p2) => {
                foreach (string p11 in p1.refs)
                {
                    AssemblyRef p12;
                    if (_refs.TryGetValue(p11, out p12))
                    {
                        if (all.Remove(p12))
                        {
                            action(p12, p2 * 1000);
                        }
                    }
                }
                SortEntry p10 = new SortEntry()
                {
                    item  = p1,
                    order = p2 * (refOrders.Count + 1)
                };
                refOrders.Add(p1.fullName, p10);
                return(p10);
            };

            while (all.Count > 0)
            {
                AssemblyRef item = all[0];
                all.RemoveAt(0);
                action(item, -1);
            }
            SortFunc classOrderGetter = (p1) => p1.Attribute.Order + GetClassRef(p1.Attribute.TableName, p1.Attribute.References);

            foreach (SortEntry p1 in LinqHelper.OrderByDescending(refOrders.Values, p => p.order))
            {
                list.AddRange(p1.item.SortList(classOrderGetter));
            }
            refOrders.Clear();
            refOrders = null;
            all       = null;
            return(list);
        }
Exemplo n.º 24
0
        private DbQueryResult GetData(string sortBy, SortAction sortOrder)
        {
            this.LoadParameters();
            PODeclareListQuery PODeclareListQuery = new PODeclareListQuery
            {
                PageSize  = this.pager.PageSize,
                PageIndex = this.pager.PageIndex,
                SortOrder = sortOrder,
                SortBy    = sortBy,
                StartDate = this.startDate,
                EndDate   = this.endDate,
                //POCDStatus = this.POCDStatus,
                fromID   = this.fromID,
                PONumber = this.poNumber
            };

            Globals.EntityCoding(PODeclareListQuery, true);
            return(PurchaseOrderHelper.GetPODeclareList(PODeclareListQuery));
        }
Exemplo n.º 25
0
        /// <summary>
        /// Pop an action from the undoneActions stack and exeucutes it. Returns false if there was no action on the stack to redo.
        /// </summary>
        public bool Redo()
        {
            if (undoneActions.Count > 0)
            {
                SortAction action = undoneActions.Pop();

                action.Do();

                if (action.Successful)
                {
                    doneActions.Push(action);
                }

                form.ValidateChildren();

                return(true);
            }

            return(false);
        }
Exemplo n.º 26
0
        private static string BuildRownumberQuery(string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
        {
            StringBuilder builder = new StringBuilder();
            string        str     = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);

            if (partitionSize > 0)
            {
                builder.AppendFormat("SELECT TOP {0} {1}, ROW_NUMBER() OVER (ORDER BY ", partitionSize.ToString(CultureInfo.InvariantCulture), selectFields);
            }
            else
            {
                builder.AppendFormat("SELECT {0} , ROW_NUMBER() OVER (ORDER BY ", selectFields);
            }
            builder.AppendFormat("{0} {1}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, sortOrder.ToString());
            builder.AppendFormat(") AS RowNumber FROM {0} {1}", table, str);
            builder.Insert(0, "SELECT * FROM (").Append(") T WHERE T.RowNumber BETWEEN @StartNumber AND @EndNumber");
            if (isCount && (partitionSize == 0))
            {
                builder.AppendFormat(";SELECT COUNT({0}) FROM {1} {2}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, table, str);
            }
            return(builder.ToString());
        }
Exemplo n.º 27
0
 public static string BuildNotinQuery(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string key, string filter, string selectFields)
 {
     string str = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);
     string str2 = string.IsNullOrEmpty(filter) ? "" : ("AND " + filter);
     string str3 = string.IsNullOrEmpty(sortBy) ? "" : ("ORDER BY " + sortBy + " " + sortOrder.ToString());
     StringBuilder builder = new StringBuilder();
     builder.AppendFormat("SELECT TOP {0} {1} FROM {2} ", pageSize.ToString(CultureInfo.InvariantCulture), selectFields, table);
     if (pageIndex == 1)
     {
         builder.AppendFormat("{0} {1}", str, str3);
     }
     else
     {
         int num = (pageIndex - 1) * pageSize;
         builder.AppendFormat("WHERE {0} NOT IN (SELECT TOP {1} {0} FROM {2} {3} {4}) {5} {4}", new object[] { key, num, table, str, str3, str2 });
     }
     if (isCount)
     {
         builder.AppendFormat(";SELECT COUNT({0}) FROM {1} {2}", key, table, str);
     }
     return builder.ToString();
 }
Exemplo n.º 28
0
        private DbQueryResult GetData(string sortBy, SortAction sortOrder)
        {
            this.LoadParameters();
            PurchaseOrderQuery purchaseOrderQuery = new PurchaseOrderQuery
            {
                PageSize   = this.pager.PageSize,
                PageIndex  = this.pager.PageIndex,
                SortOrder  = sortOrder,
                SortBy     = sortBy,
                StartDate  = this.startDate,
                EndDate    = this.endDate,
                PONumber   = this.poNumber,
                SupplierId = this.supplierId,
                POStatus   = this.Status,
                HSInOut    = this.hsInOut,
                QPStatus   = this.QPStatus,
                CIStatus   = this.CIStatus
            };

            Globals.EntityCoding(purchaseOrderQuery, true);
            return(PurchaseOrderHelper.GetPurchaseOrderList(purchaseOrderQuery));
        }
        private void EditSortDescriptions(SortAction a)
        {
            var sortDestination = (new SortDescription("Destination.Name", ListSortDirection.Ascending));
            var sortDate        = (new SortDescription("StartDate", ListSortDirection.Descending));

            switch (a)
            {
            case SortAction.Add:
                tripListBox.Items.SortDescriptions.Add(sortDestination);
                tripListBox.Items.SortDescriptions.Add(sortDate);
                break;

            case SortAction.Delete:
                if (tripListBox.Items.SortDescriptions.Contains(sortDate))
                {
                    tripListBox.Items.SortDescriptions.Remove(sortDestination);
                    tripListBox.Items.SortDescriptions.Remove(sortDate);
                }
                break;

            default:
                break;
            }
        }
Exemplo n.º 30
0
 public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
 {
     if (string.IsNullOrEmpty(table))
     {
         return null;
     }
     if (string.IsNullOrEmpty(sortBy) && string.IsNullOrEmpty(pk))
     {
         return null;
     }
     if (string.IsNullOrEmpty(selectFields))
     {
         selectFields = "*";
     }
     string query = BuildRownumberQuery(sortBy, sortOrder, isCount, table, pk, filter, selectFields, partitionSize);
     int num = ((pageIndex - 1) * pageSize) + 1;
     int num2 = (num + pageSize) - 1;
     DbQueryResult result = new DbQueryResult();
     SqlConnection cn = new SqlConnection(Init.GetConnectionString());
     SqlCommand cmd = new SqlCommand(query, cn);
     cmd.Parameters.Add("@StartNumber", num);
     cmd.Parameters.Add("@EndNumber", num2);
     cn.Open();
     using (IDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
     {
         result.Data = ConverDataReaderToDataTable(reader);
         if ((isCount && (partitionSize == 0)) && reader.NextResult())
         {
             reader.Read();
             result.TotalRecords = reader.GetInt32(0);
         }
     }
     return result;
 }
Exemplo n.º 31
0
 public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields)
 {
     return PagingByRownumber(pageIndex, pageSize, sortBy, sortOrder, isCount, table, pk, filter, selectFields, 0);
 }
Exemplo n.º 32
0
 public abstract void UpdateBrandCategoryDisplaySequence(int brandId, SortAction action);
Exemplo n.º 33
0
 public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields)
 {
     return PagingByRownumber(pageIndex, pageSize, sortBy, sortOrder, isCount, table, pk, filter, selectFields, 0);
 }
Exemplo n.º 34
0
 public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
 {
     if (string.IsNullOrEmpty(table))
     {
         return null;
     }
     if (string.IsNullOrEmpty(sortBy) && string.IsNullOrEmpty(pk))
     {
         return null;
     }
     if (string.IsNullOrEmpty(selectFields))
     {
         selectFields = "*";
     }
     string query = BuildRownumberQuery(sortBy, sortOrder, isCount, table, pk, filter, selectFields, partitionSize);
     int num = ((pageIndex - 1) * pageSize) + 1;
     int num2 = (num + pageSize) - 1;
     DbQueryResult result = new DbQueryResult();
     Database database = DatabaseFactory.CreateDatabase();
     DbCommand sqlStringCommand = database.GetSqlStringCommand(query);
     database.AddInParameter(sqlStringCommand, "StartNumber", DbType.Int32, num);
     database.AddInParameter(sqlStringCommand, "EndNumber", DbType.Int32, num2);
     using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
     {
         result.Data = ConverDataReaderToDataTable(reader);
         if ((isCount && (partitionSize == 0)) && reader.NextResult())
         {
             reader.Read();
             result.TotalRecords = reader.GetInt32(0);
         }
     }
     return result;
 }
Exemplo n.º 35
0
 public static DbQueryResult PagingByTopsort(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields)
 {
     if (string.IsNullOrEmpty(table))
     {
         return null;
     }
     if (string.IsNullOrEmpty(sortBy) && string.IsNullOrEmpty(pk))
     {
         return null;
     }
     if (string.IsNullOrEmpty(selectFields))
     {
         selectFields = "*";
     }
     string query = BuildTopQuery(pageIndex, pageSize, sortBy, sortOrder, isCount, table, pk, filter, selectFields);
     DbQueryResult result = new DbQueryResult();
     Database database = DatabaseFactory.CreateDatabase();
     DbCommand sqlStringCommand = database.GetSqlStringCommand(query);
     using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
     {
         result.Data = ConverDataReaderToDataTable(reader);
         if (isCount && reader.NextResult())
         {
             reader.Read();
             result.TotalRecords = reader.GetInt32(0);
         }
     }
     return result;
 }
Exemplo n.º 36
0
 private static string BuildRownumberQuery(string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
 {
     StringBuilder builder = new StringBuilder();
     string str = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);
     if (partitionSize > 0)
     {
         builder.AppendFormat("SELECT TOP {0} {1}, ROW_NUMBER() OVER (ORDER BY ", partitionSize.ToString(CultureInfo.InvariantCulture), selectFields);
     }
     else
     {
         builder.AppendFormat("SELECT {0} , ROW_NUMBER() OVER (ORDER BY ", selectFields);
     }
     builder.AppendFormat("{0} {1}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, sortOrder.ToString());
     builder.AppendFormat(") AS RowNumber FROM {0} {1}", table, str);
     builder.Insert(0, "SELECT * FROM (").Append(") T WHERE T.RowNumber BETWEEN @StartNumber AND @EndNumber");
     if (isCount && (partitionSize == 0))
     {
         builder.AppendFormat(";SELECT COUNT({0}) FROM {1} {2}", string.IsNullOrEmpty(sortBy) ? pk : sortBy, table, str);
     }
     return builder.ToString();
 }
Exemplo n.º 37
0
 public static void UpdateBrandCategorieDisplaySequence(int brandId, SortAction action)
 {
     new BrandCategoryDao().UpdateBrandCategoryDisplaySequence(brandId, action);
 }
Exemplo n.º 38
0
 private static string BuildTopQuery(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields)
 {
     string str = string.IsNullOrEmpty(sortBy) ? pk : sortBy;
     string str2 = string.IsNullOrEmpty(filter) ? "" : ("WHERE " + filter);
     string str3 = string.IsNullOrEmpty(filter) ? "" : ("AND " + filter);
     StringBuilder builder = new StringBuilder();
     builder.AppendFormat("SELECT TOP {0} {1} FROM {2} ", pageSize.ToString(CultureInfo.InvariantCulture), selectFields, table);
     if (pageIndex == 1)
     {
         builder.AppendFormat("{0} ORDER BY {1} {2}", str2, str, sortOrder.ToString());
     }
     else
     {
         int num = (pageIndex - 1) * pageSize;
         if (sortOrder == SortAction.Asc)
         {
             builder.AppendFormat("WHERE {0} > (SELECT MAX({0}) FROM (SELECT TOP {1} {0} FROM {2} {3} ORDER BY {0} ASC) AS TMP) {4} ORDER BY {0} ASC", new object[] { str, num, table, str2, str3 });
         }
         else
         {
             builder.AppendFormat("WHERE {0} < (SELECT MIN({0}) FROM (SELECT TOP {1} {0} FROM {2} {3} ORDER BY {0} DESC) AS TMP) {4} ORDER BY {0} DESC", new object[] { str, num, table, str2, str3 });
         }
     }
     if (isCount)
     {
         builder.AppendFormat(";SELECT COUNT({0}) FROM {1} {2}", str, table, str2);
     }
     return builder.ToString();
 }
Exemplo n.º 39
0
 public void UpdateBrandCategoryDisplaySequence(int brandId, SortAction action)
 {
     DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_BrandCategory_DisplaySequence");
     this.database.AddInParameter(storedProcCommand, "BrandId", DbType.Int32, brandId);
     this.database.AddInParameter(storedProcCommand, "Sort", DbType.Int32, action);
     this.database.ExecuteNonQuery(storedProcCommand);
 }
Exemplo n.º 40
0
 public void SortPaymentMode(int modeId, SortAction action)
 {
     DbCommand storedProcCommand = this.database.GetStoredProcCommand("sp_Pay_PaymentMode_Sequence");
     this.database.AddInParameter(storedProcCommand, "ModeId", DbType.Int32, modeId);
     this.database.AddInParameter(storedProcCommand, "Sort", DbType.Int32, (int) action);
     this.database.ExecuteNonQuery(storedProcCommand);
 }
Exemplo n.º 41
0
 public static void UpdateBrandCategorieDisplaySequence(int brandId, SortAction action)
 {
     ProductProvider.Instance().UpdateBrandCategoryDisplaySequence(brandId, action);
 }
Exemplo n.º 42
0
 public static void UpdateBrandCategorieDisplaySequence(int brandId, SortAction action)
 {
     new BrandCategoryDao().UpdateBrandCategoryDisplaySequence(brandId, action);
 }