private void button1_Click(object sender, EventArgs e) { if (KindView == 1) { if (stockOrOrder.Text != "" && KindView == 1) //写入配货员编码 { dataBase sqlConn = new dataBase(); if (selfMotion.Checked == true) //自动? { #region if (sqlConn.checkId(stockOrOrder.Text.ToString())) //检查是否有配货员id { //变更状态 if (sqlConn.WriteOrderState(AlterOrderID, 1) && sqlConn.WriteShoppingId(AlterOrderID, stockOrOrder.Text.ToString()) == 1) { //写入日志 Log_Order_info newLog = new Log_Order_info(); newLog = sqlConn.Log_Getinfo(AlterOrderID); newLog.Remark = "订单管理工具"; newLog.Creater = sqlConn.searchContent("ManageName", "ManageTel", stockOrOrder.Text.ToString(), "yl_ManageAccount"); newLog.UserCode = Convert.ToInt32(sqlConn.searchContent("UserCode", "ManageTel", stockOrOrder.Text.ToString(), "yl_ManageAccount")); newLog.Pubtime = DateTime.Now.ToString(); sqlConn.Write_Log(newLog); MessageBox.Show("变更成功"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("变更失败"); } } else { MessageBox.Show("没有该配货员"); } #endregion } else if (selfMotion.Checked == false) { DialogResult dr = MessageBox.Show("确认您输入的配货员账号?", "提示", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) { #region if (sqlConn.checkId(stockOrOrder.Text.ToString())) //检查是否有配货员id { //变更状态 if (sqlConn.WriteOrderState(AlterOrderID, 1) && sqlConn.WriteShoppingId(AlterOrderID, stockOrOrder.Text.ToString()) == 1) { //写入日志 Log_Order_info newLog = new Log_Order_info(); newLog = sqlConn.Log_Getinfo(AlterOrderID); newLog.Remark = "订单管理工具"; newLog.Creater = sqlConn.searchContent("ManageName", "ManageTel", stockOrOrder.Text.ToString(), "yl_ManageAccount"); newLog.UserCode = Convert.ToInt32(sqlConn.searchContent("UserCode", "ManageTel", stockOrOrder.Text.ToString(), "yl_ManageAccount")); newLog.Pubtime = DateTime.Now.ToString(); sqlConn.Write_Log(newLog); MessageBox.Show("变更成功"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("变更失败"); } } else { MessageBox.Show("没有该配货员"); } #endregion } } } else { stockOrOrder.Text = "请输入配货员编码"; } } if (KindView == 2) { if (stockOrOrder.Text != "" && KindView == 2) //写入配货员编码 { dataBase sqlConn = new dataBase(); if (selfMotion.Checked == true) //自动? { #region if (sqlConn.checkOrder(stockOrOrder.Text.ToString())) //检查是否有此订单 { //变更状态 if (sqlConn.WriteOrderState(stockOrOrder.Text.ToString(), 2) && sqlConn.WriteCheckerCodeId(stockOrOrder.Text.ToString(), adminId) == 1) { printShow(stockOrOrder.Text.ToString());//打印 //写入日志 Log_Order_info newLog = new Log_Order_info(); newLog = sqlConn.Log_Getinfo(stockOrOrder.Text.ToString()); newLog.Remark = "订单管理工具"; newLog.Creater = sqlConn.searchContent("ManageName", "ManageTel", adminId, "yl_ManageAccount"); newLog.UserCode = Convert.ToInt32(sqlConn.searchContent("UserCode", "ManageTel", adminId, "yl_ManageAccount")); newLog.Pubtime = DateTime.Now.ToString(); sqlConn.Write_Log(newLog); MessageBox.Show("检验成功"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("检验失败"); } } else { MessageBox.Show("没有该订单"); } #endregion } else if (selfMotion.Checked == false) { DialogResult dr = MessageBox.Show("确认您输入的订单账号?", "提示", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) { #region if (sqlConn.checkOrder(stockOrOrder.Text.ToString())) //检查是否有此订单 { //变更状态 if (sqlConn.WriteOrderState(stockOrOrder.Text.ToString(), 2) && sqlConn.WriteCheckerCodeId(stockOrOrder.Text.ToString(), adminId) == 1) { printShow(stockOrOrder.Text.ToString());//打印 //写入日志 Log_Order_info newLog = new Log_Order_info(); newLog = sqlConn.Log_Getinfo(stockOrOrder.Text.ToString()); newLog.Remark = "订单管理工具"; newLog.Creater = sqlConn.searchContent("ManageName", "ManageTel", adminId, "yl_ManageAccount"); newLog.UserCode = Convert.ToInt32(sqlConn.searchContent("UserCode", "ManageTel", adminId, "yl_ManageAccount")); newLog.Pubtime = DateTime.Now.ToString(); sqlConn.Write_Log(newLog); MessageBox.Show("检验成功"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("检验失败"); } } else { MessageBox.Show("没有该订单"); } #endregion } } } else { stockOrOrder.Text = "请输入订单编号"; } } }
private void button5_Click(object sender, EventArgs e) { if (KindView == 1) { if (KindView == 1) //写入配货员编码 { dataBase sqlConn = new dataBase(); #region if (sqlConn.checkId(stockOrOrder.Text.ToString())) //检查是否有配货员id { if (sqlConn.checkedStokUperCodeOrder(stockOrOrder.Text.ToString())) { MessageBox.Show("此售货员正在备货"); return; } //变更状态 if (sqlConn.WriteOrderState(dataGridView1.Rows[0].Cells["OrderNo"].Value.ToString(), 1) && sqlConn.WriteShoppingId(dataGridView1.Rows[0].Cells["OrderNo"].Value.ToString(), stockOrOrder.Text.ToString()) == 1) { moban newmoban = new moban(); printShow(dataGridView1.Rows[0].Cells["OrderNo"].Value.ToString(), 0, newmoban); //打印 //写入日志 Log_Order_info newLog = new Log_Order_info(); newLog = sqlConn.Log_Getinfo(dataGridView1.Rows[0].Cells["OrderNo"].Value.ToString()); newLog.Remark = "订单管理工具"; newLog.Creater = sqlConn.searchContent("ManageName", "ManageTel", stockOrOrder.Text.ToString(), "yl_ManageAccount"); newLog.UserCode = Convert.ToInt32(sqlConn.searchContent("UserCode", "ManageTel", stockOrOrder.Text.ToString(), "yl_ManageAccount")); newLog.Pubtime = DateTime.Now.ToString(); sqlConn.Write_Log(newLog); stockOrOrder.Text = "订单" + dataGridView1.Rows[0].Cells["OrderNo"].Value.ToString() + "已由备货员" + stockOrOrder.Text.ToString() + "开始备货"; weifahuoShow(); } else { stockOrOrder.Text = "订单" + dataGridView1.Rows[0].Cells["OrderNo"].Value.ToString() + "备货失败"; } } else { stockOrOrder.Text = "没有该配货员"; } #endregion return; } } if (KindView == 2) { if (KindView == 2) //写入配货员编码 { dataBase sqlConn = new dataBase(); #region if (sqlConn.checkOrder(stockOrOrder.Text.ToString())) //检查是否有此订单 { //变更状态 if (sqlConn.WriteOrderState(stockOrOrder.Text.ToString(), 2) && sqlConn.WriteCheckerCodeId(stockOrOrder.Text.ToString(), adminId) == 1) { //printShow(stockOrOrder.Text.ToString());//打印 //写入日志 Log_Order_info newLog = new Log_Order_info(); newLog = sqlConn.Log_Getinfo(stockOrOrder.Text.ToString()); newLog.Remark = "订单管理工具"; newLog.Creater = sqlConn.searchContent("ManageName", "ManageTel", adminId, "yl_ManageAccount"); newLog.UserCode = Convert.ToInt32(sqlConn.searchContent("UserCode", "ManageTel", adminId, "yl_ManageAccount")); newLog.Pubtime = DateTime.Now.ToString(); sqlConn.Write_Log(newLog); stockOrOrder.Text = "订单" + stockOrOrder.Text.ToString() + "检验成功"; beihuozhongShow(); } else { stockOrOrder.Text = "检验失败"; } } else { stockOrOrder.Text = "没有该订单"; } #endregion return; } } if (KindView == 0) { searchOrder(stockOrOrder.Text.ToString()); stockOrOrder.Focus(); return; } }