public static bool InsertData(T_TrunkNoRecognitionRecord record) { bool iRet = false; try { string strSql = "Insert Into T_TrunkNoRecognitionRecord(F_TrunkNo, F_EnterTime, F_State, F_ImageIndex) "; strSql += "Values(@F_TrunkNo, @F_EnterTime, @F_State, @F_ImmageIndex); "; Dictionary <string, object> parms = new Dictionary <string, object>(); parms.Add("F_TrunkNo", record.F_TrunkNo); parms.Add("F_EnterTime", record.F_EnterTime); parms.Add("F_State", record.F_State); parms.Add("F_ImageIndex", record.F_ImageIndex); IDatabaseBridge idb = DatabaseFactory.Create(); if (idb.ExecuteCommand(strSql.ToString(), parms) == -1) { _errorText = idb.LastException.ToString(); return(false); } return(iRet); } catch (Exception ex) { _errorText = ex.Message; return(iRet); } }
public static bool InsertLicense(string szID, string szKey) { if (String.IsNullOrEmpty(szID)) { return(false); } bool bRet = false; try { string szSQL = String.Format("Insert Into T_Aauthorization (F_ID, F_Value) Values ('{0}', '{1}')", szID, szKey); IDatabaseBridge idb = DatabaseFactory.Create(); bRet = (idb.ExecuteCommand(szSQL) != -1); if (!bRet) { _errorText = idb.LastException.ToString(); } } catch (Exception ex) { _errorText = ex.Message; } return(bRet); }
public static bool UpdateRecord(T_TrunkNoRecognitionRecord record) { try { string strSql = "Update T_TrunkNoRecognitionRecord Set F_TrunkNo =@F_TrunkNo,F_EnterTime =@F_EnterTime Where F_ImageIndex = F_ImageIndex;"; Dictionary <string, object> parms = new Dictionary <string, object>(); parms.Add("F_TrunkNo", record.F_TrunkNo); parms.Add("F_EnterTime", record.F_EnterTime); parms.Add("F_State", record.F_State); parms.Add("F_ImageIndex", record.F_ImageIndex); IDatabaseBridge idb = DatabaseFactory.Create(); if (idb.ExecuteCommand(strSql.ToString(), parms) == -1) { _errorText = idb.LastException.ToString(); return(false); } return(true); } catch (Exception ex) { _errorText = ex.Message; return(false); } }
public static bool UpdateLicense(string szID, string strKey) { if (String.IsNullOrEmpty(szID)) { return(false); } bool bRet = false; try { string szSQL = String.Format("Update T_Aauthorization Set F_Value = '{0}' Where F_ID = '{1}'", strKey, szID); IDatabaseBridge idb = DatabaseFactory.Create(); bRet = (idb.ExecuteCommand(szSQL) != -1); if (!bRet) { _errorText = idb.LastException.ToString(); } } catch (Exception ex) { _errorText = ex.Message; } return(bRet); }