public bool UpdateEntity(Model.ManufacturerModel entity)
{
string sql = string.Format("update manufacturer set name='{0}',person='{1}',telephone='{2}',address={3},status={4} where ID={5}",
entity.Name, entity.Person, entity.Telphone, entity.Address, entity.Status, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
public Model.ManufacturerModel AddEntity(Model.ManufacturerModel entity)
{
string sql = string.Format(@"insert into manufacturer(name,person,telephone,address)
values({0},'{1}','{2}','{3}')", entity.Name, entity.Person, entity.Telphone, entity.Address);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public List <Model.ManufacturerModel> GetEntities(string sqlWhere)
{
string sql = string.Format("select * from manufacturer where 1=1 {0}", sqlWhere);
List <Model.ManufacturerModel> listManufacturer = new List <Model.ManufacturerModel>();
//Using 限定对象使用的范围在花括号里面，出了花括号后释放资源
using (SqlDataReader odr = MSSqlHelper.ExecuteReader(MSSqlHelper.ConStr, CommandType.Text, sql, null))
{
while (odr.Read())
{
Model.ManufacturerModel manufacturer = new Model.ManufacturerModel();
manufacturer.ID = odr.GetInt32(0);
manufacturer.Name = odr.IsDBNull(1) ? "" : odr.GetString(1);
manufacturer.Person = odr.IsDBNull(2) ? "" : odr.GetString(2);
manufacturer.Telphone = odr.IsDBNull(3) ? "" : odr.GetString(3);
manufacturer.Address = odr.IsDBNull(4) ? "" : odr.GetString(4);
manufacturer.Status = odr.IsDBNull(5) ? "" : odr.GetString(5);
listManufacturer.Add(manufacturer);
}
}
return(listManufacturer);
}
