三层架构

最新推荐文章于 2021-10-21 20:50:37 发布

RuanJianRenAtMSN

最新推荐文章于 2021-10-21 20:50:37 发布

阅读量798

点赞数

文章标签： string dataset 工作 system class object

本文链接：https://blog.csdn.net/RuanJianRenAtMSN/article/details/1573456

版权

数据层

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace YuXiang.ManagementSoft.Data
{
    /// <summary>
    /// AdminDataSet ：
    /// 说明：此类必须继承BaseDataSet类
    /// </summary>
    /// <Author>叶荣</Author>
    /// <Date>2007-2-13</Date>
    public class AdminDataSet : BaseDataSet
    {
        public AdminDataSet()
        {
            BuildDataTables();
        }

        //构造数据集
        protected override void BuildDataTables()
        {
            //构造表
            DataTable TmpTable = new DataTable("T_Admin");
            DataColumnCollection mycolumns = TmpTable.Columns;

//参数意义依次为：字段名；数据类型；是否主键;是否有效
mycolumns.Add(new BaseDataColumn("ID", SqlDbType.Int, true, true));

mycolumns.Add(new BaseDataColumn("Jobnumber",SqlDbType.VarChar,false,true));

mycolumns.Add(new BaseDataColumn("name", SqlDbType.VarChar, false, true));

mycolumns.Add(new BaseDataColumn("Password", SqlDbType.VarChar, false, true));

mycolumns.Add(new BaseDataColumn("Department", SqlDbType.Int, false, true));

mycolumns.Add(new BaseDataColumn("WorkLevel", SqlDbType.Int, false, true));

mycolumns.Add(new BaseDataColumn("IP", SqlDbType.VarChar, false, true));

mycolumns.Add(new BaseDataColumn("Befrozen", SqlDbType.Int, false, true));

            //工作组
            mycolumns.Add(new BaseDataColumn("WorkingTeam", SqlDbType.Int, false, true));
            //产品类别
            mycolumns.Add(new BaseDataColumn("ProductType", SqlDbType.Int, false, true));

//正在执行的任务数
mycolumns.Add(new BaseDataColumn("TaskCount", SqlDbType.Int, false, true));

mycolumns.Add(new BaseDataColumn("Timer", SqlDbType.DateTime, false, true));

            //把表加入数据集中
            this.Tables.Add(TmpTable);
        }
    }
}

业务规则层

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using YuXiang.ManagementSoft.Data;
namespace YuXiang.ManagementSoft.BusinessRules
{
    public class AdminRule
    {
        //数据操作类的一个实例
        DBOperate myDBOperate;

StringBuilder SQL;

        public AdminRule()
  {
   myDBOperate = new DBOperate();
  }

        /// <summary>
        /// 获得最大的ＩＤ
        /// </summary>
        /// <returns></returns>
        public string GetMaxID()
        {
            SQL = new StringBuilder("SELECT MAX(ID) From T_Admin");

return myDBOperate.GetOneValue(SQL.ToString());
}

        /// <summary>
        /// 获得最大的ＩＤ
        /// </summary>
        /// <returns></returns>
        public int GetTaskCount(string strID)
        {
            SQL = new StringBuilder("SELECT TaskCount From T_Admin Where ID=");

SQL.Append(strID);

            return Convert.ToInt32(myDBOperate.GetOneValue(SQL.ToString()));
        }
        /// <summary>
        /// 获得所有MailServe服务接口数据集
        /// </summary>
        /// <returns>MailServe服务接口数集</returns>
        public DataSet GetAdminDataSet()
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

            //取得数据并返回
            if (myDBOperate.GetAllDataSet(myAdminDataSet))
            {
                return myAdminDataSet;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得所有MailServe服务接口数据集
        /// </summary>
        /// <returns>MailServe服务接口数集</returns>
        public DataSet GetAdminDataSet(int intID)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

            myDBOperate.WhereParam = " ID=" + Convert.ToString(intID);
            //取得数据并返回
            if (myDBOperate.GetAllDataSet(myAdminDataSet))
            {
                return myAdminDataSet;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得所有Admin指定ＩＤ的工作人员的名称
        /// </summary>
        /// <returns>Admin服务接口数集</returns>
        public string GetAdminName(int intID)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

            myDBOperate.WhereParam = " ID=" + Convert.ToString(intID);
            //取得数据并返回
            if (myDBOperate.GetAllDataSet(myAdminDataSet))
            {
                if (myAdminDataSet.Tables["T_Admin"].Rows.Count != 0)
                {

                    return myAdminDataSet.Tables["T_Admin"].Rows[0]["name"].ToString();
                }
                else
                {
                    return "";
                }
            }

                return "";

        }
        /// <summary>
        /// 根据工作人员ＩＤ获得产品类别ID
        /// </summary>
        /// <param name="intID">工作人员ＩＤ</param>
        /// <returns>产品类别ＩＤ</returns>
        public int GetAdminTypeID(int intID)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

                    return Convert.ToInt32(myAdminDataSet.Tables["T_Admin"].Rows[0]["ProductType"]);
                }
                else
                {
                    return 0;
                }
            }

return 0;

        }
        /// <summary>
        /// 根据工作人员名称获得登陆密码
        /// </summary>
        /// <returns>Admin服务接口数集</returns>
        public string GetAdminPassword(string strUserName)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

            myDBOperate.WhereParam = " name='" + strUserName + "'";
            //取得数据并返回
            if (myDBOperate.GetAllDataSet(myAdminDataSet))
            {
                if (myAdminDataSet.Tables["T_Admin"].Rows.Count != 0)
                {

                    return myAdminDataSet.Tables["T_Admin"].Rows[0]["Password"].ToString();
                }
                else
                {
                    return "";
                }
            }

return "";

        }
        /// <summary>
        /// 根据工作人员名称获得登陆密码
        /// </summary>
        /// <returns>Admin服务接口数集</returns>
        public string GetAdminID(string strUserName)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

                    return myAdminDataSet.Tables["T_Admin"].Rows[0]["ID"].ToString();
                }
                else
                {
                    return "0";
                }
            }

return "0";

        }
        /// <summary>
        /// 获得所有MailServe服务接口数据集
        /// </summary>
        /// <returns>MailServe服务接口数集</returns>
        public DataSet GetAdminDataSet(string strWhere)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

            myDBOperate.WhereParam = strWhere;
            //取得数据并返回
            if (myDBOperate.GetAllDataSet(myAdminDataSet))
            {
                return myAdminDataSet;
            }
            else
            {
                return null;
            }
        }
        public bool SearchAdmin(string strName)
        {
            //定义数据集
            AdminDataSet myAdminDataSet = new AdminDataSet();

myDBOperate.WhereParam = " Name='" + strName + "'";

            //取得数据并返回
            if (myDBOperate.GetAllDataSet(myAdminDataSet))
            {
                if (myAdminDataSet.Tables["T_Admin"].Rows.Count != 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }

                return false;
        }
    }
}

web层

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using YuXiang.ManagementSoft.BusinessRules;
using YuXiang.ManagementSoft.Data;

public partial class Admin_User_AddA : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            LoadDepartment();

            txtNumber.Text = GetJobNumber();
        }
    }

    #region 部门数据集装载
    private void LoadDepartment()
    {
        MenuCategoriesRule myMenuCategoriesRule = new MenuCategoriesRule();

dropBranch.DataSource = myMenuCategoriesRule.GetMenuCategoriesDataSet();

dropBranch.DataTextField = "CategoryName";

dropBranch.DataValueField = "DepartID";

        dropBranch.DataBind();
    }
    #endregion
    protected void Button1_Click(object sender, EventArgs e)
    {

AdminRule myAdminRule = new AdminRule();

        if (myAdminRule.SearchAdmin(txtUserName.Text.Trim()))
        {
            Response.Write("<script lauage=javascript>alert(/"已存在该工作人员添加失败!/");</script>");

            return;
        }
        DBOperate myDBOperate = new DBOperate();

AdminDataSet myAdminDataSet = new AdminDataSet();

DataRow Dr = myAdminDataSet.Tables["T_Admin"].NewRow();

Dr["JobNumber"] = txtNumber.Text;

Dr["name"] = txtUserName.Text.Trim();

Dr["Password"] = txtPassword.Text.Trim();

Dr["Department"] = dropBranch.SelectedValue;

Dr["WorkLevel"] = dropWorker.SelectedValue;

Dr["WorkingTeam"] = DropDownList1.SelectedValue;

// Dr["ProductType"] = dropProductType.SelectedValue;

myAdminDataSet.Tables["T_Admin"].Rows.Add(Dr);

        if (myDBOperate.Insert(myAdminDataSet))
        {
            Response.Write("<script lauage=javascript>alert(/"添加成功/");</script>");