XPO实践总结

昨天做了XPO方面的相关实践。感觉刚开始用的时候不是太顺手，呵呵，很多东西都不熟悉。经过了近一天的努力终于基本上完成了。在这里总结一下。

一共就两个对象：KOL，FamilyMember 。两对象为主从关系。

KOL
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using DevExpress.Xpo;
namespace XPOTest
{
    public class KOL:XPBaseObject
    {
        private Guid id;
        [Key(true)]
        public Guid ID
        {
            get { return id; }
            set { id = value; }
        }

        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }

        private bool gender;

        public bool Gender
        {
            get { return gender; }
            set { gender = value; }
        }

        private byte[] photo;

        public byte[] Photo
        {
            get { return photo; }
            set { photo = value; }
        }

        private string hospital;

        public string Hospital
        {
            get { return hospital; }
            set { hospital = value; }
        }

        private string department;

        public string Department
        {
            get { return department; }
            set { department = value; }
        }

        private string city;

        public string City
        {
            get { return city; }
            set { city = value; }
        }

        private string postcode;

        public string Postcode
        {
            get { return postcode; }
            set { postcode = value; }
        }

        private string address;

        public string Address
        {
            get { return address; }
            set { address = value; }
        }

        private string phone;

        public string Phone
        {
            get { return phone; }
            set { phone = value; }
        }

        private string mobile;

        public string Mobile
        {
            get { return mobile; }
            set { mobile = value; }
        }

        private string email;

        public string Email
        {
            get { return email; }
            set { email = value; }
        }

        private string title;

        public string Title
        {
            get { return title; }
            set { title = value; }
        }
        [Association("k-f", typeof(FamilyMember)), Aggregated]
        public XPCollection FamilyMember
        {
            get
            {
                return GetCollection("FamilyMember");
            }
        }
    }
}

FamilyMember
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using DevExpress.Xpo;
namespace XPOTest
{
    public class FamilyMember:XPBaseObject
    {
        private  Guid id;
        [Key(true)]
        public Guid ID
        {
            get { return id; }
            set { id = value; }
        }
        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        private string relationship;

        public string Relationship
        {
            get { return relationship; }
            set { relationship = value; }
        }
        private string phone;

        public string Phone
        {
            get { return phone; }
            set { phone = value; }
        }
        private string birthday;

        public string Birthday
        {
            get { return birthday; }
            set { birthday = value; }
        }
        private string company;

        public string Company
        {
            get { return company; }
            set { company = value; }
        }
        private string title;

        public string Title
        {
            get { return title; }
            set { title = value; }
        }
        private string remarks;

        public string Remarks
        {
            get { return remarks; }
            set { remarks = value; }
        }
        [Association("k-f")]
        public KOL KOL;
    }
}

sqlConnectionString
   public class sqlconnstr
    {
        public static string connstr=DevExpress.Xpo.DB.MSSqlConnectionProvider.GetConnectionString("Harry", "sa", "guodapeng", "test");
    }

Operation
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using DevExpress.Xpo;
using DevExpress.Data.Filtering;
using System.IO;
using System.Drawing;

namespace XPOTest
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                showallkol();
                showallfam();
            }
        }

        //添加讲师记录
        protected void btn_add_Click(object sender, EventArgs e)
        {
            if (kolexit())
            {
                DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
                KOL k1 = new KOL();

                k1.Name = this.txt_name.Text;
                if (this.rb_male.Checked)
                {
                    k1.Gender = true;
                }
                else
                {
                    k1.Gender = false;
                }

                HttpPostedFile hpf = this.fileupload.PostedFile;
                byte[] file = new byte[hpf.ContentLength];
                Stream ss = hpf.InputStream;
                ss.Read(file, 0, hpf.ContentLength);

                k1.Photo = file;
                Response.Write(file.Length);
                k1.Hospital = this.txt_hospital.Text;
                k1.Department = this.txt_department.Text;
                k1.City = this.txt_city.Text;
                k1.Postcode = this.txt_postcode.Text;
                k1.Address = this.txt_address.Text;
                k1.Phone = this.txt_phone.Text;
                k1.Mobile = this.txt_mobile.Text;
                k1.Email = this.txt_email.Text;
                k1.Title = this.txt_title.Text;

                k1.Save();
                
                this.txt_name.Text = "";
                this.txt_hospital.Text = "";
                this.txt_department.Text = "";
                this.txt_city.Text = "";
                this.txt_postcode.Text = "";
                this.txt_address.Text = "";
                this.txt_phone.Text = "";
                this.txt_mobile.Text = "";
                this.txt_email.Text = "";
                this.txt_title.Text = "";
                
                showallkol();
            }
            else
            {
                Response.Write("该ＩＤ讲师信息已经存在或为空，请重新添加！");
            }
        }

        //删除讲师记录
        protected void btn_del_Click(object sender, EventArgs e)
        {
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
            XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(KOL), new BinaryOperator("Name",this.txt_name.Text, BinaryOperatorType.Equal));
            DevExpress.Xpo.Session.DefaultSession.Delete(collection);
            DevExpress.Xpo.Session.DefaultSession.PurgeDeletedObjects();
                        
            this.txt_name.Text = "";
            this.txt_hospital.Text = "";
            this.txt_department.Text = "";
            this.txt_city.Text = "";
            this.txt_postcode.Text = "";
            this.txt_address.Text = "";
            this.txt_phone.Text = "";
            this.txt_mobile.Text = "";
            this.txt_email.Text = "";
            this.txt_title.Text = "";

            showallkol();
            showallfam();
        }

        //显示所有讲师的信息
        public void showallkol()　
        {            
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
            XPCollection kols = new XPCollection(typeof(KOL));
            this.dl_kol.DataSource = kols;
            this.dl_kol.DataBind();
        }

        //显示所有家属的信息
        public void showallfam()
        {
            
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
            XPCollection familys = new XPCollection(typeof(FamilyMember));
            this.dl_fkol.DataSource = familys;
            this.dl_fkol.DataBind();
        }

        //根据ＩＤ查找讲师记录
        protected void btn_search_Click(object sender, EventArgs e)
        {
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;

            if (this.txt_name.Text == "")
            { }
            else
            {
                XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(KOL), new BinaryOperator("Name",this.txt_name.Text, BinaryOperatorType.Equal));
                
                if (collection.Count > 0)
                {
                    foreach (KOL k1 in collection)
                    {
                        this.txt_name.Text = k1.Name;
                        if (k1.Gender == true)
                        {
                            this.rb_male.Checked = true;
                        }
                        else
                        {
                            this.rb_female.Checked = true;
                        }

                        this.txt_hospital.Text = k1.Hospital;
                        this.txt_department.Text = k1.Department;
                        this.txt_city.Text = k1.City;
                        this.txt_postcode.Text = k1.Postcode;
                        this.txt_address.Text = k1.Address;
                        this.txt_phone.Text = k1.Phone;
                        this.txt_mobile.Text = k1.Mobile;
                        this.txt_email.Text = k1.Email;
                        this.txt_title.Text = k1.Title;
                    }
                    this.dl_kol.DataSource = collection;
                    this.dl_kol.DataBind();

                    this.dl_fkol.DataSource = ((KOL)collection[0]).FamilyMember;
                    this.dl_fkol.DataBind();
                }
                else
                {
                    
                }
            }
        }

        //添加多个家属
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (fexit())
            {
                DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
                XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(KOL), new BinaryOperator("Name",this.txt_name.Text, BinaryOperatorType.Equal));

                FamilyMember f1 = new FamilyMember();

                f1.Name = this.txt_fname.Text;
                f1.Relationship = this.txt_frelationship.Text;
                f1.Phone = this.txt_fphone.Text;
                f1.Birthday = this.txt_fbirthday.Text;
                f1.Company = this.txt_fcompany.Text;
                f1.Title = this.txt_ftitle.Text;
                f1.Remarks = this.txt_fremarks.Text;
                f1.KOL = (KOL)collection[0];

                f1.Save();
                                
                this.txt_fname.Text = "";
                this.txt_frelationship.Text = "";
                this.txt_fphone.Text = "";
                this.txt_fbirthday.Text = "";
                this.txt_fcompany.Text = "";
                this.txt_ftitle.Text = "";
                this.txt_fremarks.Text = "";

                showallfam();
            }
            else
            {
                Response.Write("该ＩＤ家属信息已经存在或为空或未选择讲师ＩＤ，请重新添加！");
            }
        }

        //删除家属信息
        protected void btn_fdel_Click(object sender, EventArgs e)
        {
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
            XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(FamilyMember), new BinaryOperator("Name",this.txt_fname.Text, BinaryOperatorType.Equal));

            ((FamilyMember)collection[0]).Delete();

            this.txt_fname.Text = "";
            this.txt_frelationship.Text = "";
            this.txt_fphone.Text = "";
            this.txt_fbirthday.Text = "";
            this.txt_fcompany.Text = "";
            this.txt_ftitle.Text = "";
            this.txt_fremarks.Text = "";

            showallfam();
        }

        //根据ＩＤ查找家属信息
        protected void btn_fsearch_Click(object sender, EventArgs e)
        {
            if (this.txt_fname.Text == "")
            { }
            else
            {                
                DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
                XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(FamilyMember), new BinaryOperator("Name",this.txt_fname.Text, BinaryOperatorType.Equal));
                if (collection.Count > 0)
                {
                    FamilyMember f = (FamilyMember)collection[0];
                    this.txt_fname.Text = f.Name;
                    this.txt_frelationship.Text = f.Relationship;
                    this.txt_fphone.Text = f.Phone;
                    this.txt_fbirthday.Text = f.Birthday;
                    this.txt_fcompany.Text = f.Company;
                    this.txt_ftitle.Text = f.Title;
                    this.txt_fremarks.Text = f.Remarks;

                    this.dl_fkol.DataSource = collection;
                    this.dl_fkol.DataBind();
                }
                else
                { }
            }
        }

        //修改家属信息
        protected void btn_fmodify_Click(object sender, EventArgs e)
        {
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
            XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(FamilyMember), new BinaryOperator("Name",this.txt_fname.Text, BinaryOperatorType.Equal));

            FamilyMember f1 = (FamilyMember)collection[0];

            f1.Name = this.txt_fname.Text;
            f1.Relationship = this.txt_frelationship.Text;
            f1.Phone = this.txt_fphone.Text;
            f1.Birthday = this.txt_fbirthday.Text;
            f1.Company = this.txt_fcompany.Text;
            f1.Title = this.txt_ftitle.Text;
            f1.Remarks = this.txt_fremarks.Text;

            f1.Save();

            showallfam();
        }

        //修改讲师信息
        protected void btn_modify_Click(object sender, EventArgs e)
        {
            DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
            XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(KOL), new BinaryOperator("Name", this.txt_name.Text, BinaryOperatorType.Equal));

            KOL k1 = (KOL)collection[0];              
            k1.Name = this.txt_name.Text;
            if (this.rb_male.Checked)
            {
                k1.Gender = true;
            }
            else
            {
                k1.Gender = false;
            }

            HttpPostedFile hpf = this.fileupload.PostedFile;
            byte[] file = new byte[hpf.ContentLength];
            Stream ss = hpf.InputStream;
            ss.Read(file, 0, hpf.ContentLength);

            k1.Photo = file;
            k1.Hospital = this.txt_hospital.Text;
            k1.Department = this.txt_department.Text;
            k1.City = this.txt_city.Text;
            k1.Postcode = this.txt_postcode.Text;
            k1.Address = this.txt_address.Text;
            k1.Phone = this.txt_phone.Text;
            k1.Mobile = this.txt_mobile.Text;
            k1.Email = this.txt_email.Text;
            k1.Title = this.txt_title.Text;

            k1.Save();

            showallkol();
        }

        //添加前根据讲师ＩＤ检查讲师信息是否已经存在
        public bool kolexit()
        {
            if (this.txt_name.Text == "")
            {
                return false;
            }
            else
            {
                DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
                XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(KOL), new BinaryOperator("Name",this.txt_name.Text, BinaryOperatorType.Equal));
                if (collection.Count > 0 || this.txt_name.Text == "")
                {
                    return false;
                }
                else
                {
                    return true;
                }
            }
        }
        //添加前根据家属ＩＤ检查讲师家属信息是否已经存在
        public bool fexit()
        {
            if (this.txt_fname.Text == "")
            {
                return false;
            }
            else
            {
                DevExpress.Xpo.XpoDefault.ConnectionString = sqlconnstr.connstr;
                XPCollection collection = new XPCollection(DevExpress.Xpo.Session.DefaultSession, typeof(FamilyMember), new BinaryOperator("Name", this.txt_fname.Text, BinaryOperatorType.Equal));
                if (collection.Count > 0 || this.txt_fname.Text == "")
                {
                    return false;
                }
                else
                {
                    return true;
                }
            }
        }

        public void databing()
        {
 
        }
    }
}

感觉这个东西不是太好用，可能是我还没用习惯,呵呵.        


点这里下载源程序

转载于:https://www.cnblogs.com/guodapeng/archive/2007/04/20/720659.html