personinfo.cs

网上销售订单管理系统借助现代信息技术和管理理论

using System;
using System.Data;
using System.Configuration;
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 System.Data.SqlClient;


/// <summary>
/// PersonInfo 的摘要说明
/// </summary>
public class PersonInfo
{
    //==========================管理员信息==========================
    /// <summary>
    /// 判断管理员的登陆情况
    /// </summary>
    public static void Return_SessionPerson()
    { if (QueryString.Get_SessionPerson == null) { JScript.AlertAnd_Parent_Redirect("没有登陆或登陆超时！", "Default.aspx"); } }
    /// <summary>
    /// 验证管理员登陆
    /// </summary>
    /// <param name="AdminName">管理员帐户</param>
    /// <param name="AdminPwd">管理员密码</param>
    public void Check_Admin_Login(string AdminName, string AdminPwd)
    {
        string CmdTxt = "Select Count(*) From AdminInfo Where AdminName='" + AdminName + "' and AdminPwd='" + AdminPwd + "'";
        bool YesNo = Equals(new SqlDataBase().RunSqlReturn(CmdTxt), "1") ? true : false;
        if (YesNo)
        { HttpContext.Current.Session["Person"] = AdminName; HttpContext.Current.Response.Redirect("Index.aspx"); }
        else
        {
            JScript.GoHistory("登陆失败", -1);
        }
    }
    /// <summary>
    ///  检测用户名是否已经存在
    /// </summary>
    /// <param name="AdminName"></param>
    /// <returns></returns>
    public bool Check_Add_AdminName(string AdminName)
    {
        string CmdTxt = "Select Count(*) From AdminInfo Where AdminName='" + AdminName + "' ";
        return (Equals(new SqlDataBase().RunSqlReturn(CmdTxt), "1")) ? true : false;
    }
    /// <summary>
    /// 添加管理员
    /// </summary>
    /// <param name="AdminName">管理员帐户</param>
    /// <param name="AdminPwd">管理员密码</param>
    /// <param name="TypeName">帐户显示名称</param>
    public void Add_AdminInfo(string AdminName, string AdminPwd, string TypeName,string Flag)
    {
        if (Check_Add_AdminName(AdminName))
        { JScript.GoHistory("该帐户已经存在", -1); }
        else
        {
            string CmdTxt = "Insert into AdminInfo (AdminName,AdminPwd,TypeName,Flag) values ('" + AdminName + "','" + AdminPwd + "','" + TypeName + "','" + Flag + "')";
            bool YesNo = new SqlDataBase().RunSql_Return_Bool(CmdTxt);
            if (YesNo)
            { JScript.AlertAndRedirect("添加成功！", "Add_AdminPerson.aspx"); }
            else
            {
                JScript.GoHistory("Add_AdminPerson.aspx", -1);
            }
        }
    }
    /// <summary>
    /// 修改管理员
    /// </summary>
    /// <param name="AdminName">管理员帐户</param>
    /// <param name="AdminPwd">管理员密码</param>
    /// <param name="TypeName">帐户显示名称</param>
    public void Edit_AdminInfo(string AdminName, string AdminPwd, string TypeName,string Flag)
    {
        string CmdTxt = "Update AdminInfo Set AdminPwd='" + AdminPwd + "',TypeName='" + TypeName + "',Flag='" + Flag + "'  Where AdminName='" + AdminName + "'";
        new SqlDataBase().RunSql(CmdTxt);
    }
    /// <summary>
    /// 删除管理员
    /// </summary>
    /// <param name="AdminName">管理员名称</param>
    public void Del_AdminInfo(string AdminName)
    {
        string CmdTxt = "Delete AdminInfo  Where AdminName='" + AdminName + "'";
        new SqlDataBase().RunSql(CmdTxt);
    }
    /// <summary>
    /// 显示管理员列表
    /// </summary>
    /// <returns></returns>
    public DataSet Show_AdminInfo()
    {
        string CmdTxt = "Select * From AdminInfo";
        return new SqlDataBase().GetDs(CmdTxt);
    }
    /// <summary>
    /// 返回管理员的昵称
    /// </summary>
    /// <param name="AdminName"></param>
    /// <returns></returns>
    public string Return_TypeName(string AdminName)
    {
        string CmdTxt = "Select TypeName From AdminInfo Where AdminName='" + AdminName + "'";
        string ReturnTxt = "";
        SqlDataReader sdr = new SqlDataBase().GetDataReader(CmdTxt);
        if (sdr.Read())
        { ReturnTxt = sdr.GetString(0); }
        sdr.Close();
        sdr.Dispose();
        return ReturnTxt;
    }


}