📄 channel.cs
字号:
{
param = new SqlParameter("@ContentParam", "");
}
break;
case "11":
if (PreContent != null)
{
param = new SqlParameter("@ContentParam", Convert.ToDateTime(PreContent));
}
else
{
param = new SqlParameter("@ContentParam", "");
}
break;
default:
if (PreContent != null)
{
param = new SqlParameter("@ContentParam", PreContent);
}
else
{
param = new SqlParameter("@ContentParam", "");
}
break;
}
string sql = "update " + DTable + " set " + PreContentName + "=@ContentParam where ID=" + ID + "";
DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
private SqlParameter[] GetChInfoParams(NetCMS.Model.ChInfoContent uc1)
{
SqlParameter[] param = new SqlParameter[30];
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("@ClassID", SqlDbType.Int, 4);
param[2].Value = uc1.ClassID;
param[3] = new SqlParameter("@SpecialID", SqlDbType.NVarChar, 200);
param[3].Value = uc1.SpecialID;
param[4] = new SqlParameter("@title", SqlDbType.NVarChar, 100);
param[4].Value = uc1.title;
param[5] = new SqlParameter("@TitleColor", SqlDbType.NVarChar, 10);
param[5].Value = uc1.TitleColor;
param[6] = new SqlParameter("@TitleITF", SqlDbType.TinyInt, 1);
param[6].Value = uc1.TitleITF;
param[7] = new SqlParameter("@TitleBTF", SqlDbType.TinyInt, 1);
param[7].Value = uc1.TitleBTF;
param[8] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
param[8].Value = uc1.PicURL;
param[9] = new SqlParameter("@NaviContent", SqlDbType.NVarChar, 200);
param[9].Value = uc1.NaviContent;
param[10] = new SqlParameter("@Content", SqlDbType.NText);
param[10].Value = uc1.Content;
param[11] = new SqlParameter("@Author", SqlDbType.NVarChar, 100);
param[11].Value = uc1.Author;
param[12] = new SqlParameter("@Souce", SqlDbType.NVarChar, 100);
param[12].Value = uc1.Souce;
param[13] = new SqlParameter("@OrderID", SqlDbType.TinyInt, 1);
param[13].Value = uc1.OrderID;
param[14] = new SqlParameter("@Tags", SqlDbType.NVarChar, 100);
param[14].Value = uc1.Tags;
param[15] = new SqlParameter("@Templet", SqlDbType.NVarChar, 200);
param[15].Value = uc1.Templet;
param[16] = new SqlParameter("@SavePath", SqlDbType.NVarChar, 200);
param[16].Value = uc1.SavePath;
param[17] = new SqlParameter("@FileName", SqlDbType.NVarChar, 100);
param[17].Value = uc1.FileName;
param[18] = new SqlParameter("@isDelPoint", SqlDbType.TinyInt, 1);
param[18].Value = uc1.isDelPoint;
param[19] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
param[19].Value = uc1.Gpoint;
param[20] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
param[20].Value = uc1.iPoint;
param[21] = new SqlParameter("@GroupNumber", SqlDbType.NText);
param[21].Value = uc1.GroupNumber;
param[22] = new SqlParameter("@Metakeywords", SqlDbType.NVarChar, 200);
param[22].Value = uc1.Metakeywords;
param[23] = new SqlParameter("@Metadesc", SqlDbType.NVarChar, 200);
param[23].Value = uc1.Metadesc;
param[24] = new SqlParameter("@Click", SqlDbType.Int, 4);
param[24].Value = uc1.Click;
param[25] = new SqlParameter("@isHTML", SqlDbType.TinyInt, 1);
param[25].Value = uc1.isHTML;
param[26] = new SqlParameter("@isConstr", SqlDbType.TinyInt, 1);
param[26].Value = uc1.isConstr;
param[27] = new SqlParameter("@islock", SqlDbType.TinyInt, 1);
param[27].Value = uc1.islock;
param[28] = new SqlParameter("@Editor", SqlDbType.NVarChar, 150);
param[28].Value = uc1.Editor;
param[29] = new SqlParameter("@ContentProperty", SqlDbType.NVarChar, 9);
param[29].Value = uc1.ContentProperty;
return param;
}
private SqlParameter[] GetChInfoParams1(NetCMS.Model.ChInfoContent uc1)
{
SqlParameter[] param = new SqlParameter[12];
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("@ClassID", SqlDbType.Int, 4);
param[2].Value = uc1.ClassID;
param[3] = new SqlParameter("@title", SqlDbType.NVarChar, 100);
param[3].Value = uc1.title;
param[4] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
param[4].Value = uc1.PicURL;
param[5] = new SqlParameter("@NaviContent", SqlDbType.NVarChar, 200);
param[5].Value = uc1.NaviContent;
param[6] = new SqlParameter("@Content", SqlDbType.NText);
param[6].Value = uc1.Content;
param[7] = new SqlParameter("@Author", SqlDbType.NVarChar, 100);
param[7].Value = uc1.Author;
param[8] = new SqlParameter("@Souce", SqlDbType.NVarChar, 100);
param[8].Value = uc1.Souce;
param[9] = new SqlParameter("@Tags", SqlDbType.NVarChar, 100);
param[9].Value = uc1.Tags;
param[10] = new SqlParameter("@isConstr", SqlDbType.TinyInt, 1);
param[10].Value = uc1.isConstr;
param[11] = new SqlParameter("@islock", SqlDbType.TinyInt, 1);
param[11].Value = uc1.islock;
return param;
}
public int lockContent(int id, int ChID, int num)
{
string sql = string.Empty;
SqlParameter param = new SqlParameter("@id", id);
string dTable = getChannelTable(ChID);
if (num != 2)
{
sql = "update " + dTable + " set islock=" + num + " where id=@id and ChID=" + ChID + "";
}
else
{
sql = "update " + dTable + " set orderId=0 where id=@id and ChID=" + ChID + "";
}
return DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public void setOrderContent(int id, int ChID, int num)
{
SqlParameter param = new SqlParameter("@id", id);
string dTable = getChannelTable(ChID);
string sql = "update " + dTable + " set orderId=" + num + " where id=@id and ChID=" + ChID + "";
DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public IDataReader getContentAll(int ChID, int ID)
{
SqlParameter param = new SqlParameter("@ID", ID);
string DTable = getChannelTable(ChID);
if (DTable != "#")
{
string sql = "select * from " + DTable + " where ID=@ID";
return DbHelper.ExecuteReader(CommandType.Text, sql, param);
}
else
{
throw new Exception("找不到数据库表，可能是数据库表已被移除");
}
}
#endregion
#region 专题部分
public string getSpecialName(int SpecialID)
{
SqlParameter param = new SqlParameter("@SpecialID", SpecialID);
string sql = "select specialCName from " + Pre + "sys_channelspecial where ID=@SpecialID";
string CName = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
if (CName == string.Empty)
{
CName = "根专题";
}
return CName;
}
public IDataReader getSpecialInfo(int SpecialID)
{
SqlParameter param = new SqlParameter("@SpecialID", SpecialID);
string sql = "select * from " + Pre + "sys_channelspecial where ID=@SpecialID";
return DbHelper.ExecuteReader(CommandType.Text, sql, param);
}
/// <summary>
/// 得到专题英文名称是否重复
/// </summary>
/// <param name="EName"></param>
/// <param name="speicalId"></param>
/// <returns></returns>
public int getSpecialCord(string EName, int speicalId)
{
SqlParameter param = new SqlParameter("@speicalId", speicalId);
string sql = "select count(id) from " + Pre + "sys_channelspecial where ID<>@speicalId and specialEName='" + EName + "'";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
}
public void insertSpecialInfo(NetCMS.Model.ChannelSpecialInfo uc)
{
SqlParameter[] param = SpecialInfoParameter(uc);
string Sql = "insert into " + Pre + "sys_channelspecial (";
Sql += "ChID,OrderID,ParentID,specialCName,specialEName,binddomain,navicontent,savePath,filename,templet,islock,isRec,PicURL";
Sql += ") values (";
Sql += "@ChID,@OrderID,@ParentID,@specialCName,@specialEName,@binddomain,@navicontent,@savePath,@filename,@templet,@islock,@isRec,@PicURL)";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
public void updateSpecialInfo(NetCMS.Model.ChannelSpecialInfo uc)
{
SqlParameter[] param = SpecialInfoParameter(uc);
string Sql = "update " + Pre + "sys_channelspecial set ";
Sql += "OrderID=@OrderID,specialCName=@specialCName,specialEName=@specialEName,binddomain=@binddomain,navicontent=@navicontent,savePath=@savePath,filename=@filename,templet=@templet,islock=@islock,isRec=@isRec,PicURL=@PicURL";
Sql += " where ID=@Id";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
private SqlParameter[] SpecialInfoParameter(NetCMS.Model.ChannelSpecialInfo uc1)
{
SqlParameter[] param = new SqlParameter[14];
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("@ParentID", SqlDbType.Int, 4);
param[2].Value = uc1.ParentID;
param[3] = new SqlParameter("@OrderID", SqlDbType.TinyInt, 1);
param[3].Value = uc1.OrderID;
param[4] = new SqlParameter("@specialCName", SqlDbType.NVarChar, 100);
param[4].Value = uc1.specialCName;
param[5] = new SqlParameter("@specialEName", SqlDbType.NVarChar, 100);
param[5].Value = uc1.specialEName;
param[6] = new SqlParameter("@binddomain", SqlDbType.NVarChar, 100);
param[6].Value = uc1.binddomain;
param[7] = new SqlParameter("@navicontent", SqlDbType.NVarChar, 200);
param[7].Value = uc1.navicontent;
param[8] = new SqlParameter("@savePath", SqlDbType.NVarChar, 100);
param[8].Value = uc1.savePath;
param[9] = new SqlParameter("@filename", SqlDbType.NVarChar, 100);
param[9].Value = uc1.filename;
param[10] = new SqlParameter("@templet", SqlDbType.NVarChar, 200);
param[10].Value = uc1.templet;
param[11] = new SqlParameter("@islock", SqlDbType.TinyInt, 1);
param[11].Value = uc1.islock;
param[12] = new SqlParameter("@isRec", SqlDbType.TinyInt, 1);
param[12].Value = uc1.isRec;
param[13] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
param[13].Value = uc1.PicURL;
return param;
}
public int getSpecialNumber(int SpecialID)
{
SqlParameter param = new SqlParameter("@SpecialID", SpecialID);
string sql = "select count(id) from " + Pre + "sys_channelspecial where ParentID=@SpecialID";
return Convert.⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -