cteacherfactory.cs

来自「Teacher Manager System」· CS 代码 · 共 134 行

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;
using System.Collections;

/// <summary>
/// CTeacherFactory 的摘要描述
/// </summary>

public class CTeacherFactory : CObjectFactory
{
    private CDbManager iv_DBmanager;
    public CTeacherFactory(string p_str)
        : base(p_str)
    {

    }
    public CDbManager getDBManager()
    {
        if (iv_DBmanager == null)
        {
            iv_DBmanager = new CDbManager();
        }
        return iv_DBmanager;

    } 
   

    public CTeacher CreateTeacher()
    {
        CTeacher l_teacher = new CTeacher();
        
        return l_teacher;
   
    
    }
    public CTeacher[] getAll()
    {
        return transferSqltoTeacher("SELECT * FROM Teacher");
    
    }

    public CTeacher[] transferSqltoTeacher(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        CTeacher[] l_teacher=new CTeacher[l_table.Rows.Count];
        for (int i = 0; i < l_teacher.Length; i++)
        {
          l_teacher[i] =this.CreateTeacher();

          l_teacher[i].TeacherID=l_table.Rows[i]["TeacherID"].ToString();
          l_teacher[i].IdCardNo = l_table.Rows[i]["IdCardNo"].ToString();
          l_teacher[i].Name = l_table.Rows[i]["Name"].ToString();
          l_teacher[i].Email = l_table.Rows[i]["Email"].ToString();
          l_teacher[i].MPhone = l_table.Rows[i]["MPhone"].ToString();
          l_teacher[i].Sex = l_table.Rows[i]["Sex"].ToString();
          l_teacher[i].BirthDate = l_table.Rows[i]["BirthDate"].ToString();
          l_teacher[i].Degree = l_table.Rows[i]["Degree"].ToString();
          l_teacher[i].Comments = l_table.Rows[i]["Comments"].ToString();
          l_teacher[i].HPhone = l_table.Rows[i]["HPhone"].ToString();
          l_teacher[i].HFax = l_table.Rows[i]["HFax"].ToString();
          l_teacher[i].HAddr = l_table.Rows[i]["HAddr"].ToString();
          l_teacher[i].HZip = l_table.Rows[i]["HZip"].ToString();
          l_teacher[i].CompanyName = l_table.Rows[i]["CompanyName"].ToString();
          l_teacher[i].DeptName = l_table.Rows[i]["DeptName"].ToString();
          l_teacher[i].Title = l_table.Rows[i]["Title"].ToString();
          l_teacher[i].OPhone = l_table.Rows[i]["OPhone"].ToString();
          l_teacher[i].OFax = l_table.Rows[i]["OFax"].ToString();
          l_teacher[i].OAddr = l_table.Rows[i]["OAddr"].ToString();
          l_teacher[i].OZip = l_table.Rows[i]["OZip"].ToString();
          l_teacher[i].KeyinTime =l_table.Rows[i]["KeyinTime"].ToString();
          l_teacher[i].Creator = l_table.Rows[i]["Creator"].ToString();
        
        
        }
        return l_teacher;
    }


    public void Update(CTeacher p_teacher)
    {
        string l_str = "SELECT TeacherID FROM Teacher WHERE TeacherID='" + p_teacher.TeacherID + "'";
        DataTable l_table = getDBManager().queryBySql(l_str);
        if (l_table.Rows.Count==0)
        {

            CMyAaron工具 l_tool = new CMyAaron工具();
            l_str = l_tool.自動新增Sql字串(p_teacher, "Teacher");

        }
        else
        {
            CMyAaron工具 l_tool = new CMyAaron工具();
            l_str = l_tool.自動修改sql字串(p_teacher, "Teacher");
           l_str += " WHERE TeacherID='" + p_teacher.TeacherID + "'";

        }
        getDBManager().executeBySql(l_str);
        
        
        
    }
    public void Delete(CTeacher p_teacher)
    {
        string l_str = "DELETE FROM Teacher WHERE TeacherID='" + p_teacher.TeacherID + "'";
        getDBManager().executeBySql(l_str);


    }
    public CTeacher queryById(string p_strId)
    {
        CTeacher[] l_teachers
            = transferSqltoTeacher("Select * From Teacher WHERE TeacherID='" + p_strId + "'");
        if (l_teachers.Length == 0)
            return null;
        return l_teachers[0];

    }

    public void 刪除流水號(int p_int, object p_object)
    {
        String l_str = "UPDATE tTEMP SET fValue= " + (p_int - 2).ToString() + " WHERE fType='" + p_object.ToString() + "'";
        getDBManager().executeBySql(l_str);

    }
}