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