private void Show_MX(DateTime start, DateTime end) { var _s = start.ToString("yyyy-MM-dd"); var _e = end.ToString("yyyy-MM-dd"); var sql = string.Format("select djh as 单据号,tm as 条码,sl as 数量,zq as 折扣,je as 金额,shop as 门店,rq as 日期 from sale_mx where date(rq)>='{0}' and date(rq)<='{1}'", _s, _e); command.CommandText = sql; var adapter = new MySqlDataAdapter(command); var dt = new DataTable(); adapter.Fill(dt); SetName(dt); var mdi = new MdiForm(); mdi.MdiParent = this; mdi.Text = string.Format("商品明细:[{0}-->{1}]", _s, _e); mdi.dataGridView.DataSource = dt; mdi.dataGridView.Columns["日期"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss dddd"; mdi.dataGridView.Columns["日期"].FillWeight = 130; mdi.dataGridView.Columns["折扣"].FillWeight = mdi.dataGridView.Columns["数量"].FillWeight = 50; mdi.dataGridView.Columns["金额"].FillWeight = mdi.dataGridView.Columns["条码"].FillWeight = 50; mdi.dataGridView.Columns["门店"].FillWeight = 60; mdi.Show(); }
private void 查看库存ToolStripMenuItem_Click(object sender, EventArgs e) { this.toolStripComboBox门店.SelectedIndex = 0; var sql = "select tm as 条码,sl as 数量,tm*sl as 金额,shop as 门店 from goods"; command.CommandText = sql; var adapter = new MySqlDataAdapter(command); var dt = new DataTable(); adapter.Fill(dt); SetName(dt); var mdi = new MdiForm(); mdi.MdiParent = this; mdi.Text = "查看库存"; mdi.dataGridView.DataSource = dt; mdi.Show(); }
private void 查看门店ToolStripMenuItem_Click(object sender, EventArgs e) { var sql = "select name as 名称,pname as 代码,worker as 店长,address as 地址,tel as 电话,rq as 日期 from shop"; MainForm.command.CommandText = sql; var adapter = new MySqlDataAdapter(MainForm.command); var dt = new DataTable(); adapter.Fill(dt); var mdi = new MdiForm(); mdi.MdiParent = this; mdi.Text = "查看门店"; mdi.dataGridView.DataSource = dt; mdi.dataGridView.Columns["日期"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss dddd"; mdi.dataGridView.Columns["日期"].FillWeight = 130; mdi.Show(); }
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(); } }; }
private void Show_JG(DateTime start, DateTime end) { var _s = start.ToString("yyyy-MM-dd"); var _e = end.ToString("yyyy-MM-dd"); var sql = string.Format("select tm as 条码,sum(sl) as 数量,sum(je) as 金额,shop as 门店 from sale_mx where date(rq)>='{0}' and date(rq)<='{1}' group by shop,tm", _s, _e); command.CommandText = sql; var adapter = new MySqlDataAdapter(command); var dt = new DataTable(); adapter.Fill(dt); SetName(dt); var mdi = new MdiForm(); mdi.MdiParent = this; mdi.Text = string.Format("价格汇总:[{0}-->{1}]", _s, _e); mdi.dataGridView.DataSource = dt; mdi.Show(); }
private void Show_Day(DateTime start, DateTime end) { var _s = start.ToString("yyyy-MM-dd"); var _e = end.ToString("yyyy-MM-dd"); var sql = string.Format("select date(rq) as 日期,sum(sl) as 数量,sum(je) as 金额,shop as 门店 from sale_db where date(rq)>='{0}' and date(rq)<='{1}' group by shop,date(rq) order by rq desc", _s, _e); command.CommandText = sql; var adapter = new MySqlDataAdapter(command); var dt = new DataTable(); adapter.Fill(dt); SetName(dt); var mdi = new MdiForm(); mdi.MdiParent = this; mdi.Text = string.Format("按天统计:[{0}-->{1}]", _s, _e); mdi.dataGridView.DataSource = dt; mdi.dataGridView.Columns["日期"].DefaultCellStyle.Format = "yyyy-MM-dd dddd"; mdi.Show(); }