cproject.cs

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

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

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

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

		private static string InsertSql =
			" insert into tProject(ProjectName, EnglishName, ManagerNO) " +
			" values({0}, {1}, {2}) ";

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

		private static string UpdateSql =
			" update tProject set ProjectName={1}, EnglishName={2}, ManagerNO={3} " +
			" where ProjectID = {0} ";

		public static void Edit(int ProjectID, string ProjectName, string EnglishName, string ManagerNO)
		{
			CDO.Connect();
			CDO.Execute(String.Format(UpdateSql,
				CSql.Express(ProjectID),
				CSql.Express(ProjectName),
				CSql.Express(EnglishName),
				CSql.Express(ManagerNO)));
			CDO.Disconnect();
		}

		public static void End(int ProjectID)
		{
			CDO.Connect();
			CDO.Execute(String.Format("update tProject set Enabled = 0 where ProjectID = {0}",
				CSql.Express(ProjectID)));
			CDO.Disconnect();
		}
	}
}