using System;
using System.Data;
using System.Web.UI.WebControls;
using CFC;

namespace WorkLog.Classes
{
	/// <summary>
	/// CDept 的摘要說明。
	/// </summary>
	public class CDept
	{
		public CDept()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		public static DataTable GetAll()
		{
			CDO.Connect();
			DataTable dt = CDO.GetDataTable("select * from tDept");
			CDO.Disconnect();
			return dt;
		}

		public static void BindTo(DropDownList ddl)
		{
			DataTable dt = GetAll();
			ddl.Items.Clear();
			foreach (DataRow dr in dt.Rows)
			{
				ddl.Items.Add(new ListItem(dr["DeptName"].ToString(), dr["DeptID"].ToString()));
			}
		}

		private static string InsertSql =
			" insert into tDept(DeptName) " +
			" values({0}) ";

		public static void Insert(string DeptName)
		{
			CDO.Connect();
			CDO.Execute(String.Format(InsertSql, 
				CSql.Express(DeptName)));
			CDO.Disconnect();
		}

		private static string UpdateSql =
			" update tDept set DeptName={1} " +
			" where DeptID = {0} ";

		public static void Edit(int DeptID, string DeptName)
		{
			CDO.Connect();
			CDO.Execute(String.Format(UpdateSql,
				CSql.Express(DeptID),
				CSql.Express(DeptName)));
			CDO.Disconnect();
		}
	}
}