TrainSign.DAL/H_adminUserMain.cs

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

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

using System;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using TindWit.DBUtility;

namespace Maticsoft.DAL
{
    //H_adminUserMain
    public partial class H_adminUserMain
    {

        public bool Exists(int adminUserID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from H_adminUserMain");
            strSql.Append(" where ");
            strSql.Append(" adminUserID = @adminUserID  ");
            SqlParameter[] parameters = {
					new SqlParameter("@adminUserID", SqlDbType.Int,4)
			};
            parameters[0].Value = adminUserID;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }



        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.H_adminUserMain model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
            if (model.adminUserName != null)
            {
                strSql1.Append("adminUserName,");
                strSql2.Append("'" + model.adminUserName + "',");
            }
            if (model.adminUserPwd != null)
            {
                strSql1.Append("adminUserPwd,");
                strSql2.Append("'" + model.adminUserPwd + "',");
            }
            if (model.adminUserOrg != null)
            {
                strSql1.Append("adminUserOrg,");
                strSql2.Append("'" + model.adminUserOrg + "',");
            }
            if (model.adminUserDept != null)
            {
                strSql1.Append("adminUserDept,");
                strSql2.Append("'" + model.adminUserDept + "',");
            }
            if (model.adminUserPost != null)
            {
                strSql1.Append("adminUserPost,");