private void GetChildren(Model.ContentTypeInfo current, List <Model.ContentTypeInfo> list, ref string jsonAppend)
{
List <Model.ContentTypeInfo> childList = list.FindAll(delegate(Model.ContentTypeInfo m) { return(m.ParentID.Equals(current.NumberID)); });
if (childList != null)
{
int n = 0;
int count = childList.Count;
foreach (Model.ContentTypeInfo model in childList)
{
n++;
if (n == 1)
{
jsonAppend += ",'children':[";
}
jsonAppend += "{'id':'" + model.NumberID + "','text':'" + model.TypeName + "'";
GetChildren(model, list, ref jsonAppend);
jsonAppend += "},";
if (n == count)
{
jsonAppend = jsonAppend.TrimEnd(',');
jsonAppend += "]";
}
}
}
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.ContentTypeInfo model)
{
if (model == null)
{
return(-1);
}
if (IsExist(model.TypeName, model.NumberID.ToString()))
{
return(110);
}
//定义查询命令
string cmdText = @"update [ContentType] set TypeName = @TypeName,ParentID = @ParentID,Sort = @Sort,SameName = @SameName,LastUpdatedDate = @LastUpdatedDate where NumberID = @NumberID";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier),
new SqlParameter("@TypeName", SqlDbType.NVarChar, 256),
new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@SameName", SqlDbType.NVarChar, 10),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = Guid.Parse(model.NumberID.ToString());
parms[1].Value = model.TypeName;
parms[2].Value = Guid.Parse(model.ParentID.ToString());
parms[3].Value = model.Sort;
parms[4].Value = model.SameName;
parms[5].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 获取所有内容类型
/// </summary>
/// <returns></returns>
public List <Model.ContentTypeInfo> GetList()
{
List <Model.ContentTypeInfo> list = new List <Model.ContentTypeInfo>();
string cmdText = @"select t1.NumberID,t1.TypeName,t1.ParentID,t1.Sort,
(select t2.TypeName from ContentType t2 where t2.NumberID = t1.ParentID) as ParentName
from [ContentType] t1 order by t1.LastUpdatedDate ";
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
Model.ContentTypeInfo model = new Model.ContentTypeInfo();
model.NumberID = reader["NumberID"];
model.TypeName = reader["TypeName"].ToString();
model.ParentID = reader["ParentID"];
model.ParentName = reader["ParentName"].ToString();
model.Sort = int.Parse(reader["Sort"].ToString());
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.ContentTypeInfo model)
{
if (model == null)
{
return(-1);
}
//判断当前记录是否存在，如果存在则返回;
if (IsExist(model.TypeName, ""))
{
return(110);
}
string cmdText = "insert into [ContentType] (TypeName,ParentID,Sort,SameName,LastUpdatedDate) values (@TypeName,@ParentID,@Sort,@SameName,@LastUpdatedDate)";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@TypeName", SqlDbType.NVarChar, 256),
new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@SameName", SqlDbType.NVarChar, 10),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.TypeName;
parms[1].Value = model.ParentID;
parms[2].Value = model.Sort;
parms[3].Value = model.SameName;
parms[4].Value = model.LastUpdatedDate;
//执行数据库操作
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="numberId"></param>
/// <returns></returns>
public Model.ContentTypeInfo GetModel(string numberId)
{
Model.ContentTypeInfo model = null;
string cmdText = @"select top 1 t1.NumberID,t1.TypeName,t1.ParentID,t1.Sort,t1.SameName,t1.LastUpdatedDate,
(select t2.TypeName from ContentType t2 where t2.NumberID = t1.ParentID) as ParentName
from [ContentType] t1 where t1.NumberID = @NumberID order by t1.LastUpdatedDate desc ";
SqlParameter parm = new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(numberId);
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new Model.ContentTypeInfo();
model.NumberID = reader["NumberID"];
model.TypeName = reader["TypeName"].ToString();
model.ParentID = reader["ParentID"];
model.Sort = int.Parse(reader["Sort"].ToString());
model.SameName = reader["SameName"].ToString();
model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString());
model.ParentName = reader["ParentName"].ToString();
}
}
}
return(model);
}
public string UpdateContentType(string nId, string name, string parentId)
{
if (string.IsNullOrEmpty(nId))
{
return("没有找到要编辑的数据，请检查");
}
Guid gId = Guid.Empty;
if (!Guid.TryParse(nId, out gId))
{
return("当前编辑行的主键ID不合法，请检查");
}
if (string.IsNullOrEmpty(name))
{
return("类型名称不能为空");
}
if (string.IsNullOrEmpty(parentId))
{
return("所属名称对应值不正确，请检查");
}
Guid pId = Guid.Empty;
if (!Guid.TryParse(parentId, out pId))
{
return("所属名称对应值格式不正确");
}
Model.ContentTypeInfo model = new Model.ContentTypeInfo();
model.NumberID = nId;
model.TypeName = name;
model.ParentID = pId;
model.SameName = "All";
model.LastUpdatedDate = DateTime.Now;
if (ctBll == null)
{
ctBll = new BLL.ContentType();
}
int effect = ctBll.Update(model);
if (effect == 110)
{
return("已存在相同记录");
}
if (effect > 0)
{
return("操作成功");
}
else
{
return("操作失败");
}
}
private void OnSave()
{
string sTypeName = txtTypeName.Value.Trim();
string sParent = txtParent.Value.Trim();
Guid parentId = Guid.Empty;
if (!string.IsNullOrEmpty(sParent))
{
Guid.TryParse(sParent, out parentId);
}
Model.ContentTypeInfo model = new Model.ContentTypeInfo();
model.TypeName = sTypeName;
model.ParentID = parentId;
model.Sort = 0;
model.SameName = "All";
model.LastUpdatedDate = DateTime.Now;
if (ctBll == null)
{
ctBll = new BLL.ContentType();
}
int result = -1;
if (!string.IsNullOrEmpty(nId))
{
model.NumberID = nId;
result = ctBll.Update(model);
}
else
{
result = ctBll.Insert(model);
}
if (result == 110)
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "已存在相同记录！", "温馨提醒", "error");
return;
}
if (result > 0)
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "提交成功！");
}
else
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "提交失败,系统异常！", "温馨提醒", "error");
}
}
private void Bind()
{
if (!string.IsNullOrEmpty(nId))
{
if (ctBll == null)
{
ctBll = new BLL.ContentType();
}
Model.ContentTypeInfo model = ctBll.GetModel(nId);
if (model != null)
{
txtTypeName.Value = model.TypeName;
txtParent.Value = model.ParentName;
}
}
}
/// <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.ContentTypeInfo> GetList(int pageIndex, int pageSize, out int totalCount, string sqlWhere, params SqlParameter[] commandParameters)
{
//获取数据集总数
string cmdText = "select count(*) from [ContentType] 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.ContentTypeID,t1.TypeName,t1.ParentID,t1.Sort,t1.SameName,t1.LastUpdatedDate from [ContentType] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <Model.ContentTypeInfo> list = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.ContentTypeInfo>();
while (reader.Read())
{
Model.ContentTypeInfo model = new Model.ContentTypeInfo();
model.NumberID = reader["NumberID"];
model.TypeName = reader["TypeName"].ToString();
model.ParentID = reader["ParentID"];
model.Sort = int.Parse(reader["Sort"].ToString());
model.SameName = reader["SameName"].ToString();
model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString());
list.Add(model);
}
}
}
return(list);
}
//public string GetContent(object contentTypeId)
//{
//}
private string GetChildren(Model.ContentTypeInfo parentModel, List <Model.ContentTypeInfo> list)
{
string htmlAppend = string.Empty;
List <Model.ContentTypeInfo> childList = list.FindAll(delegate(Model.ContentTypeInfo m) { return(m.ParentID.Equals(parentModel.NumberID)); });
if (childList != null)
{
foreach (Model.ContentTypeInfo model in childList)
{
string selected = "selected:false";
htmlAppend += "<div data-options='" + selected + "' title=\"" + model.TypeName + "\" style=\"overflow:auto;padding:10px;\">";
htmlAppend += GetAccordionContent(model.NumberID, out selected);
htmlAppend += "</div>";
}
}
return(htmlAppend);
}
public string GetSiteHelper()
{
string htmlAppend = string.Empty;
if (ctBll == null)
{
ctBll = new BLL.ContentType();
}
if (cdBll == null)
{
cdBll = new BLL.ContentDetail();
}
cdList = cdBll.GetList();
List <Model.ContentTypeInfo> ctList = ctBll.GetList();
Model.ContentTypeInfo rootModel = ctList.Find(delegate(Model.ContentTypeInfo m) { return(m.TypeName == "站点所有帮助"); });
if (rootModel != null)
{
htmlAppend += GetChildren(rootModel, ctList);
}
return(htmlAppend);
}
