/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.ContentType 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)); }
private void GetChildren(Model.ContentType current, List <Model.ContentType> list, ref string jsonAppend) { List <Model.ContentType> childList = list.FindAll(delegate(Model.ContentType m) { return(m.ParentID.Equals(current.NumberID)); }); if (childList != null) { int n = 0; int count = childList.Count; foreach (Model.ContentType 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 Insert(Model.ContentType 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> /// <returns></returns> public List <Model.ContentType> GetList() { List <Model.ContentType> list = new List <Model.ContentType>(); 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.ContentType model = new Model.ContentType(); 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="numberId"></param> /// <returns></returns> public Model.ContentType GetModel(string numberId) { Model.ContentType 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.ContentType(); 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.ContentType model = new Model.ContentType(); 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("操作失败"); } }
public object Resolve(object source, Dictionary <String, IResolver> resolvers = null, Boolean recursive = false) { Object result = null; Model.ContentType contentType = source as Model.ContentType; if (null != contentType && !String.IsNullOrEmpty(contentType.DocumentTemplate)) { result = Activator.CreateInstance(this._targetType); result.SetPublicInstancePropertyValue("TargetName", contentType.DocumentTemplate); } return(result); }
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.ContentType model = new Model.ContentType(); 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.ContentType 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.ContentType> 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.ContentType> list = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters)) { if (reader != null && reader.HasRows) { list = new List <Model.ContentType>(); while (reader.Read()) { Model.ContentType model = new Model.ContentType(); 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.ContentType parentModel, List <Model.ContentType> list) { string htmlAppend = string.Empty; List <Model.ContentType> childList = list.FindAll(delegate(Model.ContentType m) { return(m.ParentID.Equals(parentModel.NumberID)); }); if (childList != null) { foreach (Model.ContentType 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.ContentType> ctList = ctBll.GetList(); Model.ContentType rootModel = ctList.Find(delegate(Model.ContentType m) { return(m.TypeName == "站点所有帮助"); }); if (rootModel != null) { htmlAppend += GetChildren(rootModel, ctList); } return(htmlAppend); }
/// <summary> /// 获取对应的数据 /// </summary> /// <param name="numberId"></param> /// <returns></returns> public Model.ContentType GetModel(object numberId) { Guid gId = Guid.Empty; Guid.TryParse(numberId.ToString(), out gId); if (gId == Guid.Empty) { return(null); } Model.ContentType model = null; string cmdText = @"select top 1 NumberID,TypeName,ParentID,Sort,SameName,LastUpdatedDate from [ContentType] 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.ContentType(); model.NumberID = reader.GetGuid(0); model.TypeName = reader.GetString(1); model.ParentID = reader.GetGuid(2); model.Sort = reader.GetInt32(3); model.SameName = reader.GetString(4); model.LastUpdatedDate = reader.GetDateTime(5); } } } return(model); }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.ContentType model) { return(dal.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(Model.ContentType model) { return(dal.Insert(model)); }