/// <summary>
/// 得到实体对象
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public Model.Admin GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from Admin ");
if (where != "")
{
strSql.Append(" where " + where);
}
Model.Admin model = new Model.Admin();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby);
}
else
{
strSql.Append("order by T.RecordID desc");
}
strSql.Append(")AS Row, T.* from SysParamInfo T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return(DbHelperSQLite.Query(strSql.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ScriptInfo GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select RecordID,ScriptName,ScriptDetails from ScriptInfo ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Model.ScriptInfo model = new Model.ScriptInfo();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SysParamInfo GetModel(int RecordID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RecordID,ItemName,ItemValue1,ItemValue2 from SysParamInfo ");
strSql.Append(" where RecordID=@RecordID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@RecordID", DbType.Int32, 4)
};
parameters[0].Value = RecordID;
Model.SysParamInfo model = new Model.SysParamInfo();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Agent GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,TrueName,Phone,Words,ComID,Account,PassWord,QQ,WeChat,Xiaoqu from Agent ");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = ID;
Model.Agent model = new Model.Agent();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SiteConfig GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Key,Value from SiteConfig ");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = ID;
Model.SiteConfig model = new Model.SiteConfig();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Company GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Name,Address,Phone,OpenTime,Summary from Company ");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = ID;
Model.Company model = new Model.Company();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Admin GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,LoginName,Password,Power,NickName from Admin ");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = ID;
Model.Admin model = new Model.Admin();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Branch GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,BranchName,BranchAddress,BranchPhone,BranchDetail from Branch ");
strSql.Append(" where ID=@ID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 4)
};
parameters[0].Value = ID;
Model.Branch model = new Model.Branch();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ExchangeInfo GetModel(int RecordID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RecordID,HotKeyID,ExchangeText,ShiftKey,MainKey from ExchangeInfo ");
strSql.Append(" where RecordID=@RecordID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@RecordID", DbType.Int32, 4)
};
parameters[0].Value = RecordID;
Model.ExchangeInfo model = new Model.ExchangeInfo();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.House GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Type,JingPin,Qu,XiaoQu,Ceng,ZongCeng,Shi,Ting,Wei,MianJi,ZhuangXiu,Jianyu,JiaGe,JiaGeDanwei,Chaoxiang,Chanquan,JieGou,ZhuJiMa,FyHao,DengJiTime,JJR,JJRPhone,Title,Detail from House ");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = ID;
Model.House model = new Model.House();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(new Model.House().DefaultHouse());
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Pic GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,ImageURL,AID,Type,Number,Title,Summary from Pic ");
strSql.Append(" where ID=@ID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 4)
};
parameters[0].Value = ID;
Model.Pic model = new Model.Pic();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}