using FineUIPro; using iWareCommon.Common.Entity; using iWareCommon.Common.EnumType; using iWareDataCore.BASE.EnumType; using iWareDataCore.BASE.Service; using iWareExcel.EXCEL.Service; using iWareWms; using iWareWms.Code.Excel.Service; using System; using System.Collections.Generic; namespace iWareWms.View.FM.Place { public partial class Place : PageBase { protected override Grid GetGrid() { return PlaceGrid; } protected override DropDownList GetPageSizeDropDownList() { return ddlPageSize; } protected override List GetDataSource(int pageIndex, int pageSize, out string msg, out int totalNum, out int currentPage) { var place = PlaceViewService.GetInstance().QueryByParam(new QueryParam { Search = new Dictionary { { "Code", tbCodeName.Text.Trim() } }, Filter = new Dictionary { { "TypeId", ddlTypeId.SelectedValue }}, PageIndex = pageIndex, PageSize = pageSize }, out msg, out totalNum, out currentPage); var res = new List(); place.ForEach(x => res.Add(x)); return res; } protected override void Delete(int id, out string msg) { PlaceService.GetInstance().Delete(id, out msg); WriteLog("库位删除" + msg, "库位管理"); } protected override void Delete(List ids, out string msg) { PlaceService.GetInstance().Delete(ids, out msg); WriteLog("库位删除" + msg, "库位管理"); } protected void Page_Load(object sender, EventArgs e) { string msg; if (!IsPostBack) { string name = GetIdentityName(); if (name == "admin") { Button3.Hidden = false; Button1.Hidden = false; btnReset.Hidden = false; btnUnLock.Hidden = false; } else { Button3.Hidden = true; Button1.Hidden = true; btnReset.Hidden = true; btnUnLock.Hidden = false; } //判断删除复选框是否选择了至少一项纪录 ResolveDeleteButtonForGrid(Button3, PlaceGrid); var types = PlaceTypeService.GetInstance().QueryByParam(new QueryParam(), out msg); types.ForEach(x => { if(x.Name!="无用库位") { ddlTypeId.Items.Add(x.Name, x.Id.ToString()); } }); Button1.OnClientClick = types.Count > 0 && types.Count > 0 ? Window1.GetShowReference("~/View/FM/Place/PlaceDetail.aspx", "新增库位") : "alert('请先添加库位类型')"; Query(1); } } /// /// 类型前台显示 /// /// /// protected string GetStatus(object Status) { return ((EPlaceStatus)Convert.ToInt32(Status)).ToString(); } /// /// 类型前台显示 /// /// /// protected string GetIsLock(object IsLock) { return ((EYesOrNo)Convert.ToInt32(IsLock)).ToString(); } protected override Window GetWindow() { return Window2; } protected override void GetPath(object userName) { string msg; var place = PlaceViewService.GetInstance().QueryByParam(new QueryParam { Search = new Dictionary { { "Code", tbCodeName.Text.Trim() } }, Filter = new Dictionary { { "TypeId", ddlTypeId.SelectedValue } } }, out msg); var datas = new List(); place.ForEach(x => datas.Add(x)); var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary { { "Name", "库位管理" } } }, out msg); var path = ExcelService.GetInstance().ToExcelByEPPlus(workBooks[0], new Dictionary> { { "库位管理", datas } }, out msg); Session["ExcelPath"] = path; } protected override FineUIPro.Timer GetTimer() { return timer1; } /// /// 导入Excel /// /// /// protected void FileUpload1_FileSelected(object sender, EventArgs e) { string msg; if (!FileUpload1.HasFile) { Alert.ShowInTop("请选择上传文件!"); return; } var dt = DateTime.Now; string path = string.Format(@"c:\importExcel\{0}\{1}\{2}\{3}\", dt.Year, dt.Month, dt.Day, (long)(dt - Convert.ToDateTime("1970-01-01 08:00:00")).TotalMilliseconds); ; path += FileUpload1.FileName; FileUpload1.SaveAs(path); var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary { { "Name", "库位管理" } } }, out msg); PlaceViewService.GetInstance().ImportExcel(path, workBooks[0], out msg); Alert.ShowInTop(string.IsNullOrEmpty(msg) ? "导入成功" : msg); Query(1); } /// /// 库位状态清理 /// /// /// protected void btnReset_Click(object sender, EventArgs e) { string msg = ""; List ids = GetSelectedDataKeyIDs(PlaceGrid); PlaceService.GetInstance().PlaceReset(ids, out msg); if(string.IsNullOrEmpty(msg)) { msg = "重置成功!"; } WriteLog("库位状态重置" + msg, "库位管理"); Alert.Show(msg); Query(1); } protected void btnUnLock_Click(object sender, EventArgs e) { string msg = ""; List ids = GetSelectedDataKeyIDs(PlaceGrid); PlaceService.GetInstance().PlaceUnLock(ids, out msg); if (string.IsNullOrEmpty(msg)) { msg = "解锁成功!"; } WriteLog("库位解锁" + msg, "库位管理"); Alert.Show(msg); Query(1); } } }