/// <summary> /// 更新一条数据 /// </summary> public bool Update(MultiColorPen.Model.commodity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update commodity set "); strSql.Append("name=?name,"); strSql.Append("number=?number,"); strSql.Append("count=?count,"); strSql.Append("price=?price,"); strSql.Append("type=?type,"); strSql.Append("mark=?mark,"); strSql.Append("unit=?unit,"); strSql.Append("is_del=?is_del,"); strSql.Append("special_supply=?special_supply"); strSql.Append(" where id=?id"); MySqlParameter[] parameters = { new MySqlParameter("?name", MySqlDbType.VarChar, 100), new MySqlParameter("?number", MySqlDbType.VarChar, 30), new MySqlParameter("?count", MySqlDbType.Int32, 11), new MySqlParameter("?price", MySqlDbType.Decimal, 10), new MySqlParameter("?type", MySqlDbType.VarChar, 10), new MySqlParameter("?mark", MySqlDbType.VarChar, 150), new MySqlParameter("?unit", MySqlDbType.VarChar, 10), new MySqlParameter("?is_del", MySqlDbType.VarChar, 2), new MySqlParameter("?special_supply", MySqlDbType.VarChar, 50), new MySqlParameter("?id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.name; parameters[1].Value = model.number; parameters[2].Value = model.count; parameters[3].Value = model.price; parameters[4].Value = model.type; parameters[5].Value = model.mark; parameters[6].Value = model.unit; parameters[7].Value = model.is_del; parameters[8].Value = model.special_supply; parameters[9].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MultiColorPen.Model.commodity DataRowToModel(DataRow row) { MultiColorPen.Model.commodity model = new MultiColorPen.Model.commodity(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["number"] != null) { model.number = row["number"].ToString(); } if (row["count"] != null && row["count"].ToString() != "") { model.count = int.Parse(row["count"].ToString()); } if (row["price"] != null && row["price"].ToString() != "") { model.price = decimal.Parse(row["price"].ToString()); } if (row["type"] != null) { model.type = row["type"].ToString(); } if (row["mark"] != null) { model.mark = row["mark"].ToString(); } if (row["unit"] != null) { model.unit = row["unit"].ToString(); } if (row["is_del"] != null) { model.is_del = row["is_del"].ToString(); } if (row["special_supply"] != null) { model.special_supply = row["special_supply"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MultiColorPen.Model.commodity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into commodity("); strSql.Append("name,number,count,price,type,mark,unit,is_del,special_supply)"); strSql.Append(" values ("); strSql.Append("?name,?number,?count,?price,?type,?mark,?unit,?is_del,?special_supply)"); MySqlParameter[] parameters = { new MySqlParameter("?name", MySqlDbType.VarChar, 100), new MySqlParameter("?number", MySqlDbType.VarChar, 30), new MySqlParameter("?count", MySqlDbType.Int32, 11), new MySqlParameter("?price", MySqlDbType.Decimal, 10), new MySqlParameter("?type", MySqlDbType.VarChar, 10), new MySqlParameter("?mark", MySqlDbType.VarChar, 150), new MySqlParameter("?unit", MySqlDbType.VarChar, 10), new MySqlParameter("?is_del", MySqlDbType.VarChar, 2), new MySqlParameter("?special_supply", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.name; parameters[1].Value = model.number; parameters[2].Value = model.count; parameters[3].Value = model.price; parameters[4].Value = model.type; parameters[5].Value = model.mark; parameters[6].Value = model.unit; parameters[7].Value = model.is_del; parameters[8].Value = model.special_supply; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MultiColorPen.Model.commodity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,number,count,price,type,mark,unit,is_del,special_supply from commodity "); strSql.Append(" where id=?id"); MySqlParameter[] parameters = { new MySqlParameter("?id", MySqlDbType.Int32) }; parameters[0].Value = id; MultiColorPen.Model.commodity model = new MultiColorPen.Model.commodity(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }