/// <summary>
/// 闸机信息上传
/// </summary>
/// <param name=""></param>
/// <Remark></ Remark >
public bool GateStateSnycRpc(SYS_CLIENT varSysClient)
{
bool IsResult = false;
checkConn();
try
{
IsResult = DataSyncClient.gateStateSnyc(_auth, varSysClient);
}
catch (RPCException ex)
{
_log.Error("上传闸机信息错误", ex);
throw new Exception("错误码[" + ex.ErrorCode + "] " + "错误信息[" + ex.ErrorMess + "]");
}
catch (System.IO.IOException ex)
{
_log.Error(typeof(T_RpcClient), ex);
throw new Exception("服务器连接超时,请稍后重新操作!");
}
catch (Exception ex)
{
_log.Error("上传闸机信息错误", ex);
throw new Exception(ex.Message.ToString());
}
return(IsResult);
}
/// <summary>
/// 检票数据上传
/// </summary>
/// <returns></returns>
public bool GateStateSync(int varGateMode, int runState)
{
SYS_CLIENT gateState = new SYS_CLIENT();
gateState.ClientId = _auth.ClientId;
gateState.RunStat = runState;
gateState.GateMode = varGateMode;
bool resRult = false;
try
{
resRult = _rpcClient.GateStateSnycRpc(gateState);
}
catch (Exception ex)
{
_log.Error(typeof(B_BaseDataSync), ex);
return(false);
}
return(resRult);
}
/// <summary>
/// 新增终端信息
/// </summary>
/// <param name="varParemeterModel">终端信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertClient(SYS_CLIENT varClientModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_CLIENT(");
tmpStrSql.Append("CLIENT_ID,CLIENT_NAME,CLIENT_TYPE,REGION_ID,OUTLET_ID,IP_ADDR,PORT,STAT,GATE_MODE,RUN_STAT,REPORT_TIME,TOKEN,OPE_USER_ID,OPE_TIME)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@CLIENT_ID,@CLIENT_NAME,@CLIENT_TYPE,@REGION_ID,@OUTLET_ID,@IP_ADDR,@PORT,@STAT,@GATE_MODE,@RUN_STAT,@REPORT_TIME,@TOKEN,@OPE_USER_ID,@OPE_TIME)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@CLIENT_ID", DbType.Int64),
new SQLiteParameter("@CLIENT_NAME", DbType.String, 200),
new SQLiteParameter("@CLIENT_TYPE", DbType.String, 1),
new SQLiteParameter("@REGION_ID", DbType.Int64),
new SQLiteParameter("@OUTLET_ID", DbType.Int64),
new SQLiteParameter("@IP_ADDR", DbType.String, 20),
new SQLiteParameter("@PORT", DbType.String, 20),
new SQLiteParameter("@STAT", DbType.String, 1),
new SQLiteParameter("@GATE_MODE", DbType.Int32),
new SQLiteParameter("@RUN_STAT", DbType.Int32),
new SQLiteParameter("@REPORT_TIME", DbType.DateTime),
new SQLiteParameter("@TOKEN", DbType.String, 100),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 60),
new SQLiteParameter("@OPE_TIME", DbType.DateTime)
};
tmpParameters[0].Value = varClientModel.ClientId;
tmpParameters[1].Value = varClientModel.ClientName;
tmpParameters[2].Value = varClientModel.ClientType;
tmpParameters[3].Value = varClientModel.RegionId;
tmpParameters[4].Value = varClientModel.OutletId;
tmpParameters[5].Value = varClientModel.IpAddr;
tmpParameters[6].Value = varClientModel.Port;
tmpParameters[7].Value = varClientModel.Stat;
tmpParameters[8].Value = varClientModel.GateMode;
tmpParameters[9].Value = varClientModel.RunStat;
tmpParameters[10].Value = T_Date.ConvertLongToDateTime(varClientModel.ReportTime);
tmpParameters[11].Value = varClientModel.Token;
tmpParameters[12].Value = varClientModel.OpeUserId;
tmpParameters[13].Value = T_Date.ConvertLongToDateTime(varClientModel.OpeTime);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_Client), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
