//刷新 private void skinButton2_Click(object sender, EventArgs e) { //显示出销售表信息 DataTable dt = SaleBll.SelectSale(); this.dgv_xiangqing.DataSource = dt; }
/// <summary> /// 根据时间和姓名查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void skinButton1_Click(object sender, EventArgs e) { int salemanid = SalemanBll.SelectSalemanByName(this.txt_chaxun.Text); if (salemanid == 0) { MessageBox.Show("您查找的员工销售记录不存在", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.dgv_xiangqing.DataSource = SaleBll.SelectSale(); } else { this.dgv_xiangqing.DataSource = SaleBll.SelectSaleByTime(salemanid, this.dateTimePicker1.Text, this.dateTimePicker2.Text); } }
private void SaledetailsForm_Load(object sender, EventArgs e) { //显示出销售表信息 this.dgv_xiangqing.AutoGenerateColumns = false; DataTable dt = SaleBll.SelectSale(); this.dgv_xiangqing.DataSource = dt; //初始最大化 this.WindowState = System.Windows.Forms.FormWindowState.Maximized; //设置为可编辑状态 //dgv_xiangqing.BeginEdit(false); //统计总营业额 this.lbl_yinyee.Text = SalesDailBLL.SelectDail().ToString(); }