Пример #1
0
 private void lbCategories_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     if (e.AddedItems.Count != 0)
     {
         tbEditZone.SelectedIndex = 1;
         updateCategory           = (e.AddedItems[0] as Warehouse_Category).Clone();
         (tbEditZone.Items[tbEditZone.Items.Count - 1] as TabItem).DataContext = updateCategory;
     }
 }
Пример #2
0
        /// <summary>
        /// 修改货品类别
        /// </summary>
        /// <param name="Category">需修改货品类别</param>
        public int UpdateCategory(Warehouse_Category Category)
        {
            string cmdText = @"UPDATE [EasySystem].[dbo].[Warehosue_Categories]
   SET [CategoryName] = @CategoryName
      ,[ParentID] = @ParentID
 WHERE [CategoryID] = @CategoryID";

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@CategoryName", Category.CategoryName),
                new SqlParameter("@ParentID", Category.ParentID),
                new SqlParameter("@CategoryID", Category.CategoryID)
            };
            return(DBHelper.ExecuteNonQuery(cmdText, parameters, CommandType.Text));
        }
Пример #3
0
        /// <summary>
        /// 新增货品类别
        /// </summary>
        /// <param name="Category">待新增货品类别</param>
        public int AddCategory(Warehouse_Category Category)
        {
            int    result  = 0;
            string cmdText = @"PROC_AddCategory";

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@CategoryName", Category.CategoryName),
                new SqlParameter("@ParentID", Category.ParentID),
                new SqlParameter("@Result", DbType.Int32)
            };
            parameters[2].Direction = ParameterDirection.Output;
            DBHelper.ExecuteNonQuery(cmdText, parameters, CommandType.StoredProcedure);
            if (parameters[2].Value != null)
            {
                Category.CategoryID = Convert.ToInt32(parameters[2].Value);
                return(1);
            }
            return(-1);
        }
Пример #4
0
        /// <summary>
        /// 获取货品类别列表
        /// </summary>
        public List <Warehouse_Category> GetCategories()
        {
            List <Warehouse_Category> Categories = null;
            string cmdText = "SELECT * FROM View_Warehouse_Categories";

            using (SqlDataReader reader = DBHelper.ExecuteReader(cmdText, CommandType.Text))
            {
                if (reader.HasRows)
                {
                    Categories = new List <Warehouse_Category>();
                    while (reader.Read())
                    {
                        Warehouse_Category Category = new Warehouse_Category()
                        {
                            CategoryID   = Convert.ToInt32(reader["CategoryID"]),
                            CategoryName = reader["CategoryName"] as string,
                            ParentID     = reader["ParentID"] is DBNull ? -1 : Convert.ToInt32(reader["ParentID"])
                        };
                        Categories.Add(Category);
                    }
                }
            }
            return(Categories);
        }