private void btnInsert_Click(object sender, EventArgs e) { for (int i = 0; i < 30; i++) { WorkOrder order = new WorkOrder(); order.Length = i + 100; order.Thickness = 50; order.Width = 100 + i * 10; order.Gross = 50; order.GrossWidth = order.Width * order.Gross; order.Undo = order.GrossWidth; order.ScheduleDate = DateTime.Now; order.ProductOrder = DateTime.Now.ToString("yyyyMMddHHmmss") + i.ToString(); order.Status = 1; Global.mysqlHelper.ExecuteSql(order.InsertSQL()); } }
private void ReceiveMasssage(object clientSocket) { //Socket myClientSocket = (Socket)clientSocket; while (isRun) { try { byte[] buff = new byte[2048]; int count = cSocket.Receive(buff); if (count > 5) { if (buff[0] == 0xff && buff[1] == 0xff && buff[2] == 0x01 && buff[count - 1] == 0xEE && buff[count - 2] == 0xEE) { Response res = new Response(); string info = Encoding.UTF8.GetString(buff, 3, count - 5); WorkOrder order = JsonHelper.DeserializeJsonToObject <WorkOrder>(info); if (!bOrderExist(order.ProductOrder)) { if (bCheckOrder(order)) { order.Status = 1; order.ReceiveDate = DateTime.Now; order.GrossWidth = order.Width * order.Gross; order.Undo = order.GrossWidth; order.Done = 0; Global.mysqlHelper.ExecuteSql(order.InsertSQL()); res.Result = true; res.Cmd = 1; res.ErrorCode = 0; res.Remark = "发送成功!"; } else { res.Result = false; res.Cmd = 1; res.ErrorCode = -1; res.Remark = "发送错误!"; } } else { res.Result = false; res.Cmd = 1; res.ErrorCode = -2; res.Remark = "该编号订单已存在!"; } string resp = JsonHelper.SerializeObject(res); byte[] data = Encoding.UTF8.GetBytes(resp); sendbuff[0] = 0xff; sendbuff[1] = 0xff; sendbuff[2] = 0x10; Buffer.BlockCopy(data, 0, sendbuff, 3, data.Length); sendbuff[data.Length + 3] = 0xEE; sendbuff[data.Length + 4] = 0xEE; cSocket.Send(sendbuff, data.Length + 5, SocketFlags.None); } } } catch (System.Exception ex) { } } }