baseinfo.cs

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

        }
        #endregion


        #region 库存管理--库存状况
        /// <summary>
        /// 检索库存商品--并按数量排序
        /// </summary>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet setStockStatus(string tbName)
        {
            return (data.RunProcReturn("select * from tb_stock order by qty",tbName));
        }
        /// <summary>
        /// 根据商品编号，获得库存商品中所有信息
        /// </summary>
        /// <param name="tradeCode"></param>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet GetStockLimitByTradeCode(string tradeCode,string tbName)
        {
            return(data.RunProcReturn("select * from tb_Stock where tradecode='"+tradeCode+"'",tbName));
        }
       /// <summary>
       /// 库存商品上下限设置
       /// </summary>
       /// <param name="stock"></param>
       /// <returns></returns>
        public int UpdateStockLimit(cStockInfo stock)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@tradecode",  SqlDbType.VarChar,5,stock.TradeCode),
                						data.MakeInParam("@upperlimit",  SqlDbType.Float, 8, stock.UpperLimit),
                						data.MakeInParam("@lowerlimit",  SqlDbType.Float, 8, stock.LowerLimit),
            };
             return (data.RunProc("update tb_stock set upperlimit=@upperlimit,lowerlimit=@lowerlimit where tradecode=@tradecode", prams));
         }
        #endregion

        #region 库存商品上下限报警
         /// <summary>
        /// 库存商品下限报警
        /// </summary>
        /// <returns></returns>
        public DataSet GetLowerLimit()
        {
            return (data.RunProcReturn("SELECT tradecode as 商品编号, fullname as 商品名称, qty as 库存数量,upperlimit as 库存上限,lowerlimit as 库存下限 from tb_stock WHERE (qty < lowerlimit) and lowerlimit > 0", "tb_stock"));
        }
        /// <summary>
        /// 库存商品上限报警
        /// </summary>
        /// <returns></returns>
        public DataSet GetUpperLimit()
        {
            return (data.RunProcReturn("SELECT tradecode as 商品编号, fullname as 商品名称, qty as 库存数量,upperlimit as 库存上限,lowerlimit as 库存下限 FROM tb_stock WHERE (upperlimit < qty) and upperlimit>0","tb_stock"));
        }
        #endregion

        #region 库存盘点
        public int CheckStock(cStockInfo stock)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@tradecode",  SqlDbType.VarChar, 5, stock.TradeCode),
                						data.MakeInParam("@check",  SqlDbType.Float, 8,stock.Check),
			};
            return (data.RunProc("update tb_stock set stockcheck=@check where tradecode=@tradecode", prams));
        }
        #endregion


        #region 本单位信息设置--系统设置
        /// <summary>
        /// 本单位信息设置
        /// </summary>
        /// <param name="units"></param>
        /// <returns></returns>
        public int UpdateSysUnits(cUnits units)
        {
            SqlParameter[] prams = {
                						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_unit set fullname=@fullname,tax=@tax,tel=@tel,linkman=@linkman,address=@address,accounts=@accounts", prams));
        }
        public int InsertSysUnits(cUnits units)
        {
            SqlParameter[] prams = {
                						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_unit (fullname,tax,tel,linkman,address,accounts) values (@fullname,@tax,@tel,@linkman,@address,@accounts)", prams));
        }
        /// <summary>
        /// 得到本单位信息设置
        /// </summary>
        /// <param name="tbName"></param>
        /// <returns></returns>
        public DataSet GetAllUnit()
        {
            return (data.RunProcReturn("select * from tb_unit","tb_unit"));
        }
        #endregion

        #region  数据库备份与恢复--系统设置
        /// <summary>
        /// 备份数据库
        /// </summary>
        /// <param name="bakUpName"></param>
        public void BackUp(string bakUpName)
        {
            data.RunProc("BACKUP DATABASE db_CMS TO DISK ='"+bakUpName+"'");
        }
        /// <summary>
        /// 恢复数据库
        /// </summary>
        /// <param name="reStoreName"></param>
        public void ReStore(string reStoreName)
        {
            data.RunProc("use master RESTORE DATABASE db_CMS from disk='"+reStoreName+"'");
        }
        #endregion

        #region  系统数据清理--系统设置
        /// <summary>
        /// 根据指定的数据表清除数据表中数据
        /// </summary>
        /// <param name="tbName_true"></param>
        public void ClearTable(string tbName_true)
        {
            data.RunProc("delete from " + tbName_true + "");
        }
        #endregion

        #region 系统操作员及权限设置--系统设置
        /// <summary>
        /// 添加系统操作员
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="pwd"></param>
        public void AddSysUser(string userName,string pwd)
        {
            data.RunProc("INSERT INTO tb_power (sysuser, password) VALUES ('" + userName + "', '" + pwd + "')");
        }
        /// <summary>
        /// 删除系统操作员
        /// </summary>
        /// <param name="ID"></param>
        public void DeleteSysUser(int ID)
        {
            data.RunProc("delete from tb_power where id='"+ID+"'");
        }
        /// <summary>
        /// 获得所有系统用户信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetAllUser()
        { 
            return(data.RunProcReturn("select * from tb_power","tb_Power"));
        }
        /// <summary>
        /// 根据用户名称---查询系统用户
        /// </summary>
        /// <param name="userName"></param>
        /// <returns></returns>
        public bool FindUserName(string userName)
        {
            DataSet ds = null;
            ds = data.RunProcReturn("select * from tb_power where sysuser='" + userName + "'", "tb_power");
            if (ds.Tables[0].Rows.Count > 0)
            { return true; }
            else
            { return false; }
        }
        /// <summary>
        /// 修改系统用户信息及所对应的权限
        /// </summary>
        /// <param name="popedom"></param>
        public void UpdateSysUser(cPopedom popedom)
        {
            SqlParameter[] prams = {
                                        data.MakeInParam("@id",  SqlDbType.Int, 4, popedom.ID),
									    data.MakeInParam("@sysuser",  SqlDbType.VarChar, 20, popedom.SysUser),
                						data.MakeInParam("@password",  SqlDbType.VarChar, 20,popedom.Password),
                						data.MakeInParam("@stock",  SqlDbType.Bit, 1, popedom.Stock),
                						data.MakeInParam("@vendition",  SqlDbType.Bit, 1, popedom.Vendition),
                						data.MakeInParam("@storage",  SqlDbType.Bit, 1, popedom.Storage),
                						data.MakeInParam("@system",  SqlDbType.Bit, 1, popedom.SystemSet),
                                        data.MakeInParam("@base",  SqlDbType.Bit, 1, popedom.Base_Info),
			};
            int i = data.RunProc("update tb_power set sysuser=@sysuser,password=@password,stock=@stock,vendition=@vendition,storage=@storage,system=@system,base=@base where id=@id", prams);
        }
        #endregion

        #region 往来单位对账
        /// <summary>
        /// 往来单位列表--并统计应收额-增加及减少
        /// </summary>
        /// <returns></returns>
        public DataSet GetUnitsList()
        {
            return (data.RunProcReturn("SELECT units as 往来单位, SUM(addgathering) AS 应收增加, SUM(reducegathering) AS 应收减少 FROM tb_currentaccount GROUP BY units", "tb_currentaccount"));
        }
        /// <summary>
        ///查询在指定的日期段中--是否存在－－查询结果
        /// </summary>
        /// <param name="units"></param>
        /// <param name="starDateTime"></param>
        /// <param name="endDateTime"></param>
        /// <returns></returns>
        public DataSet FindCurrentAccountDate(string units, DateTime starDateTime,DateTime endDateTime)
        {
            return (data.RunProcReturn("SELECT * FROM tb_currentaccount WHERE units='" + units + "' AND billdate BETWEEN '" +starDateTime+"'AND '" +endDateTime+ "'","tb_currentaccount"));
        }
        /// <summary>
        /// 往来对账－－根据单据编号--查询明细表中数据
        /// </summary>
        /// <param name="billcode"></param>
        /// <param name="tb_Detailed_true"></param>
        /// <returns></returns>
        public DataSet FindDetailde(string tb_Detailed_true, string billcode)
        {
            return (data.RunProcReturn("select * from "+tb_Detailed_true+" where (billcode='" + billcode + "')ORDER BY tsum","detailed"));
        }
        /// <summary>
        /// 往来对账－－根据单据编号--查询主表中数据
        /// </summary>
        /// <param name="tb_Main_true"></param>
        /// <param name="billcode"></param>
        /// <returns></returns>
        public DataSet FindMain(string tb_Main_true, string billcode)
        {
            return (data.RunProcReturn("select * from "+tb_Main_true+" where billcode='" + billcode + "'","main"));
        }
        #endregion

        #region 辅助工具管理
        //ShellExecute Me.hWnd, "open", "http://www.mingrisoft.com", 1, 1, 5
        public void OpenInernet()
        { 

        }
        #endregion

        #region 系统登录
        /// <summary>
        /// 系统登录
        /// </summary>
        /// <param name="popedom"></param>
        /// <returns></returns>
        public DataSet Login(cPopedom popedom)
        {
            SqlParameter[] prams = {
									    data.MakeInParam("@sysuser",  SqlDbType.VarChar, 20, popedom.SysUser),
                						data.MakeInParam("@password",  SqlDbType.VarChar, 20,popedom.Password),
			};
            return (data.RunProcReturn("SELECT * FROM tb_power WHERE (sysuser = @sysuser) AND (password = @password)",prams, "tb_power"));
        }

        #endregion
    }
    #region 定义往来单位--数据结构
    public class cUnitsInfo
    {
        private string unitcode = "";
        private string fullname = "";
        private string tax = "";
        private string tel = "";
        private string linkman = "";
        private string address = "";
        private string accounts = "";
        private float gathering = 0;
        private float payment = 0;
        /// <summary>
        /// 单位编号
        /// </summary>
        public string UnitCode
        {
            get { return unitcode; }
            set { unitcode = value; }
        }
        /// <summary>
        /// 单位全称
        /// </summary>
        public string FullName
        {
            get { return fullname; }
            set { fullname = value; }
        }
        /// <summary>
        /// 单位税号
        /// </summary>
        public string Tax
        {
            get { return tax; }
            set { tax = value; }
        }
        /// <summary>
        /// 联系人
        /// </summary>
        public string LinkMan
        {
            get { return linkman; }
            set { linkman = value; }
        }
        /// <summary>
        /// 联系电话
        /// </summary>
        public string Tel
        {
            get { return tel; }
            set { tel = value; }
        }
        /// <summary>