Exemplo n.º 1
0
        private void toolStripMenuItem价格汇总_Click(object sender, EventArgs e)
        {
            var sf = new Form_SelectDate();

            if (DialogResult.OK == sf.ShowDialog(this))
            {
                Show_JG(sf.dateTimePicker1.Value, sf.dateTimePicker2.Value);
            }
        }
Exemplo n.º 2
0
        private void toolStripMenuItem按天统计_Click(object sender, EventArgs e)
        {
            var sf = new Form_SelectDate();

            if (sf.ShowDialog(this) != DialogResult.OK)
            {
                return;
            }
            Show_Day(sf.dateTimePicker1.Value, sf.dateTimePicker2.Value);
        }
Exemplo n.º 3
0
 public void InitEventHandler()
 {
     //新增备注
     this.toolStripButton_add_note.Click += (o, e) =>
     {
         var input = new Form_Input();
         if (input.ShowDialog() == DialogResult.OK)
         {
             //command.Parameters.Clear();
             //command.Parameters.Add(@"rq", MySqlDbType.DateTime).Value = DateTime.Now;
             //command.Parameters.Add(@"text", MySqlDbType.VarChar).Value = input.Input;
             command.CommandText = string.Format(@"insert into note(rq,text) 
                 values('{0}','{1}')", DateTime.Now.ToString(), input.Input);
             command.ExecuteNonQuery();
             MessageBox.Show("新增备注成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     };
     //查看备注
     this.toolStripButton_view_note.Click += (o, e) =>
     {
         var select = new Form_SelectDate();
         if (select.ShowDialog() == DialogResult.OK)
         {
             //command.Parameters.Clear();
             //command.Parameters.Add("start", MySqlDbType.DateTime).Value = select.dateTimePicker1.Value;
             //command.Parameters.Add("end", MySqlDbType.DateTime).Value = select.dateTimePicker2.Value;
             //command.CommandText = "select rq as 日期,text as 备注 from note where date(rq)>=date(?start) and date(rq)<date(?end) order by rq desc";
             command.CommandText = string.Format(@"select rq as 日期,text as 备注 from note where 
                 date(rq)>='{0}' and date(rq)<='{1}'",
                                                 select.dateTimePicker1.Value.ToShortDateString(),
                                                 select.dateTimePicker2.Value.ToShortDateString());
             var dt      = new DataTable();
             var adapter = new MySqlDataAdapter(command);
             adapter.Fill(dt);
             var mdi = new MdiForm();
             mdi.MdiParent = this;
             mdi.dataGridView.DataSource = dt;
             mdi.dataGridView.Columns[0].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss dddd";
             mdi.Text = "查看备注";
             mdi.Show();
         }
     };
 }