listinfo.cs

企业管理信息化之财务管理系统

				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListHblx(System.Web.UI.WebControls.DropDownList theDDL)");
				LogService.Write ("在绑定货币类型时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************





		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定运输方式
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListYsfs(System.Web.UI.WebControls.DropDownList theDDL)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CSDM,CSMC From XTCS Where CSDM Like '10%'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				//声明并使用SqlCommand的ExecuteReader方法创建一个SqlDataReader对象的实例
				System.Data.SqlClient.SqlDataReader SqlDR = cmd.ExecuteReader();

				//将查询结果集与下拉列表框控件进行绑定
				theDDL.DataSource = SqlDR;
				theDDL.DataValueField = "CSDM";
				theDDL.DataTextField = "CSMC";
				theDDL.DataBind();

				//关闭数据库连接对象
				Connection.Close();
				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListYsfs(System.Web.UI.WebControls.DropDownList theDDL)");
				LogService.Write ("在绑定运输方式时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************



		


		
		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定信用级别类型
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListXyjblx(System.Web.UI.WebControls.DropDownList theDDL)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CSDM,CSMC From XTCS Where CSDM Like '18%'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				//声明并使用SqlCommand的ExecuteReader方法创建一个SqlDataReader对象的实例
				System.Data.SqlClient.SqlDataReader SqlDR = cmd.ExecuteReader();

				//将查询结果集与下拉列表框控件进行绑定
				theDDL.DataSource = SqlDR;
				theDDL.DataValueField = "CSDM";
				theDDL.DataTextField = "CSMC";
				theDDL.DataBind();

				//关闭数据库连接对象
				Connection.Close();
				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListYsfs(System.Web.UI.WebControls.DropDownList theDDL)");
				LogService.Write ("在绑定信用级别类型时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************





		

		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定供应商类型
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListGyslx(System.Web.UI.WebControls.DropDownList theDDL)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CSDM,CSMC From XTCS Where CSDM Like '19%'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				//声明并使用SqlCommand的ExecuteReader方法创建一个SqlDataReader对象的实例
				System.Data.SqlClient.SqlDataReader SqlDR = cmd.ExecuteReader();

				//将查询结果集与下拉列表框控件进行绑定
				theDDL.DataSource = SqlDR;
				theDDL.DataValueField = "CSDM";
				theDDL.DataTextField = "CSMC";
				theDDL.DataBind();

				//关闭数据库连接对象
				Connection.Close();
				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListGyslx(System.Web.UI.WebControls.DropDownList theDDL)");
				LogService.Write ("在绑定供应商类型时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************






		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定所有的机构简称
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListJg(System.Web.UI.WebControls.DropDownList theDDL)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select JGDM,JGJC From JGXX";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				//声明并使用SqlCommand的ExecuteReader方法创建一个SqlDataReader对象的实例
				System.Data.SqlClient.SqlDataReader SqlDR = cmd.ExecuteReader();

				//将查询结果集与下拉列表框控件进行绑定
				theDDL.DataSource = SqlDR;
				theDDL.DataValueField = "JGDM";
				theDDL.DataTextField = "JGJC";
				theDDL.DataBind();

				//关闭数据库连接对象
				Connection.Close();
				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListJg(System.Web.UI.WebControls.DropDownList theDDL)");
				LogService.Write ("在绑定机构简称时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************





		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定机构简称
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <param name="LimitFlag">限定标志，如果为真则显示状态正常的机构，为假则显示所有机构，同其重载方法</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListJg(System.Web.UI.WebControls.DropDownList theDDL, bool LimitFlag)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select JGDM,JGJC From JGXX";
			if(LimitFlag == true)
			{
				sql += " Where ZT = '0'";
			}
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				//声明并使用SqlCommand的ExecuteReader方法创建一个SqlDataReader对象的实例
				System.Data.SqlClient.SqlDataReader SqlDR = cmd.ExecuteReader();

				//将查询结果集与下拉列表框控件进行绑定
				theDDL.DataSource = SqlDR;
				theDDL.DataValueField = "JGDM";
				theDDL.DataTextField = "JGJC";
				theDDL.DataBind();

				//关闭数据库连接对象
				Connection.Close();
				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListJg(System.Web.UI.WebControls.DropDownList theDDL, bool LimitFlag)");
				LogService.Write ("在绑定机构简称时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************




		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定机构全称
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListJgmc(System.Web.UI.WebControls.DropDownList theDDL)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select JGDM,JGMC From JGXX";

			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				//声明并使用SqlCommand的ExecuteReader方法创建一个SqlDataReader对象的实例
				System.Data.SqlClient.SqlDataReader SqlDR = cmd.ExecuteReader();

				//将查询结果集与下拉列表框控件进行绑定
				theDDL.DataSource = SqlDR;
				theDDL.DataValueField = "JGDM";
				theDDL.DataTextField = "JGMC";
				theDDL.DataBind();

				//关闭数据库连接对象
				Connection.Close();
				return true;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("ListJgmc(System.Web.UI.WebControls.DropDownList theDDL)");
				LogService.Write ("在绑定机构全称时发生错误。");
				LogService.Write (e.Message);
				return false;
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	
	
		



		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 绑定机构全称
		/// </summary>
		/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
		/// <param name="LimitFlag">限定标志，如果为真则显示状态正常的机构，为假则显示所有机构，同其重载方法</param>
		/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
		/// **************************************************************************
		public static bool ListJgmc(System.Web.UI.WebControls.DropDownList theDDL, bool LimitFlag)
		{
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select JGDM,JGMC From JGXX";
			if(LimitFlag == true)
			{
				sql += " Where ZT = '0'";
			}

			cmd.CommandText = sql;