public bool SaveGeneralInfo(Model.Organization organization) { try { InfoBL.saveGeneralInfo(organization); return(true); } catch (Exception e) { throw e; } }
public int AddOrganization(Organization model) { string cmdText = @"INSERT INTO [Organization] ([Agency],[ParentId],[Sort],[Person],[Remark]) values (@Agency,@ParentId,@Sort,@Person,@Remark) "; SqlParameter[] parameters = { SqlParamHelper.MakeInParam("@Agency",SqlDbType.VarChar,50,model.Agency), SqlParamHelper.MakeInParam("@ParentId",SqlDbType.Int,4,model.ParentId), SqlParamHelper.MakeInParam("@Sort",SqlDbType.Int,4,model.Sort), SqlParamHelper.MakeInParam("@Person",SqlDbType.VarChar,10,model.Person), SqlParamHelper.MakeInParam("@Remark",SqlDbType.VarChar,50,model.Remark) }; return SqlHelper.ExecuteNonQuery(WriteConnectionString,CommandType.Text,cmdText,parameters); }
public void CreateOrganization(Model.Organization organization) { _organizations.Add(organization); }
public int UpdateOrganization(Organization model) { return _OrganizationRepository.UpdateOrganization(model); }
public int AddOrganization(Organization model) { return _OrganizationRepository.AddOrganization(model); }
public int UpdateOrganization(Organization model) { string cmdText = @"Update [Organization] set [Agency]=@Agency,[ParentId]=@ParentId,[Sort]=@Sort,[Person]=@Person,[Remark]=@Remark where Id=@Id"; SqlParameter[] parameters = { SqlParamHelper.MakeInParam("@Id",SqlDbType.Int,4,model.Id), SqlParamHelper.MakeInParam("@Agency",SqlDbType.VarChar,50,model.Agency), SqlParamHelper.MakeInParam("@ParentId",SqlDbType.Int,4,model.ParentId), SqlParamHelper.MakeInParam("@Sort",SqlDbType.Int,4,model.Sort), SqlParamHelper.MakeInParam("@Person",SqlDbType.VarChar,10,model.Person), SqlParamHelper.MakeInParam("@Remark",SqlDbType.VarChar,50,model.Remark) }; return SqlHelper.ExecuteNonQuery(WriteConnectionString,CommandType.Text,cmdText,parameters); }
public void CreateOrganization(Organization organization) { db.Organizations.Add(organization); }
private void SaveOrg() { Organization model = null; string name = GetRequestString("name"); string remark = GetRequestString("remark"); string person = GetRequestString("person"); int sort = GetRequestString("sort").ToInt32(); int parent = GetRequestString("parentId").ToInt32(0); List<Organization> list = _OrganizationService.GetOrganizationsByPid(parent); List<string> listSql = new List<string>(); if(!GetRequestString("Id").IsNullOrEmpty()){ int Id = GetRequestString("Id").ToInt32(); model = _OrganizationService.GetOrganization(Id); if(model.ParentId == parent){ if(sort > list.Count){ sort = list.Count; } if(model.Sort > sort){ _OrganizationService.UpdateParentSortUp(parent,sort,model.Sort); } else if(model.Sort < sort){ _OrganizationService.UpdateParentSortDown(parent,sort,model.Sort); } } else{ if(sort > list.Count + 1){ sort = list.Count + 1; } else{ _OrganizationService.UpdateChildSortUp(parent,sort); _OrganizationService.UpdateChildSortDown(model.ParentId,model.Sort); } } model.Agency = name; model.Person = person; model.Remark = remark; model.Sort = sort; model.ParentId = parent; _OrganizationService.UpdateOrganization(model); } else{ model = new Organization(); model.Agency = name; model.Person = person; model.Remark = remark; if(sort > list.Count + 1){ sort = list.Count + 1; } else{ _OrganizationService.UpdateChildSortUp(parent,sort); _OrganizationService.UpdateChildSortDown(model.ParentId,model.Sort); } model.Sort = sort; model.ParentId = parent; _OrganizationService.AddOrganization(model); } Response.Write("true"); }