/// <summary>
/// 验证用户名是否存在
/// </summary>
/// <param name="userName">用户名</param>
/// <returns>存在返回false,不存在返回true</returns>
public bool ValidateUsername(string userName)
{
var strSql = new StringBuilder();
strSql.Append("SELECT COUNT(1) FROM USERINFO WHERE UPPER(F_NAME) = UPPER(:F_NAME)");
OracleParameter[] parms =
{
new OracleParameter("F_NAME", userName)
};
var dbHelper = new DbAPI();
try
{
dbHelper.OpenConn("");
var rstInt = dbHelper.ExecuteOracleScalar(strSql.ToString(), parms);
dbHelper.CloseConn();
return(int.Parse(rstInt.ToString()) <= 0);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(ROLEINFO_BN), "验证用户名是否存在ValidateUsername 程序段的异常" + ex);
return(false);
}
}
/// <summary>
/// 获取实时数据列表
/// </summary>
/// <param name="device"></param>
/// <returns></returns>
public int GetDeviceInfoCount(DEVICEINFO device)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT COUNT(1) ");
strSql.Append(" FROM DEVICEINFO DI ");
strSql.Append(" LEFT JOIN DEVICEATTACH DA ON DI.DEVICECODE=DA.DEVICECODE ");
strSql.Append(" WHERE 1=1 ");
List <OracleParameter> list = new List <OracleParameter>();
// 设备类型（岸基站、浮标）
if (device.DEVICETYPE > 0)
{
strSql.Append(" AND DEVICETYPE=:DEVICETYPE ");
list.Add(new OracleParameter(":DEVICETYPE", device.DEVICETYPE));
}
if (!string.IsNullOrEmpty(device.SEAAREA))
{
strSql.Append(" AND SEAAREA=:SEAAREA ");
list.Add(new OracleParameter(":SEAAREA", device.SEAAREA));
}
if (!string.IsNullOrEmpty(device.PROVINCE))
{
strSql.Append(" AND PROVINCE=:PROVINCE ");
list.Add(new OracleParameter(":PROVINCE", device.PROVINCE));
}
if (!string.IsNullOrEmpty(device.BAY))
{
strSql.Append(" AND BAY=:BAY ");
list.Add(new OracleParameter(":BAY", device.BAY));
}
if (!string.IsNullOrEmpty(device.BUREAUDEVICE))
{
strSql.Append(" AND BUREAUDEVICE=:BUREAUDEVICE ");
list.Add(new OracleParameter(":BUREAUDEVICE", device.BUREAUDEVICE));
}
if (!string.IsNullOrEmpty(device.LOCALDEVICE))
{
strSql.Append(" AND LOCALDEVICE=:LOCALDEVICE ");
list.Add(new OracleParameter(":LOCALDEVICE", device.LOCALDEVICE));
}
if (!string.IsNullOrEmpty(device.SERVICE))
{
strSql.Append(" AND SERVICE=:SERVICE ");
list.Add(new OracleParameter(":SERVICE", device.SERVICE));
}
DbAPI dbHelper = new DbAPI();
dbHelper.OpenConn("");
object result = dbHelper.ExecuteOracleScalar(strSql.ToString(), list.ToArray());
dbHelper.CloseConn();
return(Convert.ToInt32(result.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public int GetCount(string logType, string startDate, string endDate, int pageNumber, int pageSize)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
List <OracleParameter> listParams = new List <OracleParameter>();
strSql.Append(" SELECT COUNT(1) FROM SYSTEMLOG ");
strSql.Append(" WHERE 1=1 ");
if (!string.IsNullOrEmpty(logType))
{
strSql.Append(" AND \"TYPE\" LIKE '%").Append(logType).Append("%' ");
//listParams.Add(new OracleParameter(":logType", logType));
}
if (!string.IsNullOrEmpty(startDate) && !string.IsNullOrEmpty(endDate))
{
strSql.Append(" AND DATETIME BETWEEN TO_DATE(:startDate, 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(:endDate, 'YYYY-MM-DD HH24:MI:SS') ");
listParams.Add(new OracleParameter("startDate", startDate));
listParams.Add(new OracleParameter("endDate", endDate + " 23:59:59"));
}
try
{
dbHelper.OpenConn("");
object result = dbHelper.ExecuteOracleScalar(strSql.ToString(), listParams.ToArray());
dbHelper.CloseConn();
return(Convert.ToInt32(result.ToString()));
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(SYSTEMLOG_BN), "GetCount 程序段的异常" + ex);
return(0);
}
}
/// <summary>
/// 获取用户头像(数据库中存储的是BLOB格式图片数据)
/// </summary>
/// <param name="userAccount">用户ID</param>
public byte[] GetUserLogo(string userAccount)
{
var sql = "select f_photo from USERINFO WHERE F_ACCOUNT=:F_ACCOUNT";
OracleParameter[] parameters =
{
new OracleParameter(":F_ACCOUNT", userAccount)
};
var dbapi = new DbAPI();
dbapi.OpenConn("");
var rst = dbapi.ExecuteOracleScalar(sql, parameters) as System.Data.OracleClient.OracleLob;
if (rst != null)
{
byte[] bytes = new byte[rst.Length];
rst.Read(bytes, 0, bytes.Length);
dbapi.CloseConn();
return(bytes);
}
dbapi.CloseConn();
return(null);
}
