selectclass.cs

运用ASP.net C#语言对SQL数据库表格中的数据进行运算处理。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// selectclass 的摘要说明
/// </summary>
public class selectclass
{
	public selectclass()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //固定资产部分
    public string get_select1_GDZC(string syear, string oyear, string blm)
    {
        string sql;
        switch (blm)
        {
            case "C_GDP":
                sql = "Select year,C_GDI,C_CONS,C_DI,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_CG,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_CONS":
                sql = "Select year,C_GDI,C_CP,C_DI,C_GDP,C_GDP3,C_GDPE,C_PCDI,C_PCGDP,C_POPM,C_RETAIL from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GFCF":
                sql = "Select year,C_GDI,C_DEPOSIT,C_DPST_S,C_GDP,C_GDP2,C_CG from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDP2I":
                sql = "Select year,C_GDI,C_GDP2,C_GDP2C,C_GFCF from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDP2C":
                sql = "Select year,C_GDI,C_DEPOSIT,C_GDP,C_GDP2,C_GDP2I,C_GFCF,C_CG from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDP3":
                sql = "Select year,C_GDI,C_CONS,C_DI,C_GDP,C_PCDI,C_PCGDP,C_RETAIL,C_CG from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_PCDI":
                sql = "Select year,C_GDI,C_CP,C_DI,C_GDP3,C_PCCP,C_PCDIU,C_PCGDP,C_RETAIL,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_TLM":
                sql = "Select year,C_GDI,C_DI,C_GDP,C_GDP2,C_GDP2I,C_GFCF,C_L2M,C_NEGS,C_POPM from N_variable where year >=" + syear + "and year <=" + oyear; break;
            default:
                sql = "Select year,C_GDI,C_CONS,C_DI,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_CG,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
        }
        return sql;
    }//提取数据的SQL语句函数
    public string get_select2_GDZC(string blm)
    {
        string sql;
        sql = "Select rate,year1,year2,year3,year4,year5,year6,year7,year8,year9,year10,blm,code from Result where blm='" + blm + "'and code=1";
        return sql;
    }//需要保存的数据
    public string get_delete_GDZC(string blm, string rate)
    {
        string sql;
        sql = "Delete from S_GDZC where blm='" + blm + "'and rate='" + rate + "'";
        return sql;
    }//删除函数

    //政府消费部分
    public string get_select1_ZFXF(string syear, string oyear, string blm)
    {
        string sql;
        switch (blm)
        {
            case "C_GDP":
                sql = "Select year,C_CG,C_CONS,C_DI,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_GDI,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_CP":
                sql = "Select year,C_CG,C_CONS,C_CPR,C_CPU,C_DI,C_PCCP,C_PCDI,C_PCDIR,C_PCDIU,C_POPM,C_RETAIL,CPI00,C_GDP,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_DI":
                sql = "Select year,C_CG,C_CONS,C_CP,C_GDP,C_GDP3,C_PCDI,C_PCGDP,C_POPM,C_RETAIL from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDI":
                sql = "Select year,C_CG,C_BALANCE,C_REVENUE,C_EXPT,C_DI,CPI00,C_GDP2,C_GDP3 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            default:
                sql = "Select year,C_CG,C_CONS,C_DI,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_GDI,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
        }
        return sql;
    }//提取数据的SQL语句函数
    public string get_select2_ZFXF(string blm)
    {
        string sql;
        sql = "Select rate,year1,year2,year3,year4,year5,year6,year7,year8,year9,year10,blm,code from Result where blm='" + blm + "'and code=2";
        return sql;
    }//需要保存的数据
    public string get_delete_ZFXF(string blm, string rate)
    {
        string sql;
        sql = "Delete from S_ZFXF where blm='" + blm + "'and rate='" + rate + "'";
        return sql;
    }//删除函数



    //居民收入部分
    public string get_select1_JMSR(string syear, string oyear, string blm)
    {
        string sql;
        switch (blm)
        {
            case "C_GDP":
                sql = "Select year,C_DI,C_CONS,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_CG,C_GDI,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_CPU":
                sql = "Select year,C_DI,C_CONS,C_CP,C_GDP1,C_PCCP,C_PCCPU,C_PCDI,C_PCDIR,C_PCDIU,C_POPM from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_CPR":
                sql = "Select year,C_DI,C_CP,C_PCDIR,C_PCDIU from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDP2":
                sql = "Select year,C_DI,C_GDP,C_GDP2C,C_GDP2I,C_GFCF,C_CG from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDP3":
                sql = "Select year,C_DI,C_CONS,C_GDP,C_PCDI,C_PCGDP,C_RETAIL,C_CG,C_GDI from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDI":
                sql = "Select year,C_DI,C_BALANCE,C_REVENUE,C_EXPT,C_CG,CPI00,C_GDP2,C_GDP3 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_TLM":
                sql = "Select year,C_DI,C_GDI,C_GDP,C_GDP2,C_GDP2I,C_GFCF,C_L2M,C_NEGS,C_POPM from N_variable where year >=" + syear + "and year <=" + oyear; break;
            default:
                sql = "Select year,C_DI,C_CONS,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_CG,C_GDI,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
        }
        return sql;
    }//提取数据的SQL语句函数
    public string get_select2_JMSR(string blm)
    {
        string sql;
        sql = "Select rate,year1,year2,year3,year4,year5,year6,year7,year8,year9,year10,blm,code from Result where blm='" + blm + "'and code=3";
        return sql;
    }//需要保存的数据
    public string get_delete_JMSR(string blm, string rate)
    {
        string sql;
        sql = "Delete from S_JMSR where blm='" + blm + "'and rate='" + rate + "'";
        return sql;
    }//删除函数


    //全国物价部分
    public string get_select1_QGWJ(string syear, string oyear, string blm)
    {
        string sql;
        switch (blm)
        {
            case "C_GDP":
                sql = "Select year,CPI00,C_CONS,C_DI,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,GDP00,C_CG,C_GDI,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_CP":
                sql = "Select year,CPI00,C_CONS,C_CPR,C_CPU,C_DI,C_PCCP,C_PCDI,C_PCDIR,C_PCDIU,C_POPM,C_RETAIL,C_CG,C_GDP,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_GDI":
                sql = "Select year,CPI00,C_BALANCE,C_REVENUE,C_EXPT,C_CG,C_DI,C_GDP2,C_GDP3 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_L2M":
                sql = "Select year,CPI00,C_GDP,C_GDP2,C_NEGS,C_POPM,C_TLM from N_variable where year >=" + syear + "and year <=" + oyear; break;
            case "C_L3M":
                sql = "Select year,CPI00,C_CONS,C_DI,C_GDP,C_GDP3,C_POPM,GDP00 from N_variable where year >=" + syear + "and year <=" + oyear; break;
            default:
                sql = "Select year,CPI00,C_CONS,C_DI,C_GDP2,C_GDP3,C_GFCF,C_PCGDP,C_RETAIL,CPI00,GDP00,C_CG,C_GDI,C_GDP1 from N_variable where year >=" + syear + "and year <=" + oyear; break;
        }
        return sql;
    }//提取数据的SQL语句函数
    public string get_select2_QGWJ(string blm)
    {
        string sql;
        sql = "Select rate,year1,year2,year3,year4,year5,year6,year7,year8,year9,year10,blm,code from Result where blm='" + blm + "'and code=4";
        return sql;
    }//需要保存的数据
    public string get_delete_QGWJ(string blm, string rate)
    {
        string sql;
        sql = "Delete from S_QGWJ where blm='" + blm + "'and rate='" + rate + "'";
        return sql;
    }//删除函数
}