/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.storagelocation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update storagelocation set "); strSql.Append("sl_store_type_id=@sl_store_type_id,"); strSql.Append("sl_store_min=@sl_store_min,"); strSql.Append("sl_store_max=@sl_store_max,"); strSql.Append("sl_store_area=@sl_store_area,"); strSql.Append("sl_comment=@sl_comment,"); strSql.Append("sl_remain_bulk=@sl_remain_bulk,"); strSql.Append("sl_belong_chest=@sl_belong_chest"); strSql.Append(" where sl_id=@sl_id"); MySqlParameter[] parameters = { new MySqlParameter("@sl_store_type_id", MySqlDbType.Int32, 32), new MySqlParameter("@sl_store_min", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_store_max", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_store_area", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_comment", MySqlDbType.VarChar, 255), new MySqlParameter("@sl_remain_bulk", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_belong_chest", MySqlDbType.Int32, 32), new MySqlParameter("@sl_id", MySqlDbType.Int32, 32) }; parameters[0].Value = model.sl_store_type_id; parameters[1].Value = model.sl_store_min; parameters[2].Value = model.sl_store_max; parameters[3].Value = model.sl_store_area; parameters[4].Value = model.sl_comment; parameters[5].Value = model.sl_remain_bulk; parameters[6].Value = model.sl_belong_chest; parameters[7].Value = model.sl_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.storagelocation DataRowToModel(DataRow row) { Model.storagelocation model = new Model.storagelocation(); if (row != null) { if (row["sl_id"] != null && row["sl_id"].ToString() != "") { model.sl_id = int.Parse(row["sl_id"].ToString()); } if (row["sl_store_type_id"] != null && row["sl_store_type_id"].ToString() != "") { model.sl_store_type_id = int.Parse(row["sl_store_type_id"].ToString()); } if (row["sl_store_min"] != null && row["sl_store_min"].ToString() != "") { model.sl_store_min = decimal.Parse(row["sl_store_min"].ToString()); } if (row["sl_store_max"] != null && row["sl_store_max"].ToString() != "") { model.sl_store_max = decimal.Parse(row["sl_store_max"].ToString()); } if (row["sl_store_area"] != null && row["sl_store_area"].ToString() != "") { model.sl_store_area = decimal.Parse(row["sl_store_area"].ToString()); } if (row["sl_comment"] != null) { model.sl_comment = row["sl_comment"].ToString(); } if (row["sl_remain_bulk"] != null && row["sl_remain_bulk"].ToString() != "") { model.sl_remain_bulk = decimal.Parse(row["sl_remain_bulk"].ToString()); } if (row["sl_belong_chest"] != null && row["sl_belong_chest"].ToString() != "") { model.sl_belong_chest = int.Parse(row["sl_belong_chest"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.storagelocation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into storagelocation("); strSql.Append("sl_store_type_id,sl_store_min,sl_store_max,sl_store_area,sl_comment,sl_remain_bulk,sl_belong_chest)"); strSql.Append(" values ("); strSql.Append("@sl_store_type_id,@sl_store_min,@sl_store_max,@sl_store_area,@sl_comment,@sl_remain_bulk,@sl_belong_chest)"); MySqlParameter[] parameters = { new MySqlParameter("@sl_store_type_id", MySqlDbType.Int32, 32), new MySqlParameter("@sl_store_min", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_store_max", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_store_area", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_comment", MySqlDbType.VarChar, 255), new MySqlParameter("@sl_remain_bulk", MySqlDbType.Decimal, 10), new MySqlParameter("@sl_belong_chest", MySqlDbType.Int32, 32) }; parameters[0].Value = model.sl_store_type_id; parameters[1].Value = model.sl_store_min; parameters[2].Value = model.sl_store_max; parameters[3].Value = model.sl_store_area; parameters[4].Value = model.sl_comment; parameters[5].Value = model.sl_remain_bulk; parameters[6].Value = model.sl_belong_chest; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.storagelocation GetModel(int sl_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select sl_id,sl_store_type_id,sl_store_min,sl_store_max,sl_store_area,sl_comment,sl_remain_bulk,sl_belong_chest from storagelocation "); strSql.Append(" where sl_id=@sl_id"); MySqlParameter[] parameters = { new MySqlParameter("@sl_id", MySqlDbType.Int32) }; parameters[0].Value = sl_id; Model.storagelocation model = new Model.storagelocation(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }