Beispiel #1
0
 public static Z01Beetle.Entity.Z01Customer GetCustomer(this Z10Order order, Zippy.Data.IDalProvider db)
 {
     Z01Beetle.Entity.Z01Customer rtn = db.FindUnique<Z01Beetle.Entity.Z01Customer>("CustomerID=@CustomerID", db.CreateParameter("CustomerID", order.CustomerID));
     if (rtn == null)
         rtn = new Z01Beetle.Entity.Z01Customer();
     return rtn;
 }
Beispiel #2
0
        public static List<Z10Cabbage.Entity.Z10Depot> GetDepots(Guid tenantID, Zippy.Data.IDalProvider db)
        {
            if (System.Web.HttpContext.Current.Cache["Depots"].IsNotNullOrEmpty())
                return System.Web.HttpContext.Current.Cache["Depots"] as List<Z10Cabbage.Entity.Z10Depot>;

            List<Z10Cabbage.Entity.Z10Depot> xdepots = db.Take<Z10Cabbage.Entity.Z10Depot>("TenantID=@TenantID order by DisplayOrder", db.CreateParameter("TenantID", tenantID));
            System.Web.HttpContext.Current.Cache["Depots"] = xdepots;
            return xdepots;
        }
Beispiel #3
0
        /// <summary>
        /// 获取角色
        /// </summary>
        /// <param name="db"></param>
        /// <param name="tenantID"></param>
        /// <returns></returns>
        public static List<Role> GetRoles(Zippy.Data.IDalProvider db, Guid tenantID)
        {
            //if (System.Web.HttpContext.Current.Cache["Roles_" + tenantID].IsNotNullOrEmpty())
            //    return System.Web.HttpContext.Current.Cache["Roles_" + tenantID] as List<Role>;

            List<Role> xroles = db.Take<Role>("TenantID=@TenantID order by DisplayOrder", db.CreateParameter("TenantID", tenantID));
            System.Web.HttpContext.Current.Cache["Roles_" + tenantID] = xroles;
            return xroles;
        }
Beispiel #4
0
        /// <summary>
        /// 获取货币
        /// </summary>
        /// <param name="db"></param>
        /// <returns></returns>
        public static List<Currency> GetCurrencies(Zippy.Data.IDalProvider db)
        {
            //if (System.Web.HttpContext.Current.Cache["Currencies"].IsNotNullOrEmpty())
            //    return System.Web.HttpContext.Current.Cache["Currencies"] as List<Currency>;

            List<EAP.Bus.Entity.Currency> xcurrencies = db.Take<EAP.Bus.Entity.Currency>("1=1 order by DisplayOrder");
            System.Web.HttpContext.Current.Cache["Currencies"] = xcurrencies;
            return xcurrencies;
        }
Beispiel #5
0
        public static int Delete(Zippy.Data.IDalProvider db, Z10Order xOrder)
        {
            //db.Delete<Z10OrderItem>("OrderID=@OrderID", db.CreateParameter("OrderID", _OrderID));
            //db.Delete<Z10Order>(_OrderID);

            xOrder.DeleteFlag = (int)EAP.Logic.DeleteFlags.Deleted;
            var result = db.Update<Z10Order>(xOrder);

            return result;
        }
Beispiel #6
0
        /// <summary>
        /// 合同条款下拉列表
        /// </summary>
        /// <param name="tenantID"></param>
        /// <param name="db"></param>
        /// <returns></returns>
        public static string PaperTemplateSelectOptions(Guid tenantID, Zippy.Data.IDalProvider db)
        {
            StringBuilder sb = new StringBuilder();
            List<Z01PaperTemplate> xobjs =  db.Take<Z01PaperTemplate>("TenantID=@TenantID order by DisplayOrder", db.CreateParameter("TenantID", tenantID));
            foreach (var xobj in xobjs)
            {
                sb.AppendLine("<option value='" + xobj.TemplateID + "'>" + xobj.Title + "</option>");
            }

            return sb.ToString();
        }
Beispiel #7
0
        /// <summary>
        /// 仓库的下拉列表项
        /// </summary>
        /// <returns></returns>
        public static string DepotSelectOptions(Guid tenantID, Zippy.Data.IDalProvider db)
        {
            StringBuilder sb = new StringBuilder();
            List<Z10Cabbage.Entity.Z10Depot> xdepots = Helper.GetDepots(tenantID, db);
            foreach (Z10Cabbage.Entity.Z10Depot depot in xdepots)
            {
                sb.Append("<option value='" + depot.DepotID + "'>" + depot.Title + "</option>");
            }

            return sb.ToString();
        }
Beispiel #8
0
 /// <summary>
 /// 从数据库中载入订单
 /// </summary>
 /// <param name="orderID"></param>
 /// <param name="tenantID"></param>
 /// <param name="db"></param>
 /// <returns></returns>
 public static Order LoadFromDB(long orderID, Guid tenantID, Zippy.Data.IDalProvider db)
 {
     Order order = new Order();
     order.Z10Order = db.FindUnique<Z10Order>("OrderID=@OrderID and TenantID=@TenantID",
         db.CreateParameter("OrderID", orderID),
         db.CreateParameter("TenantID", tenantID));
     order.Items = db.Take<Z10OrderItem>("OrderID=@OrderID and TenantID=@TenantID",
         db.CreateParameter("OrderID", orderID),
         db.CreateParameter("TenantID", tenantID));
     return order;
 }
Beispiel #9
0
        /// <summary>
        /// 币种的下拉列表项
        /// </summary>
        /// <returns></returns>
        public static string CurrencySelectOptions(Zippy.Data.IDalProvider db)
        {
            StringBuilder sb = new StringBuilder();
            List<EAP.Bus.Entity.Currency> xcurrencies = Helper.GetCurrencies(db);
            foreach (EAP.Bus.Entity.Currency xcurrency in xcurrencies)
            {
                sb.AppendLine("<option value='" + xcurrency.ID + "'>" + xcurrency.Title + "(" + xcurrency.ID + ")</option>");
            }

            return sb.ToString();
        }
Beispiel #10
0
 /// <summary>
 /// 表示 [父分类] 被选实体集合的 option html
 /// </summary>
 public static string GetParentIDEntitiesHtmlOption(Zippy.Data.IDalProvider db, System.Int64? selectedValue)
 {
     System.Text.StringBuilder sb = new System.Text.StringBuilder();
     List<Permission> objs = db.Take<Permission>("ParentID=0");
     foreach (var obj in objs)
     {
         if (selectedValue == obj.PermissionID)
             sb.AppendLine("<option value='" + obj.PermissionID + "' selected='selected'>" + obj.Title + "</option>");
         else
             sb.AppendLine("<option value='" + obj.PermissionID + "'>" + obj.Title + "</option>");
     }
     return sb.ToString();
 }
Beispiel #11
0
 /// <summary>
 /// 表示 [父分类] 被选实体集合的 option html
 /// </summary>
 public static string GetTitleIDEntitiesHtmlOption(Zippy.Data.IDalProvider db, Guid tenantID, System.Int64? selectedValue)
 {
     System.Text.StringBuilder sb = new System.Text.StringBuilder();
     List<Z01Title> objs = db.Take<Z01Title>("TenantID=@TenantID", db.CreateParameter("TenantID", tenantID));
     foreach (var obj in objs)
     {
         if (selectedValue == obj.TitleID)
             sb.AppendLine("<option value='" + obj.TitleID + "' selected='selected'>" + obj.Title + "</option>");
         else
             sb.AppendLine("<option value='" + obj.TitleID + "'>" + obj.Title + "</option>");
     }
     return sb.ToString();
 }
Beispiel #12
0
 /// <summary>
 /// 表示 [父分类] 被选实体集合的 option html
 /// </summary>
 public static string GetParentIDEntitiesHtmlOption(Zippy.Data.IDalProvider db, Guid tenantID, long? selectedValue, long removeID)
 {
     System.Text.StringBuilder sb = new System.Text.StringBuilder();
     List<Z01CustomerCategory> objs = db.Take<Z01CustomerCategory>("TenantID=@TenantID", db.CreateParameter("TenantID", tenantID));
     List<Z01CustomerCategory> newObjs = new List<Z01CustomerCategory>();
     ReGroup(objs, newObjs, 0, "├", removeID);
     foreach (var obj in newObjs)
     {
         if (selectedValue == obj.CategoryID)
             sb.AppendLine("<option value='" + obj.CategoryID + "' selected='selected'>" + obj.Title + "</option>");
         else
             sb.AppendLine("<option value='" + obj.CategoryID + "'>" + obj.Title + "</option>");
     }
     return sb.ToString();
 }
Beispiel #13
0
        /// <summary> Creates the game scene </summary>
        public GameScene()
        {
            _ScoreText = new TextDisplay(ZippyGame.UICanvas, ZOrders.SCORE_TEXT, Texture.GetTexture("Content/Graphics/UI/kromasky.png"), Constants.KROMASKY_CHARACTERS, 32, 32)
            {
                Position = new Vector2(-Renderer.Instance.TargetDimensions.X / 2 + 50, Renderer.Instance.TargetDimensions.Y / 2 - 60),
                Visible  = true,
                Text     = "0"
            };
            AddDrawable(_ScoreText);

            _HealthBg = new Sprite(ZippyGame.UICanvas, ZOrders.HEALTH_BG, Texture.GetTexture("Content/Graphics/UI/HealthBg.png"))
            {
                Position = new Vector2(Renderer.Instance.TargetDimensions.X / 2 - 180, Renderer.Instance.TargetDimensions.Y / 2 - 60),
                Visible  = true
            };
            AddDrawable(_HealthBg);
            _HealthBar = new HealthBar(_HealthBg.Position);
            AddDrawable(_HealthBar);

            _Zippy = new Zippy(_HealthBar)
            {
                Visible = true,
                Active  = false
            };

            _LifeImage = new Sprite(ZippyGame.UICanvas, ZOrders.SCORE_TEXT, Texture.GetTexture("Content/Graphics/UI/LivesIcon.png"))
            {
                Position = new Vector2(Renderer.Instance.TargetDimensions.X / 2 - 150, Renderer.Instance.TargetDimensions.Y / 2 - 110),
                Visible  = true
            };
            AddDrawable(_LifeImage);
            _LifeText = new TextDisplay(ZippyGame.UICanvas, ZOrders.SCORE_TEXT, Texture.GetTexture("Content/Graphics/UI/kromasky.png"), Constants.KROMASKY_CHARACTERS, 32, 32)
            {
                Position = new Vector2(Renderer.Instance.TargetDimensions.X / 2 - 100, Renderer.Instance.TargetDimensions.Y / 2 - 110),
                Visible  = true,
                Text     = $"x{_Zippy.Lives}"
            };
            AddDrawable(_LifeText);

            _LeftCollider                      = PhysicsWorld.Instance.CreateRectangle(new XVector2(-Single.MaxValue, 0), new XVector2(20, Renderer.Instance.TargetDimensions.Y), 10);
            _LeftCollider.BodyType             = BodyType.Static;
            _LeftCollider.CollisionCategories  = Constants.LIMIT_CATEGORY;
            _RightCollider                     = PhysicsWorld.Instance.CreateRectangle(new XVector2(Single.MaxValue, 0), new XVector2(20, Renderer.Instance.TargetDimensions.Y), 10);
            _RightCollider.BodyType            = BodyType.Static;
            _RightCollider.CollisionCategories = Constants.LIMIT_CATEGORY;
        }
Beispiel #14
0
        /// <summary>
        /// 获取所有权限
        /// </summary>
        /// <param name="db"></param>
        /// <param name="tenantID"></param>
        /// <returns></returns>
        public static List<Permission> GetPermissions(Zippy.Data.IDalProvider db, Guid? tenantID)
        {
            //if (System.Web.HttpContext.Current.Cache["Permissions_" + tenantID].IsNotNullOrEmpty())
            //    return System.Web.HttpContext.Current.Cache["Permissions_" + tenantID] as List<Permission>;

            List<Permission> xobjs = db.Take<Permission>();
            //按照父子关系顺序重建
            List<Permission> newRecords = new List<Permission>();
            IEnumerable<Permission> rootRecords = xobjs.Where(s => (s.ParentID ?? 0) == 0).OrderBy(s => s.DisplayOrder);
            foreach (Permission per in rootRecords)
            {
                newRecords.Add(per);
                newRecords.AddRange(xobjs.Where(s => s.ParentID == per.PermissionID).OrderBy(s => s.DisplayOrder));
            }

            System.Web.HttpContext.Current.Cache["Permissions_" + tenantID] = newRecords;
            return newRecords;
        }
Beispiel #15
0
        /// <summary>
        /// j将当前用户的url都显示出来
        /// </summary>
        /// <param name="user"></param>
        /// <param name="tenantID"></param>
        /// <param name="db"></param>
        /// <returns></returns>
        public static string ToJsonMenu(Zippy.SaaS.Entity.User user, Guid? tenantID, Zippy.Data.IDalProvider db)
        {
            System.Text.StringBuilder menus = new StringBuilder();
            menus.AppendLine("{");
            List<Permission> xobjs = GetPermissions(db, tenantID);
            List<EAP.Logic.Bus.View.V_UserPermission> mePers = null;
            if (!user.UserType.BitIs(Zippy.SaaS.UserTypes.SystemAdministrator))
            {
                mePers = db.Take<EAP.Logic.Bus.View.V_UserPermission>("UserID=@UserID", db.CreateParameter("UserID", user.UserID));
            }

            var rootRecords = xobjs.Where(s => (s.ParentID ?? 0) == 0 && s.PermissionStatus == 1).OrderBy(s => s.DisplayOrder);
            foreach (Permission per in rootRecords)
            {
                if (mePers == null || (mePers != null && mePers.Exists(s => s.PermissionID == per.PermissionID)))
                {
                    if (per.PermissionStatus == 1)
                        menus.AppendLine("'" + per.PermissionID + "' : [['" + per.PermissionID + "','" + per.Title + "','" + per.Icon + "'],{");

                    var subRecords = xobjs.Where(s => s.ParentID == per.PermissionID).OrderBy(s => s.DisplayOrder);
                    foreach (Permission subper in subRecords)
                    {
                        if (mePers == null || (mePers != null && mePers.Exists(s => s.PermissionID == subper.PermissionID)))
                        {
                            if (subper.PermissionStatus == 1)
                                menus.AppendLine("'" + subper.PermissionID + "' : ['" + subper.Title + "','" + subper.Url + "','" + subper.Icon + "'],");
                        }

                    }
                    //if (menus.ToString().EndsWith(",")) menus.Remove(menus.Length - 1, 1);
                    menus.AppendLine("}],");

                }
            }
            //if (menus.ToString().EndsWith(",\n")) menus.Remove(menus.Length - 1, 1);

            menus.AppendLine("}");

            return menus.ToString().Replace(",\r\n}", "\r\n}");
        }
Beispiel #16
0
 /// <summary>
 /// 数据源 查询
 /// </summary>
 /// <param name="where">查询条件</param>
 /// <param name="orderby">排序方式</param>
 /// <param name="PageSize">每页数量</param>
 /// <param name="PageIndex">页码</param>
 /// <param name="cmdParameters">查询条件赋值</param>
 /// <returns></returns>
 public static PaginatedList<DataSource> Take(Zippy.Data.IDalProvider db, string @where, string orderby, int PageSize, int PageIndex, params System.Data.Common.DbParameter[] cmdParameters)
 {
     PaginatedList<DataSource> rtn = new PaginatedList<DataSource>();
     List<DataSource> records = db.Take<DataSource>(where + " order by " + orderby, PageSize, PageIndex, cmdParameters);
     rtn.AddRange(records);
     rtn.PageIndex = PageIndex;
     rtn.PageSize = PageSize;
     rtn.TotalCount = db.Count<DataSource>(where, cmdParameters);
     return rtn;
 }
Beispiel #17
0
 public static List<DataSource> Take(Zippy.Data.IDalProvider db,string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters)
 {
     return db.Take<DataSource>(sqlEntry, cmdParameters);
 }
Beispiel #18
0
 public static List<DataSource> Take(Zippy.Data.IDalProvider db,int count)
 {
     return db.Take<DataSource>(count, true);
 }
Beispiel #19
0
 public static List<DataSource> Take(Zippy.Data.IDalProvider db)
 {
     return db.Take<DataSource>(true);
 }
Beispiel #20
0
 public static DataSource Create(Zippy.Data.IDalProvider db, Guid _DataSourceID)
 {
     DataSource rtn =  db.FindUnique<DataSource>(_DataSourceID);
     return rtn;
 }
Beispiel #21
0
        public static PaginatedList<Z01UserInfo> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int? orderCol)
        {
            PaginatedList<Z01UserInfo> rtn = new PaginatedList<Z01UserInfo>();
            List<System.Data.Common.DbParameter> dbParams = new List<System.Data.Common.DbParameter>();

            string where = " [TenantID]=@TenantID";
            dbParams.Add(db.CreateParameter("TenantID", tenantID));

            #region 开始查询
            if (paras != null)
            {
                object qName = paras["qName"];
                if (qName.IsNotNullOrEmpty())
                {
                    where += " and [Name] like @Name";
                    dbParams.Add(db.CreateParameter("Name", "%" + qName + "%"));
                }
                object qNickname = paras["qNickname"];
                if (qNickname.IsNotNullOrEmpty())
                {
                    where += " and [Nickname] like @Nickname";
                    dbParams.Add(db.CreateParameter("Nickname", "%" + qNickname + "%"));
                }
                object qEmail = paras["qEmail"];
                if (qEmail.IsNotNullOrEmpty())
                {
                    where += " and [Email] like @Email";
                    dbParams.Add(db.CreateParameter("Email", "%" + qEmail + "%"));
                }
                object qUserStatus = paras["qUserStatus"];
                if (qUserStatus.IsNotNullOrEmpty())
                {
                    Int32 intqUserStatus = (Int32)qUserStatus;
                    if (intqUserStatus > 0)
                    {
                        where += " and [UserStatus] = @UserStatus";
                        dbParams.Add(db.CreateParameter("UserStatus", qUserStatus));
                    }
                }
                object qCreateDateStart = paras["qCreateDateStart"];
                if (qCreateDateStart != null && qCreateDateStart.ToString()!="")
                {
                    where += " and [CreateDate] >= @CreateDateStart";
                    dbParams.Add(db.CreateParameter("CreateDateStart", qCreateDateStart));
                }
                object qCreateDateEnd = paras["qCreateDateEnd"];
                if (qCreateDateEnd != null && qCreateDateEnd.ToString()!="")
                {
                    where += " and [CreateDate] < @CreateDateEnd";
                    dbParams.Add(db.CreateParameter("CreateDateEnd", ((DateTime)qCreateDateEnd).AddDays(1)));
                }
            }
            #endregion

            string orderBy = "[CreateDate] desc";
            if (orderCol == 0)
            {
                orderBy =  "[CreateDate] desc";
            }
            else if (orderCol == 1)
            {
                orderBy = "[UserID]";
            }
            else if (orderCol == 2)
            {
                orderBy = "[UserID] desc";
            }
            else if (orderCol == 3)
            {
                orderBy = "[Name]";
            }
            else if (orderCol == 4)
            {
                orderBy = "[Name] desc";
            }
            else if (orderCol == 5)
            {
                orderBy = "[Nickname]";
            }
            else if (orderCol == 6)
            {
                orderBy = "[Nickname] desc";
            }
            else if (orderCol == 7)
            {
                orderBy = "[Email]";
            }
            else if (orderCol == 8)
            {
                orderBy = "[Email] desc";
            }
            else if (orderCol == 9)
            {
                orderBy = "[Tel1]";
            }
            else if (orderCol == 10)
            {
                orderBy = "[Tel1] desc";
            }
            else if (orderCol == 11)
            {
                orderBy = "[Tel2]";
            }
            else if (orderCol == 12)
            {
                orderBy = "[Tel2] desc";
            }
            else if (orderCol == 13)
            {
                orderBy = "[Avatar]";
            }
            else if (orderCol == 14)
            {
                orderBy = "[Avatar] desc";
            }
            else if (orderCol == 15)
            {
                orderBy = "[TitleID]";
            }
            else if (orderCol == 16)
            {
                orderBy = "[TitleID] desc";
            }
            else if (orderCol == 17)
            {
                orderBy = "[TenantID]";
            }
            else if (orderCol == 18)
            {
                orderBy = "[TenantID] desc";
            }
            else if (orderCol == 19)
            {
                orderBy = "[UserStatus]";
            }
            else if (orderCol == 20)
            {
                orderBy = "[UserStatus] desc";
            }
            else if (orderCol == 21)
            {
                orderBy = "[CreateDate]";
            }
            else if (orderCol == 22)
            {
                orderBy = "[CreateDate] desc";
            }
            int RecordCount = db.Count<Z01UserInfo>(where, dbParams.ToArray());
            int PageCount =0;
            if (RecordCount % PageSize == 0)
            {
                PageCount = RecordCount / PageSize;
            }
            else
            {
                PageCount = RecordCount / PageSize + 1;
            }
            if (PageIndex > PageCount)
                PageIndex = PageCount;
            if (PageIndex < 1)
                PageIndex = 1;

            List<Z01UserInfo> records = db.Take<Z01UserInfo>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray());
            rtn.AddRange(records);
            rtn.PageIndex = PageIndex;
            rtn.PageSize = PageSize;
            rtn.TotalCount = RecordCount;

            return rtn;
        }
Beispiel #22
0
 public static int Insert(Zippy.Data.IDalProvider db, Z01UserInfo entity)
 {
     int rtn = db.Insert(entity);
     return rtn;
 }
Beispiel #23
0
 /// <summary>
 /// 表示 [头衔/职务] 对应的实体
 /// </summary>
 public static Z01Title GetTitleIDEntity(Zippy.Data.IDalProvider db, Z01UserInfo entity)
 {
     return db.FindUnique<Z01Title>("TitleID=@TitleID", db.CreateParameter("TitleID", entity.TitleID));
 }
Beispiel #24
0
 public static int Update(Zippy.Data.IDalProvider db, Z01UserInfo entity)
 {
     return db.Update(entity);
 }
Beispiel #25
0
 /// <summary>
 /// 表示 [头衔/职务] 被选实体集合
 /// </summary>
 public static List<Z01Title> GetTitleIDEntities(Zippy.Data.IDalProvider db)
 {
     return db.Take<Z01Title>();
 }
Beispiel #26
0
 public static int Insert(Zippy.Data.IDalProvider db, DataSource entity)
 {
     int rtn = db.Insert(entity);
     return rtn;
 }
Beispiel #27
0
 public static int Delete(Zippy.Data.IDalProvider db, Guid _DataSourceID)
 {
     return db.Delete<DataSource>(_DataSourceID);
 }
Beispiel #28
0
 public static int Update(Zippy.Data.IDalProvider db, DataSource entity)
 {
     return db.Update(entity);
 }
Beispiel #29
0
 public static List<Z01UserInfo> Take(Zippy.Data.IDalProvider db)
 {
     return db.Take<Z01UserInfo>(true);
 }
Beispiel #30
0
        public static PaginatedList<DataSource> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int? orderCol)
        {
            PaginatedList<DataSource> rtn = new PaginatedList<DataSource>();
            List<System.Data.Common.DbParameter> dbParams = new List<System.Data.Common.DbParameter>();

            string where = " [TenantID]=@TenantID";
            dbParams.Add(db.CreateParameter("TenantID", tenantID));

            #region 开始查询
            if (paras != null)
            {
                object qDataSourceType = paras["qDataSourceType"];
                if (qDataSourceType != null && qDataSourceType.ToString()!="")
                {
                    Int32 intqDataSourceType = (Int32)qDataSourceType;
                    if (intqDataSourceType > 0)
                    {
                        where += " and ([DataSourceType] & @DataSourceType = @DataSourceType)";
                        dbParams.Add(db.CreateParameter("DataSourceType", qDataSourceType));
                    }
                }
                object qTitle = paras["qTitle"];
                if (qTitle != null)
                {
                    where += " and [Title] like @Title";
                    dbParams.Add(db.CreateParameter("Title", "%" + qTitle + "%"));
                }
                object qDataSourceStatus = paras["qDataSourceStatus"];
                if (qDataSourceStatus != null && qDataSourceStatus.ToString()!="" )
                {
                    Int32 intqDataSourceStatus = (Int32)qDataSourceStatus;
                    if (intqDataSourceStatus > 0)
                    {
                        where += " and [DataSourceStatus] = @DataSourceStatus";
                        dbParams.Add(db.CreateParameter("DataSourceStatus", qDataSourceStatus));
                    }
                }
                object qCreateDateStart = paras["qCreateDateStart"];
                if (qCreateDateStart != null && qCreateDateStart.ToString()!="")
                {
                    where += " and [CreateDate] >= @CreateDateStart";
                    dbParams.Add(db.CreateParameter("CreateDateStart", qCreateDateStart));
                }
                object qCreateDateEnd = paras["qCreateDateEnd"];
                if (qCreateDateEnd != null && qCreateDateEnd.ToString()!="")
                {
                    where += " and [CreateDate] < @CreateDateEnd";
                    dbParams.Add(db.CreateParameter("CreateDateEnd", ((DateTime)qCreateDateEnd).AddDays(1)));
                }
            }
            #endregion

            string orderBy = "[CreateDate] desc";
            if (orderCol == 0)
            {
                orderBy =  "[CreateDate] desc";
            }
            else if (orderCol == 1)
            {
                orderBy = "[DataSourceID]";
            }
            else if (orderCol == 2)
            {
                orderBy = "[DataSourceID] desc";
            }
            else if (orderCol == 3)
            {
                orderBy = "[DataSourceType]";
            }
            else if (orderCol == 4)
            {
                orderBy = "[DataSourceType] desc";
            }
            else if (orderCol == 5)
            {
                orderBy = "[Title]";
            }
            else if (orderCol == 6)
            {
                orderBy = "[Title] desc";
            }
            else if (orderCol == 7)
            {
                orderBy = "[DataSourceStatus]";
            }
            else if (orderCol == 8)
            {
                orderBy = "[DataSourceStatus] desc";
            }
            else if (orderCol == 9)
            {
                orderBy = "[CreateDate]";
            }
            else if (orderCol == 10)
            {
                orderBy = "[CreateDate] desc";
            }
            int RecordCount = db.Count<DataSource>(where, dbParams.ToArray());
            int PageCount =0;
            if (RecordCount % PageSize == 0)
            {
                PageCount = RecordCount / PageSize;
            }
            else
            {
                PageCount = RecordCount / PageSize + 1;
            }
            if (PageIndex > PageCount)
                PageIndex = PageCount;
            if (PageIndex < 1)
                PageIndex = 1;

            List<DataSource> records = db.Take<DataSource>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray());
            rtn.AddRange(records);
            rtn.PageIndex = PageIndex;
            rtn.PageSize = PageSize;
            rtn.TotalCount = RecordCount;

            return rtn;
        }
Beispiel #31
0
 public static List<Z01UserInfo> Take(Zippy.Data.IDalProvider db,int count)
 {
     return db.Take<Z01UserInfo>(count, true);
 }