📄 channel.cs
字号:
param[0] = new SqlParameter("@Id", SqlDbType.Int, 4);
param[0].Value = uc1.Id;
param[1] = new SqlParameter("@ChID", SqlDbType.Int, 4);
param[1].Value = uc1.ChID;
param[2] = new SqlParameter("@OrderID", SqlDbType.TinyInt, 1);
param[2].Value = uc1.OrderID;
param[3] = new SqlParameter("@CName", SqlDbType.NVarChar, 50);
param[3].Value = uc1.CName;
param[4] = new SqlParameter("@EName", SqlDbType.NVarChar, 50);
param[4].Value = uc1.EName;
param[5] = new SqlParameter("@vDescript", SqlDbType.NVarChar, 200);
param[5].Value = uc1.vDescript;
param[6] = new SqlParameter("@vType", SqlDbType.TinyInt, 1);
param[6].Value = uc1.vType;
param[7] = new SqlParameter("@vLength", SqlDbType.NVarChar, 10);
param[7].Value = uc1.vLength;
param[8] = new SqlParameter("@vValue", SqlDbType.NVarChar, 150);
param[8].Value = uc1.vValue;
param[9] = new SqlParameter("@isNulls", SqlDbType.TinyInt, 1);
param[9].Value = uc1.isNulls;
param[10] = new SqlParameter("@isUser", SqlDbType.TinyInt, 1);
param[10].Value = uc1.isUser;
param[11] = new SqlParameter("@vitem", SqlDbType.NText);
param[11].Value = uc1.vitem;
param[12] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
param[12].Value = uc1.isLock;
param[13] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[13].Value = uc1.SiteID;
param[14] = new SqlParameter("@fieldLength", SqlDbType.NVarChar, 5);
param[14].Value = uc1.fieldLength;
param[15] = new SqlParameter("@isSearch", SqlDbType.TinyInt, 1);
param[15].Value = uc1.isSearch;
param[16] = new SqlParameter("@HTMLedit", SqlDbType.TinyInt, 1);
param[16].Value = uc1.HTMLedit;
param[17] = new SqlParameter("@vHeight", SqlDbType.NVarChar, 6);
param[17].Value = uc1.vHeight;
return param;
}
/// <summary>
/// 删除字段
/// </summary>
/// <param name="ID"></param>
/// <param name="TableStr"></param>
public void delFileds(int ID, string TableStr)
{
SqlParameter param = new SqlParameter("@ID", ID);
string gSQL = "select EName from " + Pre + "sys_channelvalue where ID=@ID";
IDataReader dr = DbHelper.ExecuteReader(CommandType.Text, gSQL, param);
if (dr.Read())
{
string DeleteSql = "ALTER TABLE [" + TableStr + "] Drop column [" + dr["EName"].ToString() + "]";
DbHelper.ExecuteNonQuery(CommandType.Text, DeleteSql, param);
string delSQL = "delete from " + Pre + "sys_channelvalue where ID=@ID";
DbHelper.ExecuteNonQuery(CommandType.Text, delSQL, param);
}
dr.Close();
}
/// <summary>
/// 更新字段数据锁定状态
/// </summary>
/// <param name="ID"></param>
/// <param name="Num"></param>
public void updateValueFileds(int ID, int Num)
{
SqlParameter param = new SqlParameter("@ID", ID);
string sql = "update " + Pre + "sys_channelvalue set isLock=" + Num + " where ID=@ID";
DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
#endregion
#region 栏目部分
public void updateOrder(int ID, int OrderID, int Num)
{
SqlParameter param = new SqlParameter("@ID", ID);
string sql = string.Empty;
if (Num == 0)
{
sql = "update " + Pre + "sys_channelclass set OrderID=" + OrderID + " where ID=@ID";
}
else
{
sql = "update " + Pre + "sys_channelspecial set OrderID=" + OrderID + " where ID=@ID";
}
DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public string getClassName(int ClassID)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sql = "select classCName from " + Pre + "sys_channelclass where ID=@ClassID";
string CName = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
if (CName == string.Empty)
{
CName = "根栏目";
}
return CName;
}
/// <summary>
/// 继承频道信息
/// </summary>
/// <param name="ChID">频道ＩＤ</param>
/// <returns>记录集</returns>
public IDataReader ChannelInfo(int ChID)
{
SqlParameter param = new SqlParameter("@ChID", ChID);
string sql = "select * from " + Pre + "sys_channel where ID=@ChID";
return DbHelper.ExecuteReader(CommandType.Text, sql, param);
}
public int getClassInfoCord(string EName, int ID)
{
SqlParameter param = new SqlParameter("@ID", ID);
string sql = "select count(id) from " + Pre + "sys_channelclass where ID<>@ID and classEName='" + EName + "'";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
}
/// <summary>
/// 插入栏目数据
/// </summary>
/// <param name="uc"></param>
public void insertClassInfo(NetCMS.Model.ChannelClassInfo uc)
{
SqlParameter[] param = ClassInfoParameter(uc);
string Sql = "insert into " + Pre + "sys_channelclass (";
Sql += "ChID,OrderID,ParentID,classCName,classEName,isPage,PageContent,Templet,ContentTemplet,SavePath,FileName,ContentSavePath,ContentFileNameRule,isShowNavi,NaviContent,KeyMeta,DescMeta,PicURL,isDelPoint,Gpoint,iPoint,GroupNumber,isLock,ClassNavi,ContentNavi,SiteID";
Sql += ") values (";
Sql += "@ChID,@OrderID,@ParentID,@classCName,@classEName,@isPage,@PageContent,@Templet,@ContentTemplet,@SavePath,@FileName,@ContentSavePath,@ContentFileNameRule,@isShowNavi,@NaviContent,@KeyMeta,@DescMeta,@PicURL,@isDelPoint,@Gpoint,@iPoint,@GroupNumber,@isLock,@ClassNavi,@ContentNavi,@SiteID)";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
public void updateClassInfo(NetCMS.Model.ChannelClassInfo uc)
{
SqlParameter[] param = ClassInfoParameter(uc);
string Sql = "update " + Pre + "sys_channelclass set ";
Sql += "OrderID=@OrderID,classCName=@classCName,isPage=@isPage,PageContent=@PageContent,Templet=@Templet,ContentTemplet=@ContentTemplet,SavePath=@SavePath,ContentSavePath=@ContentSavePath,ContentFileNameRule=@ContentFileNameRule,isShowNavi=@isShowNavi,NaviContent=@NaviContent,KeyMeta=@KeyMeta,DescMeta=@DescMeta,PicURL=@PicURL,isDelPoint=@isDelPoint,Gpoint=@Gpoint,iPoint=@iPoint,GroupNumber=@GroupNumber,isLock=@isLock,ClassNavi=@ClassNavi,ContentNavi=@ContentNavi,SiteID=@SiteID where id=" + uc.Id + "";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
private SqlParameter[] ClassInfoParameter(NetCMS.Model.ChannelClassInfo uc1)
{
SqlParameter[] param = new SqlParameter[27];
param[0] = new SqlParameter("@Id", SqlDbType.Int, 4);
param[0].Value = uc1.Id;
param[1] = new SqlParameter("@ChID", SqlDbType.Int, 4);
param[1].Value = uc1.ChID;
param[2] = new SqlParameter("@OrderID", SqlDbType.TinyInt, 1);
param[2].Value = uc1.OrderID;
param[3] = new SqlParameter("@ParentID", SqlDbType.Int, 4);
param[3].Value = uc1.ParentID;
param[4] = new SqlParameter("@classCName", SqlDbType.NVarChar, 50);
param[4].Value = uc1.classCName;
param[5] = new SqlParameter("@classEName", SqlDbType.NVarChar, 50);
param[5].Value = uc1.classEName;
param[6] = new SqlParameter("@isPage", SqlDbType.TinyInt, 1);
param[6].Value = uc1.isPage;
param[7] = new SqlParameter("@PageContent", SqlDbType.NText);
param[7].Value = uc1.PageContent;
param[8] = new SqlParameter("@Templet", SqlDbType.NVarChar, 200);
param[8].Value = uc1.Templet;
param[9] = new SqlParameter("@ContentTemplet", SqlDbType.NVarChar, 200);
param[9].Value = uc1.ContentTemplet;
param[10] = new SqlParameter("@SavePath", SqlDbType.NVarChar, 100);
param[10].Value = uc1.SavePath;
param[11] = new SqlParameter("@FileName", SqlDbType.NVarChar, 100);
param[11].Value = uc1.FileName;
param[12] = new SqlParameter("@ContentSavePath", SqlDbType.NVarChar, 100);
param[12].Value = uc1.ContentSavePath;
param[13] = new SqlParameter("@ContentFileNameRule", SqlDbType.NVarChar, 150);
param[13].Value = uc1.ContentFileNameRule;
param[14] = new SqlParameter("@isShowNavi", SqlDbType.TinyInt, 1);
param[14].Value = uc1.isShowNavi;
param[15] = new SqlParameter("@NaviContent", SqlDbType.NVarChar, 200);
param[15].Value = uc1.NaviContent;
param[16] = new SqlParameter("@KeyMeta", SqlDbType.NVarChar, 100);
param[16].Value = uc1.KeyMeta;
param[17] = new SqlParameter("@DescMeta", SqlDbType.NVarChar, 150);
param[17].Value = uc1.DescMeta;
param[18] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
param[18].Value = uc1.PicURL;
param[19] = new SqlParameter("@isDelPoint", SqlDbType.TinyInt, 1);
param[19].Value = uc1.isDelPoint;
param[20] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
param[20].Value = uc1.Gpoint;
param[21] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
param[21].Value = uc1.iPoint;
param[22] = new SqlParameter("@GroupNumber", SqlDbType.NVarChar, 200);
param[22].Value = uc1.GroupNumber;
param[23] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
param[23].Value = uc1.isLock;
param[24] = new SqlParameter("@ClassNavi", SqlDbType.NText);
param[24].Value = uc1.ClassNavi;
param[25] = new SqlParameter("@ContentNavi", SqlDbType.NText);
param[25].Value = uc1.ContentNavi;
param[26] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[26].Value = uc1.SiteID;
return param;
}
public IDataReader GetClassInfo(int ClassID)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sql = "select * from " + Pre + "sys_channelclass where ID=@ClassID";
return DbHelper.ExecuteReader(CommandType.Text, sql, param);
}
public int GetTopClassID()
{
string sql = "select top 1 id from " + Pre + "sys_channelclass order by id desc";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, null));
}
public int getClassNumber(int ClassID)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sql = "select count(id) from " + Pre + "sys_channelclass where ParentID=@ClassID";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
}
public IDataReader getClassList(int ClassID, int ChID)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sql = "select id,ClassCName from " + Pre + "sys_channelclass where ParentID=@ClassID and isPage=0 and islock=0 and ChID=" + ChID + " order by Orderid desc,id desc";
return DbHelper.ExecuteReader(CommandType.Text, sql, param);
}
public int delClass(int ClassID)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sql = "delete from " + Pre + "sys_channelclass where ID=@ClassID";
delcClass(ClassID);
return DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public void delcClass(int ClassID)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sqlc = "select id from " + Pre + "sys_channelclass where ParentID=@ClassID order by id desc";
IDataReader dr = DbHelper.ExecuteReader(CommandType.Text, sqlc, param);
while (dr.Read())
{
int gID = int.Parse(dr["id"].ToString());
string sql = "delete from " + Pre + "sys_channelclass where ID=" + gID + "";
DbHelper.ExecuteNonQuery(CommandType.Text, sql, null);
delcClass(gID);
}
dr.Close();
}
public int Reset_allClass(int ClassID, int ChID)
{
string dTable = getChannelTable(ChID);
if (dTable != string.Empty)
{
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string sql = "delete from " + dTable + " where ClassID=@ClassID";
return DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -