jobdetailsform.cs

有关客户管理的功能

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace 客户管理项目
{
    public partial class JobDetailsForm : Form
    {
        public JobDetailsForm()
        {
            InitializeComponent();
        }

        private void editCarNo_Leave(object sender, EventArgs e)
        {
            if ((editCarNo.Text == "") || (editCarNo.Text == null))
            {
                MessageBox.Show("Please specify a valid value for the car number","Error in input");
                editCarNo.Focus();
            }
        }

        public void FillDataSet(客户管理项目.JobDetails dataSet)
        {
            dataSet.EnforceConstraints = false;
            try
            {
                this.oleDbConnection1.Open();
                this.oleDbDataAdapter1.Fill(dataSet);
            }
            catch (System.Exception fillException)
            {
                throw fillException;
            }
            finally
            {
                dataSet.EnforceConstraints = true;
                this.oleDbConnection1.Close();
            }
        }

        public void UpdateDataSource(客户管理项目.JobDetails ChangedRows)
        {
            try
            {
                if ((ChangedRows != null))
                {
                    this.oleDbConnection1.Open();
                    oleDbDataAdapter1.Update(ChangedRows);
                }

            }
            catch (System.Exception updataException)
            {
                throw updataException;
            }
            finally
            {
                this.oleDbConnection1.Close();
            }


        }


        public void LoadDataSet()
        {
            客户管理项目.JobDetails objDataSetTemp;
            objDataSetTemp = new 客户管理项目.JobDetails();
            try
            {
                this.FillDataSet(objDataSetTemp);
            }
            catch (System.Exception eFillDataSet)
            {
                throw eFillDataSet;
            }
            try
            {
                JobDetailsDataSet1.Clear();
                JobDetailsDataSet1.Merge(objDataSetTemp);
                //objJobDataSet.Clear();
                //objJobDataSt.Merge(objDataSetTemp);
            }
            catch(System.Exception eLoadMerge)
            {
                throw eLoadMerge;
            }

        }


        public void UpdateDataSet()
        {
            客户管理项目.JobDetails objDataSetChange = new 客户管理项目.JobDetails();
            this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].EndCurrentEdit();
            objDataSetChange = ((客户管理项目.JobDetails)(JobDetailsDataSet1.GetChanges()));
            if(objDataSetChange != null)
            {
                try
                {
                    this.UpdateDataSource(objDataSetChange);
                    JobDetailsDataSet1.Merge(objDataSetChange);
                    JobDetailsDataSet1.AcceptChanges();
                    MessageBox.Show("Database Updateed!");
                }
                catch (System.Exception eUpdate)
                {
                    throw eUpdate;
                }

            }
        }

        private void btnLoad_Click(object sender, EventArgs e)
        {
            try
            {
                this.LoadDataSet();
            }
            catch (System.Exception eLoad)
            {
                System.Windows.Forms.MessageBox.Show(eLoad.Message);
            }
            this.objJobDataSe_PositionChanged();
        }

        private void btnCancelAll_Click(object sender, EventArgs e)
        {
            this.JobDetailsDataSet1.RejectChanges();
        }


        private void objJobDataSe_PositionChanged()
        {
            this.lblNavLocation.Text = (((this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position + 1)).ToString() + "of" + this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Count.ToString());
        }

        private void btnNavNext_Click(object sender, EventArgs e)
        {
            this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position = (this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position + 1);
            this.objJobDataSe_PositionChanged();
        }

        private void btnLast_Click(object sender, EventArgs e)
        {
            this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position = (this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Count - 1);
            this.objJobDataSe_PositionChanged();

        }

        private void btnNavPrev_Click(object sender, EventArgs e)
        {
            this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position = (this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position - 1);
            this.objJobDataSe_PositionChanged();
        }

        private void btnNavFirst_Click(object sender, EventArgs e)
        {
            this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position = 0;
            this.objJobDataSe_PositionChanged();
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            if (editCarNo.Text.Length < 6)
            {
                MessageBox.Show("CarNo必须小于6位!.");
                editCarNo.Focus();
                return;
            }
            try
            {
                if (Convert.ToInt32(editWorkerId.Text) < 1)
                {
                    MessageBox.Show("员工编号必须为整数!.");
                    editWorkerId.Focus();
                    return;
                }
                if (Convert.ToDateTime(editJobDate.Value) > DateTime.Today)
                {
                    MessageBox.Show("请核对时间是否准确!");
                    editJobDate.Focus();
                    return;
                }
            }
            catch (Exception exception)
            {
                MessageBox.Show(exception.Message);
            }
            try
            {
                this.UpdateDataSet();

            }
            catch (System.Exception eUpdate)
            {
                System.Windows.Forms.MessageBox.Show(eUpdate.Message);
            }
            this.objJobDataSe_PositionChanged();
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].EndCurrentEdit();
                this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].AddNew();
            }
            catch (System.Exception eEndEdit)
            {
                System.Windows.Forms.MessageBox.Show(eEndEdit.Message);
            }
            this.objJobDataSe_PositionChanged();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].CancelCurrentEdit();
            this.objJobDataSe_PositionChanged();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            Form1 newForm1 = new Form1();
            newForm1.Show();
            this.Hide();
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if ((this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Count > 0))
            {
                this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].RemoveAt(this.BindingContext[JobDetailsDataSet1, "tblJobDetails"].Position);
                this.objJobDataSe_PositionChanged();
            }
        }

     }
}