c教材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>
/// C教材Factory 的摘要描述
/// </summary>
public class C教材Factory : CObjectFactory
{
    private CDbManager iv_DBmanager;
    public C教材Factory(string p_str)
        : base(p_str)
    {

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

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


        }
        return l_materials;

    }   
}