三层.业务层

    /// <summary>
    /// 查询
    /// </summary>
    /// <returns></returns>
    public DataSet GetAllCompanyInfo()
    {
        string sql = "SELECT * FROM R_Company ORDER BY companyId DESC ";
        return GetData(sql);
    }
    /// <summary>
    /// 查询单条
    /// </summary>
    /// <param name="bh"></param>
    /// <returns></returns>
    public DataSet GetSingleCompanyInfo(int bh)
    {
        string sql = "SELECT * FROM R_Company WHERE companyId=" + bh;
        return GetData(sql);
    }
    /// <summary>
    /// 添加
    /// </summary>
    /// <param name="companyName"></param>
    /// <param name="companyShortName"></param>
    /// <param name="companyDesc"></param>
    /// <returns></returns>
    public int Insert(string companyName, string companyShortName, string companyDesc)
    {
        string sql = "INSERT INTO R_Company(companyName,companyShortName,companyDesc)VALUES('" + companyName + "','" + companyShortName + "','" + companyDesc + "')";
        return ExecuteSql(sql);
    }
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="bh"></param>
    /// <returns></returns>
    public int Delete(int bh)
    {
        string sql = "DELETE FROM R_Company WHERE companyId=" + bh;
        return ExecuteSql(sql);
    }
    /// <summary>
    /// 修改
    /// </summary>
    /// <param name="bh"></param>
    /// <param name="companyName"></param>
    /// <param name="companyShortName"></param>
    /// <param name="companyDesc"></param>
    /// <returns></returns>
    public int Update(int bh, string companyName, string companyShortName, string companyDesc)
    {
        string sql = "UPDATE R_Company SET companyName='" + companyName + "',companyShortName='" + companyShortName + "',companyDesc='" + companyDesc + "' WHERE companyId=" + bh;
        return ExecuteSql(sql);
    }