?? tcmsremark.cs
字號(hào):
using System;
namespace _lib
{
/// <summary>
/// TCmsRemark 的摘要說明。
/// </summary>
public class TCmsRemark : TData
{
const string CTableName = "t_remark";
const string CKeyName = "remark_id";
private string FRemarkID;
private string FRemarkAID;
private int FRemarkSort;
private DateTime FRemarkTime;
private string FRemarkName;
private string FRemarkEmail;
private string FRemarkTitle;
private string FRemarkContent;
public TCmsRemark()
{
FTableName = CTableName;
FKeyName = CKeyName;
}
public TCmsRemark(string ID)
{
FTableName = CTableName;
FKeyName = CKeyName;
FKeyValue = ID;
}
/// <summary>
/// (靜態(tài))根據(jù)編號(hào)在數(shù)據(jù)庫中刪除記錄。
/// </summary>
public static void DeleteByID(string ID)
{
TData.DeleteByID(ID, CTableName, CKeyName);
}
/// <summary>
/// 在數(shù)據(jù)庫中檢索記錄(已重寫)。
/// </summary>
public override void Select()
{
string strSql= GetSelectString();
TSqlDB oDB= new TSqlDB(strSql);
if (!oDB.EOF)
{
FRemarkID = oDB["remark_id"].ToString();
FRemarkAID = oDB["remark_aid"].ToString();
FRemarkSort = oDB["remark_sort"].ToInt();
FRemarkTime = oDB["remark_time"].ToDateTime();
FRemarkName = oDB["remark_name"].ToString();
FRemarkEmail = oDB["remark_email"].ToString();
FRemarkTitle = oDB["remark_title"].ToString();
FRemarkContent = oDB["remark_content"].ToString();
}
oDB.Free();
}
/// <summary>
/// 在數(shù)據(jù)庫中插入記錄。
/// </summary>
public void Insert()
{
string ExSql = "newid(), '"+FRemarkAID+"', null, getdate(), '"+FRemarkName+"', '"+FRemarkEmail+"', '"+FRemarkTitle+"', '"+FRemarkContent+"'";
base.Insert(ExSql);
}
/// <summary>
/// 在數(shù)據(jù)庫中更新記錄。
/// </summary>
public void Update()
{
string ExSql = "remark_time=getdate(), remark_name='"+FRemarkName+"', remark_email='"+FRemarkEmail+"', remark_title='"+FRemarkTitle+"', remark_content='"+FRemarkContent+"'";
base.Update(ExSql);
}
public string RemarkAID
{
get
{
return FRemarkAID;
}
set
{
FRemarkAID= value;
}
}
public string RemarkName
{
get
{
return FRemarkName;
}
set
{
FRemarkName= value;
}
}
public string RemarkEmail
{
get
{
return FRemarkEmail;
}
set
{
FRemarkEmail= value;
}
}
public string RemarkTitle
{
get
{
return FRemarkTitle;
}
set
{
FRemarkTitle= value;
}
}
public string RemarkContent
{
get
{
return FRemarkContent;
}
set
{
FRemarkContent= value;
}
}
}
/// <summary>
/// TCmsRemarkRset 的摘要說明。
/// </summary>
public class TCmsRemarkRset : TDataRset
{
const string CTableName = "v_remark";
const string CKeyName = "remark_id";
public TCmsRemarkRset()
{
FTableName = CTableName;
FKeyName = CKeyName;
SqlOrderBy = "remark_time desc";
Load();
}
public TCmsRemarkRset(string ArticleID)
{
FTableName = CTableName;
FKeyName = CKeyName;
if ((ArticleID!=null)&&(ArticleID.Length>0))
{
SqlWhere = "remark_aid='"+ArticleID+"'";
}
SqlOrderBy = "remark_time desc";
Load();
}
/// <summary>
/// 只取與指定欄目相關(guān)的評(píng)論
/// </summary>
/// <param name="ColumnID"></param>
/// <param name="FuncNo"></param>
public TCmsRemarkRset(string ColumnID, int FuncNo)
{
FTableName = CTableName;
FKeyName = CKeyName;
if ((ColumnID!=null)&&(ColumnID.Length>0))
{
SqlWhere = "Column_id='"+ColumnID+"'";
}
SqlOrderBy = "remark_time desc";
Load();
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -