📄 testdatasource.cs
字号:
using System;
using System.Data;
namespace CQECMS
{
/// <summary>
/// TestDataSource 的摘要说明。
/// </summary>
public class TestDataSource
{
public TestDataSource()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static DataSet getConstuctTimePlanDS()
{
DataSet dsContract = new DataSet("资金来源计划");
DataColumn dataColumn1 = new DataColumn("路线编码");
DataColumn dataColumn2 = new DataColumn("项目编码");
DataColumn dataColumn3 = new DataColumn("年度");
DataColumn dataColumn4 = new DataColumn("来源细目编码");
DataColumn dataColumn5 = new DataColumn("来源细目");
DataColumn dataColumn6 = new DataColumn("来源金额");
DataColumn dataColumn7 = new DataColumn("备注");
DataTable tblContract = new DataTable("SourcePlan");
tblContract.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7});
dsContract.Tables.AddRange(new DataTable[]{tblContract});
dsContract.BeginInit();
tblContract.Rows.Add(new object[]{"G212","01","2005","","1交通部补助款",
"2,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","车购费基建补助",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","中央国债资金",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","2地方自筹",
"8,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","财政三费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","施工营业税退税",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","国债转贷资金",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","公路养路费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","货运附加费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","客运附加费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","重点建设资金",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","西部债券",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","3公司自筹",
"3,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","成渝路转让费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","渝涪路转让费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","机场路转让费",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","4银行贷款(国内)",
"3,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","交通银行",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","工商银行",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","建设银行",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","5利用外资（国外贷款）",
"2,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","世界银行",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","亚洲开发银行",
"1,000,000.000",""});
tblContract.Rows.Add(new object[]{"G212","01","2005","","来源合计",
"18,000,000.000",""});
dsContract.EndInit();
return dsContract;
}
#region 前期数据
/// <summary>
/// 网络规划
/// </summary>
/// <returns></returns>
public static DataSet getLayOutDS()
{
DataSet ds = new DataSet("网络规划");
DataColumn dataColumn1 = new DataColumn("htmcheckbox");
DataColumn dataColumn2 = new DataColumn("OID");
DataColumn dataColumn3 = new DataColumn("LayoutName");
DataColumn dataColumn4 = new DataColumn("LayoutDate");
DataColumn dataColumn5 = new DataColumn("LayoutType");
DataColumn dataColumn6 = new DataColumn("TotalMileage_Country");
DataColumn dataColumn7 = new DataColumn("LayoutMoney_Country");
DataColumn dataColumn8 = new DataColumn("ActualizeInfo_Country");
DataColumn dataColumn9 = new DataColumn("TotalMileage_CQ");
DataTable dt = new DataTable("LayOut");
dt.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7, dataColumn8, dataColumn9});
ds.Tables.AddRange(new DataTable[]{dt});
ds.BeginInit();
dt.Rows.Add(new object[]{"G212","01","上海－成都高速公路（M50）","2005-09-30","国家规划",
"1,960.00","0.00","建成53.9%，在建5.6%，未建40.5%",
"181.00"});
dt.Rows.Add(new object[]{"G212","02","重庆－长沙高速公路","2004-09-30","国家规划",
"1,060.00","0.00","建成53.9%，在建5.6%，未建40.5%",
"181.00"});
ds.EndInit();
return ds;
}
/// <summary>
/// 预可数据
/// </summary>
/// <returns></returns>
public static DataSet getYuKeDS()
{
DataSet ds = new DataSet("预可数据");
DataColumn dataColumn1 = new DataColumn("htmcheckbox");
DataColumn dataColumn2 = new DataColumn("OID");
DataColumn dataColumn3 = new DataColumn("ProjectShortName");
DataColumn dataColumn4 = new DataColumn("PrefeasibilityDatetime");
DataColumn dataColumn5 = new DataColumn("UnitOfWriter");
DataColumn dataColumn6 = new DataColumn("PrefeasibilityCourse");
DataColumn dataColumn7 = new DataColumn("ConsignDepartment");
DataColumn dataColumn8 = new DataColumn("ContractMoney");
DataColumn dataColumn9 = new DataColumn("AuthorizedTime");
DataColumn dataColumn10 = new DataColumn("AuthorizedFileNo");
DataColumn dataColumn11 = new DataColumn("AuthorizedMile");
DataColumn dataColumn12 = new DataColumn("AuthorizedMoney");
DataTable dt = new DataTable("LayOut");
dt.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7, dataColumn8, dataColumn9,
dataColumn10, dataColumn11, dataColumn12
});
ds.Tables.AddRange(new DataTable[]{dt});
ds.BeginInit();
dt.Rows.Add(new object[]{"G212","01","成渝高速","2000-01-30","交通设计院",
"已批复","设计院","800000","2001-1-1","交20010132",
"110.00","321890000"});
ds.EndInit();
return ds;
}
/// <summary>
/// 工可数据
/// </summary>
/// <returns></returns>
public static DataSet getGongKeDS()
{
DataSet ds = new DataSet("工可数据");
DataColumn dataColumn1 = new DataColumn("htmcheckbox");
DataColumn dataColumn2 = new DataColumn("OID");
DataColumn dataColumn3 = new DataColumn("SubProjectShortName");
DataColumn dataColumn4 = new DataColumn("FeasibilityDatetime");
DataColumn dataColumn5 = new DataColumn("UnitOfWriter");
DataColumn dataColumn6 = new DataColumn("FeasibilityCourse");
DataColumn dataColumn7 = new DataColumn("ConsignDepartment");
DataColumn dataColumn8 = new DataColumn("ContractMoney");
DataColumn dataColumn9 = new DataColumn("AuthorizedTime");
DataColumn dataColumn10 = new DataColumn("AuthorizedFileNo");
DataColumn dataColumn11 = new DataColumn("AuthorizedMile");
DataColumn dataColumn12 = new DataColumn("AuthorizedMoney");
DataTable dt = new DataTable("LayOut");
dt.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7, dataColumn8, dataColumn9,
dataColumn10, dataColumn11, dataColumn12
});
ds.Tables.AddRange(new DataTable[]{dt});
ds.BeginInit();
dt.Rows.Add(new object[]{"G212","01","成渝高速公路渝境段","1987-12-09","交通设计院",
"已批复","设计院","800000","2001-1-1","计交[1987]2333",
"345.500","321890000"});
dt.Rows.Add(new object[]{"G212","01","武胜至合川高速公路","2002-10-14","交通设计院",
"已批复","设计院","800000","2001-1-1","交规划发[2002]487号",
"35.000","1340000,000.00"});
dt.Rows.Add(new object[]{"G212","01","重庆至合川高速公路","1998-08-24","四川省交通厅公路规划勘察设计院",
"已批复","设计院","800000","2001-1-1","交计发[1998]517号",
"57","2700000,000"});
dt.Rows.Add(new object[]{"G212","01","邻水至重庆高速公路","2000-10-13","交通设计院",
"已批复","设计院","800000","2001-1-1","交规发[2000]29号",
"53","1400000,000"});
dt.Rows.Add(new object[]{"G212","01","重庆至遂宁高速公路","2004-05-07","交通设计院",
"已批复","设计院","800000","2004-05-07","发改交运[2004]515号",
"111.00","4480000,000"});
ds.EndInit();
return ds;
}
public static DataSet getChuSheDS()
{
DataSet ds = new DataSet("初设数据");
DataColumn dataColumn1 = new DataColumn("htmcheckbox");
DataColumn dataColumn2 = new DataColumn("OID");
DataColumn dataColumn3 = new DataColumn("SubProjectOID");
DataColumn dataColumn4 = new DataColumn("FeasibilityDatetime");
DataColumn dataColumn5 = new DataColumn("EngineeringType");
DataColumn dataColumn6 = new DataColumn("PrimaryDesignCourse");
DataColumn dataColumn7 = new DataColumn("ConsignDepartment");
DataColumn dataColumn8 = new DataColumn("ContractMoney");
DataColumn dataColumn9 = new DataColumn("AuthorizedTime");
DataColumn dataColumn10 = new DataColumn("AuthorizedFileNo");
DataColumn dataColumn11 = new DataColumn("AuthorizedMile");
DataColumn dataColumn12 = new DataColumn("AuthorizedMoney");
DataTable dt = new DataTable("LayOut");
dt.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7, dataColumn8, dataColumn9,
dataColumn10, dataColumn11, dataColumn12
});
ds.Tables.AddRange(new DataTable[]{dt});
ds.BeginInit();
dt.Rows.Add(new object[]{"G212","01","成渝高速公路渝境段","1987-12-09","土建工程",
"已批复","设计院","800000","2001-1-1","计交[1987]2333",
"345.500","321890000"});
dt.Rows.Add(new object[]{"G212","01","武胜至合川高速公路","2002-10-14","土建工程",
"已批复","设计院","800000","2003-02-17","交公路发[2003]40号",
"35.000","1,522,933,213.00"});
dt.Rows.Add(new object[]{"G212","01","重庆至合川高速公路","1998-08-24","土建工程",
"已批复","设计院","800000","1999-07-30","渝交局（1999）663号",
"57.760","3,110,450,000.00"});
dt.Rows.Add(new object[]{"G212","01","邻水至重庆高速公路","2000-10-13","土建工程",
"已批复","设计院","800000","2001-1-1","交规发[2000]29号",
"53","1400000,000"});
dt.Rows.Add(new object[]{"G212","01","重庆至遂宁高速公路","2004-05-07","土建工程",
"已批复","设计院","800000","2004-07-23","交公路发[2004]405号",
"111.830","4,746,629,010.00"});
ds.EndInit();
return ds;
}
/// <summary>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -