/// <summary> /// 通过库房名称及货位查找货位 /// </summary> /// <param name="storeHouse"></param> /// <param name="goodSiteName"></param> /// <returns></returns> public List <StockListModel> GetStockList(EnumStoreHouse storeHouse, string goodSiteName) { string whereStr = "StoreHouseName = '" + storeHouse.ToString() + "' and GoodsSiteName='" + goodSiteName + "'"; List <StockListModel> stockModelList = GetModelList(whereStr); return(stockModelList); }
public GoodsSiteModel GetGoodsSiteByGSName(EnumStoreHouse storeHouse, string gsName) { int storeAreaID = 0; if (storeHouse == EnumStoreHouse.A1库房) { storeAreaID = 2; } else if (storeHouse == EnumStoreHouse.B1库房) { storeAreaID = 4; } string whereStr = "GoodsSiteName = '" + gsName + "' and StoreAreaID = " + storeAreaID; List <GoodsSiteModel> goodsSiteList = GetModelList(whereStr); if (goodsSiteList != null && goodsSiteList.Count > 0) { return(goodsSiteList[0]); } else { return(null); } }
private void OnLoadStorageData(EnumStoreHouse enumStoreHouse, int rowth) { if (this.eventLoadStorageData != null) { StorageEventArgs storeArgs = new StorageEventArgs(); storeArgs.StoreHouse = enumStoreHouse; storeArgs.Rowth = rowth; this.eventLoadStorageData.Invoke(this, storeArgs); } }
private StoreHouseProper GetHousePro(EnumStoreHouse enumHouseName) { StoreHouseProper housePro = null; for (int i = 0; i < houseProList.Count(); i++) { if (houseProList[i].HouseName == enumHouseName) { housePro = houseProList[i]; } } return(housePro); }
/// <summary> /// 通过库房名称及货位查找货位 /// </summary> /// <param name="storeHouse"></param> /// <param name="goodSiteName"></param> /// <returns></returns> public StockListModel GetStockListModel(EnumStoreHouse storeHouse, string goodSiteName) { string whereStr = "StoreHouseName = '" + storeHouse.ToString() + "' and GoodsSiteName='" + goodSiteName + "'"; List <StockListModel> stockModelList = GetModelList(whereStr); if (stockModelList.Count > 0) { return(stockModelList[0]); } else { return(null); } }
public DataTable GetStatusNum(EnumStoreHouse storeHouse, int rowth) { int storeAreaID = 2; if (storeHouse == EnumStoreHouse.A1库房) { storeAreaID = 2; } else if (storeHouse == EnumStoreHouse.B1库房) { storeAreaID = 4; } return(dal.GetStatusNum(storeAreaID, rowth)); }
public GoodsSiteModel GetGoodsSite(EnumStoreHouse storeHouse, int rowth, int columnth, int layerth) { GoodsSiteModel goodsSite = null; string whereStr = ""; List <GoodsSiteModel> goodsSiteList = null; if (storeHouse == EnumStoreHouse.A1库房) { whereStr = "GoodsSiteRow = " + rowth + " and GoodsSiteColumn = " + columnth + " and GoodsSiteLayer =" + layerth + " and LogicStoreAreaID = 4 and GoodsSiteRunStatus != '" + EnumGSRunStatus.异常.ToString() + "'"; } else if (storeHouse == EnumStoreHouse.B1库房) { whereStr = "GoodsSiteRow = " + rowth + " and GoodsSiteColumn = " + columnth + " and GoodsSiteLayer =" + layerth + " and LogicStoreAreaID = 2 and GoodsSiteRunStatus != '" + EnumGSRunStatus.异常.ToString() + "'";; } goodsSiteList = GetModelList(whereStr); if (goodsSiteList.Count > 0) { goodsSite = goodsSiteList[0]; } return(goodsSite); }
/// <summary> /// 作者:np /// 时间:2014年8月29日 /// 内容:获取库存托盘列表 /// </summary> /// <param name="HouseName"></param> /// <param name="rowth"></param> /// <param name="columnth"></param> /// <param name="layerth"></param> /// <returns></returns> public List <string> GetStockTrayList(EnumStoreHouse HouseName, int rowth, int columnth, int layerth) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TrayID FROM View_StockListDetail"); strSql.Append(" where StoreHouseName = '" + HouseName + "' and GoodsSiteRow = " + rowth + " and GoodsSiteColumn=" + columnth + " and GoodsSiteLayer= " + layerth); DataSet ds = DbHelperSQL.Query(strSql.ToString()); List <string> trayList = new List <string>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { trayList.Add(ds.Tables[0].Rows[i][0].ToString()); } return(trayList); } else { return(null); } }
public GoodsSiteModel GetGoodsSiteByRCL(EnumStoreHouse StoreHouse, int rowth, int columnth, int layerth) { int storeAreaID = 0; if (StoreHouse == EnumStoreHouse.A1库房) { storeAreaID = 2; } else if (StoreHouse == EnumStoreHouse.B1库房) { storeAreaID = 4; } string whereStr = "StoreAreaID=" + storeAreaID + " and GoodsSiteRow=" + rowth + " and GoodsSiteColumn" + columnth + " and GoodsSiteLayer" + layerth; List <GoodsSiteModel> goodsSiteList = GetModelList(whereStr); if (goodsSiteList != null && goodsSiteList.Count > 0) { return(goodsSiteList[0]); } else { return(null); } }
/// <summary> /// 获取 /// </summary> /// <param name="storeHouse"></param> /// <param name="rowth"></param> /// <returns></returns> public DataTable GetGsData(EnumStoreHouse storeHouse, int rowth) { string whereStr = ""; if (storeHouse == EnumStoreHouse.A1库房) { whereStr += "StoreAreaID = 2 and GoodsSiteRow=" + rowth; } else if (storeHouse == EnumStoreHouse.B1库房) { whereStr += "StoreAreaID = 4 and GoodsSiteRow=" + rowth; } DataSet ds = GetList(whereStr); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds.Tables[0]); } else { return(null); } }
/// <summary> /// 作者:np /// 时间:2014年8月29日 /// 内容:获取托盘列表 /// </summary> /// <param name="HouseName"></param> /// <param name="rowth"></param> /// <param name="columnth"></param> /// <param name="layerth"></param> /// <returns></returns> public List <string> GetStockTrayList(EnumStoreHouse HouseName, int rowth, int columnth, int layerth) { return(dal.GetStockTrayList(HouseName, rowth, columnth, layerth)); }