private void CreateTreeJson(IEnumerable <DicsInfo> q, object parentId, DicsInfo rootNode, ref StringBuilder jsonAppend) { jsonAppend.Append("["); var qChild = q.Where(x => x.ParentId.Equals(parentId)); if (qChild != null && qChild.Count() > 0) { int index = 0; foreach (var model in qChild) { var state = (model.Id == rootNode.Id) ? "open" : "closed"; var sText = model.ParentId.Equals(Guid.Empty) ? model.Named : string.Format("{0}({1})", model.Coded, model.Named); jsonAppend.AppendFormat(@"{{""id"":""{0}"",""text"":""{1}"",""state"":""{2}"",""attributes"":{3}", model.Id, sText, state, JsonConvert.SerializeObject(model)); if (q.Any(r => r.ParentId.Equals(model.Id))) { jsonAppend.Append(",\"children\":"); CreateTreeJson(q, model.Id, rootNode, ref jsonAppend); } jsonAppend.Append("}"); if (index < qChild.Count() - 1) { jsonAppend.Append(","); } index++; } } jsonAppend.Append("]"); }
public int Insert(DicsInfo model) { model.Id = Guid.NewGuid(); _db.Dics.Insert(model); return(1); }
public IList <DicsInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from Dics "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <DicsInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by Sort) as RowNumber, AppCode,UserId,DepmtId,Id,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from Dics " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <DicsInfo> list = new List <DicsInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { DicsInfo model = new DicsInfo(); model.AppCode = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); model.UserId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2); model.DepmtId = reader.IsDBNull(3) ? Guid.Empty : reader.GetGuid(3); model.Id = reader.IsDBNull(4) ? Guid.Empty : reader.GetGuid(4); model.ParentId = reader.IsDBNull(5) ? Guid.Empty : reader.GetGuid(5); model.Coded = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); model.Named = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); model.Step = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); model.Sort = reader.IsDBNull(9) ? 0 : reader.GetInt32(9); model.Remark = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); model.RecordDate = reader.IsDBNull(11) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(11); model.LastUpdatedDate = reader.IsDBNull(12) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(12); list.Add(model); } } } return(list); }
public IList <DicsInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select AppCode,UserId,DepmtId,Id,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from Dics "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by Sort "); IList <DicsInfo> list = new List <DicsInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { DicsInfo model = new DicsInfo(); model.AppCode = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); model.UserId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1); model.DepmtId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2); model.Id = reader.IsDBNull(3) ? Guid.Empty : reader.GetGuid(3); model.ParentId = reader.IsDBNull(4) ? Guid.Empty : reader.GetGuid(4); model.Coded = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); model.Named = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); model.Step = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); model.Sort = reader.IsDBNull(8) ? 0 : reader.GetInt32(8); model.Remark = reader.IsDBNull(9) ? string.Empty : reader.GetString(9); model.RecordDate = reader.IsDBNull(10) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(10); model.LastUpdatedDate = reader.IsDBNull(11) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(11); list.Add(model); } } } return(list); }
public DicsInfo GetModel(Guid id) { DicsInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 AppCode,UserId,DepmtId,Id,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from Dics where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier) }; parms[0].Value = id; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new DicsInfo(); model.AppCode = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); model.UserId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1); model.DepmtId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2); model.Id = reader.IsDBNull(3) ? Guid.Empty : reader.GetGuid(3); model.ParentId = reader.IsDBNull(4) ? Guid.Empty : reader.GetGuid(4); model.Coded = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); model.Named = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); model.Step = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); model.Sort = reader.IsDBNull(8) ? 0 : reader.GetInt32(8); model.Remark = reader.IsDBNull(9) ? string.Empty : reader.GetString(9); model.RecordDate = reader.IsDBNull(10) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(10); model.LastUpdatedDate = reader.IsDBNull(11) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(11); } } } return(model); }
public int InsertByOutput(DicsInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into Dics (Id,AppCode,UserId,DepmtId,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate) values (@Id,@AppCode,@UserId,@DepmtId,@ParentId,@Coded,@Named,@Step,@Sort,@Remark,@RecordDate,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@AppCode", SqlDbType.Char, 10), new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@DepmtId", SqlDbType.UniqueIdentifier), new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.VarChar, 36), new SqlParameter("@Named", SqlDbType.NVarChar, 256), new SqlParameter("@Step", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@RecordDate", SqlDbType.DateTime), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.AppCode; parms[2].Value = model.UserId; parms[3].Value = model.DepmtId; parms[4].Value = model.ParentId; parms[5].Value = model.Coded; parms[6].Value = model.Named; parms[7].Value = model.Step; parms[8].Value = model.Sort; parms[9].Value = model.Remark; parms[10].Value = model.RecordDate; parms[11].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Update(DicsInfo model) { _db.Dics.Update(model); return(1); }
public int InsertByOutput(DicsInfo model) { _db.Dics.Insert(model); return(1); }
public int Update(DicsInfo model) { return(dal.Update(model)); }
public int InsertByOutput(DicsInfo model) { return(dal.InsertByOutput(model)); }