/// <summary> /// 返回SQLCommand /// </summary> /// <param name="person"></param> /// <returns></returns> public static SqlCommand InsertBySQLCommand(Person person,string opertion) { SqlCommand sqlCommand = new SqlCommand(); if (opertion == "Delete") { sqlCommand.CommandText = @"Delete from [Person] Where ID =@ID"; sqlCommand.Parameters.Add(new SqlParameter("@ID", person.ID)); return sqlCommand; } if (opertion == "Insert") { sqlCommand.CommandText = @"INSERT INTO [Person] (SysVersion, Code, Name, Telphone, Address, PostCode, Gender, Disabled, NativePlace, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy, ID) VALUES (@SysVersion, @Code, @Name, @Telphone, @Address, @PostCode, @Gender, @Disabled, @NativePlace, @CreatedOn, @CreatedBy, @UpdatedOn, @UpdatedBy, @ID)"; } if (opertion == "Update") { sqlCommand.CommandText = @"Update [Person] Set SysVersion =@SysVersion, Code=@Code, Name=@Name, Telphone=@Telphone, Address=@Address, PostCode=@PostCode, Gender=@Gender, Disabled= @Disabled, NativePlace=@NativePlace, CreatedOn=@CreatedOn, CreatedBy=@CreatedBy, UpdatedOn=@UpdatedOn, UpdatedBy=@UpdatedBy Where ID=@ID"; } sqlCommand.Parameters.Add(new SqlParameter("@SysVersion", person.SysVersion)); sqlCommand.Parameters.Add(new SqlParameter("@Code", person.Code)); sqlCommand.Parameters.Add(new SqlParameter("@Name", person.Name)); sqlCommand.Parameters.Add(new SqlParameter("@Telphone", person.Telphone)); sqlCommand.Parameters.Add(new SqlParameter("@Address", person.Address)); sqlCommand.Parameters.Add(new SqlParameter("@PostCode", person.PostCode)); sqlCommand.Parameters.Add(new SqlParameter("@Gender", person.Gender)); sqlCommand.Parameters.Add(new SqlParameter("@Disabled", person.Disabled)); sqlCommand.Parameters.Add(new SqlParameter("@NativePlace", person.NativePlace)); sqlCommand.Parameters.Add(new SqlParameter("@CreatedOn", person.CreatedOn)); sqlCommand.Parameters.Add(new SqlParameter("@CreatedBy", person.CreatedBy)); sqlCommand.Parameters.Add(new SqlParameter("@UpdatedOn", person.UpdatedOn)); sqlCommand.Parameters.Add(new SqlParameter("@UpdatedBy", person.UpdatedBy)); sqlCommand.Parameters.Add(new SqlParameter("@ID", person.ID)); return sqlCommand; }
/// <summary> /// 创建新的实体 /// </summary> /// <param name="code"></param> /// <param name="name"></param> /// <param name="disabled"></param> /// <param name="id"></param> /// <returns></returns> public static Person CreatePerson(string code, String name, bool disabled, Guid id) { var person = new Person(); person.Birthday = DateTime.Now; person.Telphone = "15264183573"; person.Address = "济南"; person.PostCode = "250014"; person.Gender = true; person.Disabled = disabled; person.NativePlace = "汉"; if (id != Guid.Empty) { person.ID = id; } person.Code = code; person.Name = name; person.CreatedOn = DateTime.Now; person.CreatedBy = "DS"; person.UpdatedOn = DateTime.Now; person.UpdatedBy = "DS"; return person; }
public virtual void RemoveChild(Person child) { this.Persons.Remove(child); child.Department = null; }
public virtual void AddChild(Person child) { this.Persons.Add(child); child.Department = this; }