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 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 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;
}
//ɾ��һ������
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 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 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;
}
/// <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 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;
}
/// <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 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;
}
//ɾ��
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();
}
//�����ĵ�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 void DeleteAll(String cid)
{
DAO db = new DAO();
String sql = "Delete FROM JpColumnsStyle where cid=@cid ";
SqlParameter[] prams ={
db.MakeInParam("@cid", SqlDbType.VarChar, cid)
};
db.Execute(sql, prams);
db.Close();
}
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;
}
//��ȡָ����Ϣ
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 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;
}
/// <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 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 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
{
}
}
/// <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 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 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 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;
}
