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