public static List <Z01PaperTemplate> Take(Zippy.Data.IDalProvider db, string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters) { return(db.Take <Z01PaperTemplate>(sqlEntry, cmdParameters)); }
/// <summary> /// 表示 [模板] 被选实体集合 /// </summary> public static List <PropertyTemplate> GetTemplateIDEntities(Zippy.Data.IDalProvider db) { return(db.Take <PropertyTemplate>()); }
public static List <ExtProperty> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <ExtProperty>(count, true)); }
public static PaginatedList <Z01Bank> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol) { PaginatedList <Z01Bank> rtn = new PaginatedList <Z01Bank>(); 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 qTitle = paras["qTitle"]; if (qTitle.IsNotNullOrEmpty()) { where += " and [Title] like @Title"; dbParams.Add(db.CreateParameter("Title", "%" + qTitle + "%")); } object qAccount = paras["qAccount"]; if (qAccount.IsNotNullOrEmpty()) { where += " and [Account] like @Account"; dbParams.Add(db.CreateParameter("Account", "%" + qAccount + "%")); } } #endregion string orderBy = "[DisplayOrder]"; if (orderCol == 0) { orderBy = "[DisplayOrder] desc"; } else if (orderCol == 1) { orderBy = "[Title]"; } else if (orderCol == 2) { orderBy = "[Title] desc"; } else if (orderCol == 3) { orderBy = "[Brief]"; } else if (orderCol == 4) { orderBy = "[Brief] desc"; } else if (orderCol == 5) { orderBy = "[Account]"; } else if (orderCol == 6) { orderBy = "[Account] desc"; } else if (orderCol == 7) { orderBy = "[Contact]"; } else if (orderCol == 8) { orderBy = "[Contact] desc"; } else if (orderCol == 9) { orderBy = "[Tel]"; } else if (orderCol == 10) { orderBy = "[Tel] desc"; } else if (orderCol == 11) { orderBy = "[Fax]"; } else if (orderCol == 12) { orderBy = "[Fax] desc"; } else if (orderCol == 13) { orderBy = "[CreateDate]"; } else if (orderCol == 14) { orderBy = "[CreateDate] desc"; } int RecordCount = db.Count <Z01Bank>(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 <Z01Bank> records = db.Take <Z01Bank>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray()); rtn.AddRange(records); rtn.PageIndex = PageIndex; rtn.PageSize = PageSize; rtn.TotalCount = RecordCount; return(rtn); }
public static List <Tenant> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <Tenant>(count, true)); }
public static List <Z30Communication> Take(Zippy.Data.IDalProvider db, string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters) { return(db.Take <Z30Communication>(sqlEntry, cmdParameters)); }
public static List <Z01Bank> Take(Zippy.Data.IDalProvider db) { return(db.Take <Z01Bank>(true)); }
public static List <Z01UserInfo> Take(Zippy.Data.IDalProvider db) { return(db.Take <Z01UserInfo>(true)); }
public static List <RolePermission> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <RolePermission>(count, true)); }
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); }
/// <summary> /// 表示 [头衔/职务] 被选实体集合 /// </summary> public static List <Z01Title> GetTitleIDEntities(Zippy.Data.IDalProvider db) { return(db.Take <Z01Title>()); }
public static List <Currency> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <Currency>(count, true)); }
public static List <Currency> Take(Zippy.Data.IDalProvider db) { return(db.Take <Currency>(true)); }
public static List <PropertyTemplate> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <PropertyTemplate>(count, true)); }
/// <summary> /// 表示 [分类] 被选实体集合 /// </summary> public static List <Z01CustomerCategory> GetCategoryIDEntities(Zippy.Data.IDalProvider db) { return(db.Take <Z01CustomerCategory>()); }
public static PaginatedList <RolePermission> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol) { PaginatedList <RolePermission> rtn = new PaginatedList <RolePermission>(); 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 qRoleIDStart = paras["qRoleIDStart"]; if (qRoleIDStart != null && qRoleIDStart.ToString() != "") { where += " and [RoleID] >= @RoleIDStart"; dbParams.Add(db.CreateParameter("RoleIDStart", qRoleIDStart)); } object qRoleIDEnd = paras["qRoleIDEnd"]; if (qRoleIDEnd != null && qRoleIDEnd.ToString() != "") { where += " and [RoleID] <= @RoleID"; dbParams.Add(db.CreateParameter("RoleIDEnd", qRoleIDEnd)); } object qPermissionIDStart = paras["qPermissionIDStart"]; if (qPermissionIDStart != null && qPermissionIDStart.ToString() != "") { where += " and [PermissionID] >= @PermissionIDStart"; dbParams.Add(db.CreateParameter("PermissionIDStart", qPermissionIDStart)); } object qPermissionIDEnd = paras["qPermissionIDEnd"]; if (qPermissionIDEnd != null && qPermissionIDEnd.ToString() != "") { where += " and [PermissionID] <= @PermissionID"; dbParams.Add(db.CreateParameter("PermissionIDEnd", qPermissionIDEnd)); } object qPermissionType = paras["qPermissionType"]; if (qPermissionType != null && qPermissionType.ToString() != "") { Int32 intqPermissionType = (Int32)qPermissionType; if (intqPermissionType > 0) { where += " and ([PermissionType] & @PermissionType = @PermissionType)"; dbParams.Add(db.CreateParameter("PermissionType", qPermissionType)); } } object qPermissionStatus = paras["qPermissionStatus"]; if (qPermissionStatus != null && qPermissionStatus.ToString() != "") { Int32 intqPermissionStatus = (Int32)qPermissionStatus; if (intqPermissionStatus > 0) { where += " and [PermissionStatus] = @PermissionStatus"; dbParams.Add(db.CreateParameter("PermissionStatus", qPermissionStatus)); } } 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 = "[RolePermissionID]"; } else if (orderCol == 2) { orderBy = "[RolePermissionID] desc"; } else if (orderCol == 3) { orderBy = "[RoleID]"; } else if (orderCol == 4) { orderBy = "[RoleID] desc"; } else if (orderCol == 5) { orderBy = "[PermissionID]"; } else if (orderCol == 6) { orderBy = "[PermissionID] desc"; } else if (orderCol == 7) { orderBy = "[PermissionType]"; } else if (orderCol == 8) { orderBy = "[PermissionType] desc"; } else if (orderCol == 9) { orderBy = "[PermissionStatus]"; } else if (orderCol == 10) { orderBy = "[PermissionStatus] desc"; } else if (orderCol == 11) { orderBy = "[CreateDate]"; } else if (orderCol == 12) { orderBy = "[CreateDate] desc"; } int RecordCount = db.Count <RolePermission>(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 <RolePermission> records = db.Take <RolePermission>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray()); rtn.AddRange(records); rtn.PageIndex = PageIndex; rtn.PageSize = PageSize; rtn.TotalCount = RecordCount; return(rtn); }
public static List <Z30Communication> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <Z30Communication>(count, true)); }
public static List <Z10Config> Take(Zippy.Data.IDalProvider db) { return(db.Take <Z10Config>(true)); }
public static PaginatedList <Z30Communication> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol) { PaginatedList <Z30Communication> rtn = new PaginatedList <Z30Communication>(); 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 qCreator = paras["qCreator"]; if (qCreator.IsNotNullOrEmpty()) { where += " and [Creator] = @Creator"; dbParams.Add(db.CreateParameter("Creator", qCreator)); } object qCustomerID = paras["qCustomerID"]; if (qCustomerID.IsNotNullOrEmpty()) { where += " and [CustomerID] = @CustomerID"; dbParams.Add(db.CreateParameter("CustomerID", qCustomerID)); } object qContent = paras["qContent"]; if (qContent.IsNotNullOrEmpty()) { where += " and [Content] like @Content"; dbParams.Add(db.CreateParameter("Content", "%" + qContent + "%")); } object qWish = paras["qWish"]; if (qWish.IsNotNullOrEmpty()) { where += " and [Wish] >= @Wish"; dbParams.Add(db.CreateParameter("Wish", qWish)); } object qSuccessRatio = paras["qSuccessRatio"]; if (qSuccessRatio.IsNotNullOrEmpty()) { where += " and [SuccessRatio] >= @SuccessRatio"; dbParams.Add(db.CreateParameter("SuccessRatio", qSuccessRatio)); } object qCreateDateStart = paras["qCreateDateStart"]; if (qCreateDateStart.IsNotNullOrEmpty()) { where += " and [CreateDate] >= @CreateDateStart"; dbParams.Add(db.CreateParameter("CreateDateStart", qCreateDateStart)); } object qCreateDateEnd = paras["qCreateDateEnd"]; if (qCreateDateEnd.IsNotNullOrEmpty()) { where += " and [CreateDate] < @CreateDate"; 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 = "[CommunicationID]"; } else if (orderCol == 2) { orderBy = "[CommunicationID] desc"; } else if (orderCol == 3) { orderBy = "[CustomerID]"; } else if (orderCol == 4) { orderBy = "[CustomerID] desc"; } else if (orderCol == 5) { orderBy = "[VisitWay]"; } else if (orderCol == 6) { orderBy = "[VisitWay] desc"; } else if (orderCol == 7) { orderBy = "[Wish]"; } else if (orderCol == 8) { orderBy = "[Wish] desc"; } else if (orderCol == 9) { orderBy = "[NextVisitDate]"; } else if (orderCol == 10) { orderBy = "[NextVisitDate] desc"; } else if (orderCol == 11) { orderBy = "[SuccessRatio]"; } else if (orderCol == 12) { orderBy = "[SuccessRatio] desc"; } else if (orderCol == 13) { orderBy = "[VisitDate]"; } else if (orderCol == 14) { orderBy = "[VisitDate] desc"; } else if (orderCol == 15) { orderBy = "[VisitDuration]"; } else if (orderCol == 16) { orderBy = "[VisitDuration] desc"; } else if (orderCol == 17) { orderBy = "[CreateDate]"; } else if (orderCol == 18) { orderBy = "[CreateDate] desc"; } int RecordCount = db.Count <Z30Communication>(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 <Z30Communication> records = db.Take <Z30Communication>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray()); rtn.AddRange(records); rtn.PageIndex = PageIndex; rtn.PageSize = PageSize; rtn.TotalCount = RecordCount; return(rtn); }
public static PaginatedList <Z10Config> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol) { PaginatedList <Z10Config> rtn = new PaginatedList <Z10Config>(); 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 qKey = paras["qKey"]; if (qKey.IsNotNullOrEmpty()) { where += " and [Key] like @Key"; dbParams.Add(db.CreateParameter("Key", "%" + qKey + "%")); } object qValue = paras["qValue"]; if (qValue.IsNotNullOrEmpty()) { where += " and [Value] like @Value"; dbParams.Add(db.CreateParameter("Value", "%" + qValue + "%")); } } #endregion string orderBy = "[CreateDate] desc"; if (orderCol == 0) { orderBy = "[CreateDate] desc"; } else if (orderCol == 1) { orderBy = "[Key]"; } else if (orderCol == 2) { orderBy = "[Key] desc"; } else if (orderCol == 3) { orderBy = "[Value]"; } else if (orderCol == 4) { orderBy = "[Value] desc"; } int RecordCount = db.Count <Z10Config>(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 <Z10Config> records = db.Take <Z10Config>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray()); rtn.AddRange(records); rtn.PageIndex = PageIndex; rtn.PageSize = PageSize; rtn.TotalCount = RecordCount; return(rtn); }
public static List <Z01Bank> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <Z01Bank>(count, true)); }
public static List <Z01CustomerInCategory> Take(Zippy.Data.IDalProvider db, int count) { return(db.Take <Z01CustomerInCategory>(count, true)); }
public static List <Tenant> Take(Zippy.Data.IDalProvider db) { return(db.Take <Tenant>(true)); }
public static List <Z01CustomerInCategory> Take(Zippy.Data.IDalProvider db, string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters) { return(db.Take <Z01CustomerInCategory>(sqlEntry, cmdParameters)); }
public static PaginatedList <ExtProperty> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol) { PaginatedList <ExtProperty> rtn = new PaginatedList <ExtProperty>(); 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 qTitle = paras["qTitle"]; if (qTitle.IsNotNullOrEmpty()) { where += " and [Title] like @Title"; dbParams.Add(db.CreateParameter("Title", "%" + qTitle + "%")); } 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 = "[PropertyID]"; } else if (orderCol == 2) { orderBy = "[PropertyID] desc"; } else if (orderCol == 3) { orderBy = "[Title]"; } else if (orderCol == 4) { orderBy = "[Title] desc"; } else if (orderCol == 5) { orderBy = "[TemplateID]"; } else if (orderCol == 6) { orderBy = "[TemplateID] desc"; } else if (orderCol == 7) { orderBy = "[DisplayOrder]"; } else if (orderCol == 8) { orderBy = "[DisplayOrder] desc"; } else if (orderCol == 9) { orderBy = "[CreateDate]"; } else if (orderCol == 10) { orderBy = "[CreateDate] desc"; } int RecordCount = db.Count <ExtProperty>(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 <ExtProperty> records = db.Take <ExtProperty>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray()); rtn.AddRange(records); rtn.PageIndex = PageIndex; rtn.PageSize = PageSize; rtn.TotalCount = RecordCount; return(rtn); }
public static PaginatedList <Z01CustomerInCategory> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol) { PaginatedList <Z01CustomerInCategory> rtn = new PaginatedList <Z01CustomerInCategory>(); 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 qProductIDStart = paras["qProductIDStart"]; if (qProductIDStart != null && qProductIDStart.ToString() != "") { where += " and [ProductID] >= @ProductIDStart"; dbParams.Add(db.CreateParameter("ProductIDStart", qProductIDStart)); } object qProductIDEnd = paras["qProductIDEnd"]; if (qProductIDEnd != null && qProductIDEnd.ToString() != "") { where += " and [ProductID] <= @ProductID"; dbParams.Add(db.CreateParameter("ProductIDEnd", qProductIDEnd)); } object qCategoryIDStart = paras["qCategoryIDStart"]; if (qCategoryIDStart != null && qCategoryIDStart.ToString() != "") { where += " and [CategoryID] >= @CategoryIDStart"; dbParams.Add(db.CreateParameter("CategoryIDStart", qCategoryIDStart)); } object qCategoryIDEnd = paras["qCategoryIDEnd"]; if (qCategoryIDEnd != null && qCategoryIDEnd.ToString() != "") { where += " and [CategoryID] <= @CategoryID"; dbParams.Add(db.CreateParameter("CategoryIDEnd", qCategoryIDEnd)); } 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 = "[CICID]"; } else if (orderCol == 2) { orderBy = "[CICID] desc"; } else if (orderCol == 3) { orderBy = "[ProductID]"; } else if (orderCol == 4) { orderBy = "[ProductID] desc"; } else if (orderCol == 5) { orderBy = "[CategoryID]"; } else if (orderCol == 6) { orderBy = "[CategoryID] desc"; } else if (orderCol == 7) { orderBy = "[CreateDate]"; } else if (orderCol == 8) { orderBy = "[CreateDate] desc"; } int RecordCount = db.Count <Z01CustomerInCategory>(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 <Z01CustomerInCategory> records = db.Take <Z01CustomerInCategory>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray()); rtn.AddRange(records); rtn.PageIndex = PageIndex; rtn.PageSize = PageSize; rtn.TotalCount = RecordCount; return(rtn); }
public static List <ExtProperty> Take(Zippy.Data.IDalProvider db) { return(db.Take <ExtProperty>(true)); }
/// <summary> /// 表示 [产品] 被选实体集合 /// </summary> public static List <Z01Product> GetProductIDEntities(Zippy.Data.IDalProvider db) { return(db.Take <Z01Product>()); }
public static List <ExtProperty> Take(Zippy.Data.IDalProvider db, string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters) { return(db.Take <ExtProperty>(sqlEntry, cmdParameters)); }
public static List <Z01PaperTemplate> Take(Zippy.Data.IDalProvider db) { return(db.Take <Z01PaperTemplate>(true)); }