public bool Guard_Validate(string guard_uid, string guard_data, int Num) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_GUARD_VALIDATE"; guard_data = StringSplit(guard_data); //参数添加 terminal uid command_APHandler.Parameters.Add("@array", SqlDbType.VarChar, 900).Value = guard_data; //添加seperator command_APHandler.Parameters.Add("@seperator", SqlDbType.VarChar, 5).Value = ","; command_APHandler.Parameters.Add("@guard_uid", SqlDbType.VarChar, 50).Value = guard_uid; command_APHandler.Parameters.Add("@totallength", SqlDbType.Int, 4).Value = guard_data.Length; //执行 int iRet = command_APHandler.ExecuteNonQuery(); //返回值设置 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.Int); parReturn.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //返回值 if (iRet == 0 || iRet == -1) { Log.write("Database " + identity.ToString() + " --Guard_Validate:NOT EFFECTIVE"); return(false); } if (parReturn.Value.Equals(Num)) { Log.write("Database " + identity.ToString() + " --Guard_Validate:TRUE"); return(true); } else { return(false); } } catch (InvalidOperationException ex) { Log.write("Database " + identity.ToString() + " --Guard_Validate:OperationError-" + "Message: " + ex.Message); return(false); } catch (SqlException ex) { Log.write("Database " + identity.ToString() + " --Guard_Validate:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database " + identity.ToString() + " --Guard_Validate:Error-" + "Message: " + ex.Message); return(false); } }
public bool Open(string ServerName, string account, string password, string database, int timeout = 5000) { try { sqlCnt.ConnectionString = "server=" + ServerName + ";user id=" + account + ";password="******";database=" + database + ";"; sqlCnt.Open(); if (ConnectionState.Open == sqlCnt.State) { return(true); } else { return(false); } } catch (SqlException ex) { Log.write("DBOrderMonitor SqlException Error:" + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("DBOrderMonitor---Open:ERROR-" + ex.Message, 0); return(false); } }
public byte AP_Lot_Add(string Label, string LotNo) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_AP_LOT_ADD"; bStored_Init = true; //参数添加 command_APHandler.Parameters.Add("@label", SqlDbType.VarChar, 50).Value = Label; //参数添加 command_APHandler.Parameters.Add("@LotNo", SqlDbType.VarChar, 50).Value = LotNo; //返回值设置 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.Int); parReturn.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //执行 command_APHandler.ExecuteNonQuery(); //返回值 byte ret = byte.Parse(parReturn.Value.ToString()); if (parReturn.Value.Equals(1)) { Log.write("Database " + " --AP_Lot_Add:TRUE"); return(ret); } else { Log.write("Database " + " --AP_Lot_Add:FALSE"); return(ret); } } catch (InvalidOperationException ex) { Log.write("Database " + " --AP_Lot_Add:OperationError-" + "Message: " + ex.Message, 0); return(5); } catch (SqlException ex) { Log.write("Database " + " --AP_Lot_Add:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(5); } catch (Exception ex) { Log.write("Database " + " --AP_Lot_Add:Error-" + "Message: " + ex.Message, 0); return(5); } }
public bool AP_Validate(string uid, string channelNum) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_AP_VALIDATION"; bStored_Init = true; //参数添加 ap uid command_APHandler.Parameters.Add("@uid", SqlDbType.VarChar, 50).Value = uid; //参数添加 ap 通道数 command_APHandler.Parameters.Add("@apid", SqlDbType.VarChar, 3).Value = channelNum; //返回值设置 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.Int); parReturn.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //执行 command_APHandler.ExecuteNonQuery(); //返回值 if (parReturn.Value.Equals(1)) { Log.write("Database " + identity.ToString() + " --AP_Validate:TRUE"); return(true); } else { Log.write("Database " + identity.ToString() + " --AP_Validate:FALSE"); return(false); } } catch (InvalidOperationException ex) { Log.write("Database " + identity.ToString() + " --AP_Validate:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("Database " + identity.ToString() + " --AP_Validate:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database " + identity.ToString() + " --AP_Validate:Error-" + "Message: " + ex.Message, 0); return(false); } }
public bool CmdLog(string cmdCode, string apuid, string receiveData) { if (cmd_enable != 1) { return(true); } try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_CMD_LOG"; command_APHandler.Parameters.Add("@cmdCode", SqlDbType.VarChar, 20).Value = cmdCode; command_APHandler.Parameters.Add("@apuid", SqlDbType.VarChar, 50).Value = apuid; command_APHandler.Parameters.Add("@receiveData", SqlDbType.VarChar, 500).Value = receiveData; //执行 int iRet = command_APHandler.ExecuteNonQuery(); //返回值 if (iRet == 0 || iRet == -1) { Log.write("DB_AlarmHandler " + identity.ToString() + " --CmdLog:NOT EFFECTIVE"); return(false); } Log.write("DB_AlarmHandler " + identity.ToString() + " --CmdLog:OK"); return(true); } catch (InvalidOperationException ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --CmdLog:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --CmdLog:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --CmdLog:Error-" + "Message: " + ex.Message, 0); return(false); } }
public bool Open(string ServerName, string account, string password, string database, int timeout = 5) { try { string cntStr = "server=" + ServerName + ";user id=" + account + ";password="******";MultipleActiveResultSets=true;database=" + database + ";Connection Timeout=" + timeout.ToString() + ";"; sqlCnt_APServerStatus.ConnectionString = cntStr; sqlCnt_APServerStatus.Open(); sqlCnt_MngServerStatus.ConnectionString = cntStr; sqlCnt_MngServerStatus.Open(); sqlCnt_VideoServerStatus.ConnectionString = cntStr; sqlCnt_VideoServerStatus.Open(); Thread.Sleep(500); if (ConnectionState.Open == sqlCnt_APServerStatus.State) { return(true); } else { return(false); } } catch (InvalidOperationException ex) { Log.write("Database---Open:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("Database---Open:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database---Open:Error-" + "Message: " + ex.Message, 0); return(false); } }
public bool DB_Update_Cmd(int pk_id, int status) { try { //命令设置 command_DBHandler = sqlCnt_GetOrder.CreateCommand(); command_DBHandler.CommandType = CommandType.StoredProcedure; command_DBHandler.CommandText = "P_CMD_RESPONSE"; //参数添加 terminal uid command_DBHandler.Parameters.Add("@pk_id", SqlDbType.Int, 4).Value = pk_id; //添加receive data command_DBHandler.Parameters.Add("@receiveData", SqlDbType.Int, 4).Value = status; //执行 int iRet = command_DBHandler.ExecuteNonQuery(); //返回值 if (iRet == 0 || iRet == -1) { Log.write("Database---DB_Update_Cmd:FALSE"); return(false); } Log.write("Database---DB_Update_Cmd:TRUE"); return(true); } catch (SqlException ex) { Log.write("Database SqlException DB_Update_Cmd:ERROR-" + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database---DB_Update_Cmd:ERROR-" + ex.Message, 0); return(false); } }
public bool SetVideoFile(int pk_id, string videoPath, string videoFile1, string videoFile2, string videoFile3, string videoFile4) { lock (Locker) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_GUARD_VIDEO_FILE"; //参数添加 terminal uid command_APHandler.Parameters.Add("@pk_id", SqlDbType.Int).Value = pk_id; //添加参数 command_APHandler.Parameters.Add("@videoPath", SqlDbType.VarChar, 100).Value = videoPath; command_APHandler.Parameters.Add("@videoFile1", SqlDbType.VarChar, 100).Value = videoFile1; command_APHandler.Parameters.Add("@videoFile2", SqlDbType.VarChar, 100).Value = videoFile2; command_APHandler.Parameters.Add("@videoFile3", SqlDbType.VarChar, 100).Value = videoFile3; command_APHandler.Parameters.Add("@videoFile4", SqlDbType.VarChar, 100).Value = videoFile4; //返回值设置 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.Int); parReturn.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //执行 int iRet = command_APHandler.ExecuteNonQuery(); //返回值 if (iRet == 0 || iRet == -1) { Log.write("DB_AlarmHandler " + identity.ToString() + " --SetVideoFile:NOT EFFECTIVE"); return(false); } int iRetNum = Convert.ToInt32(parReturn.Value.ToString()); if (iRetNum == 1) { Log.write("DB_AlarmHandler " + identity.ToString() + " --SetVideoFile:TRUE"); return(true); } else { return(false); } } catch (InvalidOperationException ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --SetVideoFile:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --SetVideoFile:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --SetVideoFile:Error-" + "Message: " + ex.Message, 0); return(false); } } }
public int Guard_Validate(string guard_uid, string guard_data, int Num, ref int index1, ref int index2, ref int index3, ref int pk_id) { lock (Locker) { try { guard_data = StringSplit(guard_data, 0, Num * 16); //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_GUARD_VALIDATE"; //参数添加 terminal uid command_APHandler.Parameters.Add("@array", SqlDbType.VarChar, 900).Value = guard_data; //添加seperator command_APHandler.Parameters.Add("@seperator", SqlDbType.VarChar, 5).Value = ","; command_APHandler.Parameters.Add("@guard_uid", SqlDbType.VarChar, 50).Value = guard_uid; command_APHandler.Parameters.Add("@totallength", SqlDbType.Int, 4).Value = guard_data.Length; //Index1 SqlParameter cameraIndex1 = new SqlParameter("@cameraIndex1", SqlDbType.VarChar, 200); cameraIndex1.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(cameraIndex1); //Index2 SqlParameter cameraIndex2 = new SqlParameter("@cameraIndex2", SqlDbType.VarChar, 200); cameraIndex2.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(cameraIndex2); //Index3 SqlParameter cameraIndex3 = new SqlParameter("@cameraIndex3", SqlDbType.VarChar, 200); cameraIndex3.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(cameraIndex3); //pk_id SqlParameter param_pk_id = new SqlParameter("@pk_id_ret", SqlDbType.Int); param_pk_id.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(param_pk_id); //返回值设置 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.Int); parReturn.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //执行 int iRet = command_APHandler.ExecuteNonQuery(); index1 = Convert.ToInt32(cameraIndex1.Value.ToString()); index2 = Convert.ToInt32(cameraIndex2.Value.ToString()); index3 = Convert.ToInt32(cameraIndex3.Value.ToString()); pk_id = Convert.ToInt32(param_pk_id.Value.ToString()); //返回值 if (iRet == 0 || iRet == -1) { Log.write("DB_AlarmHandler " + identity.ToString() + " --Guard_Validate:NOT EFFECTIVE", 1); return(0); } int iRetNum = Convert.ToInt32(parReturn.Value.ToString()); if (iRetNum > 0) { Log.write("DB_AlarmHandler " + identity.ToString() + " --Guard_Validate:FALSE", 1); return(iRetNum); } else { Log.write("DB_AlarmHandler " + identity.ToString() + " --Guard_Validate:TRUE", 1); return(iRetNum); } } catch (InvalidOperationException ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --Guard_Validate:OperationError-" + "Message: " + ex.Message, 0); return(-1); } catch (SqlException ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --Guard_Validate:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(-1); } catch (Exception ex) { Log.write("DB_AlarmHandler " + identity.ToString() + " --Guard_Validate:Error-" + "Message: " + ex.Message, 0); return(-1); } } }
public bool VideoServer_Status(bool IsConnected) { try { //命令设置 command_MngServerStatus = sqlCnt_MngServerStatus.CreateCommand(); command_MngServerStatus.CommandType = CommandType.StoredProcedure; command_MngServerStatus.CommandText = "P_VIDEO_SERVER_UPDATE"; bStored_Init = true; //超时 if (IsConnected == true) { command_MngServerStatus.Parameters.Add("@status", SqlDbType.Int, 4).Value = 1; } else { command_MngServerStatus.Parameters.Add("@status", SqlDbType.Int, 4).Value = 0; } //返回值设置 SqlParameter parOutput = command_MngServerStatus.Parameters.Add("@message", SqlDbType.NVarChar, 200); //定义输出参数 parOutput.Direction = ParameterDirection.Output; //参数类型为Output //执行 int iRet = command_MngServerStatus.ExecuteNonQuery(); //返回值 if (iRet == 0 || iRet == -1) { Log.write("Database---VideoServer_Status:NOT EFFECTIVE"); return(false); } string strRet = parOutput.SqlValue.ToString(); if (strRet == "Null" || strRet == "0") { Log.write("Database---VideoServer_Status:TRUE"); return(true); } else { Log.write("Database---VideoServer_Status:FALSE-" + strRet); return(false); } } catch (InvalidOperationException ex) { Log.write("Database---VideoServer_Status:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("Database---VideoServer_Status:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database---VideoServer_Status:Error-" + "Message: " + ex.Message, 0); return(false); } }
private bool DB_Get_Cmd() { try { //命令设置 command_DBThreadHandler = sqlCnt.CreateCommand(); command_DBThreadHandler.CommandType = CommandType.StoredProcedure; command_DBThreadHandler.CommandText = "P_CMD_SEND"; //返回值设置 SqlParameter Output_cmdCode = command_DBThreadHandler.Parameters.Add("@cmdCode", SqlDbType.VarChar, 20); //定义输出参数 Output_cmdCode.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter Output_data = command_DBThreadHandler.Parameters.Add("@sendData", SqlDbType.VarChar, 500); //定义输出参数 Output_data.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter Output_ID = command_DBThreadHandler.Parameters.Add("@pk_id", SqlDbType.Int, 4); //定义输出参数 Output_ID.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter Output_Return = new SqlParameter("@return", SqlDbType.Int); Output_Return.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_DBThreadHandler.Parameters.Add(Output_Return); //执行 command_DBThreadHandler.ExecuteNonQuery(); int iRet = Convert.ToInt32(Output_Return.SqlValue.ToString()); if (iRet == 0) { return(false); } else if (iRet == 1) { string strCmd_Code = Output_cmdCode.SqlValue.ToString(); string strCmd_Data = Output_data.SqlValue.ToString(); int iCmd_ID = Convert.ToInt32(Output_ID.SqlValue.ToString()); Cmd_AddList(strCmd_Code, strCmd_Data, iCmd_ID); return(true); } else { return(false); } } catch (SqlException ex) { Log.write("DB_Get_Cmd SqlException Error:" + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("DB_Get_Cmd Error:" + ex.Message, 0); SqlExceptionHelper.restart(); return(false); } }
public int Terminal_Labels_Pos_Update(string terminal_uid, string label1, string label2, string label3, string label4, string label5, int[] coilIndex = null) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_LABEL_POS_UPDATE"; //参数添加 terminal uid command_APHandler.Parameters.Add("@terminal_uid", SqlDbType.VarChar, 50).Value = terminal_uid; //添加Label RFID command_APHandler.Parameters.Add("@label1_ID", SqlDbType.VarChar, 50).Value = label1; command_APHandler.Parameters.Add("@label2_ID", SqlDbType.VarChar, 50).Value = label2; command_APHandler.Parameters.Add("@label3_ID", SqlDbType.VarChar, 50).Value = label3; command_APHandler.Parameters.Add("@label4_ID", SqlDbType.VarChar, 50).Value = label4; command_APHandler.Parameters.Add("@label5_ID", SqlDbType.VarChar, 50).Value = label5; if (coilIndex == null) { command_APHandler.Parameters.Add("@coilIndex1", SqlDbType.Int, 4).Value = 0; command_APHandler.Parameters.Add("@coilIndex2", SqlDbType.Int, 4).Value = 0; command_APHandler.Parameters.Add("@coilIndex3", SqlDbType.Int, 4).Value = 0; command_APHandler.Parameters.Add("@coilIndex4", SqlDbType.Int, 4).Value = 0; command_APHandler.Parameters.Add("@coilIndex5", SqlDbType.Int, 4).Value = 0; } else { command_APHandler.Parameters.Add("@coilIndex1", SqlDbType.Int, 4).Value = coilIndex[0]; command_APHandler.Parameters.Add("@coilIndex2", SqlDbType.Int, 4).Value = coilIndex[1]; command_APHandler.Parameters.Add("@coilIndex3", SqlDbType.Int, 4).Value = coilIndex[2]; command_APHandler.Parameters.Add("@coilIndex4", SqlDbType.Int, 4).Value = coilIndex[3]; command_APHandler.Parameters.Add("@coilIndex5", SqlDbType.Int, 4).Value = coilIndex[4]; } //返回值设置 SqlParameter parOutput1 = command_APHandler.Parameters.Add("@message1", SqlDbType.NVarChar, 200); //定义输出参数 parOutput1.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter parOutput2 = command_APHandler.Parameters.Add("@message2", SqlDbType.NVarChar, 200); //定义输出参数 parOutput2.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter parOutput3 = command_APHandler.Parameters.Add("@message3", SqlDbType.NVarChar, 200); //定义输出参数 parOutput3.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter parOutput4 = command_APHandler.Parameters.Add("@message4", SqlDbType.NVarChar, 200); //定义输出参数 parOutput4.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter parOutput5 = command_APHandler.Parameters.Add("@message5", SqlDbType.NVarChar, 200); //定义输出参数 parOutput5.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter param_count = command_APHandler.Parameters.Add("@Count", SqlDbType.Int, 4); //定义输出参数 param_count.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter param_ok = command_APHandler.Parameters.Add("@ok", SqlDbType.Int, 4); //定义输出参数 param_ok.Direction = ParameterDirection.Output; //参数类型为Output //执行 int iRet = command_APHandler.ExecuteNonQuery(); string strRet1 = parOutput1.SqlValue.ToString(); string strRet2 = parOutput1.SqlValue.ToString(); string strRet3 = parOutput1.SqlValue.ToString(); string strRet4 = parOutput1.SqlValue.ToString(); string strRet5 = parOutput1.SqlValue.ToString(); int count = Convert.ToInt32(param_count.SqlValue.ToString()); int ok = Convert.ToInt32(param_ok.SqlValue.ToString()); if (iRet == 0 || iRet == -1) { Log.write("Database " + identity.ToString() + " --Terminal_Labels_Pos_Update:NOT EFFECTIVE"); return(0); } //返回值 if (ok == 0) { Log.write("Database " + identity.ToString() + " --Terminal_Labels_Pos_Update:TRUE" + count.ToString()); return(count); } else { Log.write("Database " + identity.ToString() + " --Terminal_Labels_Pos_Update:Failed!" + strRet1 + strRet2 + strRet3 + strRet4 + strRet5); return(-1); } } catch (InvalidOperationException ex) { Log.write("Database " + identity.ToString() + " --Terminal_Labels_Pos_Update:OperationError-" + "Message: " + ex.Message, 0); return(-1); } catch (SqlException ex) { Log.write("Database " + identity.ToString() + " --Terminal_Labels_Pos_Update:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(-1); } catch (Exception ex) { Log.write("Database " + identity.ToString() + " --Terminal_Labels_Pos_Update:Error-" + "Message: " + ex.Message, 0); return(-1); } }
public bool Terminal_Status_Update(string uid, string terminal_uid, int status) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_TERMINALSTATUS_UPDATE"; bStored_Init = true; //参数添加 ap uid command_APHandler.Parameters.Add("@uid", SqlDbType.VarChar, 50).Value = uid; //参数添加 terminal uid command_APHandler.Parameters.Add("@terminal_uid", SqlDbType.VarChar, 50).Value = terminal_uid; //参数添加 ap 通道数 if (status == 1) { command_APHandler.Parameters.Add("@status", SqlDbType.Int, 4).Value = 1; } else { command_APHandler.Parameters.Add("@status", SqlDbType.Int, 4).Value = 0; } //返回值设置 SqlParameter parOutput = command_APHandler.Parameters.Add("@message", SqlDbType.NVarChar, 20); //定义输出参数 parOutput.Direction = ParameterDirection.Output; //参数类型为Output //执行 int iRet = command_APHandler.ExecuteNonQuery(); //返回值 if (iRet == 0 || iRet == -1) { Log.write("Database " + identity.ToString() + " --Terminal_Status_Update:NOT EFFECTIVE"); return(false); } string strRet = parOutput.SqlValue.ToString(); if (strRet == "Null" || strRet == "0") { Log.write("Database " + identity.ToString() + " --Terminal_Status_Update:TRUE"); return(true); } else { Log.write("Database " + identity.ToString() + " --Terminal_Status_Update:FALSE"); return(false); } } catch (InvalidOperationException ex) { Log.write("Database " + identity.ToString() + " --Terminal_Status_Update:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("Database " + identity.ToString() + " --Terminal_Status_Update:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database " + identity.ToString() + " --Terminal_Status_Update:Error-" + "Message: " + ex.Message, 0); return(false); } }
public bool AP_Show_Msg(string Label, ref string SO_NO, ref string COLOR_NO, ref string Lot_NO, ref string ClothName, ref string Cloth_Kind) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_AP_SHOW_MSG"; bStored_Init = true; //参数添加 ap uid command_APHandler.Parameters.Add("@label", SqlDbType.VarChar, 50).Value = Label; //返回参数设置 SqlParameter Ret_SO_NO = new SqlParameter("@SO_NO", SqlDbType.VarChar, 50); Ret_SO_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_SO_NO); //返回参数设置 SqlParameter Ret_COLOR_NO = new SqlParameter("@COLOR_NO", SqlDbType.VarChar, 50); Ret_COLOR_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COLOR_NO); //返回参数设置 SqlParameter Ret_Lot_NO = new SqlParameter("@Lot_NO", SqlDbType.VarChar, 50); Ret_Lot_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_Lot_NO); //返回参数设置 SqlParameter Ret_ClothName = new SqlParameter("@ClothName", SqlDbType.VarChar, 50); Ret_ClothName.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_ClothName); //返回参数设置 SqlParameter Ret_Cloth_Kind = new SqlParameter("@Cloth_Kind", SqlDbType.VarChar, 50); Ret_Cloth_Kind.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_Cloth_Kind); //返回值设置 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.VarChar, 50); parReturn.Direction = ParameterDirection.ReturnValue; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //执行 command_APHandler.ExecuteNonQuery(); SO_NO = Ret_SO_NO.Value.ToString(); COLOR_NO = Ret_COLOR_NO.Value.ToString(); Lot_NO = Ret_Lot_NO.Value.ToString(); ClothName = Ret_ClothName.Value.ToString(); Cloth_Kind = Ret_Cloth_Kind.Value.ToString(); //返回值 if (parReturn.Value.Equals(1)) { Log.write("Database " + " --AP_Show_Msg:TRUE"); return(true); } else { Log.write("Database " + " --AP_Show_Msg:FALSE"); return(false); } } catch (InvalidOperationException ex) { Log.write("Database " + " --AP_Show_Msg:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("Database " + " --AP_Show_Msg:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database " + " --AP_Show_Msg:Error-" + "Message: " + ex.Message, 0); return(false); } }
public int Mobile_Info_Get_By_RFID(string strRFID, ref string strSONO, ref string COLOR_NO, ref string strPos, ref string ClothName, ref string Cloth_Kind) { try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_MOBILE_MSG_GET_BY_RFID"; bStored_Init = true; //参数添加 ap uid command_APHandler.Parameters.Add("@RFID_NO", SqlDbType.VarChar, 20).Value = strRFID; //返回参数设置BATCH_DATE SqlParameter Ret_SO_NO = new SqlParameter("@SO_NO", SqlDbType.VarChar, 50); Ret_SO_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_SO_NO); //返回参数设置BATCH_DATE SqlParameter Ret_BATCH_DATE = new SqlParameter("@BATCH_DATE", SqlDbType.DateTime); Ret_BATCH_DATE.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_BATCH_DATE); //返回参数设置DOC_TYPE_OUT SqlParameter Ret_DOC_TYPE_OUT = new SqlParameter("@DOC_TYPE_OUT", SqlDbType.VarChar, 10); Ret_DOC_TYPE_OUT.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_DOC_TYPE_OUT); //返回参数设置SEQ_NO SqlParameter Ret_SEQ_NO = new SqlParameter("@SEQ_NO", SqlDbType.VarChar, 20); Ret_SEQ_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_SEQ_NO); //返回参数设置COL_NO SqlParameter Ret_COL_NO = new SqlParameter("@COL_NO", SqlDbType.VarChar, 20); Ret_COL_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COL_NO); //返回参数设置LOT_NO SqlParameter Ret_LOT_NO = new SqlParameter("@LOT_NO", SqlDbType.VarChar, 20); Ret_LOT_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_LOT_NO); //返回参数设置COL_NO_OK SqlParameter Ret_COL_NO_OK = new SqlParameter("@COL_NO_OK", SqlDbType.VarChar, 20); Ret_COL_NO_OK.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COL_NO_OK); //返回参数设置CUST_NO SqlParameter Ret_CUST_NO = new SqlParameter("@CUST_NO", SqlDbType.VarChar, 20); Ret_CUST_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_CUST_NO); //返回参数设置CUST_SHORT SqlParameter Ret_CUST_SHORT = new SqlParameter("@CUST_SHORT", SqlDbType.VarChar, 20); Ret_CUST_SHORT.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_CUST_SHORT); //返回参数设置PROD_NO SqlParameter Ret_PROD_NO = new SqlParameter("@PROD_NO", SqlDbType.VarChar, 20); Ret_PROD_NO.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_PROD_NO); //返回参数设置PROD_NAME2 SqlParameter Ret_PROD_NAME2 = new SqlParameter("@PROD_NAME2", SqlDbType.VarChar, 20); Ret_PROD_NAME2.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_PROD_NAME2); //返回参数设置PROD_TYPE SqlParameter Ret_PROD_TYPE = new SqlParameter("@PROD_TYPE", SqlDbType.VarChar, 20); Ret_PROD_TYPE.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_PROD_TYPE); //返回参数设置COL_NAME1 SqlParameter Ret_COL_NAME1 = new SqlParameter("@COL_NAME1", SqlDbType.VarChar, 50); Ret_COL_NAME1.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COL_NAME1); //返回参数设置COL_NAME2 SqlParameter Ret_COL_NAME2 = new SqlParameter("@COL_NAME2", SqlDbType.VarChar, 50); Ret_COL_NAME2.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COL_NAME2); //返回参数设置COL_NO_C SqlParameter Ret_COL_NO_C = new SqlParameter("@COL_NO_C", SqlDbType.VarChar, 50); Ret_COL_NO_C.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COL_NO_C); //返回参数设置COL_NO_L SqlParameter Ret_COL_NO_L = new SqlParameter("@COL_NO_L", SqlDbType.VarChar, 50); Ret_COL_NO_L.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_COL_NO_L); //返回参数设置LBL_S SqlParameter Ret_LBL_S = new SqlParameter("@LBL_S", SqlDbType.VarChar, 100); Ret_LBL_S.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_LBL_S); //返回参数设置BUYER SqlParameter Ret_BUYER = new SqlParameter("@BUYER", SqlDbType.VarChar, 100); Ret_BUYER.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_BUYER); //返回参数设置REM SqlParameter Ret_REM = new SqlParameter("@REM", SqlDbType.VarChar, 100); Ret_REM.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_REM); //返回参数设置Ret_POS SqlParameter Ret_POS = new SqlParameter("@POS", SqlDbType.VarChar, 100); Ret_POS.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(Ret_POS); //返回值设置 SqlParameter parReturn = new SqlParameter("@OK", SqlDbType.Int); parReturn.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(parReturn); //返回值设置message SqlParameter parmessage = new SqlParameter("@message", SqlDbType.VarChar, 200); parmessage.Direction = ParameterDirection.Output; //参数类型为ReturnValue command_APHandler.Parameters.Add(parmessage); //执行 command_APHandler.ExecuteNonQuery(); strSONO = Ret_SO_NO.Value.ToString(); COLOR_NO = Ret_COL_NO.Value.ToString(); ClothName = Ret_PROD_NAME2.Value.ToString(); Cloth_Kind = Ret_PROD_TYPE.Value.ToString(); strPos = Ret_POS.Value.ToString(); //返回值 byte ret = byte.Parse(parReturn.Value.ToString()); if (ret == 1) { Log.write("Database " + " --Mobile_Info_Get:TRUE"); return(ret); } else { Log.write("Database " + " --Mobile_Info_Get:FALSE"); return(ret); } } catch (InvalidOperationException ex) { Log.write("Database " + " --Mobile_Info_Get:OperationError-" + "Message: " + ex.Message, 0); return(5); } catch (SqlException ex) { Log.write("Database " + " --Mobile_Info_Get:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(5); } catch (Exception ex) { Log.write("Database " + " --Mobile_Info_Get:Error-" + "Message: " + ex.Message, 0); return(5); } }
public bool Terminal_Coil_Alarm(string terminal_uid, byte status, byte no_index) { int[] coilsstatus = new int[8]; int[] coilEnable = new int[8]; coilsstatus[0] = ((status >> 7) & 0x01); coilsstatus[1] = ((status >> 6) & 0x01); coilsstatus[2] = ((status >> 5) & 0x01); coilsstatus[3] = ((status >> 4) & 0x01); coilsstatus[4] = ((status >> 3) & 0x01); coilsstatus[5] = ((status >> 2) & 0x01); coilsstatus[6] = ((status >> 1) & 0x01); coilsstatus[7] = ((status >> 0) & 0x01); coilEnable[0] = ((no_index >> 7) & 0x01); coilEnable[1] = ((no_index >> 6) & 0x01); coilEnable[2] = ((no_index >> 5) & 0x01); coilEnable[3] = ((no_index >> 4) & 0x01); coilEnable[4] = ((no_index >> 3) & 0x01); coilEnable[5] = ((no_index >> 2) & 0x01); coilEnable[6] = ((no_index >> 1) & 0x01); coilEnable[7] = ((no_index >> 0) & 0x01); for (int i = 0; i < 8; i++) { if (coilsstatus[i] == 0 && coilEnable[i] == 1) { coilsstatus[i] = 2; } if (coilEnable[i] == 0) { coilsstatus[i] = 0; } } try { //命令设置 command_APHandler = sqlCnt.CreateCommand(); command_APHandler.CommandType = CommandType.StoredProcedure; command_APHandler.CommandText = "P_TERMINAL_COIL_STATUS_UPDATE"; //参数添加 terminal uid command_APHandler.Parameters.Add("@terminal_uid", SqlDbType.VarChar, 50).Value = terminal_uid; //添加Label RFID command_APHandler.Parameters.Add("@coil1", SqlDbType.VarChar, 50).Value = coilsstatus[0]; command_APHandler.Parameters.Add("@coil2", SqlDbType.VarChar, 50).Value = coilsstatus[1]; command_APHandler.Parameters.Add("@coil3", SqlDbType.VarChar, 50).Value = coilsstatus[2]; command_APHandler.Parameters.Add("@coil4", SqlDbType.VarChar, 50).Value = coilsstatus[3]; command_APHandler.Parameters.Add("@coil5", SqlDbType.VarChar, 50).Value = coilsstatus[4]; command_APHandler.Parameters.Add("@coil6", SqlDbType.VarChar, 50).Value = coilsstatus[5]; command_APHandler.Parameters.Add("@coil7", SqlDbType.VarChar, 50).Value = coilsstatus[6]; command_APHandler.Parameters.Add("@coil8", SqlDbType.VarChar, 50).Value = coilsstatus[7]; //返回值设置 SqlParameter parOutput1 = command_APHandler.Parameters.Add("@message", SqlDbType.NVarChar, 200); //定义输出参数 parOutput1.Direction = ParameterDirection.Output; //参数类型为Output //返回值设置 SqlParameter param_ok = command_APHandler.Parameters.Add("@ok", SqlDbType.Int, 4); //定义输出参数 param_ok.Direction = ParameterDirection.Output; //参数类型为Output int iRet = command_APHandler.ExecuteNonQuery(); int ok = Convert.ToInt32(param_ok.SqlValue.ToString()); if (ok == 0 || ok == -1) { Log.write("Database " + identity.ToString() + " --Terminal_Coil_Alarm:NOT EFFECTIVE"); return(false); } else if (ok == 1) { Log.write("Database " + identity.ToString() + " --Terminal_Coil_Alarm:TRUE"); return(true); } } catch (InvalidOperationException ex) { Log.write("Database " + identity.ToString() + " --Terminal_Coil_Alarm:OperationError-" + "Message: " + ex.Message, 0); return(false); } catch (SqlException ex) { Log.write("Database " + identity.ToString() + " --Terminal_Coil_Alarm:SqlError-Number:" + ex.Number.ToString() + ";Message: " + ex.Message, 0); SqlExceptionHelper.Deal(ex); return(false); } catch (Exception ex) { Log.write("Database " + identity.ToString() + " --Terminal_Coil_Alarm:Error-" + "Message: " + ex.Message, 0); return(false); } return(false); }
private void DBHandleJob() { try { if (dbOrderList.Count == 0 && dbSentList.Count == 0) { Log.write("DBMsgHandler-WaitOne"); resumeEvent.Reset(); resumeEvent.WaitOne(); } lock (dbOrderList) { if (dbOrderList.Count != 0) { APParser apParser = dbOrderList[0]; udpsocket.Send(apParser.GetParam_Origin_byte()); dbOrderList.RemoveAt(0); dbSentList.Add(apParser); Log.write("DBMsgHandler---Send a command", 0); } //处理发送数据 } //锁存dbOrderList int dbSent_count = dbSentList.Count; if (dbSent_count == 0) { return; }//已发送命令 lock (dbResultList) { int dbResult_count = dbResultList.Count; if (dbResult_count == 0) { Thread.Sleep(50); return; }//有处理结果返回 for (int i = dbResult_count - 1; i >= 0; i--) { dbResult_count = dbResultList.Count; if (dbResult_count == 0) { break; }//结果为0,结束 bool isReponsed = false; for (int j = dbSent_count - 1; j >= 0; j--) { APParser SentParser = dbSentList[j]; APParser ResultParser = dbResultList[i]; int iRet = APParser.RelatingMsg(SentParser, ResultParser); if (iRet == 1) { database.DB_Set_Cmd(SentParser.GetID(), ResultParser.GetParam_Result()); //Log.write("DBMsgHandler-Get relative message:sent JobDone"); Log.write("DBMsgHandler---matching a result:" + SentParser.GetParam_Origin_Hex() + "\r\n" + ResultParser.GetParam_Origin_Hex() + "\r\n", 2); dbSentList.RemoveAt(j); dbResultList.RemoveAt(i); SentParser.Dispose(); ResultParser.Dispose(); isReponsed = true; break;//match and break the circle } else if (iRet == 0) { database.DB_Update_Cmd(SentParser.GetID(), ResultParser.GetParam_Cmd_SendOrNot()); Log.write("DBMsgHandler---matching a response:" + SentParser.GetParam_Origin_Hex() + "\r\n" + ResultParser.GetParam_Origin_Hex() + "\r\n", 2); isReponsed = true; dbResultList.RemoveAt(i); ResultParser.Dispose(); break;//match and break the circle } else { } } if (!isReponsed) { APParser aa = dbResultList[i]; aa.Dispose(); dbResultList.RemoveAt(i); Log.write("DBMsgHandler---inequal result", 0); } } //遍历匹配 } //锁存 } catch (SqlException ex) { Log.write("DBMsgHandler SqlException Error:" + ex.Message, 0); SqlExceptionHelper.Deal(ex); } catch (Exception ex) { Log.write("DBMsgHandler-ThreadError:" + ex.Message, 0); dbOrderList.Clear(); dbResultList.Clear(); Log.write("DBMsgHandler-Clear All", 0); } }