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);
}