/// <summary>
/// 写入日日志
/// </summary>
/// <param name="cache"> 写入的日子表</param>
public void Write_Log(Log_Order_info cache)
{
string ConnQuery = " insert into yl_GoodsOrderLog values('" + cache.OrderNo + "'," + cache.OrderState + "," + cache.PayState + "," + cache.ShoppingState + ",'" + cache.Remark + "'," + cache.UserCode + ",'" + cache.Creater + "','" + cache.Pubtime + "')";
SqlConnection connection = new SqlConnection(ConnString);
connection.Open();
SqlCommand lo_cmd = new SqlCommand(ConnQuery, connection);
lo_cmd.ExecuteNonQuery();
connection.Close();
connection.Dispose();
}
/// <summary>
/// 查询日志信息
/// </summary>
/// <param name="OrderNo"></param>
/// <returns></returns>
public Log_Order_info Log_Getinfo(string OrderNo)
{
Log_Order_info cache = new Log_Order_info();
string ConnQuery = "select " + "OrderState,PayState,ShoppingState" + " from " + "yl_GoodsOrder" + " where " + "OrderNo" + "='" + OrderNo + "'";
SqlConnection connection = new SqlConnection(ConnString);
connection.Open();
SqlCommand lo_cmd = new SqlCommand(ConnQuery, connection);
SqlDataReader reader = lo_cmd.ExecuteReader();
reader.Read();
cache.OrderNo = OrderNo;
cache.OrderState = Convert.ToByte(reader["OrderState"]);
cache.PayState = Convert.ToByte(reader["PayState"]);
cache.ShoppingState = Convert.ToByte(reader["ShoppingState"]);
reader.Close();
connection.Close();
connection.Dispose();
return(cache);
}
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;
}
}