public List <SecuriteSiteModel> GetSecuriteSite(SecuriteSiteModel condition, int pageSize, int pageIndex)
{
try
{
StringBuilder sbCondition = GetConditionString(condition);
int startindex = (pageIndex - 1) * pageSize;
string searchSql = string.Format(Select_SecuriteSiteByConditionPage, sbCondition.ToString(), pageSize, startindex);
sr = Sqlite.ExecuteReader(searchSql);
List <SecuriteSiteModel> SecuriteSiteList = new List <SecuriteSiteModel>();
while (sr.Read())
{
SecuriteSiteList.Add(getSecuriteSiteInner(sr));
}
return(SecuriteSiteList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sr.Close();
}
}
StringBuilder GetConditionString(SecuriteSiteModel condition)
{
StringBuilder sbCondition = new StringBuilder(" 1=1 ");
if (!string.IsNullOrEmpty(condition.SecurityCodeUrl))
{
sbCondition.AppendFormat(" and [SecurityCodeUrl] = '{0}' ", condition.SecurityCodeUrl);
}
if (0 != condition.CodeNum)
{
sbCondition.AppendFormat(" and [CodeNum] = '{0}' ", condition.CodeNum);
}
if (!string.IsNullOrEmpty(condition.Name))
{
sbCondition.AppendFormat(" and [Name] = '{0}' ", condition.Name);
}
if (!string.IsNullOrEmpty(condition.Backup1))
{
sbCondition.AppendFormat(" and [Backup1] = '{0}' ", condition.Backup1);
}
if (!string.IsNullOrEmpty(condition.Backup2))
{
sbCondition.AppendFormat(" and [Backup2] = '{0}' ", condition.Backup2);
}
if (0 != condition.id)
{
sbCondition.AppendFormat(" and [id] = '{0}' ", condition.id);
}
return(sbCondition);
}
SecuriteSiteModel getSecuriteSiteInner(SQLiteDataReader sr)
{
bool acknowledge;
SecuriteSiteModel model = new SecuriteSiteModel();
if (sr.GetValue(0) != DBNull.Value)
{
model.SecurityCodeUrl = sr.GetString(0);
}
if (sr.GetValue(1) != DBNull.Value)
{
model.CodeNum = sr.GetInt32(1);
}
if (sr.GetValue(2) != DBNull.Value)
{
model.Name = sr.GetString(2);
}
if (sr.GetValue(3) != DBNull.Value)
{
model.Backup1 = sr.GetString(3);
}
if (sr.GetValue(4) != DBNull.Value)
{
model.Backup2 = sr.GetString(4);
}
if (sr.GetValue(5) != DBNull.Value)
{
model.id = sr.GetInt32(5);
}
return(model);
}
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
{
}
}
/// <summary>
/// get total rows count
/// </summary>
/// <returns></returns>
public int GetTotalCount(SecuriteSiteModel condition)
{
try
{
StringBuilder sbCondition = GetConditionString(condition);
string searchSql = string.Format(Select_TotalCount, sbCondition.ToString());
object count;
count = Sqlite.ExecuteScalar(searchSql);
int intcount = 0;
int.TryParse(count + "", out intcount);
return(intcount);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public void Update(SecuriteSiteModel ObjModel)
{
dal.Update(ObjModel);
}
public int GetTotalCount(SecuriteSiteModel condition)
{
return(dal.GetTotalCount(condition));
}
public List <SecuriteSiteModel> GetSecuriteSite(SecuriteSiteModel condition, int pageSize, int pageIndex)
{
return(dal.GetSecuriteSite(condition, pageSize, pageIndex));
}
/// <summary>
/// get SecuriteSite list by condition
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public List <SecuriteSiteModel> GetSecuriteSite(SecuriteSiteModel condition)
{
return(dal.GetSecuriteSite(condition));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="ObjModel">模型对象</param>
/// <returns>产生主键值</returns>
public void Insert(SecuriteSiteModel ObjModel)
{
dal.InsertSecuriteSiteModel(ObjModel);
}
/// <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
{
}
}
public UnCodeAiYing(Bitmap pic, List <SampleModel> codes, SecuriteSiteModel site)
: base(pic)
{
this.codes = codes;
trackSite = site;
}
