/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmSLCreateLayout_Load(object sender, EventArgs e)
{
try
{
WHStorageTypeOutputDto whStorageType = autofacConfig.wareHouseService.GetSTByWareIDandSTID(WareID, STID);
txtWareID.Text = whStorageType.WAREID;
txtWareID.ReadOnly = true;
txtWareName.Text = whStorageType.WARENAME;
txtWareName.ReadOnly = true;
txtSTID.Text = whStorageType.STID;
txtSTID.ReadOnly = true;
txtSTName.Text = whStorageType.NAME;
txtSTName.ReadOnly = true;
if (isEdit)
{
WHStorageLocationOutputDto whStorageLocation = autofacConfig.wareHouseService.GetSLByID(WareID, STID, SLID);
txtSLID.Text = whStorageLocation.SLID;
txtSLID.ReadOnly = true;
txtSLName.Text = whStorageLocation.SLNAME;
btnManager.Tag = whStorageLocation.MANAGER;
btnManager.Text = whStorageLocation.MANAGERNAME + " > ";
txtMAXCAPACITY.Text = whStorageLocation.MAXCAPACITY;
txtMAXVOLUME.Text = whStorageLocation.MAXVOLUME;
}
}
catch (Exception ex)
{
Form.Toast(ex.Message);
}
}
/// <summary>
/// 扫描到库位条码时
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bsLoc_BarcodeScanned(object sender, BarcodeResultArgs e)
{
try
{
if (String.IsNullOrEmpty(e.error))
{
String Data = e.Value;
String[] Datas = Data.Split('/');
if (Datas.Length != 3)
{
throw new Exception("库位条码错误");
}
WHStorageLocationOutputDto whLoc = autofacConfig.wareHouseService.GetSLByID(Datas[0], Datas[1], Datas[2]);
if (whLoc == null)
{
throw new Exception("库位不存在，请检查!");
}
lblLocation.Text = whLoc.WARENAME + "/" + whLoc.STNAME + "/" + whLoc.SLNAME;
lblLocation.Tag = Data;
}
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 耗材扫描
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barcodeScanner1_BarcodeScanned(object sender, BarcodeResultArgs e)
{
try
{
string locId = e.Value;
locData = locId.Split('/');
if (locData.Length != 3)
{
throw new Exception("库位条码错误");
}
WHStorageLocationOutputDto sloc = _autofacConfig.wareHouseService.GetSLByID(locData[0], locData[1], locData[2]);
if (sloc == null)
{
throw new Exception("该库位不存在");
}
List <ConInventoryResult> resultList = _autofacConfig.ConInventoryService.GetResultListBySL(IID, locData[0], locData[1], locData[2]);
if (resultList.Count == 0)
{
throw new Exception("该库位下无可盘点耗材");
}
frmCIResultTotalLayout frm = new frmCIResultTotalLayout();
frm.lblSL.Text = sloc.WARENAME + "/" + sloc.STNAME + "/" + sloc.SLNAME;
Form.ShowDialog(frm);
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 数据加载
/// </summary>
public void Bind()
{
try
{
DataTable tableAssets = new DataTable(); //未开启SN的资产列表
tableAssets.Columns.Add("CID"); //资产编号
tableAssets.Columns.Add("NAME"); //资产名称
tableAssets.Columns.Add("LOCID"); // 仓库/存储类型/库位
tableAssets.Columns.Add("LOCNAME"); // 仓库名称/类型名称/库位名称
tableAssets.Columns.Add("IMAGE"); //图片编号
tableAssets.Columns.Add("QUANTITY"); //空闲数量
tableAssets.Columns.Add("SELECTQTY"); //选择数量
if (RowData.Count > 0)
{
foreach (ConsumablesOrderRow Row in RowData)
{
ConQuant conQuant = autofacConfig.orderCommonService.GetUnUseConByCID(Row.CID, Row.WAREID, Row.STID, Row.SLID);
Consumables con = autofacConfig.consumablesService.GetConsById(Row.CID);
WHStorageLocationOutputDto WHLoc = autofacConfig.wareHouseService.GetSLByID(Row.WAREID, Row.STID, Row.SLID);
tableAssets.Rows.Add(Row.CID, con.NAME, Row.WAREID + "/" + Row.STID + "/" + Row.SLID, WHLoc.WARENAME + "/" + WHLoc.STNAME + "/" + WHLoc.SLNAME, con.IMAGE, conQuant.QUANTITY, Row.QTY);
}
}
ListCons.DataSource = tableAssets;
ListCons.DataBind();
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 加载数据
/// </summary>
public void Bind()
{
try
{
TOInputDto TOData = autofacConfig.assTransferOrderService.GetByID(TOID);
coreUser DeanInUser = autofacConfig.coreUserService.GetUserByID(TOData.MANAGER);
coreUser DealUser = autofacConfig.coreUserService.GetUserByID(TOData.HANDLEMAN);
WHStorageLocationOutputDto whLoc = autofacConfig.wareHouseService.GetSLByID(TOData.WAREID, TOData.STID, TOData.DESSLID);
lblTDInMan.Text = DeanInUser.USER_NAME;
lblDealMan.Text = DealUser.USER_NAME;
lblLocation.Text = whLoc.WARENAME + "/" + whLoc.STNAME + "/" + whLoc.SLNAME;
DatePicker.Value = TOData.TRANSFERDATE;
if (String.IsNullOrEmpty(TOData.NOTE) == false)
{
lblNote.Text = TOData.NOTE;
}
DataTable tableAssets = new DataTable(); //未开启SN的资产列表
tableAssets.Columns.Add("ASSID"); //资产编号
tableAssets.Columns.Add("NAME"); //资产名称
tableAssets.Columns.Add("IMAGE"); //资产图片
tableAssets.Columns.Add("SN"); //序列号
tableAssets.Columns.Add("STATUS"); //行项状态
foreach (AssTransferOrderRow Row in TOData.Rows)
{
Assets assets = autofacConfig.orderCommonService.GetAssetsByID(Row.ASSID);
if (Row.STATUS == 0)
{
tableAssets.Rows.Add(Row.ASSID, assets.NAME, assets.IMAGE, Row.SN, "调拨中");
}
else if (Row.STATUS == 1)
{
tableAssets.Rows.Add(Row.ASSID, assets.NAME, assets.IMAGE, Row.SN, "调拨完成");
}
else
{
tableAssets.Rows.Add(Row.ASSID, assets.NAME, assets.IMAGE, Row.SN, "调拨取消");
}
}
if (tableAssets.Rows.Count > 0)
{
ListAssetsSN.DataSource = tableAssets;
ListAssetsSN.DataBind();
}
if (Client.Session["Role"].ToString() == "SMOWMSUser")
{
plButton.Visible = false;
}
//如果维修单已完成，则隐藏维修单处理按钮
if (TOData.STATUS == 1 || TOData.STATUS == 2)
{
plButton.Visible = false;
}
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 数据加载
/// </summary>
public void Bind()
{
try
{
if (Type == PROCESSMODE.调拨确认)
{
title1.TitleText = "调拨单确认";
}
if (Type == PROCESSMODE.调拨取消)
{
title1.TitleText = "调拨单取消";
}
TOInputDto TOData = autofacConfig.assTransferOrderService.GetByID(TOID);
coreUser DeanInUser = autofacConfig.coreUserService.GetUserByID(TOData.MANAGER);
coreUser DealUser = autofacConfig.coreUserService.GetUserByID(TOData.HANDLEMAN);
lblTDInMan.Text = DeanInUser.USER_NAME;
lblDealMan.Text = DealUser.USER_NAME;
WHStorageLocationOutputDto whLoc = autofacConfig.wareHouseService.GetSLByID(TOData.WAREID, TOData.STID, TOData.DESSLID);
lblLocation.Text = whLoc.WARENAME + "/" + whLoc.STNAME + "/" + whLoc.SLNAME;
DatePicker.Value = TOData.TRANSFERDATE;
if (String.IsNullOrEmpty(TOData.NOTE))
{
lblNote.Text = TOData.NOTE;
}
DataTable tableAssets = new DataTable(); //未开启SN的资产列表
tableAssets.Columns.Add("TOROWID"); //报修单行项编号
tableAssets.Columns.Add("LOCATIONID"); //区域编号
tableAssets.Columns.Add("LOCATIONNAME"); //区域名称
tableAssets.Columns.Add("CID"); //资产编号
tableAssets.Columns.Add("NAME"); //资产名称
tableAssets.Columns.Add("IMAGE"); //图片编号
tableAssets.Columns.Add("INTRANSFERQTY"); //调拨中数量
foreach (AssTransferOrderRow Row in TOData.Rows)
{
Consumables cons = autofacConfig.consumablesService.GetConsById(Row.CID);
WareHouse Location = autofacConfig.wareHouseService.GetByWareID(Row.SLID);
if (Row.STATUS == 0)
{
tableAssets.Rows.Add(Row.TOROWID, Row.SLID, Location.NAME, Row.CID, cons.NAME, Row.IMAGE, Row.INTRANSFERQTY);
}
}
if (tableAssets.Rows.Count > 0)
{
ListAssets.DataSource = tableAssets;
ListAssets.DataBind();
}
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 数据加载
/// </summary>
public void Bind()
{
try
{
foreach (ConsumablesOrderRow data in RowData)
{
foreach (ListViewRow row in ListCons.Rows)
{
frmOrderCreateLayout Layout = row.Control as frmOrderCreateLayout;
string[] LCData = Layout.lblLocation.BindDataValue.ToString().Split('/');
string cId = Layout.lblName.BindDataValue.ToString();
if (data.CID == cId && data.WAREID == LCData[0] &&
data.STID == LCData[1] && data.SLID == LCData[2])
{
data.QTY = (Decimal)Layout.numNumber.Value;
}
}
}
DataTable tableAssets = new DataTable(); //未开启SN的资产列表
tableAssets.Columns.Add("CID"); //资产编号
tableAssets.Columns.Add("NAME"); //资产名称
tableAssets.Columns.Add("LOCID"); // 仓库/存储类型/库位
tableAssets.Columns.Add("LOCNAME"); // 仓库名称/类型名称/库位名称
tableAssets.Columns.Add("IMAGE"); //图片编号
tableAssets.Columns.Add("QUANTITY"); //空闲数量
tableAssets.Columns.Add("SELECTQTY"); //选择数量
if (RowData.Count > 0)
{
foreach (ConsumablesOrderRow Row in RowData)
{
ConQuant conQuant = autofacConfig.orderCommonService.GetUnUseConByCID(Row.CID, Row.WAREID, Row.STID, Row.SLID);
Consumables con = autofacConfig.consumablesService.GetConsById(Row.CID);
WHStorageLocationOutputDto WHLoc = autofacConfig.wareHouseService.GetSLByID(Row.WAREID, Row.STID, Row.SLID);
tableAssets.Rows.Add(Row.CID, con.NAME, Row.WAREID + "/" + Row.STID + "/" + Row.SLID, WHLoc.WARENAME + "/" + WHLoc.STNAME + "/" + WHLoc.SLNAME, con.IMAGE, conQuant.QUANTITY, Row.QTY);
}
}
ListCons.DataSource = tableAssets;
ListCons.DataBind();
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 扫描到库位时
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bcScanForSLID_BarcodeScanned(object sender, BarcodeResultArgs e)
{
try
{
string barCode = e.Value;
string WareId = "";
string STID = "";
string SLID = "";
string[] Ids = barCode.Split('/');
WareId = Ids[0];
if (Ids.Length == 3)
{
STID = Ids[1];
SLID = Ids[2];
}
else
{
throw new Exception("该库位编号不存在！");
}
if (_autofacConfig.wareHouseService.SLIsExists(WareId, STID, SLID))
{
WHStorageLocationOutputDto whLoc = _autofacConfig.wareHouseService.GetSLByID(WareId, STID, SLID);
if (whLoc == null)
{
throw new Exception("库位不存在，请检查!");
}
txtSLID.Text = whLoc.WARENAME + "/" + whLoc.STNAME + "/" + whLoc.SLNAME;
txtSLID.Tag = barCode;
}
else
{
throw new Exception("该库位编号不存在！");
}
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 数据绑定
/// </summary>
/// <param name="Name"></param>
public void Bind(String Name)
{
try
{
DataTable tableAssets = new DataTable(); //未开启SN的资产列表
tableAssets.Columns.Add("CHECK"); //资产编号
tableAssets.Columns.Add("CID"); //耗材编号
tableAssets.Columns.Add("NAME"); //资产名称
tableAssets.Columns.Add("LOCID"); // 仓库/存储类型/库位
tableAssets.Columns.Add("LOCNAME"); // 仓库名称/类型名称/库位名称
tableAssets.Columns.Add("IMAGE"); //图片编号
tableAssets.Columns.Add("QUANTITY"); //空闲数量
tableAssets.Columns.Add("SELECTQTY"); //选择数量
string[] LCData = LocInID.Split('/');
List <ConQuantOutputDto> listAss = new List <ConQuantOutputDto>();
if (String.IsNullOrEmpty(Name)) //查询所有耗材
{
listAss = autofacConfig.orderCommonService.GetUnUseCon(LCData[0], LCData[1], LCData[2], null);
}
else
{
List <Consumables> cons = autofacConfig.consumablesService.GetConsByName(Name);
foreach (Consumables con in cons)
{
List <ConQuantOutputDto> list = autofacConfig.orderCommonService.GetUnUseCon(LCData[0], LCData[1], LCData[2], con.CID);
listAss.AddRange(list);
}
}
foreach (ConQuantOutputDto Row in listAss)
{
Consumables cons = autofacConfig.consumablesService.GetConsById(Row.CID);
WHStorageLocationOutputDto WHLoc = autofacConfig.wareHouseService.GetSLByID(Row.WAREID, Row.STID, Row.SLID);
if (RowData.Count > 0)
{
Boolean isAdd = false;
foreach (ConsumablesOrderRow HaveRow in RowData)
{
if (HaveRow.CID == Row.CID && HaveRow.WAREID == Row.WAREID &&
HaveRow.STID == Row.STID && HaveRow.SLID == Row.SLID)
{
tableAssets.Rows.Add(true, Row.CID, cons.NAME, Row.WAREID + "/" + Row.STID + "/" + Row.SLID, Row.WARENAME + "/" + Row.STNAME + "/" + Row.SLNAME, cons.IMAGE, Row.QUANTITY, HaveRow.QTY);
isAdd = true;
break;
}
}
if (isAdd == false)
{
tableAssets.Rows.Add(false, Row.CID, cons.NAME, Row.WAREID + "/" + Row.STID + "/" + Row.SLID, Row.WARENAME + "/" + Row.STNAME + "/" + Row.SLNAME, cons.IMAGE, Row.QUANTITY, 0);
}
}
else
{
tableAssets.Rows.Add(false, Row.CID, cons.NAME, Row.WAREID + "/" + Row.STID + "/" + Row.SLID, Row.WARENAME + "/" + Row.STNAME + "/" + Row.SLNAME, cons.IMAGE, Row.QUANTITY, 0);
}
}
if (tableAssets.Rows.Count > 0)
{
ListCons.DataSource = tableAssets;
ListCons.DataBind();
}
}
catch (Exception ex)
{
Toast(ex.Message);
}
}
/// <summary>
/// 盘点耗材，刷新界面
/// </summary>
/// <param name="CID"></param>
/// <param name="RealNumber"></param>
public void AddConToDictionary(string CID, Decimal RealAmount)
{
WHStorageLocationOutputDto locOutputData = _autofacConfig.wareHouseService.GetSLByID(locData[0], locData[1], locData[2]);
String locId = locData[0] + "/" + locData[1] + "/" + locData[2];
String locName = locOutputData.WARENAME + "/" + locOutputData.STNAME + "/" + locOutputData.SLNAME;
String dictionaryKey = CID + "/" + locData[0] + "/" + locData[1] + "/" + locData[2];
if (conList.Contains(dictionaryKey))
{
//如果本来是需要盘点的，状态改为已盘点
conDictionary[dictionaryKey][0] = RealAmount;
object[] keys = new object[2];
keys[0] = CID;
keys[1] = locData[0] + "/" + locData[1] + "/" + locData[2];
//如果待盘点的datatable存在该资产，从待盘点中删除，并加入到已盘点datatable
DataRow row = waiTable.Rows.Find(keys);
if (row != null)
{
DataRow alreadyRow = alreadyTable.NewRow();
alreadyRow["CID"] = row["CID"].ToString();
alreadyRow["LOCID"] = locId;
alreadyRow["LOCNAME"] = locName;
alreadyRow["Image"] = row["Image"].ToString();
alreadyRow["Name"] = row["Name"].ToString();
alreadyRow["Total"] = row["Total"].ToString();
alreadyRow["RealAmount"] = RealAmount;
if (Convert.ToDecimal(row["Total"]) < RealAmount)
{
alreadyRow["RESULTNAME"] = "盘盈";
conDictionary[dictionaryKey][1] = (int)ResultStatus.盘盈;
}
else if (Convert.ToDecimal(alreadyRow["Total"]) > RealAmount)
{
alreadyRow["RESULTNAME"] = "盘亏";
conDictionary[dictionaryKey][1] = (int)ResultStatus.盘亏;
}
else
{
alreadyRow["RESULTNAME"] = "存在";
conDictionary[dictionaryKey][1] = (int)ResultStatus.存在;
}
alreadyTable.Rows.Add(alreadyRow);
waiTable.Rows.Remove(row);
}
else
{
if (conDictionary[dictionaryKey][1] != (int)ResultStatus.盘盈)
{
DataRow Arow = alreadyTable.Rows.Find(keys);
if (Convert.ToDecimal(Arow["Total"]) < RealAmount)
{
conDictionary[dictionaryKey][1] = (int)ResultStatus.盘盈;
Arow["RealAmount"] = RealAmount;
Arow["RESULTNAME"] = "盘盈";
}
else if (Convert.ToDecimal(Arow["Total"]) > RealAmount)
{
conDictionary[dictionaryKey][1] = (int)ResultStatus.盘亏;
Arow["RealAmount"] = RealAmount;
Arow["RESULTNAME"] = "盘亏";
}
else
{
conDictionary[dictionaryKey][1] = (int)ResultStatus.存在;
Arow["RealAmount"] = RealAmount;
Arow["RESULTNAME"] = "";
}
}
else
{
DataRow Arow = alreadyTable.Rows.Find(keys);
if (Convert.ToDecimal(Arow["Total"]) < RealAmount)
{
Arow["RealAmount"] = RealAmount;
}
else if (Convert.ToDecimal(Arow["Total"]) >= RealAmount)
{
if (Convert.ToDecimal(Arow["Total"]) > RealAmount)
{
conDictionary[dictionaryKey][1] = (int)ResultStatus.盘亏;
Arow["RESULTNAME"] = "盘亏";
}
else
{
conDictionary[dictionaryKey][1] = (int)ResultStatus.存在;
Arow["RESULTNAME"] = "";
}
}
}
}
}
else
{
//如果本来是不需要盘点的，状态改为盘盈
if (!conDictionary.ContainsKey(dictionaryKey))
{
List <decimal> list = new List <decimal>();
list.Add(RealAmount);
list.Add(Convert.ToDecimal((int)ResultStatus.盘盈));
conDictionary.Add(dictionaryKey, list);
}
DataRow row = alreadyTable.Rows.Find(CID);
if (row == null)
{
var con = _autofacConfig.consumablesService.GetConsById(CID);
DataRow moreRow = alreadyTable.NewRow();
moreRow["CID"] = con.CID;
moreRow["LOCID"] = locId;
moreRow["LOCNAME"] = locName;
moreRow["RESULTNAME"] = "盘盈";
moreRow["Image"] = con.IMAGE;
moreRow["Name"] = con.NAME;
moreRow["Total"] = 0;
moreRow["RealAmount"] = RealAmount;
alreadyTable.Rows.Add(moreRow);
}
else
{
row["RealAmount"] = RealAmount;
}
}
Bind();
}
