/// <summary>
/// 移除角色
/// </summary>
/// <param name="userid"></param>
/// <param name="roleid"></param>
/// <param name="tenantid"></param>
/// <param name="creator"></param>
/// <param name="db"></param>
public static void RemoveRole(Guid userid, Guid roleid, Guid?tenantid, Zippy.Data.IDalProvider db)
{
db.Delete <UserRole>("UserID=@UserID and RoleID=@RoleID and TenantID=@TenantID",
db.CreateParameter("UserID", userid),
db.CreateParameter("RoleID", roleid),
db.CreateParameter("TenantID", tenantid));
}
/// <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);
}
public static List <Z01FinancialFlow> QueryForStat(Zippy.Data.IDalProvider db,
Guid tenantID, Hashtable paras)
{
List <System.Data.Common.DbParameter> dbParams = new List <System.Data.Common.DbParameter>();
string where = " [TenantID]=@TenantID";
dbParams.Add(db.CreateParameter("TenantID", tenantID));
object qCurrency = null;
#region 开始查询
if (paras != null)
{
object qDateFrom = paras["qDateFrom"];
if (qDateFrom.IsNotNullOrEmpty())
{
where += " and [CreateDate] >= @CreateDateStart";
dbParams.Add(db.CreateParameter("CreateDateStart", qDateFrom));
}
object qDateTo = paras["qDateTo"];
if (qDateTo.IsNotNullOrEmpty())
{
where += " and [CreateDate] < @CreateDateEnd";
dbParams.Add(db.CreateParameter("CreateDateEnd", ((DateTime)qDateTo).AddDays(1)));
}
qCurrency = paras["qCurrency"];
if (qCurrency.IsNotNullOrEmpty())
{
where += " and [Currency] = @Currency";
dbParams.Add(db.CreateParameter("Currency", qCurrency));
}
object qIn = paras["qIn"];
if (qIn.IsNotNullOrEmpty())
{
if (qIn.Equals(1))
{
where += " and Amount>0";
}
else
{
where += " and Amount<0";
}
}
}
#endregion
return(db.Take <Z01FinancialFlow>(where, dbParams.ToArray()));
}
/// <summary>
/// 获取某个角色的所有权限
/// </summary>
/// <param name="roleID"></param>
/// <param name="tenantID"></param>
/// <param name="db"></param>
/// <returns></returns>
public static List <RolePermission> GetPermissions(Guid roleID, Guid?tenantID, Zippy.Data.IDalProvider db)
{
List <RolePermission> rn = db.Take <RolePermission>("RoleID=@RoleID and TenantID=@TenantID order by DisplayOrder",
db.CreateParameter("RoleID", roleID), db.CreateParameter("TenantID", tenantID));
return(rn);
}
/// <summary>
/// 获取 [银行 的 银行] 的 [财务流水] 集合
/// </summary>
public static List <Z01FinancialFlow> GetBankID_Z01FinancialFlows(Zippy.Data.IDalProvider db, Z01Bank entity)
{
if (entity.BankID.HasValue)
{
return(db.Take <Z01FinancialFlow>("BankID=@BankID", db.CreateParameter("BankID", entity.BankID)));
}
return(new List <Z01FinancialFlow>());
}
/// <summary>
/// 获取 [角色 的 角色] 的 [用户角色] 集合
/// </summary>
public static List <UserRole> GetRoleID_UserRoles(Zippy.Data.IDalProvider db, Role entity)
{
if (entity.RoleID.HasValue)
{
return(db.Take <UserRole>("RoleID=@RoleID", db.CreateParameter("RoleID", entity.RoleID)));
}
return(new List <UserRole>());
}
/// <summary>
/// 获取 [属性模板 的 属性模板] 的 [产品] 集合
/// </summary>
public static List <Z01Product> GetPropertyTemplate_Z01Products(Zippy.Data.IDalProvider db, PropertyTemplate entity)
{
if (entity.TemplateID.HasValue)
{
return(db.Take <Z01Product>("PropertyTemplate=@PropertyTemplate", db.CreateParameter("PropertyTemplate", entity.TemplateID)));
}
return(new List <Z01Product>());
}
/// <summary>
/// 获取 [组 的 组] 的 [用户分组] 集合
/// </summary>
public static List <UserGroup> GetGroupID_UserGroups(Zippy.Data.IDalProvider db, Group entity)
{
if (entity.GroupID.HasValue)
{
return(db.Take <UserGroup>("GroupID=@GroupID", db.CreateParameter("GroupID", entity.GroupID)));
}
return(new List <UserGroup>());
}
/// <summary>
/// 获取 [客户 的 客户] 的 [客户联系人] 集合
/// </summary>
public static List <Z01CustomerPerson> GetCustomerID_Z01CustomerPersons(Zippy.Data.IDalProvider db, Z01Customer entity)
{
if (entity.CustomerID.HasValue)
{
return(db.Take <Z01CustomerPerson>("CustomerID=@CustomerID", db.CreateParameter("CustomerID", entity.CustomerID)));
}
return(new List <Z01CustomerPerson>());
}
/// <summary>
/// 获取 [用户 的 用户] 的 [用户角色] 集合
/// </summary>
public static List <V_UserRole> GetUserID_UserRoles(Zippy.Data.IDalProvider db, User entity)
{
if (entity.UserID.HasValue)
{
return(db.Take <V_UserRole>("UserID=@UserID", db.CreateParameter("UserID", entity.UserID)));
}
return(new List <V_UserRole>());
}
/// <summary>
/// 获取 [行业 的 父行业] 的 [行业] 集合
/// </summary>
public static List <Industry> GetParentID_Industrys(Zippy.Data.IDalProvider db, Industry entity)
{
if (entity.IndustryID.HasValue)
{
return(db.Take <Industry>("ParentID=@ParentID", db.CreateParameter("ParentID", entity.IndustryID)));
}
return(new List <Industry>());
}
/// <summary>
/// 获取 [计量单位 的 标准计量单位] 的 [产品] 集合
/// </summary>
public static List <Z01Product> GetUnitID_Z01Products(Zippy.Data.IDalProvider db, Z01Unit entity)
{
if (entity.UnitID.HasValue)
{
return(db.Take <Z01Product>("UnitID=@UnitID", db.CreateParameter("UnitID", entity.UnitID)));
}
return(new List <Z01Product>());
}
/// <summary>
/// 获取 [头衔/职务 的 头衔/职务] 的 [用户信息] 集合
/// </summary>
public static List <Z01UserInfo> GetTitleID_Z01UserInfos(Zippy.Data.IDalProvider db, Z01Title entity)
{
if (entity.TitleID.HasValue)
{
return(db.Take <Z01UserInfo>("TitleID=@TitleID", db.CreateParameter("TitleID", entity.TitleID)));
}
return(new List <Z01UserInfo>());
}
/// <summary>
/// 获取 [权限表 的 父权限] 的 [权限表] 集合
/// </summary>
public static List <Permission> GetParentID_Permissions(Zippy.Data.IDalProvider db, Permission entity)
{
if (entity.PermissionID.HasValue)
{
return(db.Take <Permission>("ParentID=@ParentID", db.CreateParameter("ParentID", entity.PermissionID)));
}
return(new List <Permission>());
}
/// <summary>
/// 获取 [扩展属性模板 的 属性] 的 [产品扩展属性] 集合
/// </summary>
public static List <Z01ProductExtValue> GetPropertyID_Z01ProductExtValues(Zippy.Data.IDalProvider db, ExtProperty entity)
{
if (entity.PropertyID.HasValue)
{
return(db.Take <Z01ProductExtValue>("PropertyID=@PropertyID", db.CreateParameter("PropertyID", entity.PropertyID)));
}
return(new List <Z01ProductExtValue>());
}
/// <summary>
/// 获取 [客户 的 生产商] 的 [品牌] 集合
/// </summary>
public static List <Z01Brand> GetProducer_Z01Brands(Zippy.Data.IDalProvider db, Z01Customer entity)
{
if (entity.CustomerID.HasValue)
{
return(db.Take <Z01Brand>("Producer=@Producer", db.CreateParameter("Producer", entity.CustomerID)));
}
return(new List <Z01Brand>());
}
/// <summary>
/// 获取 [产品 的 产品] 的 [产品分类关系] 集合
/// </summary>
public static List <Z01ProductInCategory> GetProductID_Z01ProductInCategorys(Zippy.Data.IDalProvider db, Z01Product entity)
{
if (entity.ProductID.HasValue)
{
return(db.Take <Z01ProductInCategory>("ProductID=@ProductID", db.CreateParameter("ProductID", entity.ProductID)));
}
return(new List <Z01ProductInCategory>());
}
/// <summary>
/// 获取 [租户 的 租户] 的 [用户] 集合
/// </summary>
public static List <User> GetTenantID_Users(Zippy.Data.IDalProvider db, Tenant entity)
{
if (entity.TenantID.HasValue)
{
return(db.Take <User>("TenantID=@TenantID", db.CreateParameter("TenantID", entity.TenantID)));
}
return(new List <User>());
}
/// <summary>
/// 获取 [属性模板 的 模板] 的 [扩展属性模板] 集合
/// </summary>
public static List <ExtProperty> GetTemplateID_ExtPropertys(Zippy.Data.IDalProvider db, PropertyTemplate entity)
{
if (entity.TemplateID.HasValue)
{
return(db.Take <ExtProperty>("TemplateID=@TemplateID", db.CreateParameter("TemplateID", entity.TemplateID)));
}
return(new List <ExtProperty>());
}
/// <summary>
/// 获取 [应用 的 应用程序] 的 [租户的应用] 集合
/// </summary>
public static List <TenantApplication> GetApplicationID_TenantApplications(Zippy.Data.IDalProvider db, Application entity)
{
if (entity.ApplicationID.HasValue)
{
return(db.Take <TenantApplication>("ApplicationID=@ApplicationID", db.CreateParameter("ApplicationID", entity.ApplicationID)));
}
return(new List <TenantApplication>());
}
/// <summary>
/// 获取 [客户分类 的 分类] 的 [客户分类关系] 集合
/// </summary>
public static List <Z01CustomerInCategory> GetCategoryID_Z01CustomerInCategorys(Zippy.Data.IDalProvider db, Z01CustomerCategory entity)
{
if (entity.CategoryID.HasValue)
{
return(db.Take <Z01CustomerInCategory>("CategoryID=@CategoryID", db.CreateParameter("CategoryID", entity.CategoryID)));
}
return(new List <Z01CustomerInCategory>());
}
/// <summary>
/// 获取 [地区 的 父地区] 的 [地区] 集合
/// </summary>
public static List <Area> GetParentID_Areas(Zippy.Data.IDalProvider db, Area entity)
{
if (entity.AreaID.HasValue)
{
return(db.Take <Area>("ParentID=@ParentID", db.CreateParameter("ParentID", entity.AreaID)));
}
return(new List <Area>());
}
/// <summary>
/// 设置角色
/// </summary>
/// <param name="userid"></param>
/// <param name="roleid"></param>
/// <param name="db"></param>
public static void SetRole(Guid userid, Guid roleid, Guid?tenantid, Guid?creator, Zippy.Data.IDalProvider db)
{
if (!db.Exists <UserRole>("UserID=@UserID and RoleID=@RoleID", db.CreateParameter("UserID", userid), db.CreateParameter("RoleID", roleid)))
{
UserRole ur = new UserRole();
ur.RoleID = roleid;
ur.UserID = userid;
ur.TenantID = tenantid;
ur.Creator = creator;
db.Insert(ur);
}
}
/// <summary>
/// 制作一个订单的快照
/// </summary>
/// <param name="orderID"></param>
/// <param name="tenantID"></param>
/// <param name="userID"></param>
/// <param name="db"></param>
public static void Snap(long orderID, Guid tenantID, Guid userID, 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));
order.Z10Order.IsSnap = 1;
order.Z10Order.UpdateDate = DateTime.Now;
order.Z10Order.Updater = userID;
foreach (Z10OrderItem item in order.Items)
{
item.UpdateDate = DateTime.Now;
item.Updater = userID;
}
order.Save(tenantID, db, null);
}
/// <summary>
/// 删除一种权限
/// </summary>
/// <param name="roleID"></param>
/// <param name="permissionID"></param>
/// <param name="permissionType"></param>
/// <param name="tenantID"></param>
/// <param name="optUser"></param>
/// <param name="db"></param>
public static void RemovePermission(Guid roleID, long permissionID, int permissionType, Guid?tenantID, Guid?optUser, Zippy.Data.IDalProvider db)
{
RolePermission rp = db.FindUnique <RolePermission>("RoleID=@RoleID and PermissionID=@PermissionID and TenantID=@TenantID",
db.CreateParameter("RoleID", roleID), db.CreateParameter("PermissionID", permissionID), db.CreateParameter("TenantID", tenantID));
if (rp != null)
{
rp.PermissionType = rp.PermissionType & (~permissionType);
rp.Updater = optUser;
rp.UpdateDate = DateTime.Now;
db.Update(rp);
}
}
/// <summary>
/// 表示 [父分类] 被选实体集合的 option html
/// </summary>
public static string GetBankIDEntitiesHtmlOption(Zippy.Data.IDalProvider db, Guid tenantID, System.Int64?selectedValue)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
List <Z01Bank> objs = db.Take <Z01Bank>("TenantID=@TenantID", db.CreateParameter("TenantID", tenantID));
foreach (var obj in objs)
{
if (selectedValue == obj.BankID)
{
sb.AppendLine("<option value='" + obj.BankID + "' selected='selected'>" + obj.Title + "</option>");
}
else
{
sb.AppendLine("<option value='" + obj.BankID + "'>" + obj.Title + "</option>");
}
}
return(sb.ToString());
}
/// <summary>
/// 表示 [父分类] 被选实体集合的 option html
/// </summary>
/// <param name="db"></param>
/// <param name="tenantID"></param>
/// <param name="selectedValue"></param>
/// <param name="removalID">必须移除的ID</param>
/// <returns></returns>
public static string GetParentIDEntitiesHtmlOption(Zippy.Data.IDalProvider db, Guid tenantID, Guid?selectedValue, Guid?removalID)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
List <Group> objs = db.Take <Group>("TenantID=@TenantID", db.CreateParameter("TenantID", tenantID));
List <Group> newObjs = new List <Group>();
ReGroup(objs, newObjs, Guid.Empty, "├", removalID);
foreach (var obj in newObjs)
{
if (selectedValue == obj.GroupID)
{
sb.AppendLine("<option value='" + obj.GroupID + "' selected='selected'>" + obj.Title + "</option>");
}
else
{
sb.AppendLine("<option value='" + obj.GroupID + "'>" + obj.Title + "</option>");
}
}
return(sb.ToString());
}
/// <summary>
/// 增加一种权限
/// </summary>
/// <param name="roleID"></param>
/// <param name="permissionID"></param>
/// <param name="permissionType"></param>
/// <param name="tenantID"></param>
/// <param name="optUser"></param>
/// <param name="db"></param>
public static void SetPermission(Guid roleID, long permissionID, int permissionType, Guid?tenantID, Guid?optUser, Zippy.Data.IDalProvider db)
{
RolePermission rp = db.FindUnique <RolePermission>("RoleID=@RoleID and PermissionID=@PermissionID and TenantID=@TenantID",
db.CreateParameter("RoleID", roleID), db.CreateParameter("PermissionID", permissionID), db.CreateParameter("TenantID", tenantID));
if (rp == null)
{
rp = new RolePermission();
rp.RoleID = roleID;
rp.PermissionID = permissionID;
rp.PermissionType = permissionType;
rp.TenantID = tenantID;
rp.Creator = optUser;
db.Insert(rp);
}
else
{
rp.PermissionType = rp.PermissionType | permissionType;
rp.Updater = optUser;
rp.UpdateDate = DateTime.Now;
db.Update(rp);
}
}
public static PaginatedList <Culture> Query(Zippy.Data.IDalProvider db, Guid tenantID, int PageSize, int PageIndex, Hashtable paras, int?orderCol)
{
PaginatedList <Culture> rtn = new PaginatedList <Culture>();
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 qCultureType = paras["qCultureType"];
if (qCultureType != null && qCultureType.ToString() != "")
{
Int32 intqCultureType = (Int32)qCultureType;
if (intqCultureType > 0)
{
where += " and ([CultureType] & @CultureType = @CultureType)";
dbParams.Add(db.CreateParameter("CultureType", qCultureType));
}
}
object qCultureStatus = paras["qCultureStatus"];
if (qCultureStatus != null && qCultureStatus.ToString() != "")
{
Int32 intqCultureStatus = (Int32)qCultureStatus;
if (intqCultureStatus > 0)
{
where += " and [CultureStatus] = @CultureStatus";
dbParams.Add(db.CreateParameter("CultureStatus", qCultureStatus));
}
}
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 = "[Location]";
}
else if (orderCol == 2)
{
orderBy = "[Location] desc";
}
else if (orderCol == 3)
{
orderBy = "[CultureType]";
}
else if (orderCol == 4)
{
orderBy = "[CultureType] desc";
}
else if (orderCol == 5)
{
orderBy = "[CultureStatus]";
}
else if (orderCol == 6)
{
orderBy = "[CultureStatus] desc";
}
else if (orderCol == 7)
{
orderBy = "[CreateDate]";
}
else if (orderCol == 8)
{
orderBy = "[CreateDate] desc";
}
int RecordCount = db.Count <Culture>(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 <Culture> records = db.Take <Culture>(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 Z01Customer GetProducerEntity(Zippy.Data.IDalProvider db, Z01Brand entity)
{
return(db.FindUnique <Z01Customer>("CustomerID=@CustomerID", db.CreateParameter("CustomerID", entity.Producer)));
}
