/// <summary>
/// 获得cids的分类列表
/// </summary>
/// <param name="cids"></param>
/// <returns></returns>
public List<Category> GetListByIds(string conn,string cids)
{
List<Category> list = new List<Category>();
string[] cidstr = cids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
long[] ids = new long[cidstr.Length];
for (int i = 0; i < cidstr.Length; i++)
{
ids[i] = LibConvert.StrToInt64(cidstr[i]);
}
string sql = "SELECT Id,CategoryName,Remark,CreateTime FROM Category";
SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@cdis", cids) };
DataTable dt = SqlServerHelper.Get(conn, sql, paramters);
if (dt.Rows.Count > 0)
{
for (int m = 0; m < dt.Rows.Count; m++)
{
Category cate = new Category();
cate = Category.CreateModel(dt.Rows[m]);
list.Add(cate);
}
}
return list.Where(c => ids.Contains(c.Id)).ToList();
}
/// <summary>
/// 根据Id读取一条记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Category GetById(string conn,long id)
{
Category category = new Category();
string sql = "SELECT Id,CategoryName,Remark,CreateTime FROM Category WHERE Id=@cid";
SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@cid", id) };
DataTable dt = SqlServerHelper.Get(conn, sql, paramters);
if (dt.Rows.Count > 0)
{
category = Category.CreateModel(dt.Rows[0]);
}
return category;
}
/// <summary>
/// 读取列表
/// </summary>
/// <returns></returns>
public List<Category> GetList(string conn)
{
List<Category> list = new List<Category>();
string sql = "SELECT Id,CategoryName,Remark,CreateTime FROM Category";
DataTable dt = SqlServerHelper.Get(conn, sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Category category = new Category();
category = Category.CreateModel(dt.Rows[i]);
list.Add(category);
}
}
return list;
}
public static Category CreateModel(DataRow dr)
{
Category category = new Category();
if (dr.Table.Columns.Contains("Id"))
{
category.Id = LibConvert.ObjToInt64(dr["Id"]);
}
if (dr.Table.Columns.Contains("CategoryName"))
{
category.CategoryName = LibConvert.ObjToStr(dr["CategoryName"]);
}
if (dr.Table.Columns.Contains("Remark"))
{
category.Remark = LibConvert.ObjToStr(dr["Remark"]);
}
if (dr.Table.Columns.Contains("CreateTime"))
{
category.CreateTime = LibConvert.ObjToDateTime(dr["CreateTime"]);
}
return category;
}
