DAL/SysConfig.cs

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

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

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

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

        /// <summary>
        /// 将数据实体写入数据库.
        /// </summary>
        public bool Add(RM.Entity.SysConfig MyEntity)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("INSERT INTO " + this.strTableName + "(");
            strSql.Append("[Title],");
            strSql.Append("[Master],");
            strSql.Append("[Email],");
            strSql.Append("[Telephone],");
            strSql.Append("[Address],");
            strSql.Append("[CopyRight],");
            strSql.Append("[CharSet],");
            strSql.Append("[MailSender],");
            strSql.Append("[Sender],");
            strSql.Append("[ReplyTo],");
            strSql.Append("[UserName],");
            strSql.Append("[Password],");
            strSql.Append("[MailServer],");
            strSql.Append("[Remark]");
            strSql.Append(")VALUES(");
            strSql.Append("@Title,@Master,@Email,@Telephone,@Address,@CopyRight,@CharSet,@MailSender,@Sender,@ReplyTo,@UserName,@Password,@MailServer,@Remark)");
            RM.DataProvider.SqlDBO.SqlCmdParam[] MyParam = {
				MyDBO.CreateNewParam("@Title", SqlDbType.VarChar, MyEntity.Title),
				MyDBO.CreateNewParam("@Master", SqlDbType.VarChar, MyEntity.Master),
				MyDBO.CreateNewParam("@Email", SqlDbType.VarChar, MyEntity.Email),
				MyDBO.CreateNewParam("@Telephone", SqlDbType.VarChar, MyEntity.Telephone),
				MyDBO.CreateNewParam("@Address", SqlDbType.VarChar, MyEntity.Address),
				MyDBO.CreateNewParam("@CopyRight", SqlDbType.VarChar, MyEntity.CopyRight),
				MyDBO.CreateNewParam("@CharSet", SqlDbType.VarChar, MyEntity.CharSet),
				MyDBO.CreateNewParam("@MailSender", SqlDbType.VarChar, MyEntity.MailSender),
				MyDBO.CreateNewParam("@Sender", SqlDbType.VarChar, MyEntity.Sender),
				MyDBO.CreateNewParam("@ReplyTo", SqlDbType.VarChar, MyEntity.ReplyTo),
				MyDBO.CreateNewParam("@UserName", SqlDbType.VarChar, MyEntity.UserName),
				MyDBO.CreateNewParam("@Password", SqlDbType.VarChar, MyEntity.Password),
				MyDBO.CreateNewParam("@MailServer", SqlDbType.VarChar, MyEntity.MailServer),
				MyDBO.CreateNewParam("@Remark", SqlDbType.Text, MyEntity.Remark)
			};