testdatasource.cs

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

		public static DataSet getCompanyInfoDS()
		{
			DataSet dsCompanyInfo = new DataSet("dsCompanyInfo");
			DataColumn dataColumn1 = new DataColumn("公司简称");
			DataColumn dataColumn2 = new DataColumn("公司性质");
			DataColumn dataColumn3 = new DataColumn("投资模式");
			DataColumn dataColumn4 = new DataColumn("公司编号");
			DataColumn dataColumn5 = new DataColumn("状态");
			DataTable tblCompanyInfo = new DataTable("tblCompanyInfo");
			tblCompanyInfo.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
																dataColumn4,dataColumn5});
			dsCompanyInfo.Tables.AddRange(new DataTable[]{tblCompanyInfo});
			dsCompanyInfo.BeginInit();
			tblCompanyInfo.Rows.Add(new object[]{"高发公司","","控股","001","启用"});
			tblCompanyInfo.Rows.Add(new object[]{"中渝营运分公司","分公司","全资","002","启用"});
			tblCompanyInfo.Rows.Add(new object[]{"南方建设分公司","分公司","全资","003","启用"});
			tblCompanyInfo.Rows.Add(new object[]{"渝东分公司","分公司","全资","004","启用"});
			tblCompanyInfo.Rows.Add(new object[]{"渝东营运分公司","分公司","全资","005","启用"});			
			tblCompanyInfo.Rows.Add(new object[]{"渝邻公司","合资公司","控股","006","启用"});
			tblCompanyInfo.Rows.Add(new object[]{"渝涪分公司","合资公司","控股","007","启用"});	
			dsCompanyInfo.EndInit();

			return dsCompanyInfo;

		}

#endregion

		#region  与贷款合同相关数据集
		/// <summary>
		/// 与界面合同管理相关
		/// </summary>
		/// <returns></returns>
		public static DataSet getContractDS()
		{
			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("本年将还贷");
			DataColumn dataColumn8 = new DataColumn("合同总额");
			DataColumn dataColumn9 = new DataColumn("合同状态");
			DataColumn dataColumn10 = new DataColumn("合同起止时间");
				
			DataTable tblContract = new DataTable("tblContract");
			tblContract.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
															 dataColumn4,dataColumn5,dataColumn6,
															 dataColumn7,dataColumn8,dataColumn9,dataColumn10});
			dsContract.Tables.AddRange(new DataTable[]{tblContract});
			dsContract.BeginInit();
			tblContract.Rows.Add(new object[]{"高发公司","垫忠项目01","建设银行","6,000,000.00","0",
												 "1,000,000.00","0","7,000,000.00","执行中-上贷","1998-01-05～2006-01-05"});
			tblContract.Rows.Add(new object[]{"高发公司","长涪项目02","工商银行","2,000,000.00","0",
												 "2,000,000.00","0","4,000,000.00","执行中-上贷","2002-07-08～2006-07-08"});
			tblContract.Rows.Add(new object[]{"高发公司","长涪项目01","建设银行","4,000,000.00","0",
												 "2,000,000.00","0","6,000,000.00","执行中-上贷","2002-12-25～2008-12-25"});
			tblContract.Rows.Add(new object[]{"高发公司","梁长项目02","地方国债","3,000,000.00","2,000,000.00",
												 "0","1,000,000,00","3,000,000.00","执行中-还贷","2000-10-18～2005-10-18"});
			tblContract.Rows.Add(new object[]{"高发公司","垫忠项目03","开发银行","10,000,000.00","4,000,000.00","0",
												 "2,000,000,00","10,000,000.00","执行中-还贷","1998-05-012～2008-05-12"});
			tblContract.Rows.Add(new object[]{"高发公司","石忠项目01","中国银行","5,000,000.00","1,000,000.00",
												 "0","1,000,000.00","5,000,000.00","执行中-还贷","2001-06-01～2008-06-01"});
			dsContract.EndInit();	

			return dsContract;

		}


		/// <summary>
		///与“上贷、还贷执行情况”界面相关的数据集
		///tblContractExecute：执行情况列表
		///tblContractExecuteIN：上贷执行情况列表
		/// </summary>
		/// <returns></returns>
		public static DataSet getContractExecuteDS()
		{
			DataSet dsContractExecute = new DataSet("dsContractExecute");
			//执行情况列表
			DataColumn dataColumn1 = new DataColumn("计划时间");
			DataColumn dataColumn2 = new DataColumn("类型(还贷\\还本)");
			DataColumn dataColumn3 = new DataColumn("金额");
			DataColumn dataColumn4 = new DataColumn("状态");
			DataColumn dataColumn5 = new DataColumn("实际执行");
			DataColumn dataColumn6 = new DataColumn("经手人");
			DataTable tblContractExecute = new DataTable("tblContract");
			tblContractExecute.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
																	dataColumn4,dataColumn5,dataColumn6});
			//上贷执行情况列表
			DataColumn dataColumn11 = new DataColumn("计划时间");
			DataColumn dataColumn12 = new DataColumn("金额");
			DataColumn dataColumn13 = new DataColumn("状态");
			DataColumn dataColumn14 = new DataColumn("实际执行");
			DataColumn dataColumn15 = new DataColumn("经手人");
			DataTable tblContractExecuteIN = new DataTable("tblContractExecuteIN");
			tblContractExecuteIN.Columns.AddRange(new DataColumn[]{dataColumn11,dataColumn12,dataColumn13,
																	  dataColumn14,dataColumn15});


			dsContractExecute.Tables.AddRange(new DataTable[]{tblContractExecute,tblContractExecuteIN});
			dsContractExecute.BeginInit();

			//执行情况列表:基础数据
			tblContractExecute.Rows.Add(new object[]{"2005-06-01","上贷","20,000,000.00","已执行","20,000,000.00","邝龙"});
			tblContractExecute.Rows.Add(new object[]{"2005-08-05","上贷","10,000,000.00","已执行","10,000,000.00","邝龙"});
			tblContractExecute.Rows.Add(new object[]{"2005-08-21","上贷","30,000,000.00","已执行","30,000,000.00","邝龙"});
			tblContractExecute.Rows.Add(new object[]{"2005-09-06","上贷","40,000,000.00","已执行","40,000,000.00","邝龙"});
			tblContractExecute.Rows.Add(new object[]{"2005-10-13","还贷","30,000,000.00","已执行","30,000,000.00","邝龙"});
			tblContractExecute.Rows.Add(new object[]{"2005-11-06","还贷","20,000,000.00","已执行","20,000,000.00","邝龙"});
	
			//上贷执行情况列表：基础数据			
			tblContractExecuteIN.Rows.Add(new object[]{"2005-06-01","20,000,000.00","已执行","20,000,000.00","邝龙"});
			tblContractExecuteIN.Rows.Add(new object[]{"2005-08-05","10,000,000.00","已执行","10,000,000.00","邝龙"});
			tblContractExecuteIN.Rows.Add(new object[]{"2005-08-21","30,000,000.00","已执行","30,000,000.00","邝龙"});
			tblContractExecuteIN.Rows.Add(new object[]{"2005-09-06","40,000,000.00","已执行","40,000,000.00","邝龙"});

			dsContractExecute.EndInit();

			return dsContractExecute;

		}


		/// <summary>
		/// 得到上贷计划
		/// </summary>
		/// <returns></returns>
		public static DataSet getContractGetPlan()
		{
			DataSet dsContractGetPlan = new DataSet("上贷计划");
			DataColumn dataColumn1 = new DataColumn("计划上贷日期");
			DataColumn dataColumn2 = new DataColumn("上贷金额");
			DataColumn dataColumn3 = new DataColumn("摘要");
			DataTable tblContractGetPlan = new DataTable("tblContractGetPlan");
			tblContractGetPlan.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3});
			dsContractGetPlan.Tables.AddRange(new DataTable[]{tblContractGetPlan});
			dsContractGetPlan.BeginInit();
			tblContractGetPlan.Rows.Add(new object[]{"1999-05-04","1,000,000.00","上贷"});
			tblContractGetPlan.Rows.Add(new object[]{"2000-05-04","2,000,000.00","上贷"});
			tblContractGetPlan.Rows.Add(new object[]{"1999-05-08","1,000,000.00","上贷"});			
			tblContractGetPlan.EndInit();	

			return dsContractGetPlan ;

		}		

		/// <summary>
		/// 得到还贷计划
		/// </summary>
		/// <returns></returns>
		public static DataSet getContractReturnPlan()
		{
			DataSet dsContractReturnPlan = new DataSet("还贷计划");
			DataColumn dataColumn1 = new DataColumn("计划还贷日期");
			DataColumn dataColumn2 = new DataColumn("还款金额");
			DataColumn dataColumn3 = new DataColumn("摘要");
			DataTable tblContractGetPlan = new DataTable("tblContractGetPlan");
			tblContractGetPlan.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3});
			dsContractReturnPlan.Tables.AddRange(new DataTable[]{tblContractGetPlan});
			dsContractReturnPlan.BeginInit();
			tblContractGetPlan.Rows.Add(new object[]{"1999-05-04","3,000.00","还贷"});
			tblContractGetPlan.Rows.Add(new object[]{"2000-05-04","3,020.00","还贷"});
			tblContractGetPlan.Rows.Add(new object[]{"1999-05-08","3,320.00","还贷"});
												
			
			tblContractGetPlan.EndInit();	

			return dsContractReturnPlan;

		}

		/// <summary>
		/// 与界面"贷款合同维护"相关的合同数据集,包括"上贷维护"和"还贷维护"两个数据表
		/// </summary>
		/// <returns></returns>
		public static DataSet getContractMaintenanceDS()
		{
			DataSet dsContractMaintenance = new DataSet("贷款合同维护");
			DataColumn dataColumn1 = new DataColumn("合同编号");
			DataColumn dataColumn2 = new DataColumn("贷款银行");
			DataColumn dataColumn3 = new DataColumn("类型");
			DataColumn dataColumn4 = new DataColumn("金额");
			DataColumn dataColumn5 = new DataColumn("日期");		
			DataTable tblContractIN = new DataTable("tblContractIN");
			tblContractIN.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
															   dataColumn4,dataColumn5});
			dsContractMaintenance.Tables.AddRange(new DataTable[]{tblContractIN});
			dsContractMaintenance.BeginInit();
			tblContractIN.Rows.Add(new object[]{"垫忠项目01","银行银行","上贷","1,000,000.00","2004-05-12"});
			tblContractIN.Rows.Add(new object[]{"垫忠项目01","银行银行","上贷","2,000,000.00","2004-08-12"});
			tblContractIN.Rows.Add(new object[]{"垫忠项目01","银行银行","上贷","3,000,000.00","2004-11-12"});
			tblContractIN.Rows.Add(new object[]{"长涪项目02","工商银行","上贷","1,000,000.00","2005-02-02"});
			tblContractIN.Rows.Add(new object[]{"长涪项目02","工商银行","上贷","1,000,000.00","2005-04-17"});
			tblContractIN.Rows.Add(new object[]{"长涪项目01","建设银行","上贷","2,000,000.00","2005-02-21"});
			tblContractIN.Rows.Add(new object[]{"长涪项目01","建设银行","还本","2,000,000.00","2005-05-21"});
			tblContractIN.Rows.Add(new object[]{"梁长项目02","建设银行","还息","2,000,000.00","2000-01-05"});
			tblContractIN.Rows.Add(new object[]{"梁长项目02","建设银行","还本","1,000,000.00","2000-02-05"});
			tblContractIN.Rows.Add(new object[]{"梁长项目02","建设银行","还本","500,000.00","2005-06-03"});
			tblContractIN.Rows.Add(new object[]{"垫忠项目03","开发银行","还息","5,000,000.00","2000-06-03"});
			dsContractMaintenance.EndInit();		

			return dsContractMaintenance;			
		}

		/// <summary>
		/// 与界面"上贷\还贷到期查询"相关的数据集
		/// </summary>
		/// <returns></returns>
		public static DataSet getMatureContractQRYDS()
		{
			DataSet dsMatureContractQRY = new DataSet("dsMatureContractQRY");
			DataColumn dataColumn1 = new DataColumn("贷款主体");
			DataColumn dataColumn2 = new DataColumn("合同编号");
			DataColumn dataColumn3 = new DataColumn("贷款银行");
			DataColumn dataColumn4 = new DataColumn("合同金额(本币)");
			DataColumn dataColumn5 = new DataColumn("到期金额");
			DataColumn dataColumn6 = new DataColumn("到期时间");			
			DataTable tblMatureContractQRY = new DataTable("tblMatureContractQRY");
			tblMatureContractQRY.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
																	  dataColumn4,dataColumn5,dataColumn6});
			dsMatureContractQRY.Tables.AddRange(new DataTable[]{tblMatureContractQRY});
			dsMatureContractQRY.BeginInit();
			tblMatureContractQRY.Rows.Add(new object[]{"高发公司","垫忠项目01","建设银行","7,000,000.00","1,000,000.00","2005-12-30"});	
			tblMatureContractQRY.Rows.Add(new object[]{"高发公司","长涪项目01","建设银行","4,000,000.00","1,000.000.00","2006-01-03"});
			tblMatureContractQRY.Rows.Add(new object[]{"高发公司","梁长项目02","地方国债","3,000,000.00","1,000,000.00","2006-02-08"});
			tblMatureContractQRY.Rows.Add(new object[]{"高发公司","垫忠项目03","开发银行","10,000,000.00","2,000,000.00","2006-03-21"});
			dsMatureContractQRY.BeginInit();

			return dsMatureContractQRY;		

		}
		/// <summary>
		/// 与界面"债务情况"相关 
		/// </summary>
		/// <returns></returns>
		public static DataSet getDebtInfoDS()
		{
			DataSet dsDebtInfo = new DataSet("dsDebtInfo");
			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 tblDebtInfo = new DataTable("tblDebtInfo");
			tblDebtInfo.Columns.AddRange(new DataColumn[]{dataColumn1,dataColumn2,dataColumn3,
															 dataColumn4,dataColumn5,dataColumn6,
															 dataColumn7});
			dsDebtInfo.Tables.AddRange(new DataTable[]{tblDebtInfo});

			dsDebtInfo.BeginInit();
			tblDebtInfo.Rows.Add(new object[]{"垫忠项目01","建设银行","6,000,000.00","2500,000.00","0.00",
												 "300,000,00","5500,000.00"});
			tblDebtInfo.Rows.Add(new object[]{"长涪项目02","工商银行","1,000,000.00","1,000,000.00","0.00",
												 "1,000,000.00", "2,000,000.00"});
			tblDebtInfo.Rows.Add(new object[]{"长涪项目01","建设银行","1,000,000.00","1,000,000.00","1,000,000.00","0",
												 "200,000,00"});
			tblDebtInfo.Rows.Add(new object[]{"梁长项目02","地方国债","1,000,000.00","3,000,000.00","2,500,000.00","1,500,000.00",
												 "1,000,000.00"});
			tblDebtInfo.Rows.Add(new object[]{"垫忠项目03","开发银行","1,000,000.00","1,000,000.00","5,000,000.00","4,000,000.00",
												 "1,000,000.00"});
			tblDebtInfo.Rows.Add(new object[]{"石忠项目01","中国银行","1,000,000.00","5,000,000.00","3,500,000.00","3,500,000.00",
												 "0"});
			dsDebtInfo.EndInit();	
	
			return dsDebtInfo;
			
		}

		/// <summary>