adminservice.cs

一个比较简单的

using System;
using System.Collections.Generic;
using System.Text;
using AssetsSystem.Dao;
using AssetsSystem.Sys;
using System.Data;
using AssetsSystem.Inc;
using System.Windows.Forms;

namespace AssetsSystem.Service
{
    public class AdminService
    {

        public Admin query(Admin admin)
        {
            DBManager db = new DBManager();
            db.open();
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("select top 1 id from admin where ");

            StringBuilder sql2 = new StringBuilder();
            if (!Util.haveText(admin.getId())&&!Util.haveText(admin.getName()))
            {
                return null;
            }

            if (Util.haveText(admin.getId()))
            {
                sql2.AppendFormat("id={0}",admin.getId());
            }

            if (Util.haveText(admin.getName()))
            {
                if (Util.haveText(sql.ToString())) sql2.AppendFormat(" and ");
                sql2.AppendFormat("name='{0}'", Util.HTMLcode(admin.getName()));
            }
            
            if (Util.haveText(admin.getPassword()))
            {
                if (Util.haveText(sql.ToString())) sql2.AppendFormat(" and ");
                sql2.AppendFormat("password='{0}'", MD5.md5(admin.getPassword()));
            }
            sql.Append(sql2);
            
            try
            {
                DataTable rs = db.SelectToDataTable(sql.ToString());
                if (rs.Rows.Count > 0)
                {
                    //登录成功
                    admin.setId(rs.Rows[0]["id"].ToString());
                    admin.setPassword(null);
                    return admin;
                }
                else
                {
                    return null;
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                return null;
            }
            finally
            {
                db.close();
            }
        }


        public int update(Admin admin)
        {
            DBManager db = new DBManager();
            try{
                StringBuilder sql = new StringBuilder();
                sql.AppendFormat("update admin set ");
                sql.AppendFormat("[name]='{0}',",admin.getName());
                sql.AppendFormat("[password]='{0}'", MD5.md5(admin.getPassword()));
                sql.AppendFormat(" where id={0}", admin.getId());
                db.open();
                try
                {
                    return db.ExecuteSQLNonquery(sql.ToString());
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.Message);
                    return 0;
                }
                

            }
            finally
            {
                db.close();
            }
        }
    }
}