cpersonallog.cs

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

using System;
using System.Data;
using CFC;

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

		public static DataTable GetByUser(string UserNO)
		{
			CDO.Connect();
			DataTable dt = CDO.GetDataTable("select * from vPersonalLog where UserNO=" + CSql.Express(UserNO) + " order by LogDate desc");
			CDO.Disconnect();
			return dt;
		}

		public static DataTable GetByFilter(int DeptID, int ProjectID, DateTime FromLogDateID, DateTime ToLogDateID, string OrderBy)
		{
			CDO.Connect();
			String sql = "select * from vPersonalLog where ";
			sql += CSql.DateGreaterEqual("LogDate", FromLogDateID);
			sql += "and" + CSql.DateLessEqual("LogDate", ToLogDateID);
			if (DeptID != -1)
				sql += "and" + CSql.Equal("DeptID", "int", DeptID);
			if (ProjectID != -1)
				sql += "and" + CSql.Equal("ProjectID", "int", ProjectID);
			sql += " order by " + OrderBy;
			DataTable dt = CDO.GetDataTable(sql);
			CDO.Disconnect();
			return dt;
		}

		private static string InsertSql =
			" insert into tPersonalLog(UserNO, DeptID, LogDate, ProjectID, Target, Result, ManHour) " +
			" values({0}, {1}, {2}, {3}, {4}, {5}, {6}) ";

		public static void Insert(string UserNO, int DeptID, DateTime LogDate, int ProjectID, string Target, string Result, float ManHour)
		{
			CDO.Connect();
			CDO.Execute(String.Format(InsertSql, 
				CSql.Express(UserNO),
				CSql.Express(DeptID),
				CSql.Express(LogDate),
				CSql.Express(ProjectID),
				CSql.Express(Target),
				CSql.Express(Result),
				CSql.Express(ManHour)));
			CDO.Disconnect();
		}

		private static string UpdateSql =
			" update tPersonalLog set UserNO={1}, DeptID={2}, LogDate={3}, ProjectID={4}, Target={5}, Result={6}, ManHour={7} " +
			" where PersonalLogID={0}";

		public static void Edit(int PersonalLogID, string UserNO, int DeptID, DateTime LogDate, int ProjectID, string Target, string Result, float ManHour)
		{
			CDO.Connect();
			CDO.Execute(String.Format(UpdateSql, 
				CSql.Express(PersonalLogID),
				CSql.Express(UserNO),
				CSql.Express(DeptID),
				CSql.Express(LogDate),
				CSql.Express(ProjectID),
				CSql.Express(Target),
				CSql.Express(Result),
				CSql.Express(ManHour)));
			CDO.Disconnect();
		}

		private static string DeleteSql =
			" delete from tPersonalLog" +
			" where PersonalLogID={0}";

		public static void Delete(int PersonalLogID)
		{
			CDO.Connect();
			CDO.Execute(String.Format(DeleteSql, 
				CSql.Express(PersonalLogID)));
			CDO.Disconnect();
		}
	}
}