testdatasource.cs

网络测试--- ----test12243454546 564

		/// 与界面"银行授信"相关
		/// </summary>
		/// <returns></returns>
		public static DataSet getBankCreditDS()
		{
			DataSet dsBankCredit = new DataSet("dsBankCredit");
			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("授信主体");
			DataColumn dataColumn8 = new DataColumn("授信条件");
			DataColumn dataColumn9 = new DataColumn("备注");
			DataTable tblBankCredit = new DataTable("tblBankCredit");
			tblBankCredit.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
															   dataColumn4,dataColumn5,dataColumn6,
															   dataColumn7,dataColumn8,dataColumn9});
			dsBankCredit.Tables.AddRange(new DataTable[]{tblBankCredit});
			dsBankCredit.BeginInit();
			tblBankCredit.Rows.Add(new object[]{"建设银行","2,000,000.00","0.0367","2003-12-01～2008-12-01",
												   "7,000,000.00","13,000,000.00","高发公司","",""});
			tblBankCredit.Rows.Add(new object[]{"工商银行","5,000,000.00","0.0416","2005-08-05～2010-08-05",
												   "23,000,000.00","27,000,000.00","高发公司","",""});
			tblBankCredit.Rows.Add(new object[]{"招商银行","8,000,000.00","0.0347","2005-07-09～2007-01-09",
												   "3,000,000.00","5,000,000.00","高发公司","",""});
			tblBankCredit.Rows.Add(new object[]{"中国银行","100,000,000.00","0.0327","2001-01-01～2010-01-01",
												   "4,000,000.00","6,000,000.00","高发公司","",""});					
			dsBankCredit.EndInit();
			
			return dsBankCredit;

		}

		/// <summary>
		/// 与合同管理中“还本付息预测”界面相关五年预测
		/// </summary>
		/// <returns></returns>
		public static DataSet getForecastLoanInfoDS()
		{
			DataSet dsForecastLoanInfo = new DataSet("dsForecastLoanInfo");
			DataColumn dataColumn1 = new DataColumn("合同编号");
			DataColumn dataColumn2 = new DataColumn("贷款银行");
			DataColumn dataColumn3 = new DataColumn("贷款年度");
			DataColumn dataColumn4 = new DataColumn("合同金额");
			DataColumn dataColumn5 = new DataColumn("贷款金额");
			DataColumn dataColumn6 = new DataColumn("2005还本");
			DataColumn dataColumn7 = new DataColumn("2005还息");
			DataColumn dataColumn8 = new DataColumn("2006还本");
			DataColumn dataColumn9 = new DataColumn("2006还息");
			DataColumn dataColumn10 = new DataColumn("2007还本");
			DataColumn dataColumn11 = new DataColumn("2007还息");
			DataColumn dataColumn12 = new DataColumn("2008还本");
			DataColumn dataColumn13 = new DataColumn("2008还息");
			DataColumn dataColumn14 = new DataColumn("2009还本");
			DataColumn dataColumn15 = new DataColumn("2009还息");
			DataTable tblForecastLoanInfo = new DataTable("tblForecastLoanInfo");
			tblForecastLoanInfo.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
																	 dataColumn4,dataColumn5,dataColumn6,
																	 dataColumn7,dataColumn8,dataColumn9,
																	 dataColumn10,dataColumn11,dataColumn12,
																	 dataColumn13,dataColumn14,dataColumn15});
			dsForecastLoanInfo.Tables.AddRange(new DataTable[]{tblForecastLoanInfo});
			
			dsForecastLoanInfo.BeginInit();
			tblForecastLoanInfo.Rows.Add(new object[]{"渝黔一期01","建设银行","1998","3,000,000.00","1,000,000.00",
														 "1,000,000.00","33,624.53","500,000.00","24,183.98",
														 "500,000.00","20,122.65","500,000.00","17,561.95",
														 "500,000.00","14,563.24"});			
			tblForecastLoanInfo.Rows.Add(new object[]{"上界路01","工商银行","1999","8,000,000.00","7,000,000.00",
														 "1,500,000,00","50,346.67","1,500,000,00","39,767.45",
														 "1,500,000,00","30,474.90","1,500,000.00","23,456.89",
														 "1,000,000.00","17,236.12"});			
			tblForecastLoanInfo.Rows.Add(new object[]{"上界路02","地方国债","1996","2,000,000.00","3,000,000.00",
														 "","","","","","","","","",""});
			
			tblForecastLoanInfo.Rows.Add(new object[]{"渝合路01","建设银行","2000","800,000.00","800,000.00",
														 "800,000.00","8.456.00","","","","","","","",""});
			
			tblForecastLoanInfo.Rows.Add(new object[]{"渝合路02","建设银行","2000","1,000,000.00","1,000,000.00",
														 "500,000.00","67.452.23","500,000.00","4.579.03",
														 "","","","","",""});
			
			tblForecastLoanInfo.Rows.Add(new object[]{"渝合路03","建设银行","1999","5,000,000.00 ","159,870.00",
														 "1,000,000.00","34,123.97","1,000,000.00","26,330.00",
														 "1,000,000.00","20,430.00","1,000,000.00","17.785.70",
														 "1,000,000.00","10,430.00"});
			
			tblForecastLoanInfo.Rows.Add(new object[]{"渝沙路界水项目01","开发银行","2004","2,000,000.00","2,000,000.00",
														 "","","","","","","","","",""});
			
			tblForecastLoanInfo.Rows.Add(new object[]{"渝沙路界水项目04","开发银行","2004","40,000.00","",
														 "","","","", "","","","","",""});  
			dsForecastLoanInfo.EndInit();

			return dsForecastLoanInfo;
		}
		


		/// <summary>
		/// 与“还本付息计划表”年度计划界面相关数据集
		/// </summary>
		/// <returns></returns>
		public static DataSet getYearForecastLoanDS()
		{
			DataSet dsForecastLoanInfo = new DataSet("dsForecastLoanInfo");
			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("年初本金余额");
			DataColumn dataColumn8 = new DataColumn("本年合计");
			DataColumn dataColumn9 = new DataColumn("本年度计划还息");
			DataColumn dataColumn10 = new DataColumn("本年度计划还本");
			DataColumn dataColumn11 = new DataColumn("一季度计划还本金");
			DataColumn dataColumn12 = new DataColumn("一季度计划还息");
			DataColumn dataColumn13 = new DataColumn("二季度计划还本金");
			DataColumn dataColumn14 = new DataColumn("二季度计划还利息");
			DataColumn dataColumn15 = new DataColumn("三季度计划还息");
			DataColumn dataColumn16 = new DataColumn("三季度计划还本金");
			DataColumn dataColumn17 = new DataColumn("四季度计划还本金");
			DataColumn dataColumn18 = new DataColumn("四季度计划还息");
			DataTable tblForecastLoanInfo = new DataTable("tblForecastLoanInfo");
			tblForecastLoanInfo.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
																	 dataColumn4,dataColumn5,dataColumn6,
																	 dataColumn7,dataColumn8,dataColumn9,
																	 dataColumn10,dataColumn11,dataColumn12,
																	 dataColumn13,dataColumn14,dataColumn15,
																	 dataColumn16,dataColumn17,dataColumn18});
			dsForecastLoanInfo.Tables.AddRange(new DataTable[]{tblForecastLoanInfo});
			
			dsForecastLoanInfo.BeginInit();

			tblForecastLoanInfo.Rows.Add(new object[]{"渝黔二期"," 16,000.00","10","0.052","0.00","0.00","0.00","3,250.75",
														 "946.75","2,304.00","0.00","244.80","0.00","244.80",
														 "0.00","244.80","2,304.00","212.35"});	
			tblForecastLoanInfo.Rows.Add(new object[]{"渝黔二期04","6,000.00","15"," 0.0576","0.00","0.00","0.00","2,757.22",
														 "953.22","1,804.00","0.00","244.80","0.00","244.80",
														 "0.00","244.80","1,804.00","218.82 "});
			tblForecastLoanInfo.Rows.Add(new object[]{"渝黔二期06","10,000.00","12"," 0.05175","0.00","0.00","0.00","493.53",
														 "-6.47","500.00","0.00","0.00","0.00","0.00",
														 "0.00","0.00","500.00","-6.47"});
			
			dsForecastLoanInfo.EndInit();

			return dsForecastLoanInfo;
		}
		
		/// <summary>
		/// 
		/// </summary>
		/// <returns></returns>
		public static DataSet getBankCreditContractDS()
		{
			DataSet dsBankCredit = new DataSet("dsBankCredit");
			DataColumn dataColumn1 = new DataColumn("合同编号");
			DataColumn dataColumn2 = new DataColumn("合同金额");
			DataColumn dataColumn3 = new DataColumn("项目名称");
			DataColumn dataColumn4 = new DataColumn("执行日期");
			DataColumn dataColumn5 = new DataColumn("终止日期");
			
			DataTable tblBankCredit = new DataTable("tblBankCredit");
			tblBankCredit.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
															   dataColumn4,dataColumn5});
			dsBankCredit.Tables.AddRange(new DataTable[]{tblBankCredit});
			dsBankCredit.BeginInit();
			tblBankCredit.Rows.Add(new object[]{"垫忠项目03","10,000,000.00","垫忠项目03","1998-01-01","2008-01-01"});
			tblBankCredit.Rows.Add(new object[]{"梁长项目02","3,000,000.00","梁长项目02","2002-03-15","2006-03-15"});
			tblBankCredit.Rows.Add(new object[]{"垫忠项目01","7,000,000.00","垫忠项目01","2001-06-01","2006-06-01"});
							
			dsBankCredit.EndInit();
			
			return dsBankCredit;

		}

		#endregion

		#region 与基础设置相关的数据集


		/// <summary>
		/// 与基础设置“银行帐户管理”界面相关
		/// </summary>
		/// <returns></returns>
		public static DataSet getBankAccountsDS()
		{
			DataSet dsBBankAccounts = new DataSet("dsBankInfo");
			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("开户日期");
			DataColumn dataColumn8 = new DataColumn("操作人员");
			DataColumn dataColumn9 = new DataColumn("状态");
			DataTable tblBankAccounts = new DataTable("tblBankAccounts");
			tblBankAccounts.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
																 dataColumn4,dataColumn5,dataColumn6,
																 dataColumn7,dataColumn8,dataColumn9});
			dsBBankAccounts.Tables.AddRange(new DataTable[]{tblBankAccounts});
			dsBBankAccounts.BeginInit();
			tblBankAccounts.Rows.Add(new object[]{"北方建设分公司","北方建设分公司","商业银行","商业银行龙头寺支行",
													 "230101040007013","资本金","2004-05-10","坤源","启用"});
			tblBankAccounts.Rows.Add(new object[]{"渝涪分公司","长涪项目","交通银行"," 交行江北支行 ",
													 "149003966","资本金","2004-12-06","坤源","启用"});
			tblBankAccounts.Rows.Add(new object[]{"渝涪分公司","长涪项目","建设银行"," 建行市分行营业部 ",
													 "225214254","资本金","2004-12-06","坤源","启用"});
			tblBankAccounts.Rows.Add(new object[]{"渝涪分公司","长万项目","工商银行"," 工行较场口分理处 ",
													 "21509022104357","资本金","2004-09-08","坤源","启用"});
			tblBankAccounts.Rows.Add(new object[]{"渝涪分公司","长万项目","中国银行"," 中行重庆市分行营业部 ",
													 "018208091001","资本金","2004-09-08","坤源","启用"});
			dsBBankAccounts.EndInit();

			return dsBBankAccounts;
		}

		/// <summary>
		/// 与基础设置中“项目设置”相关
		/// </summary>
		/// <returns></returns>
		public static DataSet getCompanyItemDS()
		{			
			DataSet dsCompanyItem = new DataSet("dsCompanyItem");
			DataColumn dataColumn1 = new DataColumn("项目代号");
			DataColumn dataColumn2 = new DataColumn("公司名称");
			DataColumn dataColumn3 = new DataColumn("项目名称");
			DataColumn dataColumn4 = new DataColumn("投资总额");
			DataColumn dataColumn5 = new DataColumn("状态");
			DataTable tblCompanyItem = new DataTable("tblCompanyItem");
			tblCompanyItem.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,dataColumn4,dataColumn5});
			dsCompanyItem.Tables.AddRange(new DataTable[]{tblCompanyItem});

			dsCompanyItem.BeginInit();
			tblCompanyItem.Rows.Add(new object[]{"001","高发公司","集团公司","50,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"011","渝涪分公司","渝涪分公司经营","70,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"012","渝涪分公司","长涪项目","80,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"013","北方建设分公司","渝合一期","50,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"014","渝东分公司","万开项目","100,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"015","南方建设分公司","渝黔二期","40,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"016","垫利分公司","石忠项目","70,000,000.00","启用"});
			tblCompanyItem.Rows.Add(new object[]{"017","垫利分公司","绕城东段","80,000,000.00","启用"});			
			dsCompanyItem.EndInit();

			return dsCompanyItem;

		}

		/// <summary>
		/// 与基础设置“银行存款限额设置”界面相关
		/// </summary>
		/// <returns></returns>
		public static DataSet getBankFundQuotaDS()
		{
			DataSet dsBankFundQuota = new DataSet("dsBankFundQuota");
			DataColumn dataColumn1 = new DataColumn("公司名称");
			DataColumn dataColumn2 = new DataColumn("存款余额上限");
			DataColumn dataColumn3 = new DataColumn("存款余额下限");
			DataColumn dataColumn4 = new DataColumn("说明");
			DataTable tblBankFundQuota = new DataTable("tblBankFundQuota");
			tblBankFundQuota.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,dataColumn4});
			dsBankFundQuota.Tables.AddRange(new DataTable[]{tblBankFundQuota});

			tblBankFundQuota.BeginInit();
			tblBankFundQuota.Rows.Add(new object[]{"高发公司","20,000,000.00","1,000,000.00",""});
			tblBankFundQuota.Rows.Add(new object[]{"中渝营运分公司","5,000,000.00","500,000.00",