/// <summary>
/// 初始化
/// </summary>
/// <param name="rf"></param>
public UCPickingByTaskID4(RF rf)
: base(rf)
{
InitializeComponent();
this._DataTablePage = new DataTablePage();
this._DataTable = new DataTable();
this._DataTable.Columns.Add(new DataColumn("NO", typeof(System.String)));
this._DataTable.Columns.Add(new DataColumn("SysNo", typeof(System.String)));
}
public DataDrivenWithTableSteps()
{
dataTablePage = new DataTablePage();
}
private static void Main()
{
var app = Application.Current;
app.Use(new HtmlFromJsonProvider());
app.Use(new PartialToStandaloneHtmlProvider());
DummyData.Create();
// just to offer a REST endpoint that gives the app version, usable for diagnostics
// (currently used in github-source-links)
Handle.GET("/UniformDocs/uniformdocs-app-version", () => GetAppVersionFromAssemblyFile());
Handle.GET("/UniformDocs/partial/mainpage", () => new MainPage());
Handle.GET("/UniformDocs/mainpage", () => WrapPage <MainPage>("/UniformDocs/partial/mainpage"));
Handle.GET("/UniformDocs/partial/uikit", () => new UIKitPage());
Handle.GET("/UniformDocs/uikit", () => WrapPage <UIKitPage>("/UniformDocs/partial/uikit"));
Handle.GET("/UniformDocs", () => Self.GET("/UniformDocs/mainpage"));
Handle.GET("/UniformDocs/nav", () => new NavPage());
Handle.GET("/UniformDocs/app-name", () => new AppName());
Handle.GET("/UniformDocs/menu", () => new AppMenuPage());
#region Design
Handle.GET("/UniformDocs/partial/sections", () => new SectionsPage());
Handle.GET("/UniformDocs/sections", () => WrapPage <SectionsPage>("/UniformDocs/partial/sections"));
Handle.GET("/UniformDocs/partial/card", () => new CardPage());
Handle.GET("/UniformDocs/card", () => WrapPage <CardPage>("/UniformDocs/partial/card"));
Handle.GET("/UniformDocs/partial/alerts", () => new AlertsPage());
Handle.GET("/UniformDocs/alerts", () => WrapPage <AlertsPage>("/UniformDocs/partial/alerts"));
Handle.GET("/UniformDocs/partial/leftnavlayout", () => new LeftNavLayoutPage());
Handle.GET("/UniformDocs/leftnavlayout", () => WrapPage <LeftNavLayoutPage>("/UniformDocs/partial/leftnavlayout"));
Handle.GET("/UniformDocs/partial/native", () => new NativePage());
Handle.GET("/UniformDocs/native", () => WrapPage <NativePage>("/UniformDocs/partial/native"));
#endregion
#region Components
Handle.GET("/UniformDocs/partial/autocomplete", () => Db.Scope(() => new AutocompletePage()));
Handle.GET("/UniformDocs/autocomplete", () => WrapPage <AutocompletePage>("/UniformDocs/partial/autocomplete"));
Handle.GET("/UniformDocs/partial/breadcrumb",
() => { return(Db.Scope(() => new BreadcrumbPage())); });
Handle.GET("/UniformDocs/breadcrumb", () => WrapPage <BreadcrumbPage>("/UniformDocs/partial/breadcrumb"));
Handle.GET("/UniformDocs/partial/button", () => new ButtonPage());
Handle.GET("/UniformDocs/button", () => WrapPage <ButtonPage>("/UniformDocs/partial/button"));
Handle.GET("/UniformDocs/partial/chart", () => new ChartPage());
Handle.GET("/UniformDocs/chart", () => WrapPage <ChartPage>("/UniformDocs/partial/chart"));
Handle.GET("/UniformDocs/partial/checkbox", () => new CheckboxPage());
Handle.GET("/UniformDocs/checkbox", () => WrapPage <CheckboxPage>("/UniformDocs/partial/checkbox"));
Handle.GET("/UniformDocs/partial/datepicker", () => new DatepickerPage());
Handle.GET("/UniformDocs/datepicker", () => WrapPage <DatepickerPage>("/UniformDocs/partial/datepicker"));
Handle.GET("/UniformDocs/partial/dropdown", () => new DropdownPage());
Handle.GET("/UniformDocs/dropdown", () => WrapPage <DropdownPage>("/UniformDocs/partial/dropdown"));
Handle.GET("/UniformDocs/partial/decimal", () => new DecimalPage());
Handle.GET("/UniformDocs/decimal", () => WrapPage <DecimalPage>("/UniformDocs/partial/decimal"));
Handle.GET("/UniformDocs/partial/formitem", () =>
{
var formItemPage = new FormItemPage();
formItemPage.Init();
return(formItemPage);
});
Handle.GET("/UniformDocs/formitem", () => WrapPage <FormItemPage>("/UniformDocs/partial/formitem"));
Handle.GET("/UniformDocs/partial/formitemgroup", () =>
{
var formItemGroupPage = new FormItemGroupPage();
formItemGroupPage.Init();
return(formItemGroupPage);
});
Handle.GET("/UniformDocs/formitemgroup", () => WrapPage <FormItemGroupPage>("/UniformDocs/partial/formitemgroup"));
Handle.GET("/UniformDocs/partial/html", () => new HtmlPage());
Handle.GET("/UniformDocs/html", () => WrapPage <HtmlPage>("/UniformDocs/partial/html"));
Handle.GET("/UniformDocs/partial/integer", () => new IntegerPage());
Handle.GET("/UniformDocs/integer", () => WrapPage <IntegerPage>("/UniformDocs/partial/integer"));
Handle.GET("/UniformDocs/partial/url", () => new UrlPage());
Handle.GET("/UniformDocs/url", () => WrapPage <UrlPage>("/UniformDocs/partial/url"));
Handle.GET("/UniformDocs/download?session={?}", (string id) =>
{
var ids = new string[] { id };
Session.RunTask(ids, (session, sessionId) => {
var masterPage = Session.Ensure().Store[nameof(MasterPage)] as MasterPage;
var urlPage = masterPage.CurrentPage as UrlPage;
if (urlPage != null)
{
urlPage.DownloadStarted();
session.CalculatePatchAndPushOnWebSocket();
}
});
return(Self.GET("/UniformDocs/images/UniformDocs.svg"));
});
Handle.GET("/UniformDocs/partial/Geo", () =>
{
return(Db.Scope(() =>
{
var geoPage = new GeoPage();
geoPage.Init();
return geoPage;
}));
});
Handle.GET("/UniformDocs/Geo", () => WrapPage <GeoPage>("/UniformDocs/partial/Geo"));
Handle.GET("/UniformDocs/partial/markdown", () => new MarkdownPage());
Handle.GET("/UniformDocs/markdown", () => WrapPage <MarkdownPage>("/UniformDocs/partial/markdown"));
Handle.GET("/UniformDocs/partial/multiselect", () => new MultiselectPage());
Handle.GET("/UniformDocs/multiselect", () => WrapPage <MultiselectPage>("/UniformDocs/partial/multiselect"));
Handle.GET("/UniformDocs/partial/pagination", () => new PaginationPage());
Handle.GET("/Uniformdocs/pagination", () => WrapPage <PaginationPage>("/UniformDocs/partial/pagination"));
Handle.GET("/UniformDocs/partial/password", () => new PasswordPage());
Handle.GET("/UniformDocs/password", () => WrapPage <PasswordPage>("/UniformDocs/partial/password"));
Handle.GET("/UniformDocs/partial/radio", () => new RadioPage());
Handle.GET("/UniformDocs/radio", () => WrapPage <RadioPage>("/UniformDocs/partial/radio"));
Handle.GET("/UniformDocs/partial/radiolist", () => new RadiolistPage());
Handle.GET("/UniformDocs/radiolist", () => WrapPage <RadiolistPage>("/UniformDocs/partial/radiolist"));
Handle.GET("/UniformDocs/partial/table", () => new TablePage());
Handle.GET("/UniformDocs/table", () => WrapPage <TablePage>("/UniformDocs/partial/table"));
Handle.GET("/UniformDocs/partial/text", () => new TextPage());
Handle.GET("/UniformDocs/text", () => WrapPage <TextPage>("/UniformDocs/partial/text"));
Handle.GET("/UniformDocs/partial/textarea", () => new TextareaPage());
Handle.GET("/UniformDocs/textarea", () => WrapPage <TextareaPage>("/UniformDocs/partial/textarea"));
Handle.GET("/UniformDocs/partial/togglebutton", () => new ToggleButtonPage());
Handle.GET("/UniformDocs/togglebutton",
() => WrapPage <ToggleButtonPage>("/UniformDocs/partial/togglebutton"));
Handle.GET("/UniformDocs/partial/datatable", () =>
{
return(Db.Scope(() =>
{
var dataTablePage = new DataTablePage();
dataTablePage.Init();
return dataTablePage;
}));
});
Handle.GET("/UniformDocs/datatable", () => WrapPage <DataTablePage>("/UniformDocs/partial/datatable"));
#endregion
#region How to
Handle.GET("/UniformDocs/partial/callback", () => new CallbackPage());
Handle.GET("/UniformDocs/callback", () => WrapPage <CallbackPage>("/UniformDocs/partial/callback"));
Handle.GET("/UniformDocs/partial/clientlocalstate", () => new ClientLocalStatePage());
Handle.GET("/UniformDocs/clientlocalstate", () => WrapPage <ClientLocalStatePage>("/UniformDocs/partial/clientlocalstate"));
Handle.GET("/UniformDocs/partial/blendablemenu/menulinks", () => new MenuLinksPage());
// Handle.GET("/UniformDocs/blendablemenu/menulinks", () => WrapPage<MenuLinksPage>("/UniformDocs/partial/blendablemenu/menulinks"));
Handle.GET("/UniformDocs/partial/blendablemenu/menubuttons", () => new MenuButtonsPage());
// Handle.GET("/UniformDocs/blendablemenu/menubuttons", () => WrapPage<MenuButtonsPage>("/UniformDocs/partial/blendablemenu/menubuttons"));
// pretend it's the other app
Handle.GET("/UniformDocs/partial/blendablemenu/othermenubuttons", () => new MenuButtonsPage());
// Handle.GET("/UniformDocs/blendablemenu/menubuttons", () => WrapPage<MenuButtonsPage>("/UniformDocs/partial/blendablemenu/menubuttons"));
Handle.GET("/UniformDocs/partial/blendablemenu", () => new BlendableMenuPage
{
GridMenu = Self.GET("/UniformDocs/partial/blendablemenu/menubuttons"),
ListMenu = Self.GET("/UniformDocs/partial/blendablemenu/menulinks")
});
Handle.GET("/UniformDocs/blendablemenu", () => WrapPage <BlendableMenuPage>("/UniformDocs/partial/blendablemenu"));
Handle.GET("/UniformDocs/partial/cookie", (Request request) =>
{
string name = "UniformDocs";
CookiePage page = new CookiePage();
Cookie cookie = request.Cookies.Select(x => new Cookie(x)).FirstOrDefault(x => x.Name == name);
if (cookie != null)
{
page.RequestCookie = cookie.Value;
}
cookie = new Cookie
{
Name = name,
Value = $"UniformDocsCookie-{DateTime.Now.ToString()}",
Expires = DateTime.Now.AddDays(1)
};
Handle.AddOutgoingCookie(name, cookie.GetFullValueString());
return(page);
});
Handle.GET("/UniformDocs/cookie", () => WrapPage <CookiePage>("/UniformDocs/partial/cookie"));
Handle.GET("/UniformDocs/partial/dialog", () => new DialogPage());
Handle.GET("/UniformDocs/dialog", () => WrapPage <DialogPage>("/UniformDocs/partial/dialog"));
Handle.GET("/UniformDocs/partial/fileupload", () => new FileUploadPage());
Handle.GET("/UniformDocs/fileupload", () => WrapPage <FileUploadPage>("/UniformDocs/partial/fileupload"));
HandleFile.GET("/UniformDocs/fileupload/upload", task =>
{
Session.RunTask(task.SessionId, (session, id) =>
{
var master = session.Store[nameof(MasterPage)] as MasterPage;
var page = master?.CurrentPage as FileUploadPage;
if (page == null)
{
return;
}
var item = page.Tasks.FirstOrDefault(x => x.FileName == task.FileName);
switch (task.State)
{
case HandleFile.UploadTaskState.Error:
if (item != null)
{
page.Tasks.Remove(item);
}
break;
case HandleFile.UploadTaskState.Completed:
if (item != null)
{
page.Tasks.Remove(item);
}
var file = page.Files.FirstOrDefault(x => x.FileName == task.FileName) ?? page.Files.Add();
file.FileName = task.FileName;
file.FileSize = task.FileSize;
file.FilePath = task.FilePath;
break;
default:
if (item == null)
{
item = page.Tasks.Add();
}
item.FileName = task.FileName;
item.FileSize = task.FileSize;
item.Progress = task.Progress;
break;
}
session.CalculatePatchAndPushOnWebSocket();
});
});
Handle.GET("/UniformDocs/partial/flashmessage", () => new FlashMessagePage());
Handle.GET("/Uniformdocs/flashmessage", () => WrapPage <FlashMessagePage>("/UniformDocs/partial/flashmessage"));
Handle.GET("/UniformDocs/partial/lazyloading", () => new LazyLoadingPage());
Handle.GET("/Uniformdocs/lazyloading", () => WrapPage <LazyLoadingPage>("/UniformDocs/partial/lazyloading"));
Handle.GET("/UniformDocs/partial/nested", () => new NestedPartial
{
Data = new AnyData()
});
Handle.GET("/UniformDocs/nested", () => WrapPage <NestedPartial>("/UniformDocs/partial/nested"));
Handle.GET("/UniformDocs/partial/progressbar", () => new ProgressBarPage());
Handle.GET("/Uniformdocs/progressbar", () => WrapPage <ProgressBarPage>("/UniformDocs/partial/progressbar"));
Handle.GET("/UniformDocs/partial/Redirect", () => new RedirectPage());
Handle.GET("/UniformDocs/Redirect", () => WrapPage <RedirectPage>("/UniformDocs/partial/Redirect"));
Handle.GET("/UniformDocs/Redirect/{?}", (string param) =>
{
var master = WrapPage <RedirectPage>("/UniformDocs/partial/Redirect") as MasterPage;
var page = master.CurrentPage as RedirectPage;
page.YourFavoriteFood = "You've got some tasty " + param;
return(master);
});
#endregion
}
public ActionResult GetData(int page, int rows, string search, string sidx, string sord)
{
string Name = Request["name"] == null ? "" : Request["name"].ToString();
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filter = Request["filter"] == null ? "" : Request["filter"].ToString();
string ModuleName = Request["m"] == null ? "" : Request["m"].ToString();
string NameSpace = Request["n"] == null ? "" : Request["n"].ToString();
string filtersSql = string.Empty;
string mapSqlFilter = string.Empty;
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
Bll_Sys_Config_Refer configRefer = new Bll_Sys_Config_Refer();
Bll_Sys_Config_Field_Refer configReferList = new Bll_Sys_Config_Field_Refer();
Sys_Config_Refer model = configRefer.GetListByCode(" AND R_ModuleName='"
+ ModuleName + "'")[0];
var referList = configReferList.GetListByCode(" AND D_ModuleName='" + ModuleName + "'").Where(o => !string.IsNullOrEmpty(o.D_DictKey));
Bll_Bse_Dict DictInstance = new Bll_Bse_Dict();
DataTable dt = new DataTable();
if (!string.IsNullOrEmpty(model.R_SQL))
{
if (!string.IsNullOrEmpty(filter))
{
model.R_SQL = model.R_SQL + filter;
}
if (!string.IsNullOrEmpty(filtersSql))
{
model.R_SQL = model.R_SQL + " AND " + filtersSql;
}
dt = configRefer.ListBySql(model.R_SQL);
}
else
{
string _filtersql = !String.IsNullOrEmpty(model.R_FilterSql) ? model.R_FilterSql : "";
_filtersql = _filtersql + filter;
//#region 特殊映射处理
//if (ModuleName=="HR_StuffModule")
//{
// //读取映射配置表中公司配置
// Bll_Comm comm = new Bll_Comm();
// string mapFilter = "";
// var mapModel = comm.CommMap(ModuleName, "Company");
// if (mapModel!=null)
// {
// var deptList = comm.GetChildListDeptNon(comm.CommMap(ModuleName, "Company").Map_Object);
// if (deptList.Count()>0)
// {
// foreach (var item in deptList)
// {
// }
// for (int i = 0; i < deptList.Count;i++ )
// {
// if (i==(deptList.Count-1))
// {
// mapFilter += "'" + deptList[i].Dept_Code+"'";
// }
// else
// {
// mapFilter += "'" + deptList[i].Dept_Code+ "',";
// }
// }
// mapFilter.TrimEnd(',');
// }
// mapSqlFilter = " Stuff_DepCode in(" + mapFilter + ")";
// }
//}
//#endregion
//为空时不初始化
//if (!string.IsNullOrEmpty(filter))
//{
// dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter);
//}
dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter);
}
DataTable newdt = DataTablePage.GetPagedTable(dt, page, rows);
#region 字典进行转换
//对字典进行转换
for (int i = 0; i < newdt.Rows.Count; i++)
{
foreach (var item in referList.ToList())
{
var value = newdt.Rows[i][item.D_Index] != null ? newdt.Rows[i][item.D_Index].ToString() : "";
var DictResult = DictInstance.GetListByCode(" AND Dict_Code='" + value
+ "' AND Dict_Key='" + item.D_DictKey + "' ");
if (DictResult.Count > 0)
{
newdt.Rows[i][item.D_Index] = DictResult.FirstOrDefault().Dict_Name;
}
}
}
#endregion
var json = DataTablePage.JsonForJqgrid(newdt, page, rows, dt.Rows.Count);
return(JavaScript(json));
}
