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<object> GetDataSource(int pageIndex, int pageSize, out string msg, out int totalNum, out int currentPage)
|
{
|
var place = PlaceViewService.GetInstance().QueryByParam(new QueryParam
|
{
|
Search = new Dictionary<string, object> { { "Code", tbCodeName.Text.Trim() } },
|
Filter = new Dictionary<string, object> { { "TypeId", ddlTypeId.SelectedValue }},
|
PageIndex = pageIndex,
|
PageSize = pageSize
|
}, out msg, out totalNum, out currentPage);
|
|
var res = new List<object>();
|
|
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<int> 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);
|
}
|
}
|
/// <summary>
|
/// 类型前台显示
|
/// </summary>
|
/// <param name="type"></param>
|
/// <returns></returns>
|
protected string GetStatus(object Status)
|
{
|
return ((EPlaceStatus)Convert.ToInt32(Status)).ToString();
|
}
|
/// <summary>
|
/// 类型前台显示
|
/// </summary>
|
/// <param name="type"></param>
|
/// <returns></returns>
|
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<string, object> { { "Code", tbCodeName.Text.Trim() } },
|
Filter = new Dictionary<string, object> { { "TypeId", ddlTypeId.SelectedValue } }
|
}, out msg);
|
|
var datas = new List<object>();
|
place.ForEach(x => datas.Add(x));
|
var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary<string, object> { { "Name", "库位管理" } } }, out msg);
|
var path = ExcelService.GetInstance().ToExcelByEPPlus(workBooks[0], new Dictionary<string, List<object>> { { "库位管理", datas } }, out msg);
|
Session["ExcelPath"] = path;
|
}
|
|
|
protected override FineUIPro.Timer GetTimer()
|
{
|
return timer1;
|
}
|
|
/// <summary>
|
/// 导入Excel
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
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<string, object> { { "Name", "库位管理" } } }, out msg);
|
|
PlaceViewService.GetInstance().ImportExcel(path, workBooks[0], out msg);
|
Alert.ShowInTop(string.IsNullOrEmpty(msg) ? "导入成功" : msg);
|
Query(1);
|
}
|
|
/// <summary>
|
/// 库位状态清理
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
protected void btnReset_Click(object sender, EventArgs e)
|
{
|
string msg = "";
|
List<int> 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<int> ids = GetSelectedDataKeyIDs(PlaceGrid);
|
PlaceService.GetInstance().PlaceUnLock(ids, out msg);
|
if (string.IsNullOrEmpty(msg))
|
{
|
msg = "解锁成功！";
|
|
}
|
WriteLog("库位解锁" + msg, "库位管理");
|
Alert.Show(msg);
|
Query(1);
|
}
|
protected void btnLock_Click(object sender, EventArgs e)
|
{
|
string msg = "";
|
List<int> ids = GetSelectedDataKeyIDs(PlaceGrid);
|
PlaceService.GetInstance().PlaceLock(ids, out msg);
|
if (string.IsNullOrEmpty(msg))
|
{
|
msg = "锁定成功！";
|
|
}
|
WriteLog("库位锁定" + msg, "库位管理");
|
Alert.Show(msg);
|
Query(1);
|
}
|
|
}
|
}
|
