示例#1
0
        private void iNSERTToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ListViewItem li;
            inputbox     b;
            string       cs;

            if (lvlist.SelectedItems.Count > 0)
            {
                li = lvlist.SelectedItems[0];
                b  = new inputbox(Convert.ToDateTime(li.SubItems[2].Text));
                b.ShowDialog(this);
            }
            else
            {
                b = new inputbox();
                b.ShowDialog(this);
            }


            if (b.result)
            {
                try
                {
                    //td = Convert.ToDateTime(b.txtInput.Text);
                    cs = "insert into record_ta(Mach_no,pinfo_id,card_number,date_time,fun_key,in_out) values('1'," + uid + ",'" + uid + "','" + b.dtDateTime.Text + "',0,0)";
                    cmd.CommandText = cs;
                    cmd.ExecuteNonQuery();
                    filllist();
                }
                catch (Exception er)
                {
                    MessageBox.Show("invalid value" + " " + er.Message);
                }
            }
        }
示例#2
0
        private void eDITToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DateTime     oldtime;
            ListViewItem li;
            inputbox     b;
            string       cs;

            li      = lvlist.SelectedItems[0];
            oldtime = Convert.ToDateTime(li.SubItems[2].Text);
            //b = new inputbox(String.Format("{0:yyyy}-{0:MM}-{0:dd} {0:HH}:{0:mm}:{0:ss}", oldtime));
            b = new inputbox(oldtime);
            b.ShowDialog(this);

            if (b.result)
            {
                try
                {
                    //td = Convert.ToDateTime(b.txtInput.Text);
                    //cs = "update record_ta set date_time = '" + b.txtInput.Text + "' where id=" + li.SubItems[3].Text;
                    cs = "update record_ta set date_time = '" + b.dtDateTime.Text + "' where id=" + li.SubItems[3].Text;
                    cmd.CommandText = cs;
                    cmd.ExecuteNonQuery();
                    filllist();
                }
                catch (Exception er)
                {
                    MessageBox.Show("invalid value" + " " + er.Message);
                }
            }
        }