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

namespace OAM
{
    public partial class frmUserset : Form
    {

        public string UserName;

        public frmUserset()
        {
            InitializeComponent();
        }

        private void cmdOK_Click(object sender, EventArgs e)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            if (txtUserName.Text== DBUtility.ClsPub.CurUserName)
            {
                oCn.RunProc("Update  gy_czygl set " +
                    "OtherName='" + txtOtherName.Text.Trim() + "'" +
                    ",UnderWrite='" + txtUnderWrite.Text.Trim() + "'" +
                    ",Sex='" + cmbSex.Text.Trim() + "'" +
                    ",Age='" + txtAge.Text.Trim() + "'" +
                    ",RelName='" + txtRelName.Text.Trim() + "'" +
                    ",Animal='" + cmbAnimal.Text.Trim() + "'" +
                    ",Blood='" + cmbBlood.Text.Trim() + "'" +
                    ",BirthdayMonth='" + cmbBirthdayMonth.Text.Trim() + "'" +
                    ",BirthdayDay='" + cmbBirthdayDay.Text.Trim() + "'" +
                    ",PhoneCom='" + txtPhoneCom.Text.Trim() + "'" +
                    ",PhoneComSub='" + txtPhoneComSub.Text.Trim() + "'" +
                    ",MovePhone='" + txtMovePhone.Text.Trim() + "'" +
                    ",MovePhoneSub='" + txtMovePhoneSub.Text.Trim() + "'" +
                    ",EMail='" + txtEMail.Text.Trim() + "'" +
                    ",Address='" + txtAddress.Text.Trim() + "'" +
                    ",PhoneHome ='" + txtPhoneHome.Text.Trim() + "'" +
                    ",Remark= '" + txtRemark.Text.Trim() + "' Where czymc='" + Pub_Class.ClsPub.CurUserName + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                MessageBox.Show("×ÊÁÏÐ޸ijɹ¦");
            }
            else
            {
               
            }
           
        }

        public void Display()
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            try
            {
                //²éѯ±í
                DataSet Ds;
                Ds = oCn.RunProcReturn("Select * from gy_czygl Where czymc='" + UserName + "'", "gy_czygl");
                if (Ds.Tables[0].Rows.Count == 0)
                {
                    return;
                }
                //¸³Öµ
                txtUserName.Text = Ds.Tables[0].Rows[0]["czymc"].ToString().Trim();
                txtOtherName.Text  = Ds.Tables[0].Rows[0]["OtherName"].ToString().Trim();
                txtUnderWrite.Text = Ds.Tables[0].Rows[0]["UnderWrite"].ToString().Trim();
                cmbSex.Text = Ds.Tables[0].Rows[0]["Sex"].ToString().Trim();
                txtAge.Text = Ds.Tables[0].Rows[0]["Age"].ToString().Trim();
                txtRelName.Text = Ds.Tables[0].Rows[0]["RelName"].ToString().Trim();
                cmbAnimal.Text = Ds.Tables[0].Rows[0]["Animal"].ToString().Trim();
                cmbBlood.Text = Ds.Tables[0].Rows[0]["Blood"].ToString().Trim();
                cmbBirthdayMonth.Text = Ds.Tables[0].Rows[0]["BirthdayMonth"].ToString().Trim();
                cmbBirthdayDay.Text = Ds.Tables[0].Rows[0]["BirthdayDay"].ToString().Trim();
                txtPhoneCom.Text = Ds.Tables[0].Rows[0]["PhoneCom"].ToString().Trim();
                txtPhoneComSub.Text = Ds.Tables[0].Rows[0]["PhoneComSub"].ToString().Trim();
                txtMovePhone.Text = Ds.Tables[0].Rows[0]["MovePhone"].ToString().Trim();
                txtMovePhoneSub.Text = Ds.Tables[0].Rows[0]["MovePhoneSub"].ToString().Trim();
                txtEMail.Text = Ds.Tables[0].Rows[0]["EMail"].ToString().Trim();
                txtAddress.Text = Ds.Tables[0].Rows[0]["Address"].ToString().Trim();
                txtPhoneHome.Text = Ds.Tables[0].Rows[0]["PhoneHome"].ToString().Trim();
                txtRemark.Text = Ds.Tables[0].Rows[0]["Remark"].ToString().Trim();
                return;
            }
            catch (Exception e)
            {
                return;
            }
        
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            Display();
        }

        private void cmdCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}