delete.cs

Symbol_MC3000_C#.条码扫码范例程序之2

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

namespace Fyfjm
{
    public partial class Delete : Form
    {
        private SqlCeConnection cn = new SqlCeConnection();
        private DataSet ds;
        string sqlstr = "select Zone ,Count(*) as Num,Take_sign from Take where Take_sign = 0 Group By Zone,Take_sign ";
        private XmlDocument xd = new XmlDocument();
        private XmlNode node;
        private int _Num;//记录SKU的总数
        private SqlCeCommand cm = new SqlCeCommand();

        public Delete()
        {
            InitializeComponent();
        }

        private void tbCancel_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void BrownNum()
        {
            SqlCeCommand cm = cn.CreateCommand();
            cm.CommandText = "select Count(SKU) as Num from Take where Take_sign = 0";
            SqlCeDataReader dr = cm.ExecuteReader();
            if (dr.Read())
            {
                _Num = SymbolScanWood.WoodConvert.ToInt32(dr["Num"]);
            }
            else
            {
                _Num = 0;
            }
            dr.Close();
            tbQty.Text = Convert.ToString(_Num);
        }

        private void Delete_Load(object sender, EventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;
            btDelete.Enabled = false;
            label2.Visible = false;
            tbnewpass.Visible = false;
            label3.Visible = false;
            tbSnewpass.Visible = false;
            btReset.Enabled = false;
            cn = Logic.DataAcess.CreateConnection();//创建连接
            SqlCeDataAdapter myDataAdapter = new SqlCeDataAdapter(sqlstr, cn);
            SqlCeCommandBuilder cb = new SqlCeCommandBuilder(myDataAdapter);
            ds = new DataSet();
            myDataAdapter.Fill(ds, "Take");
            dataGrid1.DataSource = ds.Tables[0].DefaultView;
            BrownNum();
            tbpassword.Focus();
            Cursor.Current = Cursors.Default;
        }

        private void btDelete_Click(object sender, EventArgs e)
        {
            if(MessageBox.Show("Are you sure to delete the data ?","Question",MessageBoxButtons.YesNo,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                string _Zone;
                if (dataGrid1.CurrentRowIndex >= 0)
                {
                    _Zone = ds.Tables[0].Rows[dataGrid1.CurrentRowIndex][0].ToString();
                    SqlCeCommand cm = cn.CreateCommand();
                    cm.CommandText = string.Format("update Take set Take_sign = 1 where Zone = '{0}'", _Zone.Trim());
                    cm.ExecuteNonQuery();
                    Cursor.Current = Cursors.WaitCursor;
                    SqlCeDataAdapter myDataAdapter = new SqlCeDataAdapter(sqlstr, cn);
                    SqlCeCommandBuilder cb = new SqlCeCommandBuilder(myDataAdapter);
                    ds = new DataSet();
                    myDataAdapter.Fill(ds, "Take");
                    dataGrid1.DataSource = ds.Tables[0].DefaultView;
                    BrownNum();
                    Cursor.Current = Cursors.Default;
                }
                /*SqlCeDataAdapter myDataAdapter = new SqlCeDataAdapter(sqlstr,cn);
                SqlCeCommandBuilder cb = new SqlCeCommandBuilder(myDataAdapter);
                ds = new DataSet();
                myDataAdapter.Fill(ds,"Take");
                dataGrid1*/
            }
                
        }

        private void Delete_Closing(object sender, CancelEventArgs e)
        {
        }

        private void tbpassword_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.Enter:
                    xd.Load(Logic.WoodDirectory.GetCurPath() + @"\Setting.xml");
                    node = xd.SelectSingleNode("/SystemConfig/Admin");
                    if (tbpassword.Text.Trim() == node.InnerText.ToString().Trim())
                    {
                        btDelete.Enabled = true;
                        label2.Visible = true;
                        tbnewpass.Visible = true;
                        label3.Visible = true;
                        tbSnewpass.Visible = true;
                        btReset.Enabled = true;
                        tbpassword.Text = "";
                    }
                    else
                    {
                        node = xd.SelectSingleNode("/SystemConfig/Supervisor");
                        if (tbpassword.Text.Trim() == node.InnerText.ToString().Trim())
                        {
                            btDelete.Enabled = true;
                            btReset.Enabled = true;
                            tbpassword.Text = "";
                        }
                        else
                        {
                            MessageBox.Show("Password Error!", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
                            tbpassword.Text = "";
                            tbpassword.Focus();
                        }
                    }
                    break;
                case Keys.F5:
                    Close();
                    break;
                default:
                    break;
            }
        }

        private void tbnewpass_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.Enter:
                    xd.Load(Logic.WoodDirectory.GetCurPath() + @"\Setting.xml");
                    node = xd.SelectSingleNode("/SystemConfig/Admin");
                    node.InnerText = tbnewpass.Text.ToString().Trim();
                    xd.Save(Logic.WoodDirectory.GetCurPath() + @"\Setting.xml");
                    tbnewpass.Text = "";
                    break;
                case Keys.F5:
                    Close();
                    break;
                default:
                    break;
            }
        }

        private void tbSnewpass_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.Enter:
                    xd.Load(Logic.WoodDirectory.GetCurPath() + @"\Setting.xml");
                    node = xd.SelectSingleNode("/SystemConfig/Supervisor");
                    node.InnerText = tbSnewpass.Text.ToString().Trim();
                    xd.Save(Logic.WoodDirectory.GetCurPath() + @"\Setting.xml");
                    tbSnewpass.Text = "";
                    break;
                case Keys.F5:
                    Close();
                    break;
                default:
                    break;
            }
        }

        private void Delete_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.F5:
                    Close();
                    break;
                default:
                    break;
            }
        }

        private void btReset_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Are you sure to reset the data ?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                Cursor.Current = Cursors.WaitCursor;
                cm = cn.CreateCommand();
                cm.CommandText = string.Format("update Take set Take_sign = 0");
                cm.ExecuteNonQuery();
                SqlCeDataAdapter myDataAdapter = new SqlCeDataAdapter(sqlstr, cn);
                SqlCeCommandBuilder cb = new SqlCeCommandBuilder(myDataAdapter);
                ds = new DataSet();
                myDataAdapter.Fill(ds, "Take");
                dataGrid1.DataSource = ds.Tables[0].DefaultView;
                BrownNum();
                Cursor.Current = Cursors.Default;
            }
        }
    }
}