public void insert(string txtQuery)
{
try
{
sqlite.ExecuteNonQuery(txtQuery);
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertSampleModel(SampleModel data)
{
try
{
string executeInsert = string.Format(Insert_Sample, data.Code, data.TrueValue, data.SecuritySiteId, data.Backup1, data.Backup2);
int retCount = Sqlite.ExecuteNonQuery(executeInsert);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public void InsertSecuriteSiteModel(SecuriteSiteModel data)
{
try
{
string executeInsert = string.Format(Insert_SecuriteSite, data.SecurityCodeUrl, data.CodeNum, data.Name, data.Backup1, data.Backup2);
int retCount = Sqlite.ExecuteNonQuery(executeInsert);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public void InsertAgentIPModel(AgentIPModel data)
{
try
{
string executeInsert = string.Format(Insert_AgentIP, data.ip, data.port, data.LastCheckData, data.Active, data.LastSuccess);
int retCount = Sqlite.ExecuteNonQuery(executeInsert);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
/// <summary>
/// Update
/// </summary>
/// <param name="mObj"></param>
/// <returns></returns>
public void Update(SampleModel mObj)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sample set ");
StringBuilder sbCondition = new StringBuilder();
if (mObj.Code != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Code = '{0}' ", mObj.Code);
}
if (mObj.TrueValue != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" TrueValue = '{0}' ", mObj.TrueValue);
}
if (mObj.SecuritySiteId != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" SecuritySiteId = '{0}' ", mObj.SecuritySiteId);
}
if (mObj.Backup1 != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Backup1 = '{0}' ", mObj.Backup1);
}
if (mObj.Backup2 != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Backup2 = '{0}' ", mObj.Backup2);
}
strSql.Append(sbCondition.ToString());
strSql.AppendFormat(" where [Code]='{0}'", mObj.Code);
object ret = Sqlite.ExecuteNonQuery(strSql.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
/// <summary>
/// Update
/// </summary>
/// <param name="mObj"></param>
/// <returns></returns>
public void Update(SecuriteSiteModel mObj)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SecuriteSite set ");
StringBuilder sbCondition = new StringBuilder();
if (mObj.SecurityCodeUrl != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" SecurityCodeUrl = '{0}' ", mObj.SecurityCodeUrl);
}
if (mObj.CodeNum != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" CodeNum = '{0}' ", mObj.CodeNum);
}
if (mObj.Name != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Name = '{0}' ", mObj.Name);
}
if (mObj.Backup1 != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Backup1 = '{0}' ", mObj.Backup1);
}
if (mObj.Backup2 != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Backup2 = '{0}' ", mObj.Backup2);
}
if (mObj.id != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" id = '{0}' ", mObj.id);
}
strSql.Append(sbCondition.ToString());
strSql.AppendFormat(" where [SecurityCodeUrl]='{0}'", mObj.SecurityCodeUrl);
object ret = Sqlite.ExecuteNonQuery(strSql.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
/// <summary>
/// Update
/// </summary>
/// <param name="mObj"></param>
/// <returns></returns>
public void Update(AgentIPModel mObj)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AgentIP set ");
StringBuilder sbCondition = new StringBuilder();
if (mObj.ip != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" ip = '{0}' ", mObj.ip);
}
if (mObj.port != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" port = '{0}' ", mObj.port);
}
if (mObj.LastCheckData != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" LastCheckData = '{0}' ", mObj.LastCheckData);
}
if (mObj.Active != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" Active = '{0}' ", mObj.Active);
}
if (mObj.LastSuccess != null)
{
if (sbCondition.Length > 0)
{
sbCondition.Append(",");
}
sbCondition.AppendFormat(" LastSuccess = '{0}' ", mObj.LastSuccess);
}
strSql.Append(sbCondition.ToString());
strSql.AppendFormat(" where [ip]='{0}'", mObj.ip);
object ret = Sqlite.ExecuteNonQuery(strSql.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
