ccoursematerialfactory.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>
/// CCourseMaterialFactory 的摘要描述
/// </summary>
public class CCourseMaterialFactory : CObjectFactory
{
    private CDbManager iv_DBmanager;
    public CCourseMaterialFactory(string p_str)
        : base(p_str)
    {

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

    }
    public CCourseMaterial[] transferSqlto課程教材(string p_str)
    {
        DataTable l_table = getDBManager().queryBySql(p_str);
        CCourseMaterial[] l_CourseMaterials = new CCourseMaterial[l_table.Rows.Count];
        for (int i = 0; i < l_CourseMaterials.Length; i++)
        {
            l_CourseMaterials[i] = new CCourseMaterial();
            l_CourseMaterials[i].CourseID = l_table.Rows[i]["CourseID"].ToString();
            l_CourseMaterials[i].Material = l_table.Rows[i]["Material"].ToString();
            l_CourseMaterials[i].Author = l_table.Rows[i]["Author"].ToString();
            l_CourseMaterials[i].Publisher = l_table.Rows[i]["Publisher"].ToString();
            l_CourseMaterials[i].MNote = l_table.Rows[i]["MNote"].ToString();
            l_CourseMaterials[i].IID = l_table.Rows[i]["IID"].ToString();
            l_CourseMaterials[i].Creator = l_table.Rows[i]["Creator"].ToString();


        }
        return l_CourseMaterials;

    }
    public CCourseMaterial createCourse教材()
    {
        CCourseMaterial l_courseM = new CCourseMaterial();
        l_courseM.IID = CNumberGen.getNext(l_courseM.GetType().ToString(), getDBManager()).ToString("000");
        return l_courseM;

    }
    public CCourseMaterial[] getAll()
    {
        return transferSqlto課程教材("SELECT * FROM CourseMaterial");
    }
    public void update(CCourseMaterial p_courseM)
    {
        string l_str = "SELECT * FROM CourseMaterial WHERE IID='" + p_courseM.IID + "'";
        DataTable l_table = getDBManager().queryBySql(l_str);
        if (l_table.Rows.Count == 0)
        {

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

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

        }
        getDBManager().executeBySql(l_str);
    }
    public void delete(CCourseMaterial p_courseM)
    {
        string l_str = "DELETE FROM CourseMaterial WHERE IID='" + p_courseM.IID + "'";
        getDBManager().executeBySql(l_str);
    }
    public CCourseMaterial queryByIID(string p_str)
    {
        CCourseMaterial[] l_courseM = transferSqlto課程教材("SELECT * FROM CourseMaterial WHERE IID='" + p_str + "'");
       
        return l_courseM[0];
    }
    public CCourseMaterial[] 課程教材搜尋(CCourseMaterial p_cm)
    {

        CMyAaron工具 l_查詢 = new CMyAaron工具();
        l_查詢.TransferSqltoObject += this.transferSqlto課程教材;
        CCourseMaterial[] l_cms = (CCourseMaterial[])l_查詢.queryByObject(p_cm, "CourseMaterial", "CourseID", "Material");
        if (l_cms.Length == 0)
        {
            return null;
        }
       
        return l_cms;

    }
    public CCourseMaterial[] 檢查是否重覆(CCourseMaterial p_cm)
    {
        CMyAaron工具 l_tool = new CMyAaron工具();
        l_tool.TransferSqltoObject += this.transferSqlto課程教材;
        CCourseMaterial[] l_cms = (CCourseMaterial[])l_tool.checkByObject(p_cm, "CourseMaterial", "CourseID", "Material");
        if (l_cms.Length == 0)
        {
            return null;
        }

        return l_cms;
      
    }
  
}