using FineUIPro; using iWareCommon.Common.Entity; using iWareExcel.EXCEL.Service; using iWareLog.LOG.EnumType; using iWareLog.LOG.Service; using iWareWms; using iWareWms.Code.Common.Entity; using iWareWms.Code.Excel.Service; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; namespace iWareWms.View.SL.InOutStorageDetail { public partial class InOutStorageDetail : PageBase { protected override Grid GetGrid() { return InOutStorageDetailGrid; } protected override DropDownList GetPageSizeDropDownList() { return ddlPageSize; } protected override List GetDataSource(int pageIndex, int pageSize, out string msg, out int totalNum, out int currentPage) { var places = InOutStorageDetailService.GetInstance().QueryByParam(new QueryParam { Search = new Dictionary { { "FromPlaceCode", tbFromPlaceCode.Text.Trim() }, { "ToPlaceCode", tbToPlaceCode.Text.Trim() }, { "EquipName", tbEquipName.Text.Trim() } , { "MaterialCode", tbMaterialCode.Text.Trim() } }, Geq = new Dictionary { { "UpdateTime", (DateTime)SUpdateTime.SelectedDate } }, Ltd = new Dictionary { { "UpdateTime", ((DateTime)UpdateTime.SelectedDate).AddDays(1) } }, Filter = new Dictionary { { "Type", ddlType.SelectedValue } }, PageIndex = pageIndex, PageSize = pageSize }, out msg, out totalNum, out currentPage); var res = new List(); places.ForEach(x => { x.EquipName=GetTypeinfo(x.Type); res.Add(x); }); return res; } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var today = DateTime.Today; SUpdateTime.SelectedDate = today.AddDays(-6); UpdateTime.SelectedDate = today; ////记录类型 //ddlType.Items.Add("全部", ""); //foreach (var type in Enum.GetValues(typeof(EInOutStorageType))) //{ // ddlType.Items.Add(((EInOutStorageType)type).ToString(), ((int)type).ToString()); //} Query(1); } } protected string GetTypeinfo(int type) { string st = "未知"; try { int ty = int.Parse(type.ToString()); switch (ty) { case 0: st = "入库"; break; case 1: st = "出库"; break; case 2: st = "移库"; break; case 3: st = "退库"; break; default: break; } return st; } catch (Exception) { return st; } } /// /// 类型前台显示 /// /// /// protected string GetType(object type) { string st = "未知"; try { int ty = int.Parse(type.ToString()); switch (ty) { case 0: st = "入库"; break; case 1: st = "出库"; break; case 2: st = "移库"; break; case 3: st = "退库"; break; default: break; } return st; } catch (Exception) { return st; } } protected override Window GetWindow() { return Window1; } protected override void GetPath(object userName) { string msg; var places = InOutStorageDetailService.GetInstance().QueryByParam(new QueryParam { Search = new Dictionary { { "tbFromPlaceCode", tbFromPlaceCode.Text.Trim() }, { "tbToPlaceCode", tbToPlaceCode.Text.Trim() }, { "tbEquipName", tbEquipName.Text.Trim() } , { "tbMaterialCode", tbMaterialCode.Text.Trim() } }, Geq = new Dictionary { { "UpdateTime", (DateTime)SUpdateTime.SelectedDate } }, Ltd = new Dictionary { { "UpdateTime", ((DateTime)UpdateTime.SelectedDate).AddDays(1) } }, }, out msg); var datas = new List(); places.ForEach(x => datas.Add(x)); var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary { { "Name", "库存管理" } } }, out msg); var path = ExcelService.GetInstance().ToExcel(CacheEntity.WorkBookDict["库存管理"], new Dictionary> { { "库存变动记录", datas } }, out msg); Session["ExcelPath"] = path; } protected override FineUIPro.Timer GetTimer() { return timer1; } } }