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