manmanage.cs

中国文章系统数据库设计, 数据库设计.

using System;
using System.Data;

namespace kmdsoft.Database
{
    /// <summary>
    /// 人员管理模块
    /// </summary>
    public class ManManage:kmdsoft.Database.DataEngine
    {
	    public ManManage()
	    {}

        /// <summary>
        /// 人员查询。得到一条或者全部。
        /// </summary>
        /// <param name="idclient"></param>
        /// <returns></returns>
        public DataSet user_quar_getinfo(string idclient)
        {
            //生成查询条件
            string strCom = " SELECT * FROM user_quar";
            if (idclient != "")
                strCom = " SELECT * FROM user_quar where idclient = '" + idclient + "'";

            return this.query_database(strCom, "user_quar");
        }

        /// <summary>
        /// 查询“人员管理”,返回满足条件的人员信息。
        /// </summary>
        /// <param name="strRgn"></param>
        /// <param name="strName"></param>
        /// <returns></returns>
        public DataSet user_quar_getlist(string strRgn, string strName)
        {
            //生成查询条件
            string strCom = "SELECT * FROM user_quar";
            if (strRgn != "")
            {
                if (strName != "")
                {
                    strCom += " WHERE rgnname LIKE '%" + strRgn + "%' and qname LIKE '%" + strName + "%'";
                }
                else
                {
                    strCom += " WHERE rgnname LIKE '%" + strRgn + "%'";
                }
            }
            else if (strName != "")
            {
                strCom += " WHERE qname LIKE '%" + strName + "%'";
            }

            return query_database(strCom, "user_quar");
        }


        /// <summary>
        /// 请求“删除数据”。成功返回真，失败返回假。
        /// </summary>
        /// <param name="idclient"></param>
        /// <returns></returns>
        public bool user_quar_delInfo(string idclient)
        {
            //要对DataSet进行校验
            return del_database("idclient", idclient, "user_quar");
        }

        /// <summary>
        /// 保存“人员管理”的数据。
        /// </summary>
        /// <param name="mDataSet"></param>
        /// <returns></returns>
        public bool user_quar_set(DataSet mDataSet)
        {
            //要对DataSet进行校验
            int falg = this.save_database(mDataSet, "user_quar");
            if (falg == 1)
            {
                return true;
            }
            return false;
        }
    }
}