comboutil.cs

来自「工作流引擎」· CS 代码 · 共 48 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace WorkFlow.util
{
	/// <summary>
	/// ComboUtil 的摘要说明。
	/// </summary>
	public class ComboUtil
	{
		public ComboUtil()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static void getUserCombo(System.Windows.Forms.ComboBox userCombo)
		{
			using(SqlCommand cmd = MainForm.getConnection().CreateCommand())
			{
				cmd.CommandText = "select autoid,name from t_user where status=1";
				using(SqlDataReader reader = cmd.ExecuteReader())
				{
					while(reader.Read())
					{
						userCombo.Items.Add(new ComboItem(reader.GetString(1),reader.GetInt32(0)));
					}
				}
			}
		}
		public static void getDepCombo(System.Windows.Forms.ComboBox depCombo)
		{
			using(SqlCommand cmd = MainForm.getConnection().CreateCommand())
			{
				cmd.CommandText = "select autoid,depname from t_dep where status=0";
				using(SqlDataReader reader = cmd.ExecuteReader())
				{
					while(reader.Read())
					{
						depCombo.Items.Add(new ComboItem(reader.GetString(1),reader.GetInt32(0)));
					}
				}
			}
		}
	}
}