CSLA.Net 3.0.5 项目管理示例 业务集合基类（ProjectResources.cs，ProjectResource.cs）

using System; using System.Data; using System.Data.SqlClient; using Csla; using Csla.Data;namespace ProjectTracker.Library {/// <summary>/// 此?类?的?主?要?功?能?用?于?给?Project提?供?对?其?关?联?子?对?象?的?集?合?的?一?个?维?护?和?映?射?，?Project----ProjectResources----ProjectResource/// 她?是?一?个?集?合?，?是?父?对?象?组?织?子?对?象?的?一?个?集?合?/// ，?提?供?用?于?托?管?包?含?的?子?类?，?比?较?，?添?加?，?删?除?子?对?象?等?/// /// </summary>[Serializable()]public class ProjectResources : BusinessListBase<ProjectResources, ProjectResource>{#region Business Methods/// <summary>/// 获?得?一?个?项?目?集?合?中?的?项?目?资?源?对?象?（?）?/// </summary>/// <param name="resourceId">项?目?资?源?ID</param>/// <returns></returns>public ProjectResource GetItem(int resourceId){//从?当?前?对?象?集?合?中?搜?索?其?中?的?子?对?象?，?比?较?参?数?ID，?相?等?则?返?回?foreach (ProjectResource res in this)if (res.ResourceId == resourceId)return res;return null;}/// <summary>/// 通?过?指?定?的?ID值?，?像?当?前?集?合?中?加?入?子?对?象?，?分?配?/// </summary>/// <param name="resourceId">待?加?入?子?对?象?的?ID</param>public void Assign(int resourceId){if (!Contains(resourceId)){ProjectResource resource = ProjectResource.NewProjectResource(resourceId);this.Add(resource);}elsethrow new InvalidOperationException("资?源?已?经?在?项?目?中?存?在?");}/// <summary>/// 从?集?合?中?移?除?一?个?资?源?子?对?象?/// </summary>/// <param name="resourceId">待?移?除?子?对?象?id</param>public void Remove(int resourceId){foreach (ProjectResource res in this){if (res.ResourceId == resourceId){//从?集?合?类?中?移?除?，?集?合?类?是?一?个?泛?型?，?由?于?BusinessListBase集?成?自?集?合?基?类?，?所?以?他?也?同?时?拥?有?集?合?的?方?法?//Remove,Add等?，?这?个?操?作?应?该?将?数?据?放?到?DEleteList中?Remove(res);break;}}}/// <summary>/// 检?查?集?合?中?是?否?包?含?此?子?对?象?，?如?果?包?含?返?回?True，?否?则?返?回?false/// </summary>/// <param name="resourceId">子?对?象?ID，?资?源?id用?的?是?整?型?</param>/// <returns></returns>public bool Contains(int resourceId){foreach (ProjectResource res in this)if (res.ResourceId == resourceId)return true;return false;}/// <summary>/// 在?删?除?已?删?除?的?集?合?中?搜?索?子?对?象?的?存?在?/// </summary>/// <param name="resourceId"></param>/// <returns></returns>public bool ContainsDeleted(int resourceId){foreach (ProjectResource res in DeletedList)if (res.ResourceId == resourceId)return true;return false;}#endregion#region Factory Methods/// <summary>/// 内?联?工?厂?，?代?表?同?一?个?程?序?集?中?调?用?，?因?为?他?只?是?提?供?给?project对?象?在?创?建?的?时?候?同?时?被?创?建?的?一?个?方?法?，?调?用?请?看?project/// 而?UI不?会?去?使?用?她?/// </summary>/// <returns></returns>internal static ProjectResources NewProjectResources(){return new ProjectResources();}/// <summary>/// 通?过?dr获?得?一?个?集?合?/// </summary>/// <param name="dr"></param>/// <returns></returns>internal static ProjectResources GetProjectResources(SafeDataReader dr){//调?用?带?参?数?的?构?造?器?return new ProjectResources(dr);}/// <summary>/// 默?认?构?造?器?/// </summary>private ProjectResources(){//标?记?为?子?关?系?MarkAsChild();}/// <summary>/// 带?参?数?的?构?造?器?/// </summary>/// <param name="dr"></param>private ProjectResources(SafeDataReader dr){MarkAsChild();Fetch(dr);}#endregion#region Data Access// c从?数?据?看?加?载?数?据?private void Fetch(SafeDataReader dr){//将?列?表?更?改?事?件?暂?时?设?置?为?失?效?，?增?加?效?率?（?）?this.RaiseListChangedEvents = false;while (dr.Read())this.Add(ProjectResource.GetResource(dr));//DR传?个?子?对?象?用?于?初?始?化?一?个?子?对?象?//启?用?事?件?this.RaiseListChangedEvents = true;}/// <summary>/// （?）?，?这?个?方?法?是?内?联?方?法?，?因?为?她?只?是?Project来?调?用?的?/// 托?管?让?每?一?个?子?对?象?都?做?相?应?的?操?作?/// </summary>/// <param name="project"></param>internal void Update(Project project){this.RaiseListChangedEvents = false;// update (thus deleting) any deleted child objects//从?已?删?除?列?表?中?轮?寻?每?一?个?元?素?调?用?其?删?除?自?身?方?法?，?注?意?他?们?要?传?入?其?关?联?的?项?目?对?象?foreach (ProjectResource obj in DeletedList)obj.DeleteSelf(project);//从?数?据?库?中?删?除?（?）?// now that they are deleted, remove them from memory too//将?DeletedList从?系?统?缓?存?中?移?除?掉?所?有?的?元?素?，?deletedList被?清?空?，?同?步?数?据?库?DeletedList.Clear();// add/update any current child objects// 再?来?看?看?添?加?和?更?新?是?如?何?实?现?的?，?同?样?要?传?入?相?应?关?联?的?项?目?对?象?// 轮?寻?每?一?个?子?元?素?，?查?看?其?标?志?，?如?果?是?新?的?就?调?用?子?对?象?的?插?入?方?法?// 如?果?不?是?新?的?，?那?么?就?调?用?更?新?方?法?foreach (ProjectResource obj in this){//根?据?子?对?象?的?状?态?调?用?合?适?的?方?法?if (obj.IsNew)obj.Insert(project);elseobj.Update(project);}this.RaiseListChangedEvents = true;}#endregion} }

 

using System; using System.Data; using System.Data.SqlClient; using Csla; using Csla.Data; using Csla.Validation;namespace ProjectTracker.Library {/// <summary>/// 此?类?为?分?配?资?源?类?，?用?于?和?ProjectResources类?合?作?为?Project处?理?分?配?给?项?目?的?资?源?的?类?、?/// 集?成?子?业?务?基?类?，?与?project是?相?同?的?，?但?是?她?还?集?成?自?一?个?IholdRoles接?口?/// 这?个?类?只?提?供?给?ProjectResources使?用?/// </summary>[Serializable()]public class ProjectResource : BusinessBase<ProjectResource>, IHoldRoles{#region Business Methodsprivate int _resourceId;//资?源?idprivate string _firstName = string.Empty;//名?字?private string _lastName = string.Empty;//姓?氏?private SmartDate _assigned;//分?配?日?期?private int _role;//职?位?private byte[] _timestamp = new byte[8];//时?间?戳?，?用?于?处?理?并?发?修?改?的?情?况?，?先?写?者?赢?的?乐?观?并?发?//表?明?特?性?，?表?示?是?主?键?，?但?是?并?不?一?定?是?唯?一?的?可?识?别?值?[System.ComponentModel.DataObjectField(false, true)]public int ResourceId{[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]get{CanReadProperty(true);return _resourceId;}}public string FirstName{[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]get{CanReadProperty(true);return _firstName;}}public string LastName{[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]get{CanReadProperty(true);return _lastName;}}/// <summary>/// 全?名?属?性?/// </summary>public string FullName{[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]get{if (CanReadProperty("FirstName") && CanReadProperty("LastName"))return string.Format("{0}, {1}", LastName, FirstName);elsethrow new System.Security.SecurityException( "没?有?读?取?权?限?");}}/// <summary>/// 分?配?日?期?/// </summary>public string Assigned{[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]get{CanReadProperty(true);//获?取?时?间?的?文?本?return _assigned.Text;}}public int Role{[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]get{CanReadProperty(true);return _role;}[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]set{CanWriteProperty(true);//如?果?不?重?复?则?更?改?if (!_role.Equals(value)){_role = value;//1调?用?对?数?据?验?证?规?则?的?检?查?AddBusinessRules,2,IsDirty标?记?已?经?修?改?,//3,出?发?属?性?更?改?事?件?提?供?给?UI刷?新?的?警?示?(411)，?发?生?变?化?就?要?调?用?此?方?法?PropertyHasChanged();}}}//获?得?资?源?public Resource GetResource(){return Resource.GetResource(_resourceId);}//提?供?Id，?是?为?了?支?持?Object的?，?Equals().toString(),GetHashCode()protected override object GetIdValue(){return _resourceId;}#endregion#region Validation Rulesprotected override void AddBusinessRules(){//通?过?RuleHandler委?托?，?调?用?Assignment.ValidRole方?法?，?对?Role进?行?验?证?，?这?个?方?法?在?Assignment中?定?义?，?你?可?以?看?一?下?，?是?公?用?的?方?法?//如?果?返?回?false的?话?就?是?代?表?验?证?失?败?，?true验?证?成?功?ValidationRules.AddRule( new Csla.Validation.RuleHandler( Assignment.ValidRole), "Role");}#endregion#region Authorization Rulesprotected override void AddAuthorizationRules(){//只?有?ProjectManager，?才?有?权?限?修?改?RoleAuthorizationRules.AllowWrite( "Role", "ProjectManager");}#endregion#region Factory Methodsinternal static ProjectResource NewProjectResource(int resourceId){//调?用?构?造?器?初?始?化?，?，?获?得?一?个?资?源?，?，?给?予?一?个?默?认?职?位?return new ProjectResource( Resource.GetResource(resourceId), RoleList.DefaultRole());}internal static ProjectResource GetResource(SafeDataReader dr){//调?用?构?造?器?初?始?化?return new ProjectResource(dr);}//默?认?构?造?private ProjectResource(){//标?记?为?子?很?重?要?，?必?须?的?MarkAsChild();}/// <summary>/// 通?过?一?个?已?有?资?源?，?和?一?个?职?位?来?构?造?一?个?ProjectResource/// </summary>/// <param name="resource"></param>/// <param name="role"></param>private ProjectResource(Resource resource, int role){MarkAsChild();_resourceId = resource.Id;_lastName = resource.LastName;_firstName = resource.FirstName;_assigned.Date = Assignment.GetDefaultAssignedDate();_role = role;}/// <summary>/// 单?参?数?构?造?，?这?个?时?候?DR是?一?个?记?录?/// </summary>/// <param name="dr"></param>private ProjectResource(SafeDataReader dr){MarkAsChild();Fetch(dr);}#endregion#region Data Accessprivate void Fetch(SafeDataReader dr){_resourceId = dr.GetInt32("ResourceId");_lastName = dr.GetString("LastName");_firstName = dr.GetString("FirstName");_assigned = dr.GetSmartDate("Assigned");_role = dr.GetInt32("Role");//非?常?标?准?的?时?间?戳?dr.GetBytes("LastChanged", 0, _timestamp, 0, 8);//做?旧?，?因?为?此?对?象?与?数?据?库?是?数?据?同?步?的?MarkOld();}/// <summary>/// 内?联?的?，?当?其?父?对?象?调?用?此?对?象?时?候?判?断?对?象?状?态?，?isDeleted=false isnew=true，?调?用?此?方?法?/// </summary>/// <param name="project"></param>internal void Insert(Project project){// if we're not dirty then don't update the database//如?果?当?前?对?象?不?脏?也?就?是?没?有?给?其?付?过?值?，?没?有?必?要?更?新?到?数?据?库?if (!this.IsDirty) return;using (SqlConnection cn = new SqlConnection(Database.PTrackerConnection)){cn.Open();//调?用?分?派?类?中?的?方?法?，?并?且?返?回?时?间?戳?//参?数?是?连?接?，?项?目?id父?id，?资?源?id子?id，?分?配?时?间?，?角?色?_timestamp = Assignment.AddAssignment(cn, project.Id, _resourceId, _assigned, _role);//做?旧?This对?象?，?因?为?她?已?经?与?数?据?库?同?步?，?也?就?是?说?她?已?经?在?数?据?库?中?了?，?不?是?新?的?数?据?库?//这?个?方?法?如?果?是?在?根?对?象?数?据?门?户?会?自?动?调?用?，?但?是?子?对?象?需?要?手?动?//这?个?方?法?会?将?isNew标?记?，?和?IsDirty标?记?设?置?为?False，?因?为?这?时?，?这?个?数?据?既?不?是?新?的?也?不?是?脏?的?MarkOld();}}internal void Update(Project project){// if we're not dirty then don't update the databaseif (!this.IsDirty) return;using (SqlConnection cn = new SqlConnection(Database.PTrackerConnection)){cn.Open();//与?Insert同?理?_timestamp = Assignment.UpdateAssignment(cn, project.Id, _resourceId, _assigned, _role, _timestamp);MarkOld();}}internal void DeleteSelf(Project project){// if we're not dirty then don't update the databaseif (!this.IsDirty) return;// if we're new then don't update the databaseif (this.IsNew) return;using (SqlConnection cn = new SqlConnection(Database.PTrackerConnection)){cn.Open();Assignment.RemoveAssignment(cn, project.Id, _resourceId);MarkNew();}}#endregion} }

 

 

//此?业?务?类?实?现?与?.0完?全?一?致? using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using Csla; using Csla.Validation; using Csla.Data; using System.Reflection;namespace ProjectTracker.Library {//定?义?这?个?接?口?是?为?了?使?子?类?提?供?，?可?以?提?供?对?Role属?性?的?访?问?internal interface IHoldRoles{int Role { get; set; }}/// <summary>/// 这?个?类?定?义?为?内?联?的?，?同?时?是?静?态?的?，?是?因?为?这?个?类?是?提?供?了?ProjectResource和?ResourceAssignmet的?通?用?方?法?的?集?合?，?因?为?/// 这?个?两?个?对?象?都?在?操?作?这?相?同?的?数?据?，?一?个?资?源?属?于?某?个?项?目?，?和?一?个?项?目?拥?有?多?少?资?源?在?是?一?个?含?义?/// 静?态?类?，?是?因?为?这?个?类?没?有?任?何?私?有?变?量?，?也?就?是?数?据?域?，?所?以?声?明?为?静?态?方?便?使?用?/// 此?对?象?对?Assignment表?进?行?操?作?，?这?个?表?是?一?个?中?间?表?，?用?来?存?储?多?对?多?的?表?数?据?映?射?/// 通?用?原?则?/// </summary>internal static class Assignment{#region Business Methods/// <summary>/// 获?得?默?认?的?分?配?时?间?/// </summary>/// <returns></returns>public static DateTime GetDefaultAssignedDate(){return DateTime.Today;}#endregion#region Validation Rules/// <summary>/// Ensure the Role property value exists/// in RoleList/// 像?上?面?的?英?文?解?释?一?样?，?这?个?验?证?确?保?了?Role在?RoleList中?可?以?被?找?到?/// 这?个?方?法?是?一?个?公?用?的?验?证?方?法?ProjectResource和?ResourceAssignmet通?过?委?托?来?调?用?这?个?方?法?验?证?/// </summary>public static bool ValidRole(object target, RuleArgs e){int role = ((IHoldRoles)target).Role;//通?过?RoleList的?GetList获?得?List对?象?，?RolesList对?象?拥?有?的?ContainsKey方?法?可?以?判?断?此?id在?列?表?中?是?否?存?在?if (RoleList.GetList().ContainsKey(role))return true;else{e.Description = "职?务?必?须?在?职?务?列?表?中?存?在?";return false;}}#endregion#region Data Access/// <summary>/// 添?加?一?个?分?配?/// </summary>/// <param name="cn">连?接?</param>/// <param name="projectId">项?目?id</param>/// <param name="resourceId">资?源?id</param>/// <param name="assigned">分?配?时?间?</param>/// <param name="role">职?位?</param>/// <returns></returns>public static byte[] AddAssignment(SqlConnection cn, Guid projectId, int resourceId, SmartDate assigned, int role){using (SqlCommand cm = cn.CreateCommand()){cm.CommandText = "addAssignment";return DoAddUpdate(cm, projectId, resourceId, assigned, role);}}/// <summary>/// 更?新?一?个?分?配?/// </summary>/// <param name="cn">连?接?</param>/// <param name="projectId">项?目?id</param>/// <param name="resourceId">资?源?id</param>/// <param name="assigned">分?配?时?间?</param>/// <param name="newRole">更?新?后?的?职?位?</param>/// <param name="timestamp">时?间?戳?</param>/// <returns></returns>public static byte[] UpdateAssignment(SqlConnection cn, Guid projectId, int resourceId, SmartDate assigned, int newRole, byte[] timestamp){using (SqlCommand cm = cn.CreateCommand()){cm.CommandText = "updateAssignment";cm.Parameters.AddWithValue("@lastChanged", timestamp);return DoAddUpdate( cm, projectId, resourceId, assigned, newRole);}}/// <summary>/// 添?加?和?更?新?的?公?共?方?法?/// </summary>/// <param name="cm"></param>/// <param name="projectId"></param>/// <param name="resourceId"></param>/// <param name="assigned"></param>/// <param name="newRole"></param>/// <returns></returns>private static byte[] DoAddUpdate(SqlCommand cm, Guid projectId, int resourceId, SmartDate assigned, int newRole){cm.CommandType = CommandType.StoredProcedure;cm.Parameters.AddWithValue("@projectId", projectId);cm.Parameters.AddWithValue("@resourceId", resourceId);cm.Parameters.AddWithValue("@assigned", assigned.DBValue);cm.Parameters.AddWithValue("@role", newRole);//时?间?戳?返?回?值?SqlParameter param = new SqlParameter("@newLastChanged", SqlDbType.Timestamp);param.Direction = ParameterDirection.Output;cm.Parameters.Add(param);cm.ExecuteNonQuery();return (byte[])cm.Parameters["@newLastChanged"].Value;}/// <summary>/// 删?除?一?个?分?配?/// </summary>/// <param name="cn"></param>/// <param name="projectId"></param>/// <param name="resourceId"></param>public static void RemoveAssignment(SqlConnection cn, Guid projectId, int resourceId){using (SqlCommand cm = cn.CreateCommand()){cm.CommandType = CommandType.StoredProcedure;cm.CommandText = "deleteAssignment";cm.Parameters.AddWithValue("@projectId", projectId);cm.Parameters.AddWithValue("@resourceId", resourceId);cm.ExecuteNonQuery();}}#endregion} }

 

代码下载：CSLA3.0中文学习演示程序1.2.rar

转载于:https://www.cnblogs.com/doubleyan/archive/2009/10/06/2164965.html

总结

以上是生活随笔为你收集整理的CSLA.Net 3.0.5 项目管理示例 业务集合基类（ProjectResources.cs，ProjectResource.cs）的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。