protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string foldername = Request.Form["foldername"]; string selectid = Request.Form["selectid"]; string message = Request.Form["message"]; if (selectid.Contains("root")) { selectid = selectid.Remove(0, "root".Length); eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders(); model.Foldername = foldername.Trim(); model.ParentID = int.Parse(selectid); model.isDeleted = 1; model.isOffline = 0; Fbll.Add(model); Response.Write("success"); Response.End(); } else if (selectid.Contains("folder")) { selectid = selectid.Remove(0, "folder".Length); //insert message eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.Question = message.Trim(); model.FolderID = int.Parse(selectid); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 0; model.RelatedID = 0; model.sortOrder = SortOrderHelper.GetSortOrder(model.FolderID); model.isDeleted = 1; bll.Add(model); //insert answer eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers(); ansmodel.Answer = ""; ansmodel.MessageID = bll.GetMaxId() - 1; ansmodel.isDeleted = 0; abll.Add(ansmodel); Response.Write("success"); Response.End(); } } catch { } } }
public void PasteFromCopy() { try { if (toID.Contains(Nodetype.message.ToString())) { int iMsgID = int.Parse(toID.Remove(0, Nodetype.message.ToString().Length)); int iToFolderID = int.Parse(ID.Remove(0, Nodetype.folder.ToString().Length)); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model = bll.GetModel(iMsgID); model.FolderID = iToFolderID; model.sortOrder = SortOrderHelper.GetSortOrder(iToFolderID); bll.Add(model); int newID = bll.GetMaxId() - 1; //add variation DataSet ds = bll.GetList(" relatedid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { model.ID = int.Parse(dr["ID"].ToString()); model.RelatedID = newID; model.Question = dr["Question"].ToString(); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 1;//设置成true model.isDeleted = 1; model.FolderID = null; model.sortOrder = null; bll.Add(model); } } eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers(); //if answer exist, update answer ,else if answer not exist,add answer ds = abll.GetList(" messageid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //insert answer with answer content ansmodel.Answer = ds.Tables[0].Rows[0]["answer"].ToString(); ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } else { //insert answer without content ansmodel.Answer = ""; ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } } } catch { } }
/// <summary> /// The PostgreSQL index sort ordering to be used. /// </summary> /// <remarks> /// https://www.postgresql.org/docs/current/static/indexes-ordering.html /// </remarks> /// <param name="indexBuilder">The builder for the index being configured.</param> /// <param name="values">The sort order to use for each column.</param> /// <returns>A builder to further configure the index.</returns> public static IndexBuilder HasSortOrder( this IndexBuilder indexBuilder, params SortOrder[]?values) { Check.NotNull(indexBuilder, nameof(indexBuilder)); Check.NullButNotEmpty(values, nameof(values)); if (!SortOrderHelper.IsDefaultSortOrder(values)) { indexBuilder.Metadata.SetSortOrder(values); } return(indexBuilder); }
private void CopyNextTo([NotNull] DragCopyPipeline pipeline) { Debug.ArgumentNotNull(pipeline, nameof(pipeline)); int sortOrder; int sortOrderDelta; ItemTreeViewItem parent; ItemTreeViewItem anchor; SortOrderHelper.GetSortOrder(pipeline.Target, pipeline.Position, pipeline.Items.Count(), out sortOrder, out sortOrderDelta, out parent, out anchor); if (parent == null) { AppHost.MessageBox(Resources.CopyItems_CopyNextTo_Parent_is_not_an_item, Resources.Error, MessageBoxButton.OK, MessageBoxImage.Error); pipeline.Abort(); return; } pipeline.Owner = parent; pipeline.Anchor = anchor; var fieldId = IdManager.GetFieldId("/sitecore/templates/System/Templates/Sections/Appearance/Appearance/__Sortorder"); foreach (var item in pipeline.Items) { var newName = string.Format(Resources.CopyItems_CopyNextTo_Copy_of__0_, item.Name); var newItemUri = item.ItemUri.Site.DataService.Copy(item.ItemUri, parent.ItemUri.ItemId, newName); if (newItemUri == ItemUri.Empty) { AppHost.MessageBox(string.Format(Resources.CopyItems_CopyNextTo_Failed_to_copy___0_, item.Name), Resources.Error, MessageBoxButton.OK, MessageBoxImage.Information); pipeline.Abort(); return; } var newItem = new DragCopyPipeline.NewItem { Item = item, NewName = newName, NewItemUri = newItemUri, SortOrder = sortOrder }; ItemModifier.Edit(newItemUri, fieldId, sortOrder.ToString(CultureInfo.InvariantCulture)); sortOrder += sortOrderDelta; pipeline.NewItems.Add(newItem); } }
/// <summary> /// The PostgreSQL index NULL sort ordering to be used. /// </summary> /// <remarks> /// https://www.postgresql.org/docs/current/static/indexes-ordering.html /// </remarks> /// <param name="indexBuilder">The builder for the index being configured.</param> /// <param name="values">The sort order to use for each column.</param> /// <returns>A builder to further configure the index.</returns> public static IndexBuilder HasNullSortOrder( [NotNull] this IndexBuilder indexBuilder, [CanBeNull] params NullSortOrder[] values) { Check.NotNull(indexBuilder, nameof(indexBuilder)); Check.NullButNotEmpty(values, nameof(values)); var sortOrders = indexBuilder.Metadata.GetSortOrder(); if (!SortOrderHelper.IsDefaultNullSortOrder(values, sortOrders)) { indexBuilder.Metadata.SetNullSortOrder(values); } return(indexBuilder); }
/// <summary> /// The PostgreSQL index NULL sort ordering to be used. /// </summary> /// <remarks> /// https://www.postgresql.org/docs/current/static/indexes-ordering.html /// </remarks> /// <param name="indexBuilder">The builder for the index being configured.</param> /// <param name="values">The sort order to use for each column.</param> /// <param name="fromDataAnnotation">Indicates whether the configuration was specified using a data annotation.</param> /// <returns>A builder to further configure the index.</returns> public static IConventionIndexBuilder?HasNullSortOrder( this IConventionIndexBuilder indexBuilder, IReadOnlyList <NullSortOrder>?values, bool fromDataAnnotation) { if (indexBuilder.CanSetNullSortOrder(values, fromDataAnnotation)) { if (!SortOrderHelper.IsDefaultNullSortOrder(values, indexBuilder.Metadata.IsDescending)) { indexBuilder.Metadata.SetNullSortOrder(values, fromDataAnnotation); } return(indexBuilder); } return(null); }
/// <summary> /// The PostgreSQL index NULL sort ordering to be used. /// </summary> /// <remarks> /// https://www.postgresql.org/docs/current/static/indexes-ordering.html /// </remarks> /// <param name="indexBuilder">The builder for the index being configured.</param> /// <param name="values">The sort order to use for each column.</param> /// <param name="fromDataAnnotation">Indicates whether the configuration was specified using a data annotation.</param> /// <returns>A builder to further configure the index.</returns> public static IConventionIndexBuilder HasNullSortOrder( [NotNull] this IConventionIndexBuilder indexBuilder, [CanBeNull] IReadOnlyList <NullSortOrder> values, bool fromDataAnnotation) { if (indexBuilder.CanSetNullSortOrder(values, fromDataAnnotation)) { var sortOrders = indexBuilder.Metadata.GetSortOrder(); if (!SortOrderHelper.IsDefaultNullSortOrder(values, sortOrders)) { indexBuilder.Metadata.SetNullSortOrder(values, fromDataAnnotation); } return(indexBuilder); } return(null); }
/// <summary> /// The PostgreSQL index sort ordering to be used. /// </summary> /// <remarks> /// https://www.postgresql.org/docs/current/static/indexes-ordering.html /// </remarks> /// <param name="indexBuilder">The builder for the index being configured.</param> /// <param name="fromDataAnnotation">Indicates whether the configuration was specified using a data annotation.</param> /// <param name="values">The sort order to use for each column.</param> /// <returns>A builder to further configure the index.</returns> public static IConventionIndexBuilder?HasSortOrder( this IConventionIndexBuilder indexBuilder, IReadOnlyList <SortOrder>?values, bool fromDataAnnotation) { if (indexBuilder.CanSetSortOrder(values, fromDataAnnotation)) { Check.NotNull(indexBuilder, nameof(indexBuilder)); Check.NullButNotEmpty(values, nameof(values)); if (!SortOrderHelper.IsDefaultSortOrder(values)) { indexBuilder.Metadata.SetSortOrder(values, fromDataAnnotation); } return(indexBuilder); } return(null); }
public async Task <ActionResult> Get(long userId, int?pageSize = null, int?pageNumber = null, string sortOrder = null) { SortOrder parsedSortOrder = SortOrder.Descending; //Default sort order shows most recent items first if (!string.IsNullOrEmpty(sortOrder)) { //If sort order is not null, check it has a valid value if (!SortOrderHelper.TryParse(sortOrder, out parsedSortOrder)) { return(BadRequest($"Sort order '' is not valid, enter ASC or DESC")); } } var charges = await _chargeRepository.ListAsync( predicate : x => x.Event.User.Id == userId, sortOptions : new SortOptions(nameof(Charge.Id), parsedSortOrder), pageSize : pageSize, pageNumber : pageNumber); return(Ok(_mapper.Map <List <GetChargeResponse> >(charges))); }
public void PasteFromCut() { if (toID.Contains(Nodetype.message.ToString())) { int iMsgID = int.Parse(toID.Remove(0, Nodetype.message.ToString().Length)); int iToFolderID = int.Parse(ID.Remove(0, Nodetype.folder.ToString().Length)); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model = bll.GetModel(iMsgID); model.FolderID = iToFolderID; model.sortOrder = SortOrderHelper.GetSortOrder(iToFolderID); bll.Add(model); int newID = bll.GetMaxId() - 1; //add variation DataSet ds = bll.GetList(" relatedid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { model.ID = int.Parse(dr["ID"].ToString()); model.RelatedID = newID; model.Question = dr["Question"].ToString(); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 1;//设置成true model.isDeleted = 1; model.FolderID = null; model.sortOrder = null; bll.Add(model); } } eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers(); //if answer exist, update answer ,else if answer not exist,add answer string ans = string.Empty; ds = abll.GetList(" messageid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //insert answer with answer content ans = ds.Tables[0].Rows[0]["answer"].ToString(); ansmodel.Answer = ds.Tables[0].Rows[0]["answer"].ToString(); ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } else { //insert answer ansmodel.Answer = ""; ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } int newAnsID = abll.GetMaxId() - 1; //if rule exist, update rule eChartProject.Model.eChart.server_contents_rule rulemodel = new eChartProject.Model.eChart.server_contents_rule(); ds = RuleBll.GetList(" messageid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { //insert rule rulemodel.MessageID = newID; rulemodel.Rule1 = dr["Rule1"].ToString(); RuleBll.Add(rulemodel); int newRuleID = RuleBll.GetMaxId() - 1; //update answer ansmodel.ID = newAnsID; ansmodel.Answer = ans.Replace("<img id=\"" + dr["ID"].ToString() + "\" img=\"\" src=\"../App_Themes/DefaultTheme/images/database_add.png\" />", "<img id=\"" + newRuleID + "\" img=\"\" src=\"../App_Themes/DefaultTheme/images/database_add.png\" />"); ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Update(ansmodel); ans = ansmodel.Answer; } } bll.Delete(iMsgID); } }