DAL/T_worklog.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace SoftMVC.DAL
{
	/// <summary>
	/// 数据访问类:T_worklog
	/// </summary>
	public partial class T_worklog
	{
		public T_worklog()
		{}
		#region  BasicMethod



		/// <summary>
		/// 增加一条数据
		/// </summary>
		public void Add(SoftMVC.Model.T_worklog model)
		{
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into T_worklog(");
                strSql.Append("username,workcontent,worktime)");
                strSql.Append(" values (");
                strSql.Append("@username,@workcontent,@worktime)");
                SqlParameter[] parameters = {
					new SqlParameter("@username", SqlDbType.VarChar,200),
					new SqlParameter("@workcontent", SqlDbType.VarChar,300),
					new SqlParameter("@worktime", SqlDbType.DateTime)};
                parameters[0].Value = model.username;
                parameters[1].Value = model.workcontent;
                parameters[2].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                Utils.WriteLog(ex.Message, "T_worklog_Add");
            }
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(SoftMVC.Model.T_worklog model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update T_worklog set ");
			strSql.Append("compareid=@compareid,");
			strSql.Append("username=@username,");
			strSql.Append("workcontent=@workcontent,");
			strSql.Append("worktime=@worktime");
			strSql.Append(" where ");
			SqlParameter[] parameters = {
					new SqlParameter("@compareid", SqlDbType.Decimal,9),
					new SqlParameter("@username", SqlDbType.VarChar,200),
					new SqlParameter("@workcontent", SqlDbType.VarChar,300),