/// <summary>
/// 查询所有数据并返回数据集
/// </summary>
public static List <TbruzhuInfo> GetTbruzhu(string strWhere)
{
string sql = "select * from [Tbruzhu]";
sql = (strWhere.Length > 0) ? sql += " where " + strWhere : sql;
DataTable dt = DBM.getTable(sql);
List <TbruzhuInfo> list = new List <TbruzhuInfo>();
foreach (DataRow dr in dt.Rows)
{
TbruzhuInfo model = new TbruzhuInfo();
model.Id = int.Parse(dr["Id"].ToString());
model.Chuangid = int.Parse(dr["Chuangid"].ToString());
model.Userid = int.Parse(dr["Userid"].ToString());
model.Ruzhudate = dr["Ruzhudate"].ToString();
model.Tuchudate = dr["Tuchudate"].ToString();
model.State = int.Parse(dr["State"].ToString());
list.Add(model);
}
return(list);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="Tbruzhu">数据表实体对象</param>
public static Exception Update(TbruzhuInfo TbruzhuInfo)
{
return(TbruzhuDAL.Update(TbruzhuInfo));
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Tbruzhu">数据表实体对象</param>
public static Exception Add(TbruzhuInfo TbruzhuInfo)
{
return(TbruzhuDAL.Add(TbruzhuInfo));
}
///GetPK
/// <summary>
/// 根据数据表主键更新数据
/// </summary>
/// <param name="Tbruzhu">数据表实体对象</param>
public static Exception Update(TbruzhuInfo Tbruzhu)
{
string sql = string.Format("update [Tbruzhu] set[chuangid]='{0}',[userid]='{1}',[ruzhudate]='{2}',[tuchudate]='{3}',[state]='{4}' where[id]='{5}'", Tbruzhu.Chuangid, Tbruzhu.Userid, Tbruzhu.Ruzhudate, Tbruzhu.Tuchudate, Tbruzhu.State, Tbruzhu.Id);
return(DBM.Execute(sql));
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Tbruzhu">数据表实体对象</param>
public static Exception Add(TbruzhuInfo Tbruzhu)
{
string sql = string.Format("insert into [Tbruzhu] values ('{0}','{1}','{2}','{3}','{4}')", Tbruzhu.Chuangid, Tbruzhu.Userid, Tbruzhu.Ruzhudate, Tbruzhu.Tuchudate, Tbruzhu.State);
return(DBM.Execute(sql));
}
