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

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

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

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

    }
    public CCourse[] transferSqltoCourse(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        CCourse[] l_course = new CCourse[l_table.Rows.Count];
        for (int i = 0; i < l_course.Length; i++)
        {
            l_course[i] = new CCourse();
            l_course[i].CID = l_table.Rows[i]["CID"].ToString();
            l_course[i].CourseID = l_table.Rows[i]["CourseID"].ToString();
            l_course[i].CourseEngName = l_table.Rows[i]["CourseEngName"].ToString();
            l_course[i].CourseName = l_table.Rows[i]["CourseName"].ToString();
            l_course[i].Note = l_table.Rows[i]["Note"].ToString();
            l_course[i].fStyle = l_table.Rows[i]["fStyle"].ToString();

        }
        return l_course;

    }   
   
    public CCourse createCourse()
    {
        CCourse l_course = new CCourse();
        l_course.CID = CNumberGen.getNext(l_course.GetType().ToString(), getDBManager()).ToString("000");
        return l_course;
    
    }
    public CCourse[] getAll()
    {
        return transferSqltoCourse("SELECT * FROM Course");
    }
    public void update(CCourse p_course)
    {
        string l_str = "SELECT * FROM Course WHERE CourseID='" + p_course.CourseID + "'";
        DataTable l_table=getDBManager().queryBySql(l_str);
        if (l_table.Rows.Count == 0)
        {
            
            CMyAaron工具 l_tool = new CMyAaron工具();
            p_course.CourseEngName = " ";
            l_str = l_tool.自動新增Sql字串(p_course, "Course");
                      
        }
        else
        {
            CMyAaron工具 l_tool = new CMyAaron工具();
            l_str = l_tool.自動修改sql字串(p_course, "Course");
            l_str += " WHERE CourseID='" + p_course.CourseID + "'";        
        
        }
        getDBManager().executeBySql(l_str);
    }
    public void delete(CCourse p_course)
    {
        string l_str = "DELETE FROM Course WHERE CID='" + p_course.CID + "'";
        getDBManager().executeBySql(l_str);
    }
    public CCourse queryByCID(string p_str)
    {
        CCourse[] l_course=transferSqltoCourse("SELECT * FROM Course WHERE CID='"+p_str+"'");
        if (l_course.Length == 0)
        { return null; 
                }
        return l_course[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);

    }
    public CCourse queryByCourseID(string p_str)
    {
        CCourse[] l_course = transferSqltoCourse("SELECT * FROM Course WHERE CourseID='" + p_str + "'");
        if (l_course.Length == 0)
        {
            return null;
        }
        return l_course[0];
    }
   

}