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; }
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; }
/// <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; }
/// <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; }
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; }
/// <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(); }
/// <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(); }
/// <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; }
/// <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(); }
/// <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(); }
/// <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(); }
/// <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(); }
/// <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; }
/// <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; }
/// <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}"); }
/// <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; }
public static List<DataSource> Take(Zippy.Data.IDalProvider db,string sqlEntry, params System.Data.Common.DbParameter[] cmdParameters) { return db.Take<DataSource>(sqlEntry, cmdParameters); }
public static List<DataSource> Take(Zippy.Data.IDalProvider db,int count) { return db.Take<DataSource>(count, true); }
public static List<DataSource> Take(Zippy.Data.IDalProvider db) { return db.Take<DataSource>(true); }
public static DataSource Create(Zippy.Data.IDalProvider db, Guid _DataSourceID) { DataSource rtn = db.FindUnique<DataSource>(_DataSourceID); return rtn; }
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; }
public static int Insert(Zippy.Data.IDalProvider db, Z01UserInfo entity) { int rtn = db.Insert(entity); return rtn; }
/// <summary> /// 表示 [头衔/职务] 对应的实体 /// </summary> public static Z01Title GetTitleIDEntity(Zippy.Data.IDalProvider db, Z01UserInfo entity) { return db.FindUnique<Z01Title>("TitleID=@TitleID", db.CreateParameter("TitleID", entity.TitleID)); }
public static int Update(Zippy.Data.IDalProvider db, Z01UserInfo entity) { return db.Update(entity); }
/// <summary> /// 表示 [头衔/职务] 被选实体集合 /// </summary> public static List<Z01Title> GetTitleIDEntities(Zippy.Data.IDalProvider db) { return db.Take<Z01Title>(); }
public static int Insert(Zippy.Data.IDalProvider db, DataSource entity) { int rtn = db.Insert(entity); return rtn; }
public static int Delete(Zippy.Data.IDalProvider db, Guid _DataSourceID) { return db.Delete<DataSource>(_DataSourceID); }
public static int Update(Zippy.Data.IDalProvider db, DataSource entity) { return db.Update(entity); }
public static List<Z01UserInfo> Take(Zippy.Data.IDalProvider db) { return db.Take<Z01UserInfo>(true); }
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; }
public static List<Z01UserInfo> Take(Zippy.Data.IDalProvider db,int count) { return db.Take<Z01UserInfo>(count, true); }