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();
}
