//查询私有公共方法：所有字段
private List <EOfficeGoodsInfo> CommQueryOfficeGoodsInfos(string sql)
{
List <EOfficeGoodsInfo> elist = new List <EOfficeGoodsInfo>();
SqlDataReader dr = DBHelper.GetReader(sql);
while (dr.Read())
{
EOfficeGoodsInfo entity = new EOfficeGoodsInfo();
entity.GoodID = Convert.ToString(dr["GoodID"]);
entity.GoodName = Convert.ToString(dr["GoodName"]);
elist.Add(entity);
}
return(elist);
}
//根据主键更新数据
public bool UpdateOfficeGoodsInfo(EOfficeGoodsInfo entity)
{
string sql = string.Format("UPDATE OfficeGoodsInfo SET GoodName='{1}' WHERE GoodID='{0}'", entity.GoodID, entity.GoodName);
return(DBHelper.UpdateOpera(sql));
}
//插入所有数据
public bool InsertOfficeGoodsInfo(EOfficeGoodsInfo entity)
{
string sql = string.Format("INSERT INTO OfficeGoodsInfo(GoodID,GoodName) VALUES('{0}','{1}')", entity.GoodID, entity.GoodName);
return(DBHelper.UpdateOpera(sql));
}
//根据主键更新数据
public static bool UpdateOfficeGoodsInfo(EOfficeGoodsInfo entity)
{
return(svr.UpdateOfficeGoodsInfo(entity));
}
//插入所有字段
public static bool InsertOfficeGoodsInfo(EOfficeGoodsInfo entity)
{
return(svr.InsertOfficeGoodsInfo(entity));
}
