@using Bowin.Web.Controls.Mvc; @using EMIS.Web.Controls; @{ string Daytime = DateTime.Now.AddMonths(8).ToLongDateString(); ViewBag.Title = "List"; ComboGridOptions Psop = new ComboGridOptions { TextField = "UnitName", ValueField = "PublishID", ID = "PublishDropdown", Name = "PublishDropdown", OnSelect = "QueryPublishDropdownList", GridOptions = new DataGridOptions { Columns = new List() { // new BoundFieldColumn { FieldName="UnitCode", HeaderText="单位编号", Align=AlignStyle.Center }, new BoundFieldColumn { FieldName="UnitName", HeaderText="出版单位", Align=AlignStyle.Center } }, IsCheckOnSelect = true, DataSourceUrl = Url.Content("~/Publisher/List"), IsPagination = true, IsShowRowNumbers = true, IsSingleSelect = false } }; ComboGridOptions Csop = new ComboGridOptions { TextField = "CourseName", ValueField = "CoursematerialID", ID = "CourseDropdown", Name = "CourseDropdown", OnSelect = "QueryCourseDropdownList", GridOptions = new DataGridOptions { Columns = new List() { // new LinkButtonColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center }, new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center } }, IsCheckOnSelect = true, DataSourceUrl = Url.Content("~/Coursematerial/ListForDropdown"), IsPagination = true, IsShowRowNumbers = true, IsSingleSelect = false } }; ComboGridOptions MaterialCode = new ComboGridOptions { TextField = "TeachingMaterialName", ValueField = "TeachingMaterialPoolID", ID = "TeachingMaterialDropdown", Name = "TeachingMaterialDropdown", OnSelect = "QueryTeachingMaterialDropdownList", GridOptions = new DataGridOptions { Columns = new List() { new BoundFieldColumn { FieldName="TeachingMaterialName",HeaderText="教材名称", Align=AlignStyle.Center }, // new BoundFieldColumn { FieldName="TeachingMaterialCode",HeaderText="教材编号", Align=AlignStyle.Center } }, IsCheckOnSelect = true, DataSourceUrl = Url.Content("~/TeachingMaterialPool/List"), IsPagination = true, IsShowRowNumbers = true, IsSingleSelect = false } }; } @section scripts{ }
@Html.Position()
查询条件
@Html.PositionCondition()
  • 学年学期:
  • @Html.DropdownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ItemSourceUrl = Url.Content("~/SchoolYear/DropDown"), ID = "SchoolYearDropdown", Name = "SchoolYearDropdown", OnSelect = "QuerySchoolYearDropdownList",SelectedValue =@ViewBag.SchoolYearID }, new Dictionary { { "data-condition", "dgStockInStatisticsList" } })
  • 教材名称:
  • @Html.ComboGrid(MaterialCode, new Dictionary { { "data-condition", "dgStockInStatisticsList" } })
  • 出版单位:
  • @Html.ComboGrid(Psop, new Dictionary { { "data-condition", "dgStockInStatisticsList" } })
入库统计列表
@Html.ContextMenuBar("List")
@Html.DataGrid(new DataGridOptions { Columns = new List() { //new CheckBoxFieldColumn{ HeaderText="", FieldName="StockInDetailID", Align = AlignStyle.Center }, new BoundFieldColumn { FieldName="SchoolyearName", HeaderText="学年学期", Align=AlignStyle.Center,Width=0.06}, //new BoundFieldColumn { FieldName="StockInDocumentNo", HeaderText="入库单据号", Align=AlignStyle.Center }, //new BoundFieldColumn { FieldName="StockInNumber", HeaderText="入库编号", Align=AlignStyle.Center }, //new BoundFieldColumn { FieldName="TeachingMaterialCode", HeaderText="教材编号", Align=AlignStyle.Center,Width=0.04 }, new BoundFieldColumn { FieldName="TeachingMaterialName", HeaderText="教材名称", Align=AlignStyle.Center, Width=0.1, OverflowLength=15 }, //new BoundFieldColumn { FieldName="SupplierName", HeaderText="供应商", Align=AlignStyle.Center,Width=0.1 }, //new BoundFieldColumn { FieldName="ISBN", HeaderText="ISBN", Align=AlignStyle.Center,Width=0.08 }, new BoundFieldColumn { FieldName="PublishName", HeaderText="出版单位", Align=AlignStyle.Center,Width=0.08 }, new BoundFieldColumn { FieldName="PublishTime", HeaderText="版本时间",Align=AlignStyle.Center,Width=0.08 }, new BoundFieldColumn { FieldName="Author", HeaderText="作者", Align=AlignStyle.Center,Width=0.08, OverflowLength=10 }, new BoundFieldColumn { FieldName="Price", HeaderText="单价(¥)", Align=AlignStyle.Center, Width=0.04 }, new BoundFieldColumn { FieldName="Quantity", HeaderText="总数量", Align=AlignStyle.Center, Width=0.03 }, new BoundFieldColumn { FieldName="DiscountStr", HeaderText="折扣率", Align=AlignStyle.Center, Width=0.04 }, new BoundFieldColumn { FieldName="DiscountPriceStr", HeaderText="折合价(¥)", Align=AlignStyle.Center, Width=0.04 }, new BoundFieldColumn { FieldName="TotalPriceStr", HeaderText="码洋(¥)", Align=AlignStyle.Center , Width=0.04}, new BoundFieldColumn { FieldName="TotalDollarStr", HeaderText="实洋(¥)", Align=AlignStyle.Center, Width=0.04 } //new BoundFieldColumn { FieldName="HandlerUserName", HeaderText="经手人", Align=AlignStyle.Center, Width=0.04 }, //new BoundFieldColumn { FieldName="StockInUserName", HeaderText="入库人",Align=AlignStyle.Center, Width=0.04 }, //new BoundFieldColumn { FieldName="StockInTime", HeaderText="入库日期",Align=AlignStyle.Center,Formatter= Formatter.OnlyYearMonthDay } }, PageSize = 30 , IsCheckOnSelect = true, DataSourceUrl = Url.Content("~/StockInStatistics/List"), ID = "dgStockInStatisticsList", IsPagination = true, IsShowRowNumbers = true, IsSingleSelect = false })