public void InsertMachineCallMaterial(MachineCallMaterial info) { string strSql = @"INSERT INTO MachineCallMaterials (DateCreate,MachineId,MachineNumber,MachineName,RoomId,RoomNumber,RoomName, OrderId,OrderNumber,ScheduleId,SchueduleNumber,MaterialInfo,[Status]) VALUES (@DateCreate,@MachineId,@MachineNumber,@MachineName,@RoomId,@RoomNumber,@RoomName, @OrderId,@OrderNumber,@ScheduleId,@SchueduleNumber,@MaterialInfo,@Status)"; using (SqlCommand cmd = new SqlCommand(strSql, conn)) { cmd.Parameters.AddWithValue("@DateCreate", info.DateCreate); cmd.Parameters.AddWithValue("@MachineId", info.MachineId); cmd.Parameters.AddWithValue("@MachineNumber", info.MachineNumber); cmd.Parameters.AddWithValue("@MachineName", info.MachineName); cmd.Parameters.AddWithValue("@RoomId", info.RoomId); cmd.Parameters.AddWithValue("@RoomNumber", info.RoomNumber); cmd.Parameters.AddWithValue("@RoomName", info.RoomName); cmd.Parameters.AddWithValue("@OrderId", info.OrderId); cmd.Parameters.AddWithValue("@OrderNumber", info.OrderNumber); cmd.Parameters.AddWithValue("@ScheduleId", info.ScheduleId); cmd.Parameters.AddWithValue("@SchueduleNumber", info.SchueduleNumber); cmd.Parameters.AddWithValue("@MaterialInfo", info.MaterialInfo); cmd.Parameters.AddWithValue("@Status", info.Status); cmd.ExecuteNonQuery(); } }
public byte[] HandlerClientData(byte[] buff) { byte[] buffResp = { 1 }; DbHandler db = new DbHandler(); NetStructure.DeviceMaterial outInfo = this.DecodeData(buff); Machines machine = db.SelectMachine(outInfo.MachineId); Schedules schedule = db.SelectSchedule(outInfo.ScheduleNumber); MachineCallMaterial innerInfo = this.exchangeData(machine, schedule); //记录原始数据 db.InsertMachineCallMaterial(innerInfo); buffResp[0] = 0; return(buffResp); }