cposition.cs

小型项目组用的工作日志记录系统

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

namespace WorkLog.Classes
{
	/// <summary>
	/// CPosition 的摘要说明。
	/// </summary>
	public class CPosition
	{
		public CPosition()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public static DataTable GetAll()
		{
			CDO.Connect();
			DataTable dt = CDO.GetDataTable("select * from tPosition");
			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["PositionName"].ToString(), dr["PositionID"].ToString()));
			}
		}

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

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

		private static string UpdateSql =
			" update tPosition set PositionName={1} " +
			" where PositionID = {0} ";

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