//读写器天线录入 public static int WriterReader(WriterReaderBean bean,Window win) { ReaderAndWriterConnection _Connection = new ReaderAndWriterConnection(); MySqlConnection conn = new MySqlConnection(MySqlHelper.Conn); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; MySqlTransaction tx = conn.BeginTransaction(); cmd.Transaction = tx; try { //读写器连接 int state = _Connection.Connection(); int _WState = _Connection.WritertEPC(bean.EpcCode, win); if (state == BaseRequest.SUCCESS && _WState == BaseRequest.SUCCESS) { //把16进制字符串转换成ushout数组 string date = Convert.ToDateTime(DateTime.Now).ToString(BaseRequest.DATE_TIME_FORMAT); string sql = "INSERT INTO reader_writer(READER_WRITER_ID,NUMBER,NAME,IP,PORT,ANTENNA_SUM,TYPE,SWEEP_TIME,CREATE_USER_ID,CREATE_TIME,ROOM_ID)" + "VALUES(" + @bean.Id + ",'" + @bean.EpcCode + "','" + @bean.Name + "','" + @bean.Ip + "'," + @bean.Port + "," + @bean.AntennaSum + "," + @bean.Type + "," + [email protected] + "," + @Session.UserId + ",'" + @date + "'," + @bean.RoomId + ")"; MySqlParameter[] parameters = { new MySqlParameter("@bean.Id",bean.Id), new MySqlParameter("@bean.EpcCode",bean.EpcCode), new MySqlParameter("@bean.Name",bean.Name), new MySqlParameter("@bean.Ip",bean.Ip), new MySqlParameter("@bean.Port",bean.Port), new MySqlParameter("@bean.AntennaSum",bean.AntennaSum), new MySqlParameter("@bean.Type",bean.Type), new MySqlParameter("@bean.SweepTime",bean.SweepTime), new MySqlParameter("@Session.UserId",Session.UserId), new MySqlParameter("@date",date), new MySqlParameter("@bean.RoomId",bean.RoomId), }; cmd.CommandText = sql; if (parameters != null) { foreach (MySqlParameter parm in parameters) cmd.Parameters.Add(parm); } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); //string InSql = "INSERT INTO work_order(ID,STATUS,USER_ID,DATE_TIME) VALUES(" + @bean.Id + "," + @BaseRequest.INPUT_STATUS + "," + //[email protected] + ",'" + @date + "')"; //MySqlParameter[] parametersIt = // { // new MySqlParameter("@bean.Id",bean.Id), // new MySqlParameter("@BaseRequest.INPUT_STATUS",BaseRequest.INPUT_STATUS), // new MySqlParameter("@Session.UserId",Session.UserId), // new MySqlParameter("@date",date), // }; //cmd.CommandText = InSql; //if (parametersIt != null) //{ // foreach (MySqlParameter parm in parameters) // cmd.Parameters.Add(parm); //} //cmd.ExecuteNonQuery(); //cmd.Parameters.Clear(); for (int i = 1; i < (bean.AntennaSum + 1); i++) { string _sql = "INSERT INTO antenna (ID_CODE,READER_WRITER_ID) VALUES(" + @i + "," + @bean.Id + ") "; MySqlParameter[] _Parameters = { new MySqlParameter("@i",i), new MySqlParameter("@bean.Id",bean.Id), }; cmd.CommandText = _sql; if (_Parameters != null) { foreach (MySqlParameter parm in parameters) cmd.Parameters.Add(parm); } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } tx.Commit(); return BaseRequest.SUCCESS; } else { return BaseRequest.SYSTEM_EXCEPTION; } } catch (Exception e) { tx.Rollback(); conn.Close(); e.GetBaseException(); return BaseRequest.SYSTEM_EXCEPTION; } }
object IValueConverter.Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) { //ReaderAndWriterConnection _ReaderWriter = new ReaderAndWriterConnection(); return(ReaderAndWriterConnection.getEPCCode(int.Parse(value.ToString()))); }
/************************************************************************/ /* 设备信息录入,录入属原子性,要么写如标签和插入数据同时通过,要么就同时失败 . */ /************************************************************************/ public static int addEquipmentService(DeviceBean bean,Window win) { ReaderAndWriterConnection _Connection = new ReaderAndWriterConnection(); MySqlConnection conn = new MySqlConnection(MySqlHelper.Conn); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; MySqlTransaction tx = conn.BeginTransaction(); cmd.Transaction = tx; try { //读写器连接 int state = _Connection.Connection(); //返回写入标签状态(成功/失败) int _WState = _Connection.WritertEPC(bean.EPCCode, win); //如果连接和写入标签成功,则操作数据库存储 if (state == BaseRequest.SUCCESS&&_WState==BaseRequest.SUCCESS) { string date = Convert.ToDateTime(DateTime.Now).ToString(BaseRequest.DATE_TIME_FORMAT); string sql = "INSERT INTO equipment(ID,NUMBER,NAME,DEVICE_CLASS_ID,ROOMS_ID,USER_ID,STORAGE_TIME)" + " VALUES(" + @bean.Id + ",'" + @bean.EPCCode + "','" + @bean.Name + "'," + @bean.Type + "," + @bean.RoomId + "," + @Session.UserId + ",'" + @date + "')"; MySqlParameter[] parameters = { new MySqlParameter("@bean.Id",bean.Id), new MySqlParameter("@bean.EPCCode",bean.EPCCode), new MySqlParameter("@bean.Name",bean.Name), new MySqlParameter("@bean.Type",bean.Type), new MySqlParameter("@bean.RoomId",bean.RoomId), new MySqlParameter("@Session.UserId",Session.UserId), new MySqlParameter("@date",date), }; cmd.CommandText = sql; if (parameters != null) { foreach (MySqlParameter parm in parameters) cmd.Parameters.Add(parm); } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); string orderSql = "INSERT INTO work_order(ID,STATUS,USER_ID,DATE_TIME) " + "VALUES(" + @bean.Id + "," + @BaseRequest.INPUT_STATUS + "," + @Session.UserId + ",'" + @date + "')"; MySqlParameter[] parametersTow = { new MySqlParameter("@bean.Id",bean.Id), new MySqlParameter("@BaseRequest.REPAIR_STATUS",BaseRequest.INPUT_STATUS), new MySqlParameter("@Session.UserId",Session.UserId), new MySqlParameter("@date",date), }; cmd.CommandText = orderSql; if (parametersTow != null) { foreach (MySqlParameter parm in parameters) cmd.Parameters.Add(parm); } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); tx.Commit(); conn.Close(); return BaseRequest.SUCCESS; } else { return BaseRequest.SYSTEM_EXCEPTION; } } catch (Exception e) { tx.Rollback(); e.GetBaseException(); return BaseRequest.SYSTEM_EXCEPTION; } }