public DataTable GetHits()
{
String sql = "Select * from JpHits order by hits_date desc";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sql);
return dt;
}
public JpColumns(string cid)
{
string sql = " select * from JpColumns ";
sql += " where cid = @cid ";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@cid",SqlDbType.VarChar,cid),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
if (dt.Rows.Count > 0)
{
this.cid = dt.Rows[0]["cid"].ToString();
this.cname = dt.Rows[0]["cname"].ToString();
this.tmp_col = dt.Rows[0]["tmp_col"].ToString();
this.tmp_art = dt.Rows[0]["tmp_art"].ToString();
this.online = dt.Rows[0]["online"].ToString();
this.hotpublish = dt.Rows[0]["hotpublish"].ToString();
this.pubtime = dt.Rows[0]["pubtime"].ToString();
this.seotitle = dt.Rows[0]["seotitle"].ToString();
this.seokeywords = dt.Rows[0]["seokeywords"].ToString();
this.seodescription = dt.Rows[0]["seodescription"].ToString();
this.pubhtmlpath = dt.Rows[0]["pubhtmlpath"].ToString();
this.ifhotnews = dt.Rows[0]["ifhotnews"].ToString();
this.csort = Int32.Parse(dt.Rows[0]["csort"].ToString());
this.shtml = dt.Rows[0]["shtml"].ToString();
this.rss = Int32.Parse(dt.Rows[0]["rss"].ToString());
this.newpic = dt.Rows[0]["newpic"].ToString();
this.newday = Int32.Parse(dt.Rows[0]["newday"].ToString());
}
}
public JpSite()
{
String sql = "Select * from JpSite";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
SiteName = dt.Rows[0]["SiteName"].ToString();
CompName = dt.Rows[0]["CompName"].ToString();
host = dt.Rows[0]["host"].ToString();
root = dt.Rows[0]["root"].ToString();
tel = dt.Rows[0]["tel"].ToString();
fax = dt.Rows[0]["fax"].ToString();
adminemail = dt.Rows[0]["adminemail"].ToString();
bah = dt.Rows[0]["bah"].ToString();
seo_indextitle = dt.Rows[0]["seo_indextitle"].ToString();
seo_indexkeyword = dt.Rows[0]["seo_indexkeyword"].ToString();
seo_indexdescription = dt.Rows[0]["seo_indexdescription"].ToString();
copyright = dt.Rows[0]["copyright"].ToString();
homepage = dt.Rows[0]["homepage"].ToString();
visitors = System.Int32.Parse(dt.Rows[0]["visitors"].ToString());
dbname = dt.Rows[0]["dbname"].ToString();
version = dt.Rows[0]["version"].ToString();
nwyuming = dt.Rows[0]["nwyuming"].ToString();
wwyuming = dt.Rows[0]["wwyuming"].ToString();
lan_big5 = dt.Rows[0]["lan_big5"].ToString();
}
}
public DataTable Getdocs()
{
String sql = " select * from HyQzwd ";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sql);
db.Close();
return dt;
}
public DataTable getActive(int count)
{
string cmdStr = " Select top " + count + " * from hy_activity where hy_ifsh='2' and hy_starttime <=getdate() and hy_endtime >=getdate() order by hy_addtime desc , hy_sort desc ";
DAO db = new DAO();
DataTable dt = db.GetDataTable(cmdStr);
db.Close();
db.Dispose();
return dt;
}
/// <summary>
/// ��ȡ�̳Ƿ����ĺû�
/// </summary>
/// <param name="count">��ȡ����������</param>
/// <returns></returns>
public DataTable getBetterGoods(int count)
{
String sqlSelect = " select top " + count + " * from hy_goods where (hy_cid = '006001001' or hy_cid='006002001' or hy_cid='006003001' or hy_cid='006004001') and hy_ifsh='2' order by hy_sort ";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sqlSelect);
db.Close();
db.Dispose();
return dt;
}
//�����ĵ�ID�õ���¼
public DataTable Getdocbyid(string id)
{
String sql = " select * from HyQzwd where id=@id ";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@id",SqlDbType.Int,System.Int32.Parse(id)),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
//获取指定信息
public DataTable Getdocbyid(Int32 id)
{
String sql = " select * from hy_news ";
sql += " where id = @id";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@id",SqlDbType.Int,id),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
//获取指定信息
public DataTable Getdocs(String orderby)
{
String sql = " select * from hy_news ";
sql += " @orderby ";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@orderby",SqlDbType.VarChar,orderby),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
//��ȡָ����Ϣ
public DataTable GetNewsbyaid(Int32 aid)
{
String sql = " select * from JpNews ";
sql += " where aid = @aid";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@aid",SqlDbType.Int,aid),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
public DataTable GetData(string strWhere)
{
String sql = " select * from hy_favorite where 1=1 ";
if (strWhere != "")
{
sql += strWhere;
}
DAO db = new DAO();
DataTable dt = db.GetDataTable(sql);
db.Close();
return dt;
}
/// <summary>
/// 根据手机号查询最新一条验证码
/// </summary>
/// <param name="hy_tel"></param>
/// <returns></returns>
public DataTable GetCodesByTel(string hy_tel)
{
String sql = " select top 1 * from hy_verifycode where hy_tel=@hy_tel ";
sql += " order by hy_addtime desc";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@hy_tel",SqlDbType.VarChar,hy_tel),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
public DataTable Getdocbyid(string id)
{
string sql = " select * from hy_fileatt where id=@id ";
DAO db = new DAO();
SqlParameter[] sqlparam = new SqlParameter[]
{
db.MakeInParam("@id", SqlDbType.VarChar, id)
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
db.Dispose();
return dt;
}
public JpPubHtml()
{
String sql = "Select * from JpPubHtml";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
id = dt.Rows[0]["id"].ToString();
pages = dt.Rows[0]["pages"].ToString();
days = dt.Rows[0]["days"].ToString();
status = dt.Rows[0]["status"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Request.QueryString["aid"] != null)
{
aid = this.Request.QueryString["aid"].ToString();
}
if (this.Request.QueryString["cid"] != null)
{
cid = this.Request.QueryString["cid"].ToString();
}
this.txtcid.Value = cid;
this.txtaid.Value = aid;
StringBuilder stringBuilder = new StringBuilder();
DAO db = new DAO();
//获得当前栏目名称
string sqlSelect = " select cid,cname from JpColumns where cid ='" + cid + "' ";
DataTable dt = db.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
this.lb_type.Text = dt.Rows[0]["cname"].ToString();
}
stringBuilder.Remove(0, stringBuilder.Length);
dt.Clear();
//获得当前文章内容
sqlSelect = " select * from JpArticle where aid ='" + aid + "' ";
dt = db.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
this.lb_time.Text = Convert.ToDateTime(dt.Rows[0]["crtime"].ToString()).ToString("yyyy-MM-dd HH:mm");
this.lb_title.Text = dt.Rows[0]["title"].ToString();
imgPath = dt.Rows[0]["indexdisplaypicpath"].ToString();
this.lb_article.Text = dt.Rows[0]["ht_content"].ToString();
}
stringBuilder.Remove(0, stringBuilder.Length);
dt.Clear();
}
//��ȡָ��������Ϣ
public DataTable GetDept(string deptid)
{
String sql = " select * from JpDepts ";
sql += " where deptid = @deptid";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@deptid",SqlDbType.VarChar,deptid),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
return dt;
}
public DataTable GetDocbyhyid(string hy_id)
{
String sql = " select * from hy_user ";
sql += " where hy_id = @hy_id";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@hy_id",SqlDbType.VarChar,hy_id),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
//����IP���ؽ��������˼���ͶƱ��Ϣ ls_date:yyyy-MM-dd��ʽ
public DataTable Getdocsbyip(int id, string ip)
{
String sql = " select * from JpVoteIP ";
sql += " where id = @id and ip = @ip and convert(char(10),addtime,120)=convert(char(10),getdate(),120) ";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@id",SqlDbType.Int,id),
db.MakeInParam("@ip",SqlDbType.VarChar,ip),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
//��ȡָ����Ϣ
public DataTable Getdocbyid(String id)
{
String sql = " select a.id,a.fid,a.recName,a.recTel,a.recEmail,a.recTime,a.recContent,a.recip,a.ispub,a.islook, ";
sql += " b.title,b.content,b.addTime,b.startTime,b.endTime,b.sort,b.by1,b.by2,b.by3,b.by4,b.by5,b.type,b.state,b.online";
sql += " from JpOpinionHF a,JpOpinion b where a.fid=b.id and a.id = @id ";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@id",SqlDbType.Int,id),
};
DataTable dt = db.GetDataTable(sql, sqlparam);
db.Close();
return dt;
}
public DataTable GetStyles(string tclass,String cid)
{
string sql = " select a.*,b.description+' '+a.url as thetxt from JpColumnsStyle a left join JpTemplate b on a.url=b.url where 1=1";
sql += " and a.tclass=@tclass ";
sql += " and cid=@cid ";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@tclass",SqlDbType.VarChar,tclass),
db.MakeInParam("@cid",SqlDbType.VarChar,cid)
};
DataTable dt = db.GetDataTable(sql, sqlparam);
return dt;
}
public JpForm(String ld_sno)
{
if (ld_sno == "")
{
sno = "";
cid = "";
aid = -1;
ip = "";
ht_content.Clear();
qdate = "";
adate = "";
//hits = 0;
publish = 0;
}
else
{
String sql = "Select * from JpForm where sno=@sno";
DAO db = new DAO();
SqlParameter[] prams ={
db.MakeInParam("@sno",SqlDbType.VarChar,ld_sno)
};
DataTable art = db.GetDataTable(sql, prams);
if (art.Rows.Count > 0)
{
sno = art.Rows[0]["sno"].ToString();
aid = Int32.Parse(art.Rows[0]["aid"].ToString());
cid = art.Rows[0]["cid"].ToString();
ip = art.Rows[0]["ip"].ToString();
qdate = art.Rows[0]["qdate"].ToString();
adate = art.Rows[0]["adate"].ToString();
//hits = Int32.Parse(art.Rows[0]["hits"].ToString());
publish = Int32.Parse(art.Rows[0]["publish"].ToString());
byte[] imagebin = (byte[])art.Rows[0]["xmlcontent"];
BinaryFormatter Formatter = new BinaryFormatter();
JpStream jpstream = new JpStream();
Stream stream = jpstream.BytesToStream(imagebin);
ht_content = (System.Collections.Hashtable)Formatter.Deserialize(stream);
stream.Close();
}
}
}
public JpTemplate(String turl)
{
string sql = " select * from JpTemplate ";
sql += " where url=@turl";
DAO db = new DAO();
SqlParameter[] sqlparam = {
db.MakeInParam("@turl",SqlDbType.VarChar,turl),
};
DataTable dturl = db.GetDataTable(sql, sqlparam);
if (dturl.Rows.Count > 0)
{
this.url = dturl.Rows[0]["url"].ToString();
this.tclass = dturl.Rows[0]["tclass"].ToString();
this.description = dturl.Rows[0]["description"].ToString();
}
}
public JpUsers(String userid)
{
string cmdStr = "";
cmdStr = "Select * from JpUsers where uid=@userid";
DAO db = new DAO();
SqlParameter[] prams ={
db.MakeInParam("@userid",SqlDbType.VarChar,userid)
};
DataTable dtuser = db.GetDataTable(cmdStr, prams);
if (dtuser.Rows.Count > 0)
{
this.uid = dtuser.Rows[0]["uid"].ToString();
this.uname = dtuser.Rows[0]["uname"].ToString();
this.deptid = dtuser.Rows[0]["deptid"].ToString();
this.usort = System.Int32.Parse(dtuser.Rows[0]["usort"].ToString());
this.pwd = dtuser.Rows[0]["pwd"].ToString();
this.createtime = dtuser.Rows[0]["createtime"].ToString();
}
}
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
}
if (this.Request.QueryString["id"] != null)
{
this.txtid.Value = this.Request.QueryString["id"].ToString(); //文档ID
}
TPortalClass.JpNewsBroke JpNewsBroke = new TPortalClass.JpNewsBroke();
//旧文档
if (this.txtop.Value == "modify")
{
DataTable dt = JpNewsBroke.Getdocbyid(int.Parse(this.txtid.Value));
if (dt.Rows.Count > 0)
{
this.txtid.Value = dt.Rows[0]["id"].ToString();
this.txthy_tel.Text = dt.Rows[0]["hy_tel"].ToString();
this.txthy_content.Text = dt.Rows[0]["hy_content"].ToString();
this.txthy_addtime.Text = Convert.ToDateTime(dt.Rows[0]["hy_addtime"].ToString()).ToString("yyyy-MM-dd");
this.txthy_sort.Text = dt.Rows[0]["hy_sort"].ToString();
}
}
else
{
TPortalClass.DAO db = new TPortalClass.DAO();
string sql = "select top 1 hy_sort from hy_news order by hy_sort desc ";
DataTable dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.txthy_sort.Text = (Convert.ToInt32(dt.Rows[0]["hy_sort"].ToString()) + 1).ToString();
}
else
{
this.txthy_sort.Text = "1";
}
}
}
/// <summary>
/// 获取
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="count">数据条数 0为不限条数</param>
/// <returns></returns>
public DataTable getData(string keyWord, int count)
{
string sqlSelect = "";
sqlSelect = " select ";
if (count != 0)
{
sqlSelect += " top " + count + " ";
}
sqlSelect += " * from hy_searchArt where 1=1 ";
if (keyWord != "")
{
sqlSelect += " and hy_title like '%" + keyWord + "%' ";
}
sqlSelect += " order by addTime desc ";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sqlSelect);
// DataTable dt = new DataTable();
db.Close();
db.Dispose();
return dt;
}
/// <summary>
/// ����
/// </summary>
/// <returns></returns>
public DataTable Getlog(String id)
{
string cmdStr = "";
DataTable dt = new DataTable();
cmdStr = "Select * from JpLog where ID = @ID ";
DAO db = new DAO();
SqlParameter[] prams ={
db.MakeInParam("@ID",SqlDbType.VarChar,id)
};
dt = db.GetDataTable(cmdStr, prams);
db.Close();
db.Dispose();
return dt;
}
/// <summary>
/// ��������
/// </summary>
/// <returns></returns>
public DataTable Getlogs_search(string date_s, string date_e)
{
string cmdStr = "";
cmdStr = "Select * from JpLog where 1=1 ";
if (date_s != "")
{
cmdStr += " and hy_createtime>='" + date_s + "' ";
}
if (date_e != "")
{
cmdStr += " and hy_createtime<='" + date_e + "' ";
}
cmdStr += " order by hy_createtime desc ";
DataTable dt = new DataTable();
DAO db = new DAO();
dt = db.GetDataTable(cmdStr);
db.Close();
db.Dispose();
return dt;
}
/// <summary>
/// ��������
/// </summary>
/// <returns></returns>
public DataTable Getlogs()
{
string cmdStr = "";
cmdStr = "Select * from JpLog order by hy_createtime desc ";
DataTable dt = new DataTable();
DAO db = new DAO();
dt = db.GetDataTable(cmdStr);
db.Close();
db.Dispose();
return dt;
}
//ȡ������ID
public string GetMaxID()
{
String MaxID = "";
String sql = " select max(Id) as maxid from JpCollect ";
DAO db = new DAO();
DataTable dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
MaxID = dt.Rows[0]["maxid"].ToString();
}
else
{
}
return MaxID;
}
/// <summary>
/// ��ʾ�ɼ��б�
/// </summary>
/// <returns></returns>
public DataTable Getcjlb()
{
DAO db = new DAO();
DataTable dt = new DataTable();
try
{
String sql = "SELECT * FROM JpCollect as a,JpColumns as b where a.ClassId = b.cid order by a.Id";
dt = db.GetDataTable(sql);
}
catch
{
}
finally
{
db.Close();
db.Dispose();
}
return dt;
}
