customerform.cs

有关客户管理的功能

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

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

        private void CustomerForm_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“customerDataSet11.tblCustomer”中。您可以根据需要移动或移除它。
            //this.tblCustomerTableAdapter.Fill(this.customerDataSet11.tblCustomer);
            errCustForm.SetError(editCarNo,"");
            errCustForm.SetError(editName,"");
            errCustForm.SetError(editAddress,"");
            errCustForm.SetError(editMake,"");
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            bool flag;
            flag = true;
            if (editCarNo.Text == "")
            {
                errCustForm.SetError(editCarNo, "编号不能为空!请输入.");
                flag = false;
            }
            else
                errCustForm.SetError(editCarNo,"");
            if (editName.Text == "")
            {
                errCustForm.SetError(editName, "名称不能为空，请输入!.");
                flag = false;
            }
            else
                errCustForm.SetError(editName, "");
            if (editAddress.Text == "")
            {
                errCustForm.SetError(editAddress, "地址不能为空，请重新输入!.");
                flag = false;
            }
            else
                errCustForm.SetError(editAddress, ""); 
            if (editMake.Text == "")
            {
                errCustForm.SetError(editMake, "Please specify a valid make.");
                flag = false;
            }
            else
                errCustForm.SetError(editMake, "");
            if (flag == false)
                return;
            else
            {
                sqlDataAdapter1.Update(customerDataSet11);
                MessageBox.Show("数据已更新!");
            }
        }

        private void btnEdit_Click(object sender, EventArgs e)
        {
            customerDataSet11.Clear();
            sqlDataAdapter1.Fill(customerDataSet11);
            CurrentPosition();

        }

        private void btnBack_Click(object sender, EventArgs e)
        {
            btnBack.BindingContext[customerDataSet11,"tblCustomer"].Position -=1;
            CurrentPosition();
        }

        private void btnNext_Click(object sender, EventArgs e)
        {
            btnNext.BindingContext[customerDataSet11, "tblCustomer"].Position += 1;
            CurrentPosition();

        }

        private void btnCancel_Click(object sender, EventArgs e)
        {

        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            Form1 newForm1 = new Form1();
            newForm1.Show();
            this.Hide();
        }
        private void CurrentPosition()
        {
            int currentPosition, ctr;
            ctr = this.BindingContext[customerDataSet11, "tblCustomer"].Count;
            if (ctr == 0)
            {
                txtDisplayPosition.Text = "(There are no records in the Customer table)";
            }
            else
            {
                currentPosition = this.BindingContext[customerDataSet11, "tblCustomer"].Position + 1;
                txtDisplayPosition.Text = currentPosition.ToString() + "of " + ctr.ToString();
            }


        }

        private void textBox1_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();
            }
            
        }

        
    }
}