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; }