/// <summary>
/// 根据车牌号判断当前车的订单状态
/// </summary>
/// <param name="szTrunkNo"></param>
/// <returns></returns>
public static int GetOrderStateByTrunkNo(string szTrunkNo)
{
int state = -1;
try
{
string sqlStr = "Select F_OrderStatus From T_Order Where F_TrunkNo = @F_TrunkNo; ";
Dictionary <string, object> parm = new Dictionary <string, object>();
parm.Add("F_TrunkNo", szTrunkNo);
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(sqlStr, parm);
if (dt == null)
{
_errorText = idb.LastException.Message;
return(-1);
}
if (dt.Rows.Count == 0)
{
return(-1);
}
state = CommonFunction.GetIntValue(dt.Rows[0]["F_OrderStatus"].ToString());
return(state);
}
catch (Exception ex)
{
_errorText = ex.Message;
return(state);
}
}
/// <summary>
/// 获取订单状态为大于新油单并未过皮重的车辆
/// </summary>
/// <returns></returns>
public static DataTable GetNoWeightbridgeFromState()
{
try
{
string strSql = "Select F_TrunkNo,F_DriverName,F_Company,F_OrderStatus,F_CallTime From T_Order Where F_OrderStatus > 0 and F_OrderStatus < 6;";
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(strSql);
if (dt == null)
{
return(null);
}
if (dt.Rows.Count == 0)
{
_errorText = "没有找到状态大于0并且小于6的信息";
return(null);
}
return(dt);
}
catch (Exception ex)
{
_errorText = ex.Message;
return(null);
}
}
/// <summary>
/// 查询订单状态
/// </summary>
/// <param name="szState"></param>
/// <returns></returns>
public static string GetStateNameForOrder(int szState)
{
string state = "";
try
{
string strSql = "Select F_Name From T_OrderStatus Where F_ID =@F_ID; ";
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("F_ID", szState);
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(strSql, param);
if (dt == null)
{
_errorText = idb.LastException.Message;
return(state);
}
if (dt.Rows.Count == 0)
{
state = "没有该车牌号状态";
return(state);
}
state = dt.Rows[0]["F_Name"].ToString();
return(state);
}
catch (Exception ex)
{
_errorText = ex.Message;
return(state);
}
}
public static T_TrunkNoRecognitionRecord GetRecordFromImageIndex(string szImageIndex)
{
try
{
string strSql = "Select * From T_TrunkNoRecognitionRecord Where F_ImageIndex = @F_ImageIndex;";
Dictionary <string, object> parm = new Dictionary <string, object>();
parm.Add("F_ImageIndex", szImageIndex);
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(strSql, parm);
if (dt == null)
{
return(null);
}
if (dt.Rows.Count == 0)
{
_errorText = "信息不存在";
return(null);
}
T_TrunkNoRecognitionRecord record = GetRecordFromDR(dt.Rows[0]);
return(record);
}
catch (Exception ex)
{
_errorText = ex.Message;
return(null);
}
}
public static bool VerifyLicense(string szID, string szKey)
{
if (String.IsNullOrEmpty(szID))
{
return(false);
}
bool bRet = false;
try
{
string szSQL = String.Format("Select * From T_Aauthorization Where F_ID = '{0}'", szID);
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(szSQL);
foreach (DataRow dr in dt.Rows)
{
string szDBKey = dr["F_Value"].ToString();
if (szDBKey.CompareTo(szKey) == 0)
{
bRet = true;
}
break;
}
}
catch (Exception ex)
{
_errorText = ex.Message;
}
return(bRet);
}
public static bool HardwareIDExist(string szID)
{
bool bRet = false;
try
{
string szSQL = String.Format("Select * From T_Aauthorization Where F_ID = '{0}'", szID);
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(szSQL);
bRet = (dt.Rows.Count > 0);
}
catch (Exception ex)
{
_errorText = ex.Message;
}
return(bRet);
}
public static DataTable GetAllDataTable(string szFilter)
{
string strSql = "Select * From T_TrunkNoRecognitionRecord ";
strSql += szFilter;
IDatabaseBridge idb = DatabaseFactory.Create();
DataTable dt = idb.GetDataTable(strSql);
if (dt == null)
{
return(null);
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(dt);
}
