baseinfo.cs.bak

企业进销存管理系统,C#版

using System;
using System.Collections.Generic;
using System.Text;
//引用类库
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Runtime.InteropServices;

namespace EMS.BaseClass
{
    class BaseInfo
    {
        //[DllImport("shell32")]
        //public static extern long ShellExecute()
        ////(ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
        //public static extern long 
        //[DllImport("NETAPI32")]
        //public static extern long NetMessageBufferSend(string Server, byte[] yToName, byte[] yFromName, byte[] yMsg, int lSize);

        DataBase data = new DataBase();

        #region 添加--往来单位信息
        /// <summary>
        /// 添加往来单位
        /// </summary>
        /// <param name="client"></param>
        /// <returns>返回往来单位id</returns>
        public int AddUnits(cUnitsInfo units)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@unitcode",  SqlDbType.VarChar, 5, units.UnitCode),
                						data.MakeInParam("@fullname",  SqlDbType.VarChar, 30, units.FullName),
                						data.MakeInParam("@tax",  SqlDbType.VarChar, 30, units.Tax),
                						data.MakeInParam("@tel",  SqlDbType.VarChar, 20, units.Tel),
                						data.MakeInParam("@linkman",  SqlDbType.VarChar, 10, units.LinkMan),
                						data.MakeInParam("@address",  SqlDbType.VarChar, 60, units.Address),
                						data.MakeInParam("@accounts",  SqlDbType.VarChar, 80, units.Accounts),
										
			};
            return (data.RunProc("INSERT INTO tb_units (unitcode, fullname, tax, tel, linkman, address, accounts) VALUES (@unitcode,@fullname,@tax,@tel,@linkman,@address,@accounts)", prams));
        }
        #endregion 

        #region 修改--往来单位信息
        /// <summary>
        /// 修改往来单位信息
        /// </summary>
        /// <param name="units"></param>
        /// <returns></returns>
        public int UpdateUnits(cUnitsInfo units)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@unitcode",  SqlDbType.VarChar, 5, units.UnitCode),
                						data.MakeInParam("@fullname",  SqlDbType.VarChar, 30, units.FullName),
                						data.MakeInParam("@tax",  SqlDbType.VarChar, 30, units.Tax),
                						data.MakeInParam("@tel",  SqlDbType.VarChar, 20, units.Tel),
                						data.MakeInParam("@linkman",  SqlDbType.VarChar, 10, units.LinkMan),
                						data.MakeInParam("@address",  SqlDbType.VarChar, 60, units.Address),
                						data.MakeInParam("@accounts",  SqlDbType.VarChar, 80, units.Accounts),
			};
            return (data.RunProc("update tb_units set fullname=@fullname,tax=@tax,tel=@tel,linkman=@linkman,address=@address,accounts=@accounts where unitcode=@unitcode", prams));
        }
        #endregion

        #region 删除--往来单位信息
        /// <summary>
        /// 删除往来单位
        /// </summary>
        /// <param name="client"></param>
        /// <returns>返回往来单位id</returns>
        public int DeleteUnits(cUnitsInfo units)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@unitcode",  SqlDbType.VarChar, 5, units.UnitCode),
			};
            return (data.RunProc("delete from tb_units where unitcode=@unitcode", prams));
        }
        #endregion 

        #region 查询--往来单位信息
        /// <summary>
        /// 根据--单位编号--得到往来单位信息
        /// </summary>
        /// <param name="units"></param>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet FindUnitsByUnitCode(cUnitsInfo units,string tbName)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@unitcode",  SqlDbType.VarChar, 5, units.UnitCode+"%"),
			};
            return (data.RunProcReturn("select * from tb_units where unitcode like @unitcode", prams, tbName));
        }
        /// <summary>
        /// 根据--单位名称--得到往来单位信息
        /// </summary>
        /// <param name="units"></param>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet FindUnitsByFullName(cUnitsInfo units, string tbName)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@fullname",  SqlDbType.VarChar, 30, units.FullName+"%"),
			};
            return (data.RunProcReturn("select * from tb_units where fullname like @fullname", prams, tbName));
        }
        /// <summary>
        /// 得到所有--往来单位信息
        /// </summary>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet GetAllUnits(string tbName)
        {
            return (data.RunProcReturn("select * from tb_units ORDER BY unitcode", tbName));
        }
        #endregion


        #region 添加--库存商品信息
        /// <summary>
        /// 添加库存商品基本信息
        /// </summary>
        /// <param name="stock">库存商品数据结构类对象</param>
        /// <returns></returns>
        public int AddStock(cStockInfo stock)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@tradecode",  SqlDbType.VarChar, 5, stock.TradeCode),
                						data.MakeInParam("@fullname",  SqlDbType.VarChar, 30,stock.FullName),
                						data.MakeInParam("@type",  SqlDbType.VarChar, 10, stock.TradeType),
                						data.MakeInParam("@standard",  SqlDbType.VarChar, 10, stock.Standard),
                						data.MakeInParam("@unit",  SqlDbType.VarChar, 4, stock.Unit),
                						data.MakeInParam("@produce",  SqlDbType.VarChar, 20, stock.Produce),
			};
            return (data.RunProc("INSERT INTO tb_stock (tradecode, fullname, type, standard, unit, produce) VALUES (@tradecode,@fullname,@type,@standard,@unit,@produce)", prams));
        }
        #endregion

        #region 修改--库存商品信息
        /// <summary>
        /// 修改库存商品信息
        /// </summary>
        /// <param name="stock">库存商品数据结构类对象</param>
        /// <returns></returns>
        public int UpdateStock(cStockInfo stock)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@tradecode",  SqlDbType.VarChar, 5, stock.TradeCode),
                						data.MakeInParam("@fullname",  SqlDbType.VarChar, 30,stock.FullName),
                						data.MakeInParam("@type",  SqlDbType.VarChar, 10, stock.TradeType),
                						data.MakeInParam("@standard",  SqlDbType.VarChar, 10, stock.Standard),
                						data.MakeInParam("@unit",  SqlDbType.VarChar, 4, stock.Unit),
                						data.MakeInParam("@produce",  SqlDbType.VarChar, 20, stock.Produce),
			};
            return (data.RunProc("update tb_stock set fullname=@fullname,type=@type,standard=@standard,unit=@unit,produce=@produce where tradecode=@tradecode", prams));
        }
        #endregion

        #region 删除--库存商品信息
        /// <summary>
        /// 删除库存商品信息
        /// </summary>
        /// <param name="stock">库存商品数据结构类对象</param>
        /// <returns></returns>
        public int DeleteStock(cStockInfo stock)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@tradecode",  SqlDbType.VarChar, 5, stock.TradeCode),
			};
            return (data.RunProc("delete from tb_stock where tradecode=@tradecode", prams));
        }
        #endregion

        #region 查询--往来单位信息
        /// <summary>
        /// 根据--商品产地--得到库存商品信息
        /// </summary>
        /// <param name="stock">库存商品数据结构类对象</param>
        /// <param name="tbName">映射原表名称</param>
        /// <returns></returns>
        public DataSet FindStockByProduce(cStockInfo stock, string tbName)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@produce",  SqlDbType.VarChar, 5, stock.Produce+"%"),
			};
            return (data.RunProcReturn("select * from tb_stock where produce like @produce", prams, tbName));
        }
        /// <summary>
        /// 根据--商品名称--得到库存商品信息
        /// </summary>
        /// <param name="units"></param>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet FindStockByFullName(cStockInfo stock, string tbName)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@fullname",  SqlDbType.VarChar, 30, stock.FullName+"%"),
			};
            return (data.RunProcReturn("select * from tb_stock where fullname like @fullname", prams, tbName));
        }
        /// <summary>
        /// 得到所有--库存商品信息
        /// </summary>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet GetAllStock(string tbName)
        {
            return (data.RunProcReturn("select * from tb_Stock ORDER BY tradecode", tbName));
        }
        #endregion


        #region 添加--公司职员信息
        /// <summary>
        /// 添加--公司职员--信息
        /// </summary>
        /// <param name="client"></param>
        /// <returns></returns>
        public int AddEmployee(cEmployeeInfo employee)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@employeecode",  SqlDbType.VarChar, 5, employee.EmployeeCode),
                						data.MakeInParam("@fullname",  SqlDbType.VarChar, 20,employee.FullName),
                						data.MakeInParam("@sex",  SqlDbType.VarChar, 4, employee.Sex),
                						data.MakeInParam("@dept",  SqlDbType.VarChar, 20, employee.Dept),
                						data.MakeInParam("@tel",  SqlDbType.VarChar, 20, employee.Tel),
                						data.MakeInParam("@memo",  SqlDbType.VarChar, 20, employee.Memo),
			};
            return (data.RunProc("INSERT INTO tb_Employee (employeecode, fullname, sex, dept, tel, memo) VALUES (@employeecode,@fullname,@sex,@dept,@tel,@memo)", prams));
        }
        #endregion

        #region 修改--公司职员信息
        /// <summary>
        /// 修改--公司职员--信息
        /// </summary>
        /// <param name="units"></param>
        /// <returns></returns>
        public int UpdateEmployee(cEmployeeInfo employee)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@employeecode",  SqlDbType.VarChar, 5, employee.EmployeeCode),
                						data.MakeInParam("@fullname",  SqlDbType.VarChar, 20,employee.FullName),
                						data.MakeInParam("@sex",  SqlDbType.VarChar, 4, employee.Sex),
                						data.MakeInParam("@dept",  SqlDbType.VarChar, 20, employee.Dept),
                						data.MakeInParam("@tel",  SqlDbType.VarChar, 20, employee.Tel),
                						data.MakeInParam("@memo",  SqlDbType.VarChar, 20, employee.Memo),
			};
            return (data.RunProc("update tb_Employee set fullname=@fullname,sex=@sex,dept=@dept,tel=@tel,memo=@memo where employeecode=@employeecode", prams));
        }
        #endregion

        #region 删除--公司职员信息
        /// <summary>
        /// 删除--公司职员--信息
        /// </summary>
        /// <param name="client"></param>
        /// <returns></returns>
        public int DeleteEmployee(cEmployeeInfo employee)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@employeecode",  SqlDbType.VarChar, 5, employee.EmployeeCode),
			};
            return (data.RunProc("delete from tb_employee where employeecode=@employeecode", prams));
        }
        #endregion

        #region 查询--公司职员信息
        /// <summary>
        /// 根据--职员所在部门--得到公司职员信息
        /// </summary>
        /// <param name="units"></param>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet FindEmployeeByDept(cEmployeeInfo employee, string tbName)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@dept",  SqlDbType.VarChar, 20, employee.Dept+"%"),
			};
            return (data.RunProcReturn("select * from tb_employee where dept like @dept", prams, tbName));
        }
        /// <summary>
        /// 根据--职员姓名--得到公司职员信息
        /// </summary>
        /// <param name="units"></param>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet FindEmployeeByFullName(cEmployeeInfo employee, string tbName)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@fullname",  SqlDbType.VarChar, 20, employee.FullName+"%"),
			};
            return (data.RunProcReturn("select * from tb_employee where fullname like @fullname", prams, tbName));
        }
        /// <summary>
        /// 得到所有--公司职员信息
        /// </summary>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet GetAllEmployee(string tbName)
        {
            return (data.RunProcReturn("select * from tb_Employee ORDER BY employeecode", tbName));
        }
        #endregion


        #region 商品进销存---单据过账

        /// <summary>
        /// 得到所有tbName表中信息－－主要用来：得到最大的单据编号然后自动编号
        /// </summary>
        /// <param name="tbName">数据表名称</param>
        /// <returns></returns>
        public DataSet GetAllBill(string tbName_trueName)
        { 
            return(data.RunProcReturn("select * from "+tbName_trueName+"",tbName_trueName));