public static Config CreateModel(DataRow dr)
{
Config config = new Config();
if (dr.Table.Columns.Contains("Id"))
{
config.Id = LibConvert.ObjToInt64(dr["Id"]);
}
if (dr.Table.Columns.Contains("CategoryId"))
{
config.CategoryId = LibConvert.ObjToInt64(dr["CategoryId"]);
}
if (dr.Table.Columns.Contains("ConfigKey"))
{
config.ConfigKey = LibConvert.ObjToStr(dr["ConfigKey"]);
}
if (dr.Table.Columns.Contains("ConfigValue"))
{
config.ConfigValue = LibConvert.ObjToStr(dr["ConfigValue"]);
}
if (dr.Table.Columns.Contains("Remark"))
{
config.Remark = LibConvert.ObjToStr(dr["Remark"]);
}
if (dr.Table.Columns.Contains("CreateTime"))
{
config.CreateTime = LibConvert.ObjToDateTime(dr["CreateTime"]);
}
if (dr.Table.Columns.Contains("UpdateTime"))
{
config.UpdateTime = LibConvert.ObjToDateTime(dr["UpdateTime"]);
}
return config;
}
public Config GetByCategoryId(string conn,long cid)
{
Config config = new Config();
string sql = "SELECT Id,CategoryId,ConfigKey,ConfigValue,Remark,CreateTime FROM Config WHERE CategoryId=@cid";
SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@cid", cid) };
DataTable dt = SqlServerHelper.Get(conn, sql, paramters);
if (dt.Rows.Count > 0)
{
config = Config.CreateModel(dt.Rows[0]);
}
return config;
}
/// <summary>
/// 读取列表
/// </summary>
/// <returns></returns>
public List<Config> GetList(string conn)
{
List<Config> list = new List<Config>();
string sql = "SELECT Id,CategoryId,ConfigKey,ConfigValue,Remark,CreateTime FROM Config";
DataTable dt = SqlServerHelper.Get(conn, sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Config category = new Config();
category = Config.CreateModel(dt.Rows[i]);
list.Add(category);
}
}
return list;
}
public List<Config> GetListByCategoryIds(string conn, long[] cids, DateTime updatetime)
{
List<Config> list = new List<Config>();
string sql = "SELECT Id,CategoryId,ConfigKey,ConfigValue,Remark,CreateTime,UpdateTime FROM Config WHERE UpdateTime < @updatetime";
SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@updatetime", updatetime) };
DataTable dt = SqlServerHelper.Get(conn, sql, paramters);
if (dt.Rows.Count > 0)
{
for (int m = 0; m < dt.Rows.Count; m++)
{
Config config = new Config();
config = Config.CreateModel(dt.Rows[m]);
list.Add(config);
}
}
return list.Where(c => cids.Contains(c.CategoryId)).ToList();
}
