public virtual ActionResult Create(string table, FormCollection collection) { try { #if DEBUG Debug.WriteLine("________________\n________________\n________________\n"); foreach (string key in collection) { Debug.WriteLine($"[{key}] = {collection[key]} "); } Debug.WriteLine("________________\n________________\n________________\n"); #endif var model = QueryHelper.GetInstance(table); model.CopyFrom(collection, table); QueryHelper.Add(table, model); return(RedirectToAction("Index")); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return(View()); } }
public async Task <ActionResult> Run() { if (!SiteDefinition.INITIAL_INSTALL || SiteDefinition.INITIAL_INSTALL_ENDED) { return(NotAuthorized()); } List <string> wantedPackages = new List <string>(); FormHelper form = Manager.RequestForm; foreach (string key in form.GetCollection().Keys) { if (form[key] == "on") { wantedPackages.Add(key); } } wantedPackages.AddRange(RequiredPackages); PackagesDataProvider packagesDP = new PackagesDataProvider(); QueryHelper qh = new QueryHelper(); qh.Add("From", "Data"); await packagesDP.InitAllAsync(qh, wantedPackages); return(new EmptyResult()); }
public ActionResult Create(string table, IFormCollection collection) { try { #if DEBUG Debug.WriteLine("________________\n________________\n________________\n"); foreach (var item in collection) { Debug.WriteLine($"[{item.Key}] = {item.Value} "); } Debug.WriteLine("________________\n________________\n________________\n"); #endif var instance = QueryHelper.GetInstance(table); instance.CopyFrom(collection, table); QueryHelper.Add(table, instance); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public async Task <ModuleAction> GetAction_BlogAsync(string url, int blogCategory = 0, DateTime?StartDate = null, int Count = 0) { BlogConfigData config = await BlogConfigDataProvider.GetConfigAsync(); QueryHelper query = new QueryHelper(); if (string.IsNullOrWhiteSpace(url)) { url = await BlogConfigData.GetCategoryCanonicalNameAsync(blogCategory); } else { url = ModulePermanentUrl; query.Add("BlogCategory", blogCategory.ToString()); } string date = null; if (StartDate != null) { query.Add("StartDate", StartDate.ToString()); date = Formatting.Date_Month_YYYY((DateTime)StartDate); if (StartDate >= DateTime.UtcNow) { date = this.__ResStr("latest", "{0} - Latest", date); } } else { Count = 0;// must have a date for Count to be displayed } return(new ModuleAction(this) { Url = string.IsNullOrWhiteSpace(url) ? ModulePermanentUrl : url, QueryArgsDict = query, Image = "#Display", LinkText = Count != 0 ? this.__ResStr("countLink", "{0} ({1})", date, Count) : this.__ResStr("displayLink", "Blog"), MenuText = Count != 0 ? this.__ResStr("countMenu", "{0} ({1})", date, Count) : this.__ResStr("displayText", "Blog"), Tooltip = Count != 0 ? this.__ResStr("countTooltip", "Display blog entries starting {0}", date, Count) : this.__ResStr("displayTooltip", "Display the blog"), Legend = Count != 0 ? this.__ResStr("countLegend", "Displays the blog entries starting {0}", date, Count) : this.__ResStr("displayLegend", "Displays the blog"), Style = ModuleAction.ActionStyleEnum.Normal, Category = ModuleAction.ActionCategoryEnum.Read, Mode = ModuleAction.ActionModeEnum.Any, Location = ModuleAction.ActionLocationEnum.NoAuto, }); }
private EncodeCollection <CheckOrder> GetDatas() { var query = new QueryHelper <CheckOrder>(); query.Add("createtime", this.dateTimeRange1); if (!rtbCheckOrder.Text.IsNullOrWhiteSpace()) { var CheckOrderIDs = rtbCheckOrder.Text.ToLikeString(); query.Add("checkorderid", CheckOrderIDs); } if (rcddState.CheckedItems.Count > 0) { string[] StateNames = rcddState.CheckedItems.Select(x => x.Text).ToList().ToArray(); query.Add <CheckOrderStateEnum>("checkorderstate", StateNames); } var ec = query.GetDatas(); return(ec); }
private void InitGrid() { #region 表格属性设定 OrderGV = new SSITGridView <CheckOrder>(); OrderGV.Dock = DockStyle.Fill; OrderGV.AllowDeleteRow = false; OrderGV.AllowAddNewRow = false; OrderGV.AllowEditRow = false; OrderGV.AllowToolBar = true; OrderGV.AllowBottomToolBar = true; OrderGV.AllowBottomToolBarFilter = false; OrderGV.AllowDragToGroup = false; OrderGV.AllowPaging = false; OrderGV.MultiSelect = false; OrderGV.AllowCheckedColumn = false; #endregion #region 表格事件 //过滤: OrderGV.GridFilterMode = FilterMode.None; OrderGV.StyleChanged += OrderGV_StyleChanged; OrderGV.CellFormatting += OrderGV_CellFormatting; OrderGV.GridDbClick += OrderGV_GridDbClick; #endregion OrderGV.InitColumns(); //GV.AllowEditColumns(); var Query = new QueryHelper <CheckOrder>(); Query.Add("sampledate", DateTime.Now.Date.AddDays(-8).ToString(EncodeConst.DateTimeFormat), SSIT.DataField.Comparer.GreaterEqual); Query.Add("sampledate", DateTime.Now.Date.AddDays(1).ToString(EncodeConst.DateTimeFormat), SSIT.DataField.Comparer.Less); string[] StateNames = new string[] { SampleTypeEnum.PackagesComming.GetDescription() }; Query.Add <SampleTypeEnum>("sampletype", StateNames); var str = Query.GetSQLCondition(); var ec = Query.GetDatas(); OrderGV.FillGrid(ec); GridPanel.Controls.Add(OrderGV); }
public async Task SendVerificationAsync(UserDefinition user, string ccEmail = null) { string retUrl = Manager.ReturnToUrl; string urlOnly; QueryHelper qh = QueryHelper.FromUrl(Manager.CurrentSite.LoginUrl, out urlOnly); qh.Add("Name", user.UserName, Replace: true); qh.Add("V", user.VerificationCode, Replace: true); string urlNoOrigin = qh.ToUrl(urlOnly); qh.Add("CloseOnLogin", "true", Replace: true); qh.Add(Globals.Link_OriginList, Utility.JsonSerialize(new List <Origin> { new Origin { Url = retUrl } }), Replace: true); string url = qh.ToUrl(urlOnly); SendEmail sendEmail = new SendEmail(); object parms = new { User = user, Url = Manager.CurrentSite.MakeUrl(url), UrlNoOrigin = Manager.CurrentSite.MakeUrl(urlNoOrigin), Code = user.VerificationCode, }; string subject = this.__ResStr("verificationSubject", "Verification required for site {0}", Manager.CurrentSite.SiteDomain); await sendEmail.PrepareEmailMessageAsync(user.Email, subject, await sendEmail.GetEmailFileAsync(Package.GetCurrentPackage(this), "Account Verification.txt"), Parameters : parms); if (!string.IsNullOrWhiteSpace(ccEmail)) { sendEmail.AddBcc(ccEmail); } await sendEmail.SendAsync(true); SendingEmailAddress = await sendEmail.GetSendingEmailAddressAsync(); }
public async Task <string> RenderAsync(PageBarInfo model) { HtmlBuilder hb = new HtmlBuilder(); string pane = model.ContentPane; string styleCss; string styleListCss = ""; string activeCss; switch (model.Style) { default: case PageBarModule.PanelStyleEnum.Vertical: styleCss = "t_stylesvert"; break; case PageBarModule.PanelStyleEnum.Horizontal: styleCss = "t_styleshorz"; break; } if (model.UseSkinFormatting) { await JqueryUICore.UseAsync();// needed for css styleCss += " t_skin"; styleListCss = " ui-widget-content"; activeCss = " t_active ui-state-active"; } else { styleCss += " t_noskin"; activeCss = " t_active"; } string paneContents = ""; if (model.ContentPage != null) { paneContents = await model.ContentPage.RenderPaneAsync(HtmlHelper, pane == ""?Globals.MainPane : pane, PaneDiv : false); } string pageUrl = Manager.CurrentPage.EvaluatedCanonicalUrl; string pageUrlOnly; QueryHelper qh = QueryHelper.FromUrl(pageUrl, out pageUrlOnly); hb.Append($@" <div class='yt_panels_pagebarinfo t_display {styleCss}' id='{ControlId}'> <div class='yt_panels_pagebarinfo_list yNoPrint{styleListCss}'>"); foreach (PageBarInfo.PanelEntry entry in model.Panels) { string caption = entry.Caption.ToString(); if (string.IsNullOrWhiteSpace(caption)) { caption = this.__ResStr("emptyCaption", "(no caption - Page Title)"); } string actionLinkClass = "yaction-link"; string active = ""; if (model.ContentUri != null) { Uri uriLink = new Uri(entry.Url); if (uriLink.AbsolutePath.ToLower() == model.ContentUri.AbsolutePath.ToLower()) { active = activeCss; } } qh.Add("!ContentUrl", entry.Url, Replace: true); string anchor = $"<a class='{actionLinkClass}' data-contenttarget='{DivId}' data-contentpane='{HAE(pane == "" ? "MainPane" : pane)}' {Basics.CssSaveReturnUrl}='' href='{HAE(qh.ToUrl(pageUrlOnly))}' data-tooltip='{HAE(entry.ToolTip.ToString())}'>"; hb.Append($@" <div class='t_entry{active}'> <div class='t_image'> {anchor} <img src='{HAE(entry.ImageUrl)}' alt='{HAE(caption)}' title='{HAE(entry.ToolTip.ToString())}' /> </a> </div> <div class='t_link'> {anchor} {HE(caption)}</a> </div> </div>"); } hb.Append($@" </div> <div class='t_area' id='{DivId}'> {paneContents} </div> </div>"); Setup setup = new Setup { Resize = model.Style == PageBarModule.PanelStyleEnum.Vertical, ActiveCss = activeCss, }; Manager.ScriptManager.AddLast($@"new YetaWF_Panels.PageBarInfoComponent('{ControlId}', {Utility.JsonSerialize(setup)});"); return(hb.ToString()); }
private EncodeCollection <MMInOrder> GetDatas() { var Helper = new QueryHelper <MMInOrder>(); Helper.Add("SynTime", this.dateTimeRange1); if (!rtbBatch.Text.IsNullOrWhiteSpace()) { var LotIDs = rtbBatch.Text.ToLikeString(); Helper.Add("BatchID", LotIDs); } if (!rtbOrderID.Text.IsNullOrWhiteSpace()) { var orderIDs = rtbOrderID.Text.ToLikeString(); Helper.Add("OrderID", orderIDs); } if (!rtbPurOrderID.Text.IsNullOrWhiteSpace()) { var purIDs = rtbPurOrderID.Text.ToLikeString(); Helper.Add("PurchaseOrderPK", purIDs); } var ec = Helper.GetDatas(); EncodeCollection <MMInOrder> sec = new EncodeCollection <MMInOrder>(); EncodeCollection <MMInOrder> tec = new EncodeCollection <MMInOrder>(); if (!rtbMMDef.Text.IsNullOrWhiteSpace()) { var mmHelper = new QueryHelper <MMDefinition>(); var MMnames = rtbMMDef.Text.ToLikeString(); mmHelper.Add("paramname", MMnames); string mmclause = mmHelper.GetSQLCondition(); var mmec = mmHelper.GetDatas(); List <int> DefIDs = new List <int>(); foreach (var data in mmec) { DefIDs.Add(data.ParamID); } foreach (var item in ec) { if (DefIDs.Contains(item.DefPK)) { sec.Add(item); } } if (sec.Count == 0) { var mmidHelper = new QueryHelper <MMDefinition>(); var MMids = rtbMMDef.Text.ToLikeString(); mmidHelper.Add("DefID", MMids); string mmidclause = mmHelper.GetSQLCondition(); mmec = mmidHelper.GetDatas(); DefIDs.Clear(); foreach (var data in mmec) { DefIDs.Add(data.ParamID); } foreach (var item in ec) { if (DefIDs.Contains(item.DefPK)) { sec.Add(item); } } } } else { sec = ec; } if (!rtbSupplier.Text.IsNullOrWhiteSpace()) { var supHelper = new QueryHelper <Supplier>(); var supnames = rtbSupplier.Text.ToLikeString(); supHelper.Add("paramname", supnames); string supclause = supHelper.GetSQLCondition(); var supec = supHelper.GetDatas(); List <int> SupIDs = new List <int>(); foreach (var data in supec) { SupIDs.Add(data.ParamID); } foreach (var item in sec) { if (SupIDs.Contains(item.SupPK)) { tec.Add(item); } } return(tec); } return(sec); }