cuserfactory.cs

Teacher Manager System

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 tw.org.iii.crm.data;

/// <summary>
/// CLoginFactory 的摘要描述
/// </summary>
public class CUserFactory : CObjectFactory
{
	
    private CDbManager iv_DBmanager;
    public CUserFactory(string p_str)
        : base(p_str)
    {

    }
 
    public CUser[] transferSqltoLogin(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        CUser[] l_logins = new CUser[l_table.Rows.Count];
        for (int i = 0; i < l_logins.Length; i++)
        {
            l_logins[i] = new CUser();
            l_logins[i].USERNAME = l_table.Rows[i]["USERNAME"].ToString();
            l_logins[i].PASSWORD = l_table.Rows[i]["PASSWORD"].ToString();
           

        }
        return l_logins;

    }
    public CUser[] getAll()
    {
        return transferSqltoLogin("SELECT * FROM PASSWD");
    
    }
    public CUser getByUSERNAME(string p_str)
    {
        CUser[] l_users = transferSqltoLogin("SELECT * FROM PASSWD WHERE USERNAME='" + p_str + "'");
       if (l_users.Length == 0)
       {
           return null;
       }

       return l_users[0];
     
    
    }
}