?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>
/// 專長Factory 的摘要描述
/// </summary>
public class C專長Factory : CObjectFactory
{
    public C專長Factory(string p_str)
        : base(p_str)
    {

    }
    private CDbManager iv_dbmanager;
    private CDbManager getDBManager()
    {
        if(iv_dbmanager==null)
        {
            iv_dbmanager=new CDbManager();
        }
        return iv_dbmanager;
    
    }
    public C專長[] transferSqltoObject(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        C專長[] l_專長 = new C專長[l_table.Rows.Count];
        for (int i = 0; i < l_專長.Length; i++)
        {
            l_專長[i] = new C專長();
            l_專長[i].TeacherID = l_table.Rows[i]["TeacherID"].ToString();
            l_專長[i].SpecID = l_table.Rows[i]["SpecID"].ToString();
            l_專長[i].SpecName = l_table.Rows[i]["SpecName"].ToString();
            l_專長[i].Description = l_table.Rows[i]["Description"].ToString();
        }
        return l_專長;

    }
    public C專長[] getAll()
    {
        return transferSqltoObject("SELECT * FROM tSpecialTeacher");
    }
    public void delete(C專長 p_專長)
    {
        string l_str = "DELETE FROM tSpecialTeacher WHERE SpecID='" + p_專長.SpecID + "' AND TeacherID='" + p_專長.TeacherID + "'";
        getDBManager().executeBySql(l_str);
    }
    public void update(C專長 p_專長)
    {
        string l_str = "SELECT * FROM tSpecialTeacher WHERE TeacherID='" + p_專長.TeacherID + "'AND SpecID='"+p_專長.SpecID+"'";
        DataTable l_table = getDBManager().queryBySql(l_str);
        if (l_table.Rows.Count == 0)
        {

            l_str = "INSERT INTO tSpecialTeacher (";
            l_str += "TeacherID,";
            l_str += "SpecID,";
            l_str += "SpecName,";
            l_str += "Description";
            l_str += ") VALUES (";
            l_str += "'" + p_專長.TeacherID +"',";
            l_str += "'" + p_專長.SpecID + "',";
            l_str += "'" + p_專長.SpecName + "',";
            l_str += "'" + p_專長.Description + "'";
            l_str += ")";
        }
        else
        {
            l_str = "UPDATE tSpecialTeacher  SET ";
            l_str += "SpecName='" + p_專長.SpecName + "', ";
            l_str += "Description='" + p_專長.Description + "' ";
            l_str += " WHERE TeacherID='" + p_專長.TeacherID + "' AND SpecID='"+p_專長.SpecID+"'";

        }
        getDBManager().executeBySql(l_str);
    }
    public C專長 create專長()
    {
        C專長 l_專長 = new C專長();
        
        return l_專長;

    }

    public C專長[] query(C專長 p_專長)
    {
        CMyAaron工具 l_tool = new  CMyAaron工具();
        l_tool.TransferSqltoObject += this.transferSqltoObject;
        C專長[] l_專長s = (C專長[])l_tool.queryByObject(p_專長, "tSpecialTeacher", "TeacherID");

        return l_專長s;
    }

    public C專長[] show所有專長(C專長 p_專長)
    {
            CMyAaron工具 l_tool = new  CMyAaron工具();
            l_tool.TransferSqltoObject += this.transfer專長SqltoObject;
            C專長[] l_專長s = (C專長[])l_tool.queryByObject(p_專長, "Specialty");

        return l_專長s;
    }
    private C專長[] transfer專長SqltoObject(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        C專長[] l_專長 = new C專長[l_table.Rows.Count];
        for (int i = 0; i < l_專長.Length; i++)
        {
            l_專長[i] = new C專長();           
            l_專長[i].SpecID = l_table.Rows[i]["SpecID"].ToString();
            l_專長[i].SpecName = l_table.Rows[i]["SpecName"].ToString();
            l_專長[i].Description = l_table.Rows[i]["Description"].ToString();
        }
        return l_專長;

    }
    public C專長[] queryByTeacherID(string p_str)
    {
        C專長[] l_專長s = transferSqltoObject("SELECT * FROM tSpecialTeacher WHERE TeacherID='" + p_str + "'");
        return l_專長s;
    }
}