/// <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)); }