dataoperate.cs

库存管理系统

            sqlcom.Parameters.Add("@HandlePeople", SqlDbType.VarChar, 20).Value = P_str_HPeople;
            sqlcom.Parameters.Add("@ISRemark", SqlDbType.VarChar, 1000).Value = P_str_Remark;
            SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
            returnValue.Direction = ParameterDirection.ReturnValue;
            sqlcon.Open();
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sqlcom.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
            }
            int P_int_returnValue = (int)returnValue.Value;
            return P_int_returnValue;
        }
        #endregion

        #region  添加供应商信息
        /// <summary>
        /// 添加供应商信息
        /// </summary>
        /// <param name="P_str_PrName">供应商名称</param>
        /// <param name="P_str_PrPeople">负责人</param>
        /// <param name="P_str_PrPhone">供应商联系电话</param>
        /// <param name="P_str_PrFax">供应商传真号码</param>
        /// <param name="P_int_PrRemark">备注</param>
        /// <returns>返回一个int类型的值</returns>
        public int InsertProvider(string P_str_PrName, string P_str_PrPeople, string P_str_PrPhone, string P_str_PrFax, string P_int_PrRemark)
        {
            SqlConnection sqlcon = datacon.getcon();
            SqlCommand sqlcom = new SqlCommand("proc_insertProvider", sqlcon);
            sqlcom.CommandType = CommandType.StoredProcedure;
            sqlcom.Parameters.Add("@PrName", SqlDbType.VarChar, 100).Value = P_str_PrName;
            sqlcom.Parameters.Add("@PrPeople", SqlDbType.VarChar, 20).Value = P_str_PrPeople;
            sqlcom.Parameters.Add("@PrPhone", SqlDbType.VarChar, 20).Value = P_str_PrPhone;
            sqlcom.Parameters.Add("@PrFax", SqlDbType.VarChar, 20).Value = P_str_PrFax;
            sqlcom.Parameters.Add("@PrRemark", SqlDbType.VarChar, 1000).Value = P_int_PrRemark;
            SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
            returnValue.Direction = ParameterDirection.ReturnValue;
            sqlcon.Open();
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sqlcom.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
            }
            int P_int_returnValue = (int)returnValue.Value;
            return P_int_returnValue;
        }
        #endregion

        #region  添加仓库信息
        /// <summary>
        /// 添加仓库信息
        /// </summary>
        /// <param name="P_str_StoreName">仓库名称</param>
        /// <param name="P_str_StorePeople">仓库负责人</param>
        /// <param name="P_str_StorePhone">仓库电话</param>
        /// <param name="P_str_StoreUnit">仓库所属单位</param>
        /// <param name="P_int_StoreRemark">备注</param>
        /// <returns>返回一个int类型的值</returns>
        public int InsertStorage(string P_str_StoreName, string P_str_StorePeople, string P_str_StorePhone, string P_str_StoreUnit, string P_int_StoreRemark)
        {
            SqlConnection sqlcon = datacon.getcon();
            SqlCommand sqlcom = new SqlCommand("proc_insertStorage", sqlcon);
            sqlcom.CommandType = CommandType.StoredProcedure;
            sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 100).Value = P_str_StoreName;
            sqlcom.Parameters.Add("@StorePeople", SqlDbType.VarChar, 20).Value = P_str_StorePeople;
            sqlcom.Parameters.Add("@StorePhone", SqlDbType.VarChar, 20).Value = P_str_StorePhone;
            sqlcom.Parameters.Add("@StoreUnit", SqlDbType.VarChar, 100).Value = P_str_StoreUnit;
            sqlcom.Parameters.Add("@StoreRemark", SqlDbType.VarChar, 1000).Value = P_int_StoreRemark;
            SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
            returnValue.Direction = ParameterDirection.ReturnValue;
            sqlcon.Open();
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sqlcom.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
            }
            int P_int_returnValue = (int)returnValue.Value;
            return P_int_returnValue;
        }
        #endregion

        #region  添加新用户
        /// <summary>
        /// 添加新用户
        /// </summary>
        /// <param name="P_str_UserName">用户名</param>
        /// <param name="P_str_UserPwd">用户密码</param>
        /// <param name="P_str_UserRight">用户权限</param>
        /// <returns>返回一个int类型的值</returns>
        public int InsertUser(string P_str_UserName, string P_str_UserPwd, string P_str_UserRight)
        {
            SqlConnection sqlcon = datacon.getcon();
            SqlCommand sqlcom = new SqlCommand("proc_insertUser",sqlcon);
            sqlcom.CommandType = CommandType.StoredProcedure;
            sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 20).Value = P_str_UserName;
            sqlcom.Parameters.Add("@UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;
            sqlcom.Parameters.Add("@UserRight", SqlDbType.Char, 10).Value = P_str_UserRight;
            SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
            returnValue.Direction = ParameterDirection.ReturnValue;
            sqlcon.Open();
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sqlcom.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
            }
            int P_int_returnValue = (int)returnValue.Value;
            return P_int_returnValue;
        }
        #endregion

        #region  盘点货物
        /// <summary>
        /// 盘点货物
        /// </summary>
        /// <param name="P_int_ISID">货物入库编号</param>
        /// <param name="P_str_SName">仓库名称</param>
        /// <param name="P_str_GName">货物名称</param>
        /// <param name="P_str_GUnit">计量单位</param>
        /// <param name="P_int_CKNum">盘点数量</param>
        /// <param name="P_int_PALNum">盈亏数量</param>
        /// <param name="P_str_CPeople">盘点人</param>
        /// <param name="P_str_Remark">备注</param>
        /// <returns>返回一个int类型的值</returns>
        public int InsertCheck(int P_int_GoodsID, string P_str_SName, string P_str_GName,
            string P_str_GUnit, int P_int_CKNum, int P_int_PALNum, string P_str_CPeople, string P_str_Remark)
        {
            SqlConnection sqlcon = datacon.getcon();
            SqlCommand sqlcom = new SqlCommand("proc_insertCheck", sqlcon);
            sqlcom.CommandType = CommandType.StoredProcedure;
            sqlcom.Parameters.Add("@GoodsID", SqlDbType.BigInt).Value = P_int_GoodsID;
            sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 100).Value = P_str_SName;
            sqlcom.Parameters.Add("@GoodsName", SqlDbType.VarChar, 50).Value = P_str_GName;
            sqlcom.Parameters.Add("@GoodsUnit", SqlDbType.Char, 8).Value = P_str_GUnit;
            sqlcom.Parameters.Add("@CheckNum", SqlDbType.BigInt).Value = P_int_CKNum;
            sqlcom.Parameters.Add("@PALNum", SqlDbType.BigInt).Value = P_int_PALNum;
            sqlcom.Parameters.Add("@CheckPeople", SqlDbType.VarChar, 20).Value = P_str_CPeople;
            sqlcom.Parameters.Add("@CheckRemark", SqlDbType.VarChar, 1000).Value = P_str_Remark;
            SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
            returnValue.Direction = ParameterDirection.ReturnValue;
            sqlcon.Open();
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sqlcom.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
            }
            int P_int_returnValue = (int)returnValue.Value;
            return P_int_returnValue;
        }
        #endregion

        #region  修改用户信息
        /// <summary>
        /// 修改用户信息
        /// </summary>
        /// <param name="P_int_UID">用户编号</param>
        /// <param name="P_str_UserPwd">用户密码</param>
        /// <param name="P_str_UserRight">用户权限</param>
        /// <returns>返回一个int类型的值</returns>
        public void updateUser(int P_int_UID,string P_str_UserPwd, string P_str_UserRight)
        {
            SqlConnection sqlcon = datacon.getcon();
            SqlCommand sqlcom = new SqlCommand("proc_updateUser", sqlcon);
            sqlcom.CommandType = CommandType.StoredProcedure;
            sqlcom.Parameters.Add("@UserID", SqlDbType.BigInt).Value = P_int_UID;
            sqlcom.Parameters.Add("@UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;
            sqlcom.Parameters.Add("@UserRight", SqlDbType.Char, 10).Value = P_str_UserRight;
            sqlcon.Open();
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sqlcom.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
            }
        }
        #endregion
    }
}