ccourse教師factory.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>
/// CCourse教師Factory 的摘要描述
/// </summary>
public class CCourse教師Factory : CObjectFactory
{
    private CDbManager iv_DBmanager;
    public CCourse教師Factory(string p_str)
        : base(p_str)
    {

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

    }
    public CCourse教師[] transferSqlto課程教師(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        CCourse教師[] l_CourseTeachers = new CCourse教師[l_table.Rows.Count];
        for (int i = 0; i < l_CourseTeachers.Length; i++)
        {
            l_CourseTeachers[i] = new CCourse教師();
            l_CourseTeachers[i].CourseID = l_table.Rows[i]["CourseID"].ToString();
            l_CourseTeachers[i].Teacher = l_table.Rows[i]["Teacher"].ToString();
            l_CourseTeachers[i].Expert = l_table.Rows[i]["Expert"].ToString();
            l_CourseTeachers[i].TNote = l_table.Rows[i]["TNote"].ToString();
            l_CourseTeachers[i].Creator = l_table.Rows[i]["Creator"].ToString();  


        }
        return l_CourseTeachers;

    }
    public CCourse教師 createCourse教師()
    {
        CCourse教師 l_courseT = new CCourse教師();
        
        return l_courseT;

    }
    public CCourse教師[] getAll()
    {
        return transferSqlto課程教師("SELECT * FROM CourseTeacher");
    }
    public void update(CCourse教師 p_courseT)
    {
        string l_str = "SELECT * FROM CourseTeacher WHERE CourseID='" + p_courseT.CourseID + "' AND Teacher='"+p_courseT.Teacher+"'";
        DataTable l_table = getDBManager().queryBySql(l_str);
        if (l_table.Rows.Count == 0)
        {
            
            CMyAaron工具 l_tool = new CMyAaron工具();

            l_str = l_tool.自動新增Sql字串(p_courseT, "CourseTeacher");

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

        }
        getDBManager().executeBySql(l_str);
    }
    public void delete(CCourse教師 p_courseT)
    {
        string l_str = "DELETE FROM CourseTeacher WHERE CourseID='" + p_courseT.CourseID + "' AND Teacher='" + p_courseT.Teacher + "'";
        getDBManager().executeBySql(l_str);
    }
    public CCourse教師[] queryByCourseID(string p_courseID)
    {
        CCourse教師[] l_coursets = transferSqlto課程教師("SELECT * FROM CourseTeacher WHERE CourseID='" + p_courseID + "'");
        if (l_coursets.Length == 0)
        {
            return null;
        }
        return l_coursets;
    }
    public CCourse教師[] 課程講師搜尋(CCourse教師 p_ct)
    {

        CMyAaron工具 l_查詢 = new CMyAaron工具();
        l_查詢.TransferSqltoObject += this.transferSqlto課程教師;
        CCourse教師[] l_cts = (CCourse教師[])l_查詢.queryByObject(p_ct, "CourseTeacher", "CourseID", "Teacher");
        if (l_cts.Length == 0)
        {
            return null;
        }

        return l_cts;

    }
    public CCourse教師 queryByCourseIDAndTeacher(string p_courseID, string p_teacher)
    {
        CCourse教師[] l_coursets = transferSqlto課程教師("SELECT * FROM CourseTeacher WHERE CourseID='" + p_courseID + "' AND Teacher='" + p_teacher + "'");
        if (l_coursets.Length == 0)
        {
            return null;
        }
        return l_coursets[0];
    }
}