Esempio n. 1
0
        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);
        }
Esempio n. 2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(ECAMSDataAccess.GoodsSiteModel model)
 {
     return(dal.Update(model));
 }
Esempio n. 3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(ECAMSDataAccess.GoodsSiteModel model)
 {
     return(dal.Add(model));
 }