📄 publish.cs
字号:
return DbHelper.ExecuteReader(CommandType.Text, Sql, Param);
}
public DataTable GetSysUser(int topnum)
{
string Sql = "Select Top " + topnum + " [UserName],[RegTime] From [" + Pre + "sys_User] Where [isLock]=0 Order By [RegTime] Desc";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
public DataTable GetApiComm(int LoopNumber)
{
string Sql = "Select top " + LoopNumber + " [InfoID],[Commid],[Content],[creatTime],[DataLib] From [" + Pre + "API_commentary] Where [isRecyle]=0 And [islock]=0 And [isCheck]=0 Order By [creatTime] Desc";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
public string GetNewsTag(string newsid)
{
string Sql = "Select [Tags] From [" + Pre + "News] Where [NewsID]=@NewsID";
SqlParameter Param = new SqlParameter("@NewsID", newsid);
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
}
public void UpdateNewsIsHtml(string tablename, string ishtml, string idfield, IList<string> succeedlist)
{
SqlParameter[] sqlParams = new SqlParameter[4];
sqlParams[0] = new SqlParameter("@tableName", SqlDbType.VarChar, 30);
sqlParams[0].Value = tablename;
sqlParams[1] = new SqlParameter("@filedname", SqlDbType.VarChar, 30);
sqlParams[1].Value = ishtml;
sqlParams[2] = new SqlParameter("@idtype", SqlDbType.VarChar, 30);
sqlParams[2].Value = idfield;
for (int i = 0; i < succeedlist.Count; i++)
{
sqlParams[3] = new SqlParameter("@newsID", SqlDbType.VarChar, 12);
sqlParams[3].Value = succeedlist[i];
DbHelper.ExecuteNonQuery(CommandType.StoredProcedure, Pre + "publish_updateishtml", sqlParams);
}
}
public void UpdateCHNewsIsHtml(string tablename, string ishtml, string idfield, IList<string> succeedlist)
{
SqlParameter[] sqlParams = new SqlParameter[4];
sqlParams[0] = new SqlParameter("@tableName", SqlDbType.VarChar, 30);
sqlParams[0].Value = tablename;
sqlParams[1] = new SqlParameter("@filedname", SqlDbType.VarChar, 30);
sqlParams[1].Value = ishtml;
sqlParams[2] = new SqlParameter("@idtype", SqlDbType.VarChar, 30);
sqlParams[2].Value = idfield;
for (int i = 0; i < succeedlist.Count; i++)
{
sqlParams[3] = new SqlParameter("@ID", SqlDbType.Int, 4);
sqlParams[3].Value = int.Parse(succeedlist[i]);
DbHelper.ExecuteNonQuery(CommandType.StoredProcedure, Pre + "publish_CHupdateishtml", sqlParams);
}
}
public IDataReader GetDiscussInfo(string grouptype, int TopNumber)
{
string Sql;
switch (grouptype)
{
case "hot":
Sql = "Select top " + TopNumber + " [DisID],[Cname],[Creatime],((Select Count([Id]) From [" + Pre + "User_DiscussMember] Where [" + Pre + "User_DiscussMember].[DisID]=[" + Pre + "User_Discuss].[DisID])+Browsenumber) As Cnt1 From [" + Pre + "User_Discuss] Order By Cnt1 Desc";
break;
case "click":
Sql = "Select top " + TopNumber + " [DisID],[Cname],[Creatime],[Browsenumber] From [" + Pre + "User_Discuss] Order By [Browsenumber] Desc";
break;
case "Mmore":
Sql = "Select top " + TopNumber + " [DisID],[Cname],[Creatime],(Select Count([Id]) From [" + Pre + "User_DiscussMember] Where [" + Pre + "User_DiscussMember].[DisID]=[" + Pre + "User_Discuss].[DisID]) As Cnt1 From [" + Pre + "User_Discuss] Order By Cnt1 Desc";
break;
case "Last":
Sql = "Select top " + TopNumber + " [DisID],[Cname],[Creatime] From [" + Pre + "User_Discuss] Order By [Creatime] Desc";
break;
default:
Sql = "Select top " + TopNumber + " [DisID],[Cname],[Creatime] From [" + Pre + "User_Discuss] Order By [Creatime] Desc";
break;
}
return DbHelper.ExecuteReader(CommandType.Text, Sql, null);
}
public string GetMetaContent(string id, string Str, int num)
{
string Sql = "";
switch (Str)
{
case "News":
if (num == 0)
Sql = "select top 1 Metakeywords from " + Pre + "news where NewsID=@ID";
else
Sql = "select top 1 Metadesc from " + Pre + "news where NewsID=@ID";
break;
case "Class":
if (num == 0)
Sql = "select top 1 MetaKeywords from " + Pre + "news_class where ClassID=@ID";
else
Sql = "select top 1 MetaDescript from " + Pre + "news_class where ClassID=@ID";
break;
case "Special":
Sql = "select top 1 SpecialCName from " + Pre + "news_special where SpecialID=@ID";
break;
}
if (Sql != "")
{
SqlParameter Param = new SqlParameter("@ID", id);
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
}
else
return "";
}
public string GetPageTitle(string id, string Str)
{
string Sql = "";
switch (Str)
{
case "News":
Sql = "select top 1 NewsTitle from " + Pre + "news where NewsID=@ID";
break;
case "Class":
Sql = "select top 1 ClassCName from " + Pre + "news_class where ClassID=@ID";
break;
case "Special":
Sql = "select top 1 SpecialCName from " + Pre + "news_special where SpecialID=@ID";
break;
}
if (Sql != "")
{
SqlParameter Param = new SqlParameter("@ID", id);
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
}
else
return "";
}
public IDataReader GetNewsFiles(string newsid)
{
string Sql = "select id,URLName,FileURL from " + Pre + "news_URL where [NewsID]=@NewsID order by orderid desc";
SqlParameter Param = new SqlParameter("@NewsID", newsid);
return DbHelper.ExecuteReader(CommandType.Text, Sql, Param);
}
public IDataReader GetPrePage(int id, string datalib, int num, string classid, int ChID)
{
if (ChID == 0)
{
string Sql = "select top 1 a.newsID,a.NewsTitle,a.SavePath,a.FileName,a.FileEXName,b.savepath as savepath1,b.SaveClassframe,a.isDelPoint from " + Pre + "news a," + Pre + "news_class b where a.id";
if (num == 0)
Sql += ">";
else
Sql += "<";
Sql += id + " and a.CLassID=@ClassID and a.ClassID=b.ClassID and a.NewsType<>2 and a.islock=0 and a.isRecyle=0 order by a.id desc";
SqlParameter Param = new SqlParameter("@ClassID", classid);
return DbHelper.ExecuteReader(CommandType.Text, Sql, Param);
}
else
{
string csql = "select top 1 a.id,a.Title,a.SavePath,a.FileName,b.SavePath as savepath1,a.isDelPoint from " + datalib + " a," + Pre + "sys_channelclass b where a.id";
if (num == 0)
csql += ">";
else
csql += "<";
csql += id + " and a.CLassID=@ID and a.ClassID=b.id and a.islock=0 order by a.id desc";
SqlParameter Param1 = new SqlParameter("@ID", int.Parse(classid));
return DbHelper.ExecuteReader(CommandType.Text, csql, Param1);
}
}
public IDataReader GetNewsInfoAndClassInfo(string NewsID, string DataLib)
{
string Sql = "select a.SavePath,a.FileName,a.FileEXName,a.NewsType,a.URLaddress,a.isDelPoint,b.SavePath as SavePath1,b.SaveClassframe from " + Pre + "news a," + Pre + "news_class b where a.NewsID=@NewsID and a.ClassID=b.ClassID and a.isLock=0 and a.isRecyle=0";
SqlParameter Param = new SqlParameter("@NewsID", NewsID);
return DbHelper.ExecuteReader(CommandType.Text, Sql, Param);
}
public int GetCommCount(string newsid, int td, int ChID)
{
string WhereStr = string.Empty;
if (ChID != 0)
{
WhereStr = " and ChID=" + ChID + "";
}
string Sql = "Select Count(ID) From [" + Pre + "api_commentary] Where [InfoID]=@NewsID and islock=0" + WhereStr;
if (td == 1)
{
Sql += " And DateDiff(Day,[creatTime] ,Getdate())=0";
}
SqlParameter Param = new SqlParameter("@NewsID", newsid);
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
}
public string GetStyleContent(string styleid)
{
string Sql = "select [Content] from " + Pre + "sys_LabelStyle where styleID=@styleID and isRecyle=0";
SqlParameter Param = new SqlParameter("@styleID", styleid);
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
}
public string GetCHStyleContent(int ID, int ChID)
{
string Sql = "select [styleContent] from " + Pre + "sys_channelstyle where id=@ID and isLock=0 and ChID=" + ChID + "";
SqlParameter Param = new SqlParameter("@ID", ID);
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
}
public IDataReader GetNaviShowClass(string parentid)
{
string Sql = "select [ClassID],[ClassCName],[ParentID],[ClassSaveRule],[SaveClassFrame],[SavePath],[isDelPoint] from " + Pre + "News_Class where ParentID=@ParentID and isLock=0 and isRecyle=0 and NaviShowtf=1 order by orderid desc,id desc";
SqlParameter Param = new SqlParameter("@ParentID", parentid);
return DbHelper.ExecuteReader(CommandType.Text, Sql, Param);
}
public DataTable Gethistory(int Numday)
{
string Sql = "select * from " + Pre + "old_news where DateDiff(Day,[creatTime] ,Getdate()) = " + Numday + " and isLock=0 and isRecyle=0 order by orderid desc,id desc";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
public DataTable GetTopLine(string newsid)
{
SqlParameter Param = null;
string Sql = "select top 1 NewsID,tl_SavePath from " + DBConfig.TableNamePrefix + "news_topline ";
if (newsid != null && newsid != "")
{
Sql += " where NewsID=@NewsID";
Param = new SqlParameter("@NewsID", newsid);
}
else
{
Sql += " order by Id desc";
}
return DbHelper.ExecuteTable(CommandType.Text, Sql, Param);
}
public DataTable GetPosition(string ID, int Num)
{
SqlParameter param = new SqlParameter("@ID", ID);
string sql = string.Empty;
if (Num == 0)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -