/// <summary> /// ɾ�� /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; DAO db = new DAO(); try { String sql = "delete from JpStudents where uid=@uid "; SqlParameter[] sqlparam = { db.MakeInParam("@uid",SqlDbType.VarChar,uid), }; 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_favorite 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; }
/// <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 = "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; }
//ɾ��һ������ 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; }
/// <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> /// <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; }
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="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> /// ɾ����� /// 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; }
//ɾ����ɫ�е���Ա public bool Delete(string groupid,string uid) { bool ret = true; DAO db = new DAO(); try { String sql = " delete from JpGroupUser "; sql += " where groupid='" + groupid + "'"; sql += " and uid='" + uid + "'"; db.Execute(sql); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// ɾ������ /// </summary> /// <returns></returns> public bool DeleteByDate(String hits_date) { bool ret = true; String sql = "delete from JpHits where hits_date=@hits_date "; DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@hits_date",SqlDbType.VarChar,hits_date), }; try { db.Execute(sql, prams); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// ɾ������ /// </summary> /// <returns></returns> public bool DeleteById(String id) { bool ret = true; String sql = "delete from JpHits where id=@id "; DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@id",SqlDbType.VarChar,id), }; try { db.Execute(sql, prams); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// ɾ������ /// </summary> /// <returns></returns> public bool Delete() { bool ret = true; String sql = "delete from JpLog where ID=@ID "; DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@ID",SqlDbType.VarChar,ID), }; try { db.Execute(sql, prams); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <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; }
/// <summary> /// ���Ʋɼ� /// </summary> /// <returns></returns> public bool Copydoc() { bool ret = true; DAO db = new DAO(); try { string sql = "insert into JpCollect (ItemName,ClassId,WebEncode,WebName,WebUrl,ItemRemark,Script_Iframe"; sql += ",Script_Object,Script_Script,Script_Div,Script_Table,Script_Span,Script_Img,Script_Font"; sql += ",Script_A,Script_Html,IsSaveImg,IsDesc,CollecNum,ListUrl,ListStart"; sql += ",ListEnd,LinkStart,LinkEnd,TitleStart,TitleEnd,RemoveTitle,KeyWordStart"; sql += ",KeyWordEnd,DateStart,DateEnd,SourceStart,SourceEnd,ContentStart,ContentEnd"; sql += ",RemoveBodyStart,RemoveBodyEnd,NextPageRegex) values ("; sql += "@ItemName,@ClassId,@WebEncode,@WebName,@WebUrl,@ItemRemark,@Script_Iframe"; sql += ",@Script_Object,@Script_Script,@Script_Div,@Script_Table,@Script_Span,@Script_Img,@Script_Font"; sql += ",@Script_A,@Script_Html,@IsSaveImg,@IsDesc,@CollecNum,@ListUrl,@ListStart"; sql += ",@ListEnd,@LinkStart,@LinkEnd,@TitleStart,@TitleEnd,@RemoveTitle,@KeyWordStart"; sql += ",@KeyWordEnd,@DateStart,@DateEnd,@SourceStart,@SourceEnd,@ContentStart,@ContentEnd"; sql += ",@RemoveBodyStart,@RemoveBodyEnd,@NextPageRegex"; sql += ")"; SqlParameter[] sqlparam = { db.MakeInParam("@ItemName",SqlDbType.VarChar,ItemName), db.MakeInParam("@ClassId",SqlDbType.VarChar,ClassId), db.MakeInParam("@WebEncode",SqlDbType.VarChar,WebEncode), db.MakeInParam("@WebName",SqlDbType.VarChar,WebName), db.MakeInParam("@WebUrl",SqlDbType.VarChar,WebUrl), db.MakeInParam("@ItemRemark",SqlDbType.VarChar,ItemRemark), db.MakeInParam("@Script_Iframe",SqlDbType.Int,Script_Iframe), db.MakeInParam("@Script_Object",SqlDbType.Int,Script_Object), db.MakeInParam("@Script_Script",SqlDbType.Int,Script_Script), db.MakeInParam("@Script_Div",SqlDbType.Int,Script_Div), db.MakeInParam("@Script_Table",SqlDbType.Int,Script_Table), db.MakeInParam("@Script_Span",SqlDbType.Int,Script_Span), db.MakeInParam("@Script_Img",SqlDbType.Int,Script_Img), db.MakeInParam("@Script_Font",SqlDbType.Int,Script_Font), db.MakeInParam("@Script_A",SqlDbType.Int,Script_A), db.MakeInParam("@Script_Html",SqlDbType.Int,Script_Html), db.MakeInParam("@IsSaveImg",SqlDbType.Int,IsSaveImg), db.MakeInParam("@IsDesc",SqlDbType.Int,IsDesc), db.MakeInParam("@CollecNum",SqlDbType.Int,CollecNum), db.MakeInParam("@ListUrl",SqlDbType.VarChar,ListUrl), db.MakeInParam("@ListStart",SqlDbType.VarChar,ListStart), db.MakeInParam("@ListEnd",SqlDbType.VarChar,ListEnd), db.MakeInParam("@LinkStart",SqlDbType.VarChar,LinkStart), db.MakeInParam("@LinkEnd",SqlDbType.VarChar,LinkEnd), db.MakeInParam("@TitleStart",SqlDbType.VarChar,TitleStart), db.MakeInParam("@TitleEnd",SqlDbType.VarChar,TitleEnd), db.MakeInParam("@RemoveTitle",SqlDbType.VarChar,RemoveTitle), db.MakeInParam("@KeyWordStart",SqlDbType.VarChar,KeyWordStart), db.MakeInParam("@KeyWordEnd",SqlDbType.VarChar,KeyWordEnd), db.MakeInParam("@DateStart",SqlDbType.VarChar,DateStart), db.MakeInParam("@DateEnd",SqlDbType.VarChar,DateEnd), db.MakeInParam("@SourceStart",SqlDbType.VarChar,SourceStart), db.MakeInParam("@SourceEnd",SqlDbType.VarChar,SourceEnd), db.MakeInParam("@ContentStart",SqlDbType.VarChar,ContentStart), db.MakeInParam("@ContentEnd",SqlDbType.VarChar,ContentEnd), db.MakeInParam("@RemoveBodyStart",SqlDbType.VarChar,RemoveBodyStart), db.MakeInParam("@RemoveBodyEnd",SqlDbType.VarChar,RemoveBodyEnd), db.MakeInParam("@NextPageRegex",SqlDbType.VarChar,NextPageRegex), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// �IJɼ����ݲ��� /// </summary> /// <returns></returns> public bool UpdateCjnrcs() { bool ret = true; DAO db = new DAO(); try { String sql = "update JpCollect set State='0' 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; }
/// <summary> /// �IJɼ����� /// </summary> /// <returns></returns> public bool UpdateCjnr() { bool ret = true; DAO db = new DAO(); try { String sql = "update JpCollect set TitleStart=@TitleStart,TitleEnd=@TitleEnd,RemoveTitle=@RemoveTitle"; sql += ",KeyWordStart=@KeyWordStart,KeyWordEnd=@KeyWordEnd,DateStart=@DateStart,DateEnd=@DateEnd"; sql += ",SourceStart=@SourceStart,SourceEnd=@SourceEnd,ContentStart=@ContentStart,ContentEnd=@ContentEnd"; sql += ",RemoveBodyStart=@RemoveBodyStart,RemoveBodyEnd=@RemoveBodyEnd,NextPageRegex=@NextPageRegex"; sql += " where Id=@Id"; SqlParameter[] sqlparam = { db.MakeInParam("@Id",SqlDbType.Int,Id), db.MakeInParam("@TitleStart",SqlDbType.VarChar,TitleStart), db.MakeInParam("@TitleEnd",SqlDbType.VarChar,TitleEnd), db.MakeInParam("@RemoveTitle",SqlDbType.VarChar,RemoveTitle), db.MakeInParam("@KeyWordStart",SqlDbType.VarChar,KeyWordStart), db.MakeInParam("@KeyWordEnd",SqlDbType.VarChar,KeyWordEnd), db.MakeInParam("@DateStart",SqlDbType.VarChar,DateStart), db.MakeInParam("@DateEnd",SqlDbType.VarChar,DateEnd), db.MakeInParam("@SourceStart",SqlDbType.VarChar,SourceStart), db.MakeInParam("@SourceEnd",SqlDbType.VarChar,SourceEnd), db.MakeInParam("@ContentStart",SqlDbType.VarChar,ContentStart), db.MakeInParam("@ContentEnd",SqlDbType.VarChar,ContentEnd), db.MakeInParam("@RemoveBodyStart",SqlDbType.VarChar,RemoveBodyStart), db.MakeInParam("@RemoveBodyEnd",SqlDbType.VarChar,RemoveBodyEnd), db.MakeInParam("@NextPageRegex",SqlDbType.VarChar,NextPageRegex), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// �IJɼ��б����� /// </summary> /// <returns></returns> public bool UpdateCjlblj() { bool ret = true; DAO db = new DAO(); try { String sql = "update JpCollect set LinkStart=@LinkStart,LinkEnd=@LinkEnd"; sql += " where Id=@Id"; SqlParameter[] sqlparam = { db.MakeInParam("@Id",SqlDbType.Int,Id), db.MakeInParam("@LinkStart",SqlDbType.VarChar,LinkStart), db.MakeInParam("@LinkEnd",SqlDbType.VarChar,LinkEnd), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <summary> /// �IJɼ�������Ϣ /// </summary> /// <returns></returns> public bool UpdateCjjbxx() { bool ret = true; DAO db = new DAO(); try { String sql = "update JpCollect set ItemName=@ItemName,ClassId=@ClassId,WebEncode=@WebEncode"; sql += ",WebName=@WebName,WebUrl=@WebUrl,ItemRemark=@ItemRemark"; sql += ",Script_Iframe=@Script_Iframe,Script_Object=@Script_Object,Script_Script=@Script_Script"; sql += ",Script_Div=@Script_Div,Script_Table=@Script_Table,Script_Span=@Script_Span"; sql += ",Script_Img=@Script_Img,Script_Font=@Script_Font,Script_A=@Script_A"; sql += ",Script_Html=@Script_Html,IsSaveImg=@IsSaveImg,IsDesc=@IsDesc"; sql += ",CollecNum=@CollecNum where Id=@Id"; SqlParameter[] sqlparam = { db.MakeInParam("@Id",SqlDbType.Int,Id), db.MakeInParam("@ItemName",SqlDbType.VarChar,ItemName), db.MakeInParam("@ClassId",SqlDbType.VarChar,ClassId), db.MakeInParam("@WebEncode",SqlDbType.VarChar,WebEncode), db.MakeInParam("@WebName",SqlDbType.VarChar,WebName), db.MakeInParam("@WebUrl",SqlDbType.VarChar,WebUrl), db.MakeInParam("@ItemRemark",SqlDbType.VarChar,ItemRemark), db.MakeInParam("@Script_Iframe",SqlDbType.Int,Script_Iframe), db.MakeInParam("@Script_Object",SqlDbType.Int,Script_Object), db.MakeInParam("@Script_Script",SqlDbType.Int,Script_Script), db.MakeInParam("@Script_Div",SqlDbType.Int,Script_Div), db.MakeInParam("@Script_Table",SqlDbType.Int,Script_Table), db.MakeInParam("@Script_Span",SqlDbType.Int,Script_Span), db.MakeInParam("@Script_Img",SqlDbType.Int,Script_Img), db.MakeInParam("@Script_Font",SqlDbType.Int,Script_Font), db.MakeInParam("@Script_A",SqlDbType.Int,Script_A), db.MakeInParam("@Script_Html",SqlDbType.Int,Script_Html), db.MakeInParam("@IsSaveImg",SqlDbType.Int,IsSaveImg), db.MakeInParam("@IsDesc",SqlDbType.Int,IsDesc), db.MakeInParam("@CollecNum",SqlDbType.Int,CollecNum), }; 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 sql = "insert into JpCollect (ItemName,ClassId,WebEncode,WebName,WebUrl,ItemRemark,Script_Iframe"; sql += ",Script_Object,Script_Script,Script_Div,Script_Table,Script_Span,Script_Img,Script_Font"; sql += ",Script_A,Script_Html,IsSaveImg,IsDesc,CollecNum) values ("; sql += "@ItemName,@ClassId,@WebEncode,@WebName,@WebUrl,@ItemRemark,@Script_Iframe"; sql += ",@Script_Object,@Script_Script,@Script_Div,@Script_Table,@Script_Span,@Script_Img,@Script_Font"; sql += ",@Script_A,@Script_Html,@IsSaveImg,@IsDesc,@CollecNum"; sql += ")"; SqlParameter[] sqlparam = { db.MakeInParam("@ItemName",SqlDbType.VarChar,ItemName), db.MakeInParam("@ClassId",SqlDbType.VarChar,ClassId), db.MakeInParam("@WebEncode",SqlDbType.VarChar,WebEncode), db.MakeInParam("@WebName",SqlDbType.VarChar,WebName), db.MakeInParam("@WebUrl",SqlDbType.VarChar,WebUrl), db.MakeInParam("@ItemRemark",SqlDbType.VarChar,ItemRemark), db.MakeInParam("@Script_Iframe",SqlDbType.Int,Script_Iframe), db.MakeInParam("@Script_Object",SqlDbType.Int,Script_Object), db.MakeInParam("@Script_Script",SqlDbType.Int,Script_Script), db.MakeInParam("@Script_Div",SqlDbType.Int,Script_Div), db.MakeInParam("@Script_Table",SqlDbType.Int,Script_Table), db.MakeInParam("@Script_Span",SqlDbType.Int,Script_Span), db.MakeInParam("@Script_Img",SqlDbType.Int,Script_Img), db.MakeInParam("@Script_Font",SqlDbType.Int,Script_Font), db.MakeInParam("@Script_A",SqlDbType.Int,Script_A), db.MakeInParam("@Script_Html",SqlDbType.Int,Script_Html), db.MakeInParam("@IsSaveImg",SqlDbType.Int,IsSaveImg), db.MakeInParam("@IsDesc",SqlDbType.Int,IsDesc), db.MakeInParam("@CollecNum",SqlDbType.Int,CollecNum), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <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; }
/// <summary> /// �� /// </summary> /// <returns></returns> public bool Update() { bool ret = true; DAO db = new DAO(); try { JpArticle jpArticle = new JpArticle(); DataTable dt = new DataTable(); try { dt = jpArticle.GetArticleByaid(Convert.ToInt32(hy_aid)); } catch { } if (dt.Rows.Count > 0) { hy_bt = dt.Rows[0]["title"].ToString(); } String sql = " update hy_favorite "; sql += " set hy_uid = @hy_uid"; sql += " ,hy_aid = @hy_aid"; sql += " ,hy_addtime = @hy_addtime"; sql += " ,hy_bt = @hy_bt"; sql += " ,hy_cid = @hy_cid"; sql += " ,hy_sort = @hy_sort"; sql += " where id=@id "; SqlParameter[] sqlparam = { db.MakeInParam("@id",SqlDbType.Int,id), db.MakeInParam("@hy_uid",SqlDbType.VarChar,hy_uid), db.MakeInParam("@hy_aid",SqlDbType.VarChar,hy_aid), db.MakeInParam("@hy_addtime",SqlDbType.VarChar,hy_addtime), db.MakeInParam("@hy_bt",SqlDbType.VarChar,hy_bt), db.MakeInParam("@hy_cid",SqlDbType.VarChar,hy_cid), db.MakeInParam("@hy_sort",SqlDbType.Int,hy_sort), }; db.Execute(sql, sqlparam); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
/// <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 bool Insert() { bool ret = true; String sql = "insert into JpLog(ID,hy_createtime,hy_oppip,hy_opptype,hy_oppcontent,hy_oppuserid,hy_oppusername) values "; sql += "(@ID,@hy_createtime,@hy_oppip,@hy_opptype,@hy_oppcontent,@hy_oppuserid,@hy_oppusername) "; DAO db = new DAO(); SqlParameter[] prams ={ db.MakeInParam("@ID",SqlDbType.VarChar,ID), db.MakeInParam("@hy_createtime",SqlDbType.VarChar,hy_createtime), db.MakeInParam("@hy_oppip",SqlDbType.VarChar,hy_oppip), db.MakeInParam("@hy_opptype",SqlDbType.VarChar,hy_opptype), db.MakeInParam("@hy_oppcontent",SqlDbType.VarChar,hy_oppcontent), db.MakeInParam("@hy_oppuserid",SqlDbType.VarChar,hy_oppuserid), db.MakeInParam("@hy_oppusername",SqlDbType.VarChar,hy_oppusername), }; try { db.Execute(sql, prams); } catch { ret = false; } finally { db.Close(); db.Dispose(); } return ret; }
//���ں�̨ public DataTable SearchdocsByKey(string ls_where, string orderby, int page, int pageSize) { string tablename = " hy_favorite "; string lssearchif = " where 1=1 " + ls_where + " "; string cmdStr = " Select top " + pageSize + " * from " + tablename + lssearchif; cmdStr += " and id not in(select top " + (page - 1) * pageSize + " id "; cmdStr += " from " + tablename + lssearchif + orderby + " ) " + orderby; DAO db = new DAO(); DataTable dt = db.GetDataTable(cmdStr); 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; }
public int SearchdocsByKeyNum(string ls_where) { Int32 listnum = 0; string cmdStr = ""; string tablename = " hy_favorite "; cmdStr = "Select count(*) from " + tablename + " where 1=1 " + ls_where; DAO db = new DAO(); DataTable dt = db.GetDataTable(cmdStr); if (dt.Rows.Count > 0) { listnum = System.Int32.Parse(dt.Rows[0][0].ToString()); } db.Close(); db.Dispose(); return listnum; }