public void CreateTreeData(IEnumerable <OrgDepmtInfo> q, object parentId, OrgDepmtInfo node, ref DataTable dt) { var parentNode = q.FirstOrDefault(m => m.Id.Equals(parentId)); var qChild = q.Where(x => x.ParentId.Equals(parentId)); if (qChild != null && qChild.Count() > 0) { foreach (var item in qChild) { var itemArr = new Dictionary <string, string>(); itemArr.Add("部门编码", item.Coded); itemArr.Add("部门名称", item.Named); itemArr.Add("所属上级部门编码", parentNode.Coded.Replace("All", "")); itemArr.Add("所属上级部门", parentNode.Named); itemArr.Add("排序", item.Sort.ToString()); DataRow dr = dt.NewRow(); foreach (var kv in itemArr) { dr[kv.Key] = kv.Value; } dt.Rows.Add(dr); if (q.Any(r => r.ParentId.Equals(item.Id))) { CreateTreeData(q, item.Id, node, ref dt); } } } }
public int Insert(OrgDepmtInfo model) { StringBuilder sb = new StringBuilder(250); sb.Append(@"insert into OrgDepmt (CompanyId,ParentId,Coded,Named,IdStep,CodeStep,Sort,Remark,LastUpdatedDate,UserId) values (@CompanyId,@ParentId,@Coded,@Named,@IdStep,@CodeStep,@Sort,@Remark,@LastUpdatedDate,@UserId) " ); SqlParameter[] parms = { new SqlParameter("@CompanyId", SqlDbType.UniqueIdentifier), new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.VarChar, 50), new SqlParameter("@Named", SqlDbType.NVarChar, 50), new SqlParameter("@IdStep", SqlDbType.VarChar, 1000), new SqlParameter("@CodeStep", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 50), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime), new SqlParameter("@UserId", SqlDbType.UniqueIdentifier) }; parms[0].Value = model.CompanyId; parms[1].Value = model.ParentId; parms[2].Value = model.Coded; parms[3].Value = model.Named; parms[4].Value = model.IdStep; parms[5].Value = model.CodeStep; parms[6].Value = model.Sort; parms[7].Value = model.Remark; parms[8].Value = model.LastUpdatedDate; parms[9].Value = model.UserId; return(SqlHelper.ExecuteNonQuery(SqlHelper.AssetConnString, CommandType.Text, sb.ToString(), parms)); }
public int Insert(OrgDepmtInfo model) { model.Id = Guid.NewGuid(); _db.OrgDepmts.Insert(model); return(1); }
public OrgDepmtInfo GetModelByCode(string code) { OrgDepmtInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,ParentId,Coded,Named,Remark,Sort,LastUpdatedDate,UserId from OrgDepmt where Coded = @Coded " ); SqlParameter parm = new SqlParameter("@Coded", SqlDbType.VarChar, 256); parm.Value = code; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { if (reader.Read()) { model = new OrgDepmtInfo(); model.Id = reader.GetGuid(0); model.ParentId = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.Remark = reader.GetString(4); model.Sort = reader.GetInt32(5); model.LastUpdatedDate = reader.GetDateTime(6); model.UserId = reader.GetGuid(7); } } } return(model); }
private void CreateTreeJson(IEnumerable <OrgDepmtInfo> q, object parentId, OrgDepmtInfo rootNode, ref StringBuilder jsonAppend) { jsonAppend.Append("["); var qChild = q.Where(x => x.ParentId.Equals(parentId)); if (qChild == null || qChild.Count() == 0) { qChild = q.Where(x => x.Step.Contains(rootNode.Id.ToString())); } 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 IList <OrgDepmtInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from OrgDepmt "); 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 <OrgDepmtInfo>()); } 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, Id,AppCode,UserId,DepmtId,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from OrgDepmt " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <OrgDepmtInfo> list = new List <OrgDepmtInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { OrgDepmtInfo model = new OrgDepmtInfo(); model.Id = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1); model.AppCode = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); model.UserId = reader.IsDBNull(3) ? Guid.Empty : reader.GetGuid(3); model.DepmtId = 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 ResResultModel SaveOrgDepmt(OrgDepmtFmModel model) { try { if (model == null) { return(ResResult.Response(false, "未获取到任何参数")); } if (string.IsNullOrWhiteSpace(model.Coded) || string.IsNullOrWhiteSpace(model.Named)) { return(ResResult.Response(false, "编码或名称不能为空字符串")); } var Id = Guid.Empty; var parentId = Guid.Empty; if (model.Id != null && !string.IsNullOrWhiteSpace(model.Id.ToString())) { Guid.TryParse(model.Id.ToString(), out Id); } if (model.ParentId != null && !string.IsNullOrWhiteSpace(model.ParentId.ToString())) { Guid.TryParse(model.ParentId.ToString(), out parentId); } var bll = new OrgDepmt(); int effect = 0; var modelInfo = new OrgDepmtInfo(); modelInfo.Id = Id; modelInfo.ParentId = parentId; modelInfo.Coded = model.Coded; modelInfo.Named = model.Named; modelInfo.Remark = model.Remark; modelInfo.Sort = model.Sort; modelInfo.LastUpdatedDate = DateTime.Now; modelInfo.UserId = Guid.Parse(SecurityService.GetUserId().ToString()); if (modelInfo.Id.Equals(Guid.Empty)) { modelInfo.Id = Guid.NewGuid(); effect = bll.InsertByOutput(modelInfo); } else { effect = bll.Update(modelInfo); } if (effect < 1) { return(ResResult.Response(false, "操作失败,数据库操作异常")); } return(ResResult.Response(true, "操作成功", modelInfo.Id)); } catch (Exception ex) { return(ResResult.Response(false, "操作异常:" + ex.Message + "")); } }
public OrgDepmtInfo GetModel(string code, string name) { if (string.IsNullOrEmpty(code) && string.IsNullOrEmpty(name)) { return(null); } OrgDepmtInfo model = null; var sb = new StringBuilder(300); sb.Append(@"select top 1 Id,AppCode,UserId,DepmtId,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from OrgDepmt where 1=1 " ); if (!string.IsNullOrEmpty(code)) { sb.Append("and Coded = @Coded "); } else { sb.Append("and Named = @Coded "); } var parm = new SqlParameter("@Coded", !string.IsNullOrEmpty(code) ? code : name); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { if (reader.Read()) { model = new OrgDepmtInfo(); model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0); 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.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 IList <OrgDepmtInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, Id,CompanyId,ParentId,Coded,Named,IdStep,CodeStep,Sort,Remark,LastUpdatedDate,UserId from OrgDepmt " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <OrgDepmtInfo> list = new List <OrgDepmtInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { OrgDepmtInfo model = new OrgDepmtInfo(); model.Id = reader.GetGuid(1); model.CompanyId = reader.GetGuid(2); model.ParentId = reader.GetGuid(3); model.Coded = reader.GetString(4); model.Named = reader.GetString(5); model.IdStep = reader.GetString(6); model.CodeStep = reader.GetString(7); model.Sort = reader.GetInt32(8); model.Remark = reader.GetString(9); model.LastUpdatedDate = reader.GetDateTime(10); model.UserId = reader.GetGuid(11); list.Add(model); } } } return(list); }
public void AppendFullInfo(ProductInfo p) { CategoryInfo categoryInfo = _db.Categories.FindById(p.CategoryId); CategoryInfo parentCategoryInfo = _db.Categories.FindById(categoryInfo.ParentId); OrgDepmtInfo useOrgDepmtInfo = _db.OrgDepmts.FindById(p.UseDepmtId); OrgDepmtInfo mgrOrgDepmtInfo = _db.OrgDepmts.FindById(p.MgrDepmtId); StoragePlaceInfo storagePlaceInfo = _db.StoragePlaces.FindById(p.StoragePlaceId); p.CategoryCode = categoryInfo.Coded; p.CategoryParentCode = parentCategoryInfo.Coded; p.CategoryName = categoryInfo.Named; p.CategoryParentName = parentCategoryInfo.Named; p.UseOrgCode = useOrgDepmtInfo.Coded; p.UseOrgName = useOrgDepmtInfo.Named; p.MgrOrgCode = mgrOrgDepmtInfo.Coded; p.MgrOrgName = mgrOrgDepmtInfo.Named; p.StoragePlaceCode = storagePlaceInfo.Coded; p.StoragePlaceName = storagePlaceInfo.Named; }
public IList <OrgDepmtInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select Id,AppCode,UserId,DepmtId,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from OrgDepmt "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by Sort "); IList <OrgDepmtInfo> list = new List <OrgDepmtInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { OrgDepmtInfo model = new OrgDepmtInfo(); model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0); 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.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 OrgDepmtInfo GetModel(Guid id) { OrgDepmtInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,AppCode,UserId,DepmtId,ParentId,Coded,Named,Step,Sort,Remark,RecordDate,LastUpdatedDate from OrgDepmt 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 OrgDepmtInfo(); model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0); 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.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 IList <OrgDepmtInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,CompanyId,ParentId,Coded,Named,IdStep,CodeStep,Sort,Remark,LastUpdatedDate,UserId from OrgDepmt "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } IList <OrgDepmtInfo> list = new List <OrgDepmtInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { OrgDepmtInfo model = new OrgDepmtInfo(); model.Id = reader.GetGuid(0); model.CompanyId = reader.GetGuid(1); model.ParentId = reader.GetGuid(2); model.Coded = reader.GetString(3); model.Named = reader.GetString(4); model.IdStep = reader.GetString(5); model.CodeStep = reader.GetString(6); model.Sort = reader.GetInt32(7); model.Remark = reader.GetString(8); model.LastUpdatedDate = reader.GetDateTime(9); model.UserId = reader.GetGuid(10); list.Add(model); } } } return(list); }
public int Update(OrgDepmtInfo model) { StringBuilder sb = new StringBuilder(500); sb.Append(@"update OrgDepmt set AppCode = @AppCode,UserId = @UserId,DepmtId = @DepmtId,ParentId = @ParentId,Coded = @Coded,Named = @Named,Step = @Step,Sort = @Sort,Remark = @Remark,RecordDate = @RecordDate,LastUpdatedDate = @LastUpdatedDate where Id = @Id " ); 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, 100), new SqlParameter("@Step", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), 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 OrgDepmtInfo GetModel(object Id) { OrgDepmtInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,CompanyId,ParentId,Coded,Named,IdStep,CodeStep,Sort,Remark,LastUpdatedDate,UserId from OrgDepmt where Id = @Id " ); SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); parm.Value = Guid.Parse(Id.ToString()); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { if (reader.Read()) { model = new OrgDepmtInfo(); model.Id = reader.GetGuid(0); model.CompanyId = reader.GetGuid(1); model.ParentId = reader.GetGuid(2); model.Coded = reader.GetString(3); model.Named = reader.GetString(4); model.IdStep = reader.GetString(5); model.CodeStep = reader.GetString(6); model.Sort = reader.GetInt32(7); model.Remark = reader.GetString(8); model.LastUpdatedDate = reader.GetDateTime(9); model.UserId = reader.GetGuid(10); } } } return(model); }
public IList <OrgDepmtInfo> GetList() { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,CompanyId,ParentId,Coded,Named,IdStep,CodeStep,Sort,Remark,LastUpdatedDate,UserId from OrgDepmt order by LastUpdatedDate desc " ); IList <OrgDepmtInfo> list = new List <OrgDepmtInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { OrgDepmtInfo model = new OrgDepmtInfo(); model.Id = reader.GetGuid(0); model.CompanyId = reader.GetGuid(1); model.ParentId = reader.GetGuid(2); model.Coded = reader.GetString(3); model.Named = reader.GetString(4); model.IdStep = reader.GetString(5); model.CodeStep = reader.GetString(6); model.Sort = reader.GetInt32(7); model.Remark = reader.GetString(8); model.LastUpdatedDate = reader.GetDateTime(9); model.UserId = reader.GetGuid(10); list.Add(model); } } } return(list); }
/// <summary> /// 导入组织机构 /// </summary> /// <param name="context"></param> private void OnImportOrgDepmt(HttpContext context) { var files = context.Request.Files; if (files.Count == 0) { throw new ArgumentException(MC.M_UploadFileNotExist); } var appCode = context.Request.Form["AppCode"]; var userId = WebCommon.GetUserId(); var orgId = new Staff().GetOrgId(userId); var bll = new OrgDepmt(); int effect = 0; var categories = bll.GetList(); foreach (string item in files.AllKeys) { HttpPostedFile file = files[item]; if (file == null || file.ContentLength == 0) { continue; } var dt = ExcelHelper.Import(file.InputStream); if (dt == null || dt.Rows.Count == 0) { throw new ArgumentException(MC.M_UploadFileDataNotExist); } var currTime = DateTime.Now; var sEmpty = string.Empty; var drc = dt.Rows; foreach (DataRow dr in drc) { #region 请求参数集 string coded = string.Empty; if (dr["资产分类编码"] != null) { coded = dr["资产分类编码"].ToString().Trim(); } string named = string.Empty; if (dr["资产分类名称"] != null) { named = dr["资产分类名称"].ToString().Trim(); } string parentCode = string.Empty; if (dr["所属上级分类编码"] != null) { parentCode = dr["所属上级分类编码"].ToString().Trim(); } string parentName = string.Empty; if (dr["所属上级分类"] != null) { parentName = dr["所属上级分类"].ToString().Trim(); } int sort = 0; if (dr["排序"] != null) { int.TryParse(dr["排序"].ToString(), out sort); } if (string.IsNullOrWhiteSpace(coded) || string.IsNullOrWhiteSpace(named)) { continue; } var id = Guid.NewGuid(); var parentId = Guid.Empty; if (string.IsNullOrWhiteSpace(parentCode)) { parentCode = named; } var parentInfo = bll.GetModel(parentCode, parentName); var step = id.ToString(); var ids = new List <Guid>(); if (parentInfo != null) { parentId = parentInfo.Id; bll.GetStep(categories, parentId, ref ids); if (ids.Count > 0) { Array.Reverse(ids.ToArray()); step += "," + string.Join(",", ids.ToArray()); } } var currInfo = new OrgDepmtInfo(id, appCode, userId, orgId, parentId, coded, named, step, sort, sEmpty, currTime, currTime); effect += bll.Insert(currInfo); #endregion } } if (effect < 1) { context.Response.Write(ResResult.ResJsonString(false, MC.M_Save_Error, "")); } else { context.Response.Write(ResResult.ResJsonString(true, MC.M_Save_Ok, effect)); } }
public int Update(OrgDepmtInfo model) { return(dal.Update(model)); }
public int InsertByOutput(OrgDepmtInfo model) { return(dal.InsertByOutput(model)); }
public int InsertByOutput(OrgDepmtInfo model) { _db.OrgDepmts.Insert(model); return(1); }
public int Update(OrgDepmtInfo model) { _db.OrgDepmts.Update(model); return(1); }