/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.ContentDetail model)
{
if (model == null)
{
return(-1);
}
if (IsExist(model.Title, model.ContentTypeID.ToString(), model.NumberID.ToString()))
{
return(110);
}
//定义查询命令
string cmdText = @"update [ContentDetail] set ContentTypeID = @ContentTypeID,Title = @Title,ContentText = @ContentText,Sort = @Sort,LastUpdatedDate = @LastUpdatedDate where NumberID = @NumberID";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier),
new SqlParameter("@ContentTypeID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar,256),
new SqlParameter("@ContentText", SqlDbType.NText),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.NumberID;
parms[1].Value = model.ContentTypeID;
parms[2].Value = model.Title;
parms[3].Value = model.ContentText;
parms[4].Value = model.Sort;
parms[5].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 获取内容列表
/// </summary>
/// <returns></returns>
public List <Model.ContentDetail> GetList()
{
List <Model.ContentDetail> list = new List <Model.ContentDetail>();
string cmdText = "select NumberID,ContentTypeID,Title from ContentDetail order by Sort";
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.ContentDetail>();
while (reader.Read())
{
Model.ContentDetail model = new Model.ContentDetail();
model.NumberID = reader["NumberID"];
model.ContentTypeID = reader["ContentTypeID"];
model.Title = reader["Title"].ToString();
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 获取当前根节点下的所有内容类型和内容
/// </summary>
/// <param name="typeName"></param>
/// <returns></returns>
public List <Model.ContentDetail> GetSiteContent(string typeName)
{
List <Model.ContentDetail> list = new List <Model.ContentDetail>();
string cmdText = @"SELECT ct2.TypeName,cd.NumberID,cd.Title,cd.ContentTypeID
FROM dbo.ContentType ct1,dbo.ContentType ct2,dbo.ContentDetail cd
WHERE ct1.NumberID = ct2.ParentID and ct2.NumberID = cd.ContentTypeID
and ct1.TypeName = @TypeName";
SqlParameter parm = new SqlParameter("@TypeName", SqlDbType.NVarChar, 256);
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.ContentDetail>();
while (reader.Read())
{
Model.ContentDetail model = new Model.ContentDetail();
model.NumberID = reader["NumberID"];
model.ContentTypeID = reader["ContentTypeID"];
model.Title = reader["Title"].ToString();
model.TypeName = reader["TypeName"].ToString();
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="numberId"></param>
/// <returns></returns>
public Model.ContentDetail GetModel(string numberId)
{
Model.ContentDetail model = null;
string cmdText = @"select top 1 NumberID,ContentTypeID,Title,ContentText,Sort,LastUpdatedDate from [ContentDetail] where NumberID = @NumberID order by LastUpdatedDate desc ";
SqlParameter parm = new SqlParameter("@NumberID", SqlDbType.VarChar, 50);
parm.Value = numberId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new Model.ContentDetail();
model.NumberID = reader["NumberID"];
model.ContentTypeID = reader["ContentTypeID"];
model.Title = reader["Title"].ToString();
model.ContentText = reader["ContentText"].ToString();
model.Sort = int.Parse(reader["Sort"].ToString());
model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString());
}
}
}
return(model);
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.ContentDetail model)
{
if (model == null)
{
return(-1);
}
//判断当前记录是否存在，如果存在则返回;
if (IsExist(model.Title, model.ContentTypeID.ToString(), ""))
{
return(110);
}
string cmdText = "insert into [ContentDetail] (ContentTypeID,Title,ContentText,Sort,LastUpdatedDate) values (@ContentTypeID,@Title,@LoweredTitle,@ContentText,@Sort,@LastUpdatedDate)";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@ContentTypeID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar,256),
new SqlParameter("@ContentText", SqlDbType.NText),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.ContentTypeID;
parms[1].Value = model.Title;
parms[2].Value = model.ContentText;
parms[3].Value = model.Sort;
parms[4].Value = model.LastUpdatedDate;
//执行数据库操作
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
private void OnSave()
{
string sTitle = txtTitle.Value.Trim();
if (string.IsNullOrEmpty(sTitle))
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "标题不能为空，请检查", "温馨提醒", "error");
return;
}
string sParent = txtParent.Value.Trim();
Guid contentTypeId = Guid.Empty;
if (!string.IsNullOrEmpty(sParent))
{
Guid.TryParse(sParent, out contentTypeId);
}
string sContent = HttpUtility.UrlDecode(hEditor1.Value).Trim();
if (bll == null)
{
bll = new BLL.ContentDetail();
}
Model.ContentDetail model = new Model.ContentDetail();
model.Title = sTitle;
model.ContentTypeID = contentTypeId;
model.ContentText = sContent;
model.Sort = 0;
model.LastUpdatedDate = DateTime.Now;
model.UserId = WebHelper.Common.GetUserId();
int effectCount = -1;
if (!string.IsNullOrEmpty(nId))
{
model.NumberID = nId;
effectCount = bll.Update(model);
}
else
{
effectCount = bll.Insert(model);
}
if (effectCount == 110)
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "已存在相同记录", "温馨提醒", "error");
return;
}
if (effectCount > 0)
{
WebHelper.MessageBox.MessagerShow(this.Page, lbtnPostBack, "操作成功");
}
else
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "操作失败");
}
}
/// <summary>
/// 获取数据分页列表，并返回所有记录数
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <param name="sqlWhere"></param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public IList <Model.ContentDetail> GetList(int pageIndex, int pageSize, out int totalCount, string sqlWhere, params SqlParameter[] commandParameters)
{
//获取数据集总数
string cmdText = "select count(*) from [ContentDetail] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
totalCount = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters);
//返回分页数据
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = @"select * from(select row_number() over(order by t1.LastUpdatedDate desc) as RowNumber,t1.NumberID,t1.ContentTypeID,t1.Title,t1.ContentText,t1.Sort,t1.LastUpdatedDate,t1.UserId from [ContentDetail] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <Model.ContentDetail> list = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.ContentDetail>();
while (reader.Read())
{
Model.ContentDetail model = new Model.ContentDetail();
model.NumberID = reader.GetGuid(1);
model.ContentTypeID = reader.GetGuid(2);
model.Title = reader.GetString(3);
model.ContentText = reader.GetString(4);
model.Sort = reader.GetInt32(5);
model.LastUpdatedDate = reader.GetDateTime(6);
model.UserId = reader.GetGuid(7);
list.Add(model);
}
}
}
return(list);
}
private void Bind()
{
if (!string.IsNullOrEmpty(nId))
{
if (bll == null)
{
bll = new BLL.ContentDetail();
}
Model.ContentDetail model = bll.GetModel(nId);
if (model != null)
{
txtTitle.Value = model.Title;
txtParent.Value = model.ContentTypeID.ToString();
hEditor1.Value = model.ContentText;
}
}
}
private void Bind()
{
if (!Page.IsPostBack)
{
BLL.ContentDetail bll = new BLL.ContentDetail();
Model.ContentDetail model = bll.GetModel(nId);
if (model != null)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<div id='cTitle' class='tc'>{0}</div>", model.Title, model.ContentTypeID);
sb.AppendFormat("<div id='cContent' class='mt10'>{0}</div>", model.ContentText);
ltrContent.Text = sb.ToString();
}
else
{
ltrContent.Text = "<div id='cTitle' class='tc'></div><div id='cContent' class='mt10'></div>";
}
}
}
/// <summary>
/// 初始化并显示到页面
/// </summary>
private void Bind()
{
if (!string.IsNullOrEmpty(nId))
{
Model.ContentDetail model = WebHelper.ContentDetailDataProxy.GetModel(nId);
if (model != null)
{
BindContent(model.Title, model.ContentText);
Dictionary <string, string> titleDic = WebHelper.ContentDetailDataProxy.GetKeyValueByTypeID(model.ContentTypeID);
if (titleDic == null || titleDic.Count == 0)
{
titleDic = WebHelper.ContentDetailDataProxy.GetKeyValueByType("帮助中心");
//绑定帮助标题
BindTitle(titleDic);
}
else
{
//绑定属于当前的帮助标题
BindTitle(titleDic);
}
}
else
{
Dictionary <string, string> titleDic = WebHelper.ContentDetailDataProxy.GetKeyValueByType("帮助中心");
//绑定帮助标题
BindTitle(titleDic);
}
}
else
{
Dictionary <string, string> titleDic = WebHelper.ContentDetailDataProxy.GetKeyValueByType("帮助中心");
//绑定帮助标题
BindTitle(titleDic);
Model.ContentDetail cdModel = WebHelper.ContentDetailDataProxy.GetModel(titleDic.First().Key);
BindContent(cdModel.Title, cdModel.ContentText);
}
}
/// <summary>
/// 获取满足当前条件的数据列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="sqlWhere"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public IList <Model.ContentDetail> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
string cmdText = @"select * from(select row_number() over(order by cd.LastUpdatedDate desc) as RowNumber,cd.NumberID,cd.ContentTypeID,cd.Title,cd.ContentText,cd.Sort,cd.LastUpdatedDate,cd.UserId from [ContentDetail] cd
left join ContentType ct on ct.NumberID = cd.ContentTypeID ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <Model.ContentDetail> list = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.ContentDetail>();
while (reader.Read())
{
Model.ContentDetail model = new Model.ContentDetail();
model.NumberID = reader.GetGuid(1);
model.ContentTypeID = reader.GetGuid(2);
model.Title = reader.GetString(3);
model.ContentText = reader.GetString(4);
model.Sort = reader.GetInt32(5);
model.LastUpdatedDate = reader.GetDateTime(6);
model.UserId = reader.GetGuid(7);
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 获取当前ID对应数据
/// </summary>
/// <param name="nId"></param>
/// <returns></returns>
public static Model.ContentDetail GetModel(object nId)
{
BLL.ContentDetail bll = new BLL.ContentDetail();
if (!enableCaching)
{
return(bll.GetModel(nId));
}
string key = "contentDetail_" + nId.ToString() + "";
Model.ContentDetail data = (Model.ContentDetail)HttpRuntime.Cache[key];
if (data == null)
{
data = bll.GetModel(nId);
AggregateCacheDependency cd = DependencyFactory.GetContentDetailDependency();
HttpRuntime.Cache.Add(key, data, cd, DateTime.Now.AddHours(contentDetailTimeout), Cache.NoSlidingExpiration, CacheItemPriority.High, null);
}
return(data);
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="numberId"></param>
/// <returns></returns>
public Model.ContentDetail GetModel(object numberId)
{
Guid gId = Guid.Empty;
Guid.TryParse(numberId.ToString(), out gId);
if (gId == Guid.Empty)
{
return(null);
}
Model.ContentDetail model = null;
string cmdText = @"select top 1 NumberID,ContentTypeID,Title,ContentText,Sort,LastUpdatedDate,UserId from [ContentDetail] where NumberID = @NumberID order by LastUpdatedDate desc ";
SqlParameter parm = new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier);
parm.Value = gId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new Model.ContentDetail();
model.NumberID = reader.GetGuid(0);
model.ContentTypeID = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.ContentText = reader.GetString(3);
model.Sort = reader.GetInt32(4);
model.LastUpdatedDate = reader.GetDateTime(5);
model.UserId = reader.GetGuid(6);
}
}
}
return(model);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.ContentDetail model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.ContentDetail model)
{
return(dal.Insert(model));
}
