📄 testdatasource.cs
字号:
/// 施设数据
/// </summary>
/// <returns></returns>
public static DataSet getshiSheDS()
{
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;
}
//数据字典数据
public static DataSet getDictPLANDS()
{
DataSet ds = new DataSet("投资预算");
DataColumn dataColumn1 = new DataColumn("htmcheckbox");
DataColumn dataColumn2 = new DataColumn("OID");
DataColumn dataColumn3 = new DataColumn("SubProjectOID");
DataColumn dataColumn4 = new DataColumn("InvestItemID");
DataColumn dataColumn5 = new DataColumn("InvestItemName");
DataColumn dataColumn6 = new DataColumn("Amount");
DataColumn dataColumn7 = new DataColumn("Remark");
DataColumn dataColumn8 = new DataColumn("IsSum");
DataTable dt = new DataTable("LayOut");
dt.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7, dataColumn8
});
ds.Tables.AddRange(new DataTable[]{dt});
ds.BeginInit();
dt.Rows.Add(new object[]{"G212","01","","","第一部分 建筑安装工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 一 路基工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 二 路面工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 三 桥涵工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 四 交叉工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 五 隧道工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1土建",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2机电工程安装",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 六 其他工程及沿线设施",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1通讯管道",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2安全设施",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 3收费站",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 4服务区",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 5路段机电工程安装",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 6供配电",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 7绿化",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 8其他",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 七 临时工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1便道、便桥",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2附属零星工程",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 3其他",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 八 管理养护及服务房屋",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 减 矿粉单价调整",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 九 施工技术装备",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 十 计划利润",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 十一 税金",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 十二 法定利润",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","","","第二部分 设备及工器具购置费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 一 设备及工具器具购置费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1隧道机电设备",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2路段机电设备",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 3设备购置",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 4工具及器具购置",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 5其他",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 二 办公及生活家具购置费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","","","第三部分 工程建设及其他费用",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 一 青苗补助费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 二 建设单位管理费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1建设单位管理费(含招标会议、审查等工作经费)",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2工程质量监督费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 3工程监理费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 4定额编制管理费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 5设计文件审查费(含设计监理费)",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 6其他",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 三 研究实验费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 四 勘察设计费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1工可",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2初设",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 3施设",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 4变更",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 5其他",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 五 建设期贷款利息",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1、建设期国内贷款利息",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2、建设期亚行贷款利息",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 六 航道管理费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 七 供电贴费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 八 中梁山隧道外电力工程费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 九 压煤开采安全设施费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","","","第一、二、三部分合计",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","","","第四部分 其他部分合计",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 1、新增加费用项目",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 2、预留费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 3、大型专用机械设备购置费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 4、勘察设计单位技术装备费",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","",""," 5、固定资产投资方向调节税",
"0","",""});
dt.Rows.Add(new object[]{"G212","01","","","费用总计",
"0","",""});
ds.EndInit();
return ds;
}
public static DataSet getDictSourceDS()
{
DataSet ds = new DataSet("投资来源字典");
DataColumn dataColumn1 = new DataColumn("htmcheckbox");
DataColumn dataColumn2 = new DataColumn("OID");
DataColumn dataColumn3 = new DataColumn("SubProjectOID");
DataColumn dataColumn4 = new DataColumn("SourceID");
DataColumn dataColumn5 = new DataColumn("SourceName");
DataColumn dataColumn6 = new DataColumn("Amount");
DataColumn dataColumn7 = new DataColumn("Remark");
DataColumn dataColumn8 = new DataColumn("IsSum");
DataTable tblContract = new DataTable("LayOut");
tblContract.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
dataColumn4,dataColumn5,dataColumn6,
dataColumn7, dataColumn8
});
ds.Tables.AddRange(new DataTable[]{tblContract});
ds.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","","工商银行",
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -