/// <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); }