/// <summary>
/// 查询所有数据并返回数据集
/// </summary>
public static List <TbsusheInfo> GetTbsushe(string strWhere)
{
string sql = "select * from [Tbsushe]";
sql = (strWhere.Length > 0) ? sql += " where " + strWhere : sql;
DataTable dt = DBM.getTable(sql);
List <TbsusheInfo> list = new List <TbsusheInfo>();
foreach (DataRow dr in dt.Rows)
{
TbsusheInfo model = new TbsusheInfo();
model.Id = int.Parse(dr["Id"].ToString());
model.Ssname = dr["Ssname"].ToString();
model.Remark = dr["Remark"].ToString();
model.Pic = "Upload/" + dr["Pic"].ToString();
list.Add(model);
}
return(list);
}
///GetPK
/// <summary>
/// 根据数据表主键更新数据
/// </summary>
/// <param name="Tbsushe">数据表实体对象</param>
public static Exception Update(TbsusheInfo Tbsushe)
{
string sql = string.Format("update [Tbsushe] set[ssname]='{0}',[remark]='{1}',[pic]='{2}' where[id]='{3}'", Tbsushe.Ssname, Tbsushe.Remark, Tbsushe.Pic, Tbsushe.Id);
return(DBM.Execute(sql));
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Tbsushe">数据表实体对象</param>
public static Exception Add(TbsusheInfo Tbsushe)
{
string sql = string.Format("insert into [Tbsushe] values ('{0}','{1}','{2}')", Tbsushe.Ssname, Tbsushe.Remark, Tbsushe.Pic);
return(DBM.Execute(sql));
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="Tbsushe">数据表实体对象</param>
public static Exception Update(TbsusheInfo TbsusheInfo)
{
return(TbsusheDAL.Update(TbsusheInfo));
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Tbsushe">数据表实体对象</param>
public static Exception Add(TbsusheInfo TbsusheInfo)
{
return(TbsusheDAL.Add(TbsusheInfo));
}
