?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 OleDbHelper;
using System.Data.OleDb;
/// <summary>
/// GetContent 的摘要說明
/// </summary>
public class GetContent
{
    public OleDbDataReader GetCon()
    {
        OleDbHelper.OleDbHelper oledbhelper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            oledbhelper.RunCmd("select * from contact", out dr);
        }
        catch(Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);

    }
    public OleDbDataReader GetIntro()
    {
        OleDbHelper.OleDbHelper oledbhepler = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            oledbhepler.RunCmd("select * from about", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetNewsList(string ID)
    {
        OleDbHelper.OleDbHelper oledbhepler = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            oledbhepler.RunCmd("select * from product where id=" + ID, out dr);
        }
            catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetNewsImagesTop()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select top 1 * from product where pro_name='news' and img is not null order by id desc", out dr);

        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetNewsTop()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader drt;
        try
        {
            helper.RunCmd("select top 6 * from product where pro_name='news' order by id desc", out drt);

        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (drt);
    }
    public OleDbDataReader GetCases()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select top 4 * from product where pro_name='cases' order by id desc", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetProduct()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select top 4 * from product where pro_name='product'  order by id desc", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    //Gg
    public OleDbDataReader GetGg()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select  top 6 * from product where pro_name='gg'", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex); 
        }
        return (dr);
    }
    public OleDbDataReader GetLink()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select top 6 * from link", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetVote()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select * from VoteMaster", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetSinVote()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select * from vote", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader GetAddVote(string id)
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("update vote set VoteCount=VoteCount+1 where VoteID=" + id, out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader SetVote()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select * from vote order by VoteID desc", out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }
    public OleDbDataReader BindVote()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        helper.RunCmd("select * from vote order by VoteID asc", out dr);
        return (dr);
    }
    public OleDbDataReader Calculate()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        helper.RunCmd("select count(*) as co from product where pro_name='product'", out dr);
        return (dr);
    }
    public OleDbDataReader GetTDC()
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        helper.RunCmd("select * from title", out dr);
        return (dr);
    }
    //jobs_more
    public OleDbDataReader GetJobs(string ID)
    {
        OleDbHelper.OleDbHelper helper = new OleDbHelper.OleDbHelper();
        OleDbDataReader dr;
        try
        {
            helper.RunCmd("select * from product where id=" + ID, out dr);
        }
        catch (Exception ex)
        {
            SystemError.CreateErrorLog(ex.Message);
            throw new Exception(ex.Message, ex);
        }
        return (dr);
    }

}