📄 contentmanage.cs
字号:
param[20] = new SqlParameter("@Content", SqlDbType.NText);
param[20].Value = uc.Content;
param[21] = new SqlParameter("@naviContent", SqlDbType.NVarChar, 255);
param[21].Value = uc.naviContent;
param[22] = new SqlParameter("@CreatTime", SqlDbType.DateTime, 8);
param[22].Value = uc.CreatTime;
param[23] = new SqlParameter("@SavePath", SqlDbType.NVarChar, 200);
param[23].Value = uc.SavePath;
param[24] = new SqlParameter("@FileName", SqlDbType.NVarChar, 100);
param[24].Value = uc.FileName;
param[25] = new SqlParameter("@FileEXName", SqlDbType.NVarChar, 6);
param[25].Value = uc.FileEXName;
param[26] = new SqlParameter("@ContentPicTF", SqlDbType.TinyInt, 1);
param[26].Value = uc.ContentPicTF;
param[27] = new SqlParameter("@ContentPicURL", SqlDbType.NVarChar, 200);
param[27].Value = uc.ContentPicURL;
param[28] = new SqlParameter("@ContentPicSize", SqlDbType.NVarChar, 10);
param[28].Value = uc.ContentPicSize;
param[29] = new SqlParameter("@CommTF", SqlDbType.TinyInt, 1);
param[29].Value = uc.CommTF;
param[30] = new SqlParameter("@DiscussTF", SqlDbType.TinyInt, 1);
param[30].Value = uc.DiscussTF;
param[31] = new SqlParameter("@TopNum", SqlDbType.Int, 4);
param[31].Value = uc.TopNum;
param[32] = new SqlParameter("@VoteTF", SqlDbType.TinyInt, 1);
param[32].Value = uc.VoteTF;
param[33] = new SqlParameter("@NewsPicTopline", SqlDbType.TinyInt, 1);
param[33].Value = uc.NewsPicTopline;
param[34] = new SqlParameter("@CheckStat", SqlDbType.NVarChar, 10);
param[34].Value = uc.CheckStat;
param[35] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
param[35].Value = uc.isLock;
param[36] = new SqlParameter("@isRecyle", SqlDbType.TinyInt, 1);
param[36].Value = uc.isRecyle;
param[37] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[37].Value = uc.SiteID;
param[38] = new SqlParameter("@DataLib", SqlDbType.NVarChar, 20);
param[38].Value = uc.DataLib;
param[39] = new SqlParameter("@DefineID", SqlDbType.TinyInt, 1);
param[39].Value = uc.DefineID;
param[40] = new SqlParameter("@isVoteTF", SqlDbType.TinyInt, 1);
param[40].Value = uc.isVoteTF;
param[41] = new SqlParameter("@Editor", SqlDbType.NVarChar, 18);
param[41].Value = uc.Editor;
param[42] = new SqlParameter("@isHtml", SqlDbType.TinyInt, 1);
param[42].Value = uc.isHtml;
param[43] = new SqlParameter("@Click", SqlDbType.Int, 4);
param[43].Value = uc.Click;
param[44] = new SqlParameter("@isDelPoint", SqlDbType.TinyInt, 1);
param[44].Value = uc.isDelPoint;
param[45] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
param[45].Value = uc.Gpoint;
param[46] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
param[46].Value = uc.iPoint;
param[47] = new SqlParameter("@GroupNumber", SqlDbType.NText);
param[47].Value = uc.GroupNumber;
param[48] = new SqlParameter("@Metakeywords", SqlDbType.NVarChar, 200);
param[48].Value = uc.Metakeywords;
param[49] = new SqlParameter("@Metadesc", SqlDbType.NVarChar, 200);
param[49].Value = uc.Metadesc;
param[50] = new SqlParameter("@isFiles", SqlDbType.TinyInt, 1);
param[50].Value = uc.isFiles;
param[51] = new SqlParameter("@vURL", SqlDbType.NVarChar, 200);
param[51].Value = uc.vURL;
return param;
#endregion
}
public DataTable sel_infoByStr(string NewsID, string Datatb, int flag)
{
#region
string Sql = null;
SqlParameter param = null;
if (flag == 0)
{
Sql = "select NewsID from " + Datatb + " where NewsID='" + NewsID + "' order by id desc";
}
else if (flag == 1)
{
param = new SqlParameter("@NewsID", NewsID);
Sql = "select URLName,id,FileURL,OrderID from " + Pre + "news_URL where NewsID=@NewsID and DataLib='" + Datatb + "'";
}
else if (flag == 2)
{
Sql = "select voteNum,NewsID,voteContent,ismTF,isMember,SiteID,isTimeOutTime from " + Pre + "news_vote where NewsID='" + NewsID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "' and DataLib='" + Datatb + "'";
}
else if (flag == 3)
{
Sql = "select Id,NewsID,NewsTitle from " + NewsID + " where Id in ('" + Datatb + "')";
}
else if (flag == 4)
{
Sql = "select id from " + NewsID + " where ClassID='" + Datatb + "'";
}
else if (flag == 5)
{
Sql = "select PicURL,SPicUrl from " + Datatb + " where Id='" + NewsID + "'";
}
else if (flag == 6)
{
Sql = "Select NewsTitle From " + Pre + "News where NewsID='" + Datatb + "'";
}
return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
#endregion
}
/// <summary>
/// 插入子新闻
/// </summary>
/// <param name="uc2"></param>
public void insertSubNewsContent(string NewsID, string getNewsID, string NewsTitle, string DataLib, string TitleColor, int TitleBTF, int TitleITF, int colsNum)
{
string Sql = "insert into " + Pre + "news_sub(";
Sql += "NewsID,getNewsID,NewsTitle,DataLib,TitleColor,TitleBTF,TitleITF,colsNum,SiteID";
Sql += ") values (";
Sql += "'" + NewsID + "','" + getNewsID + "','" + NewsTitle + "','" + DataLib + "','" + TitleColor + "'," + TitleBTF + "," + TitleITF + "," + colsNum + ",'" + NetCMS.Global.Current.SiteID + "')";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
}
/// <summary>
/// 插入头条
/// </summary>
/// <param name="uc2"></param>
public void addUpdate_TT(NetCMS.Model.NewsContentTT uc, int flag)
{
#region
string Sql = null;
if (flag == 0)
{
Sql = "insert into " + Pre + "news_topline(";
Sql += "NewsTF,NewsID,DataLib,tl_font,tl_style,tl_size,tl_color,tl_space,tl_PicColor,tl_SavePath,Creattime,tl_Title,tl_Width,SiteID";
Sql += ") values (";
Sql += "@NewsTF,@NewsID,@DataLib,@tl_font,@tl_style,@tl_size,@tl_color,@tl_space,@tl_PicColor,@tl_SavePath,@Creattime,@tl_Title,@tl_Width,@SiteID)";
}
else if (flag == 1)
{
Sql = "update " + Pre + "news_topline set NewsTF=@NewsTF,NewsID=@NewsID,DataLib=@DataLib,tl_font=@tl_font,tl_style=@tl_style,tl_size=@tl_size,tl_color=@tl_color,tl_space=@tl_space,tl_PicColor=@tl_PicColor,tl_SavePath=@tl_SavePath,Creattime=@Creattime,tl_Title=@tl_Title,tl_Width=@tl_Width,SiteID=@SiteID where NewsID='" + uc.NewsID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
}
SqlParameter[] parm = intsertTTParameters(uc);
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
#endregion
}
/// <summary>
/// 获取NewsContentTT构造
/// </summary>
/// <param name="uc"></param>
/// <returns></returns>
private SqlParameter[] intsertTTParameters(NetCMS.Model.NewsContentTT uc)
{
#region
SqlParameter[] param = new SqlParameter[14];
param[0] = new SqlParameter("@NewsTF", SqlDbType.TinyInt, 1);
param[0].Value = uc.NewsTF;
param[1] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
param[1].Value = uc.NewsID;
param[2] = new SqlParameter("@DataLib", SqlDbType.NVarChar, 50);
param[2].Value = uc.DataLib;
param[3] = new SqlParameter("@tl_font", SqlDbType.NVarChar, 20);
param[3].Value = uc.tl_font;
param[4] = new SqlParameter("@tl_style", SqlDbType.TinyInt, 1);
param[4].Value = uc.tl_style;
param[5] = new SqlParameter("@tl_size", SqlDbType.TinyInt, 1);
param[5].Value = uc.tl_size;
param[6] = new SqlParameter("@tl_color", SqlDbType.NVarChar, 8);
param[6].Value = uc.tl_color;
param[7] = new SqlParameter("@tl_space", SqlDbType.TinyInt, 1);
param[7].Value = uc.tl_space;
param[8] = new SqlParameter("@tl_PicColor", SqlDbType.NVarChar, 8);
param[8].Value = uc.tl_PicColor;
param[9] = new SqlParameter("@tl_SavePath", SqlDbType.NVarChar, 220);
param[9].Value = uc.tl_SavePath;
param[10] = new SqlParameter("@Creattime", SqlDbType.DateTime, 8);
param[10].Value = uc.Creattime;
param[11] = new SqlParameter("@tl_Title", SqlDbType.NVarChar, 150);
param[11].Value = uc.tl_Title;
param[12] = new SqlParameter("@tl_Width", SqlDbType.Int, 4);
param[12].Value = uc.tl_Width;
param[13] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[13].Value = uc.SiteID;
return param;
#endregion
}
/// <summary>
/// 插入附件
/// </summary>
/// <param name="NewsID"></param>
/// <param name="DataLib"></param>
/// <param name="FileURL"></param>
/// <param name="OrderID"></param>
public void insertFileURL(string URLName, string NewsID, string DataLib, string FileURL, int OrderID)
{
string Sql = "insert into " + Pre + "news_URL(";
Sql += "URLName,NewsID,DataLib,FileURL,CreatTime,OrderID";
Sql += ") values (";
Sql += "'" + URLName + "','" + NewsID + "','" + DataLib + "','" + FileURL + "','" + DateTime.Now + "'," + OrderID + ")";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
}
/// <summary>
/// 更新附件文件地址
/// </summary>
/// <param name="URLName"></param>
/// <param name="DataLib"></param>
/// <param name="FileURL"></param>
/// <param name="OrderID"></param>
/// <param name="ID"></param>
public void updateFileURL(string URLName, string DataLib, string FileURL, int OrderID, int ID)
{
string Sql = "update " + Pre + "news_URL set ";
Sql += "URLName='" + URLName + "',DataLib='" + DataLib + "',FileURL='" + FileURL + "',OrderID=" + OrderID + " where id=" + ID + "";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
}
/// <summary>
/// 更新附件
/// </summary>
/// <param name="NewsID"></param>
/// <param name="DataLib"></param>
/// <param name="FileURL"></param>
/// <param name="OrderID"></param>
public void deleteFilesurl(int flgTF, string NewsID)
{
#region
string Sql = null;
string SQL1 = null;
if (flgTF == 1)
{
SQL1 = "select id,NewsID,DataLib from " + Pre + "news_URL order by id desc";
DataTable dt = DbHelper.ExecuteTable(CommandType.Text, SQL1, null);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string SQLN = "select id from " + dt.Rows[i]["DataLib"].ToString() + " where NewsID='" + dt.Rows[i]["NewsID"].ToString() + "' order by id desc";
DataTable dts = DbHelper.ExecuteTable(CommandType.Text, SQLN, null);
if (dts != null && dts.Rows.Count == 0)
{
Sql = "delete from " + Pre + "news_URL where NewsId='" + dt.Rows[i]["NewsID"].ToString() + "'";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
dts.Clear(); dts.Dispose();
}
}
dt.Clear(); dt.Dispose();
}
}
else
{
string getSQL = "select NewsID,DataLib from " + Pre + "News where ID=" + int.Parse(NewsID) + "";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -