public static int Delete(Zippy.Data.IDalProvider db, Guid _TenantID)
{
return(db.Delete <Tenant>(_TenantID));
}
public static List <UserRole> Take(Zippy.Data.IDalProvider db, string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters)
{
return(db.Take <UserRole>(sqlEntry, cmdParameters));
}
public static EAP.Bus.Entity.Currency GetCurrency(this Z10Order order, Zippy.Data.IDalProvider db)
{
return(db.FindUnique <EAP.Bus.Entity.Currency>("ID=@ID", db.CreateParameter("ID", order.Currency)));
}
public static int Insert(Zippy.Data.IDalProvider db, UserRole entity)
{
int rtn = db.Insert(entity);
return(rtn);
}
public static List <UserRole> Take(Zippy.Data.IDalProvider db)
{
return(db.Take <UserRole>(true));
}
/// <summary>
/// 表示 [角色] 对应的实体
/// </summary>
public static Role GetRoleIDEntity(Zippy.Data.IDalProvider db, UserRole entity)
{
return(db.FindUnique <Role>("RoleID=@RoleID", db.CreateParameter("RoleID", entity.RoleID)));
}
public static UserRole Create(Zippy.Data.IDalProvider db, Int64 _UserRoleID)
{
UserRole rtn = db.FindUnique <UserRole>(_UserRoleID);
return(rtn);
}
/// <summary>
/// 表示 [模板] 被选实体集合
/// </summary>
public static List <PropertyTemplate> GetTemplateIDEntities(Zippy.Data.IDalProvider db)
{
return(db.Take <PropertyTemplate>());
}
public static ExtProperty Create(Zippy.Data.IDalProvider db, Int64 _PropertyID)
{
ExtProperty rtn = db.FindUnique <ExtProperty>(_PropertyID);
return(rtn);
}
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);
}
/// <summary>
/// 表示 [模板] 对应的实体
/// </summary>
public static PropertyTemplate GetTemplateIDEntity(Zippy.Data.IDalProvider db, ExtProperty entity)
{
return(db.FindUnique <PropertyTemplate>("TemplateID=@TemplateID", db.CreateParameter("TemplateID", entity.TemplateID)));
}
public static List <Tenant> Take(Zippy.Data.IDalProvider db, int count)
{
return(db.Take <Tenant>(count, true));
}
public static List <Tenant> Take(Zippy.Data.IDalProvider db)
{
return(db.Take <Tenant>(true));
}
public static int Update(Zippy.Data.IDalProvider db, Tenant entity)
{
return(db.Update(entity));
}
/// <summary>
/// 表示 [用户] 对应的实体
/// </summary>
public static User GetUserIDEntity(Zippy.Data.IDalProvider db, UserRole entity)
{
return(db.FindUnique <User>("UserID=@UserID", db.CreateParameter("UserID", entity.UserID)));
}
public static int Delete(Zippy.Data.IDalProvider db, Int64 _PropertyID)
{
return(db.Delete <ExtProperty>(_PropertyID));
}
/// <summary>
/// 表示 [用户] 被选实体集合
/// </summary>
public static List <User> GetUserIDEntities(Zippy.Data.IDalProvider db)
{
return(db.Take <User>());
}
public static int Insert(Zippy.Data.IDalProvider db, ExtProperty entity)
{
int rtn = db.Insert(entity);
return(rtn);
}
/// <summary>
/// 表示 [角色] 被选实体集合
/// </summary>
public static List <Role> GetRoleIDEntities(Zippy.Data.IDalProvider db)
{
return(db.Take <Role>());
}
public static int Update(Zippy.Data.IDalProvider db, ExtProperty entity)
{
return(db.Update(entity));
}
public static int Delete(Zippy.Data.IDalProvider db, Int64 _UserRoleID)
{
return(db.Delete <UserRole>(_UserRoleID));
}
public static List <ExtProperty> Take(Zippy.Data.IDalProvider db)
{
return(db.Take <ExtProperty>(true));
}
public static int Update(Zippy.Data.IDalProvider db, UserRole entity)
{
return(db.Update(entity));
}
public static List <ExtProperty> Take(Zippy.Data.IDalProvider db, int count)
{
return(db.Take <ExtProperty>(count, true));
}
public static List <UserRole> Take(Zippy.Data.IDalProvider db, int count)
{
return(db.Take <UserRole>(count, true));
}
protected void Session_Start()
{
Zippy.Data.IDalProvider db = Zippy.Data.DalFactory.CreateProvider();
Zippy.SaaS.Helper.UserHelper.LogonFromCookie(db);
}
public static PaginatedList <Z10Order> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol)
{
PaginatedList <Z10Order> rtn = new PaginatedList <Z10Order>();
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 qCustomerID = paras["qCustomerID"];
if (qCustomerID.IsNotNullOrEmpty())
{
where += " and [CustomerID] = @CustomerID";
dbParams.Add(db.CreateParameter("CustomerID", qCustomerID));
}
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] < @CreateDateEnd";
dbParams.Add(db.CreateParameter("CreateDateEnd", ((DateTime)qCreateDateEnd).AddDays(1)));
}
object qOrderType = paras["qOrderType"];
if (qOrderType.IsNotNullOrEmpty())
{
where += " and ([OrderType]&@OrderType)=@OrderType";
dbParams.Add(db.CreateParameter("OrderType", qOrderType));
}
object qIsSnap = paras["qIsSnap"];
if (qIsSnap.IsNotNullOrEmpty())
{
where += " and [IsSnap] = @IsSnap";
dbParams.Add(db.CreateParameter("IsSnap", qIsSnap));
}
object qDeleteFlag = paras["qDeleteFlag"];
if (qDeleteFlag.IsNotNullOrEmpty())
{
where += " and [DeleteFlag] = @DeleteFlag";
dbParams.Add(db.CreateParameter("DeleteFlag", qDeleteFlag));
}
}
#endregion
string orderBy = "[CreateDate] desc";
if (orderCol == 0)
{
orderBy = "[CreateDate] desc";
}
else if (orderCol == 1)
{
orderBy = "[OrderID]";
}
else if (orderCol == 2)
{
orderBy = "[OrderID] desc";
}
else if (orderCol == 3)
{
orderBy = "[CustomerID]";
}
else if (orderCol == 4)
{
orderBy = "[CustomerID] desc";
}
else if (orderCol == 5)
{
orderBy = "[DateOrder]";
}
else if (orderCol == 6)
{
orderBy = "[DateOrder] desc";
}
else if (orderCol == 7)
{
orderBy = "[DateShip]";
}
else if (orderCol == 8)
{
orderBy = "[DateShip] desc";
}
else if (orderCol == 9)
{
orderBy = "[CreateDate]";
}
else if (orderCol == 10)
{
orderBy = "[CreateDate] desc";
}
int RecordCount = db.Count <Z10Order>(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 <Z10Order> records = db.Take <Z10Order>(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 <UserRole> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol)
{
PaginatedList <UserRole> rtn = new PaginatedList <UserRole>();
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 qUserIDStart = paras["qUserIDStart"];
if (qUserIDStart != null && qUserIDStart.ToString() != "")
{
where += " and [UserID] >= @UserIDStart";
dbParams.Add(db.CreateParameter("UserIDStart", qUserIDStart));
}
object qUserIDEnd = paras["qUserIDEnd"];
if (qUserIDEnd != null && qUserIDEnd.ToString() != "")
{
where += " and [UserID] <= @UserID";
dbParams.Add(db.CreateParameter("UserIDEnd", qUserIDEnd));
}
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 qUserRoleType = paras["qUserRoleType"];
if (qUserRoleType != null && qUserRoleType.ToString() != "")
{
Int32 intqUserRoleType = (Int32)qUserRoleType;
if (intqUserRoleType > 0)
{
where += " and ([UserRoleType] & @UserRoleType = @UserRoleType)";
dbParams.Add(db.CreateParameter("UserRoleType", qUserRoleType));
}
}
object qUserRoleStatus = paras["qUserRoleStatus"];
if (qUserRoleStatus != null && qUserRoleStatus.ToString() != "")
{
Int32 intqUserRoleStatus = (Int32)qUserRoleStatus;
if (intqUserRoleStatus > 0)
{
where += " and [UserRoleStatus] = @UserRoleStatus";
dbParams.Add(db.CreateParameter("UserRoleStatus", qUserRoleStatus));
}
}
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 = "[UserRoleID]";
}
else if (orderCol == 2)
{
orderBy = "[UserRoleID] desc";
}
else if (orderCol == 3)
{
orderBy = "[UserRoleType]";
}
else if (orderCol == 4)
{
orderBy = "[UserRoleType] desc";
}
else if (orderCol == 5)
{
orderBy = "[UserRoleStatus]";
}
else if (orderCol == 6)
{
orderBy = "[UserRoleStatus] desc";
}
else if (orderCol == 7)
{
orderBy = "[CreateDate]";
}
else if (orderCol == 8)
{
orderBy = "[CreateDate] desc";
}
int RecordCount = db.Count <UserRole>(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 <UserRole> records = db.Take <UserRole>(where + " order by " + orderBy, PageSize, PageIndex, dbParams.ToArray());
rtn.AddRange(records);
rtn.PageIndex = PageIndex;
rtn.PageSize = PageSize;
rtn.TotalCount = RecordCount;
return(rtn);
}
public static Z10Cabbage.Entity.Z10OrderItem GetTop1OrderItem(this Z10Order order, Zippy.Data.IDalProvider db)
{
return(db.FindUnique <Z10Cabbage.Entity.Z10OrderItem>("OrderID=@OrderID", db.CreateParameter("OrderID", order.OrderID)));
}
public static Tenant Create(Zippy.Data.IDalProvider db, Guid _TenantID)
{
Tenant rtn = db.FindUnique <Tenant>(_TenantID);
return(rtn);
}
