DAL/Leave.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
namespace RM.DAL
{
    /// <summary>
    /// 数据访问类Leave
    /// </summary>
    public class Leave : Basic
    {
        #region 构造函数
        public Leave()
        {
            this.strPKName = "ID";
            this.strTableName = "rm_Leave";
        }
        #endregion

        #region 数据访问处理方法[自动生成].

        /// <summary>
        /// 将数据实体写入数据库.
        /// </summary>
        public bool Add(RM.Entity.Leave MyEntity)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("INSERT INTO " + this.strTableName + "(");
            strSql.Append("[Name],");
            strSql.Append("[Title],");
            strSql.Append("[Email],");
            strSql.Append("[Content],");
            strSql.Append("[IsPub],");
            strSql.Append("[CreateTime],");
            strSql.Append("[Operator]");
            strSql.Append(")VALUES(");
            strSql.Append("@Name,@Title,@Email,@Content,@IsPub,@CreateTime,@Operator)");
            RM.DataProvider.SqlDBO.SqlCmdParam[] MyParam = {
				MyDBO.CreateNewParam("@Name", SqlDbType.VarChar, MyEntity.Name),
				MyDBO.CreateNewParam("@Title", SqlDbType.VarChar, MyEntity.Title),
				MyDBO.CreateNewParam("@Email", SqlDbType.VarChar, MyEntity.Email),
				MyDBO.CreateNewParam("@Content", SqlDbType.VarChar, MyEntity.Content),
				MyDBO.CreateNewParam("@IsPub", SqlDbType.Bit, MyEntity.IsPub),
				MyDBO.CreateNewParam("@CreateTime", SqlDbType.SmallDateTime, MyEntity.CreateTime),
				MyDBO.CreateNewParam("@Operator", SqlDbType.VarChar, MyEntity.Operator)
			};
            bool result = false;
            if (MyDBO.ExecuteNonQuery(strSql.ToString(), MyParam) > 0)
            {
                result = true;
            }
            return result;
        }

        /// <summary>
        /// 将数据实体更新到数据库.
        /// </summary>
        public bool Update(RM.Entity.Leave MyEntity)
        {
            StringBuilder strSql = new StringBuilder();