//ɾ��һ������ public bool Delete() { bool ret = true; DAO db = new DAO(); try { string sql = " delete JpColumnRelations where cid=@cid and cid_relation=@cid_relation and relation=@relation "; SqlParameter[] sqlparam = { db.MakeInParam("@cid",SqlDbType.VarChar,cid), db.MakeInParam("@cid_relation",SqlDbType.VarChar,cid_relation), db.MakeInParam("@relation",SqlDbType.VarChar,relation), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
public bool Update() { bool ret = true; DAO db = new DAO(); try { String sql = "UPDATE JpPubHtml SET pages=@pages,days=@days,status=@status where id=@id"; SqlParameter[] sqlparam = { db.MakeInParam("@id",SqlDbType.VarChar,id), db.MakeInParam("@pages",SqlDbType.VarChar,pages), db.MakeInParam("@days",SqlDbType.VarChar,days), db.MakeInParam("@status",SqlDbType.VarChar,status), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// 插入 /// </summary> /// <returns></returns> public bool Insert() { bool ret = true; DAO db = new DAO(); try { String sqlInsert = " insert into hy_verifycode(hy_tel,hy_code,hy_addtime) values (@hy_tel,@hy_code,@hy_addtime)"; SqlParameter[] sqlparam = {db.MakeInParam("@hy_addtime",SqlDbType.DateTime,hy_addtime), db.MakeInParam("@hy_tel",SqlDbType.VarChar,hy_tel), db.MakeInParam("@hy_code",SqlDbType.VarChar,hy_code) }; db.Execute(sqlInsert, sqlparam); } catch (Exception ex) { throw ex; ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
public bool Insert() { bool ret = true; DAO db = new DAO(); try { string sql = " insert into JpPubHtml(id,pages,days,status) values (@id,@pages,@days,@status)"; SqlParameter[] sqlparam = { db.MakeInParam("@id",SqlDbType.VarChar,id), db.MakeInParam("@pages",SqlDbType.VarChar,pages), db.MakeInParam("@days",SqlDbType.VarChar,days), db.MakeInParam("@status",SqlDbType.VarChar,status), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// ɾ�� /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; DAO db = new DAO(); try { //��ɾ��ѡ�� String sql_option = "delete from JpVoteOptions where id=@id "; SqlParameter[] sqlparam_option = { db.MakeInParam("@id",SqlDbType.Int,id), }; db.Execute(sql_option, sqlparam_option); String sql = "delete from JpVote where id=@id "; SqlParameter[] sqlparam = { db.MakeInParam("@id",SqlDbType.Int,id), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
public void Delete(String cid,String tclass) { DAO db = new DAO(); String sql = "Delete FROM JpColumnsStyle where cid=@cid and tclass=@tclass "; SqlParameter[] prams ={ db.MakeInParam("@cid", SqlDbType.VarChar, cid), db.MakeInParam("@tclass", SqlDbType.VarChar, tclass) }; db.Execute(sql, prams); db.Close(); }
/// <summary> /// ɾ�� /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; DAO db = new DAO(); try { string sql = "delete from JpTemplate where url=@url "; SqlParameter[] sqlparam = { db.MakeInParam("@url",SqlDbType.VarChar,url), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// ɾ�� /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; DAO db = new DAO(); try { String sql = "delete from JpOpinionHF where id=@id "; SqlParameter[] sqlparam = { db.MakeInParam("@id",SqlDbType.Int,id), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
public bool DeleteImg(string id) { bool ret = true; DAO db = new DAO(); try { string sql = "delete from hy_fileatt where id=@id "; SqlParameter[] sqlparam = new SqlParameter[] { db.MakeInParam("@id", SqlDbType.VarChar, id) }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// ɾ����� /// </summary> /// <returns></returns> public bool DeleteAll(string uids) { bool ret = true; DAO db = new DAO(); try { String sql = "delete from JpStudents where @uid like '%,'+uid+',%'"; SqlParameter[] sqlparam = { db.MakeInParam("@uid",SqlDbType.VarChar,uids), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
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()); } }
//����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; }
/// <summary> /// ɾ�� /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; DAO db = new DAO(); try { String sql = "delete from JpDepts where deptid=@deptid "; SqlParameter[] sqlparam = { db.MakeInParam("@deptid",SqlDbType.VarChar,deptid), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// 删除 /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; DAO db = new DAO(); try { //先删除选项 String sql_option = "delete from hy_guidepage where id=@id "; SqlParameter[] sqlparam_option = { db.MakeInParam("@id",SqlDbType.Int,id), }; db.Execute(sql_option, sqlparam_option); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
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 void DeleteAll(String ids) { DAO db = new DAO(); String sql = "Delete FROM JpNews where @aids like '%,'+cast(aid as varchar(12))+',%'"; SqlParameter[] prams ={ db.MakeInParam("@aids", SqlDbType.VarChar, ids) }; db.Execute(sql, prams); db.Close(); }
public Int32 Insert() { try { String sql = "INSERT INTO JpNews(cid,kcid,title,subhead,content,authorid,author,status,crtime,modtime,pubtime,hits,GUID)"; sql += " VALUES(@cid,@kcid,@title,@subhead,@content,@authorid,@author,@status,getdate(),getdate(),getdate(),0,@GUID)"; GUID = System.Guid.NewGuid().ToString(); DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@cid",SqlDbType.VarChar,cid), db.MakeInParam("@kcid",SqlDbType.VarChar,kcid), db.MakeInParam("@title",SqlDbType.VarChar,title), db.MakeInParam("@subhead",SqlDbType.VarChar,subhead), db.MakeInParam("@content",SqlDbType.VarChar,content), db.MakeInParam("@authorid",SqlDbType.VarChar,authorid), db.MakeInParam("@author",SqlDbType.VarChar,author), db.MakeInParam("@status",SqlDbType.VarChar,status), db.MakeInParam("@GUID",SqlDbType.VarChar,GUID), }; db.Execute(sql, prams); db.Close(); sql = "Select aid from JpNews where GUID=@GUID"; SqlParameter[] prams1 ={ db.MakeInParam("@GUID",SqlDbType.VarChar,GUID), }; DataTable dt = db.GetDataTable(sql, prams1); if (dt.Rows.Count > 0) { this.aid = System.Int32.Parse(dt.Rows[0]["aid"].ToString()); } return aid; } catch { return -2; } finally { } }
//�����ĵ�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 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 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 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 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; }
/// <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 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; }
//��ȡָ����Ϣ 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 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 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 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(); } }
/// <summary> /// ɾ����� /// roleids��ʽ��,1111,2222,33333, /// </summary> /// <returns></returns> public bool DeleteAll(string roleids) { bool ret = true; String sql = "delete from JpRole where @hy_roleid like '%,'+hy_roleid+',%'"; DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@hy_roleid",SqlDbType.VarChar,roleids), }; try { db.Execute(sql, prams); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }