Example #1
0
 /// <summary>
 /// 添加仓库
 /// </summary>
 /// <param name="warecode">仓库编码</param>
 /// <param name="name">名称</param>
 /// <param name="shortname">简称</param>
 /// <param name="citycode">所在地区编码</param>
 /// <param name="status">状态</param>
 /// <param name="description">描述</param>
 /// <param name="operateid">操作人</param>
 /// <param name="clientid">客户端ID</param>
 /// <returns></returns>
 public string AddWareHouse(string warecode, string name, string shortname, string citycode, int status, string description, string operateid, string clientid)
 {
     var id = Guid.NewGuid().ToString();
     var dal = new WarehouseDAL();
     if (dal.AddWareHouse(id, warecode, name, shortname, citycode, status, description, operateid, clientid))
     {
         return id.ToString();
     }
     return string.Empty;
 }
Example #2
0
 /// <summary>
 /// 添加库别
 /// </summary>
 /// <param name="name">库别名称</param>
 /// <param name="description">描述</param>
 /// <param name="operateid">操作人</param>
 /// <param name="clientid">客户端ID</param>
 /// <returns></returns>
 public string AddWarehouseType(string name, string description, string operateid, string clientid)
 {
     var id = Guid.NewGuid().ToString();
     var dal = new WarehouseDAL();
     if (dal.AddWarehouseType(id, name, description, operateid, clientid))
     {
         return id.ToString();
     }
     return string.Empty;
 }
Example #3
0
 /// <summary>
 /// 添加货位
 /// </summary>
 /// <param name="depotcode">货位编码</param>
 /// <param name="wareid">仓库ID</param>
 /// <param name="name">名称</param>
 /// <param name="status">状态</param>
 /// <param name="description">描述</param>
 /// <param name="operateid"></param>
 /// <param name="clientid"></param>
 /// <returns></returns>
 public string AddDepotSeat(string depotcode, string wareid, string name, int status, string description, string operateid, string clientid)
 {
     var id = Guid.NewGuid().ToString();
     var dal = new WarehouseDAL();
     if (dal.AddDepotSeat(id, depotcode, wareid, name, status, description, operateid, clientid))
     {
         return id.ToString();
     }
     return string.Empty;
 }
Example #4
0
 /// <summary>
 /// 编辑库别
 /// </summary>
 /// <param name="id">库别ID</param>
 /// <param name="name">库别名称</param>
 /// <param name="description">描述</param>
 /// <param name="operateid">操作人</param>
 /// <param name="clientid">客户端ID</param>
 /// <returns></returns>
 public bool UpdateWarehouseType(string id, string name, string description, string operateid, string clientid)
 {
     var dal = new WarehouseDAL();
     return dal.UpdateWarehouseType(id, name, description);
 }
Example #5
0
 /// <summary>
 /// 编辑货位
 /// </summary>
 /// <param name="id">ID</param>
 /// <param name="name">名称</param>
 /// <param name="status">状态</param>
 /// <param name="description">描述</param>
 /// <param name="operateid"></param>
 /// <param name="clientid"></param>
 /// <returns></returns>
 public bool UpdateDepotSeat(string id, string name, int status, string description, string operateid, string clientid)
 {
     var dal = new WarehouseDAL();
     return dal.UpdateDepotSeat(id, name, status, description);
 }
Example #6
0
 /// <summary>
 /// 编辑仓库
 /// </summary>
 /// <param name="id">仓库ID</param>
 /// <param name="name">名称</param>
 /// <param name="shortname">简称</param>
 /// <param name="citycode">地区编码</param>
 /// <param name="status">状态</param>
 /// <param name="description">描述</param>
 /// <param name="operateid">操作人</param>
 /// <param name="clientid">客户端ID</param>
 /// <returns></returns>
 public bool UpdateWareHouse(string id, string name, string shortname, string citycode, int status, string description, string operateid, string clientid)
 {
     var dal = new WarehouseDAL();
     return dal.UpdateWareHouse(id, name, shortname, citycode, status, description);
 }
Example #7
0
        /// <summary>
        /// 获取所有仓库(ID和Name)
        /// </summary>
        /// <param name="clientID"></param>
        /// <returns></returns>
        public List<WareHouse> GetWareHouses(string clientID)
        {
            var dal = new WarehouseDAL();
            DataTable dt = dal.GetWareHouses(clientID);

            List<WareHouse> list = new List<WareHouse>();
            foreach (DataRow dr in dt.Rows)
            {
                WareHouse model = new WareHouse();
                model.FillData(dr);
                list.Add(model);
            }
            return list;
        }
Example #8
0
 /// <summary>
 /// 获取库别列表
 /// </summary>
 /// <param name="clientid"></param>
 /// <returns></returns>
 public List<WareHouseType> GetWarehouseTypes(string clientid)
 {
     var dal = new WarehouseDAL();
     DataTable dt = dal.GetWarehouseTypes(clientid);
     List<WareHouseType> list = new List<WareHouseType>();
     foreach (DataRow item in dt.Rows)
     {
         WareHouseType model = new WareHouseType();
         model.FillData(item);
         list.Add(model);
     }
     return list;
 }
Example #9
0
        /// <summary>
        /// 获取仓库列表
        /// </summary>
        /// <param name="keyWords">关键词</param>
        /// <param name="pageSize">每页条数</param>
        /// <param name="pageIndex">页码</param>
        /// <param name="totalCount">总记录数</param>
        /// <param name="pageCount">总页数</param>
        /// <param name="clientID">客户端ID</param>
        /// <returns></returns>
        public List<WareHouse> GetWareHouses(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
        {
            var dal = new WarehouseDAL();
            DataSet ds = dal.GetWareHouses(keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID);

            List<WareHouse> list = new List<WareHouse>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                WareHouse model = new WareHouse();
                model.FillData(dr);
                model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
                list.Add(model);
            }
            return list;
        }
Example #10
0
        /// <summary>
        /// 根据ID获取仓库详情
        /// </summary>
        /// <param name="wareid"></param>
        /// <returns></returns>
        public WareHouse GetWareByID(string wareid)
        {
            var dal = new WarehouseDAL();
            DataTable dt = dal.GetWareByID(wareid);

            WareHouse model = new WareHouse();
            if (dt.Rows.Count > 0)
            {
                model.FillData(dt.Rows[0]);
                model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
            }
            return model;
        }
Example #11
0
        /// <summary>
        /// 根据仓库ID获取货位
        /// </summary>
        /// <param name="wareid"></param>
        /// <param name="clientid"></param>
        /// <returns></returns>
        public List<DepotSeat> GetDepotSeatsByWareID(string wareid, string clientid)
        {
            var dal = new WarehouseDAL();
            DataTable dt = dal.GetDepotSeatsByWareID(wareid);

            List<DepotSeat> list = new List<DepotSeat>();
            foreach (DataRow dr in dt.Rows)
            {
                DepotSeat model = new DepotSeat();
                model.FillData(dr);
                list.Add(model);
            }
            return list;
        }
Example #12
0
        /// <summary>
        /// 获取货位列表
        /// </summary>
        /// <param name="keyWords">关键词</param>
        /// <param name="pageSize">每页条数</param>
        /// <param name="pageIndex">页码</param>
        /// <param name="totalCount">总记录数</param>
        /// <param name="pageCount">总页数</param>
        /// <param name="clientID">客户端ID</param>
        /// <returns></returns>
        public List<DepotSeat> GetDepotSeats(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID, string wareid = "")
        {
            var dal = new WarehouseDAL();
            DataSet ds = dal.GetDepotSeats(keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID, wareid);

            List<DepotSeat> list = new List<DepotSeat>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                DepotSeat model = new DepotSeat();
                model.FillData(dr);
                list.Add(model);
            }
            return list;
        }
Example #13
0
        /// <summary>
        /// 获取货位详情
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public DepotSeat GetDepotByID(string depotid)
        {
            var dal = new WarehouseDAL();
            DataTable dt = dal.GetDepotByID(depotid);

            DepotSeat model = new DepotSeat();
            if (dt.Rows.Count > 0)
            {
                model.FillData(dt.Rows[0]);
            }
            return model;
        }