/// <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 bool Update(Model.material_info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update material_info set "); strSql.Append("mat_name=@mat_name,"); strSql.Append("mat_father_id=@mat_father_id,"); strSql.Append("mat_create_time=@mat_create_time,"); strSql.Append("mat_fengdu=@mat_fengdu,"); strSql.Append("mat_state=@mat_state,"); strSql.Append("mat_colour=@mat_colour,"); strSql.Append("mat_smell=@mat_smell,"); strSql.Append("mat_type=@mat_type,"); strSql.Append("mat_type_id=@mat_type_id,"); strSql.Append("mat_purpose=@mat_purpose,"); strSql.Append("mat_source=@mat_source,"); strSql.Append("mat_suanjianxing=@mat_suanjianxing,"); strSql.Append("mat_yuansuzhanbi=@mat_yuansuzhanbi,"); strSql.Append("mat_yuansuliang=@mat_yuansuliang"); strSql.Append(" where mat_id=@mat_id "); MySqlParameter[] parameters = { new MySqlParameter("@mat_name", MySqlDbType.VarChar, 32), new MySqlParameter("@mat_father_id", MySqlDbType.Int32, 11), new MySqlParameter("@mat_create_time", MySqlDbType.DateTime), new MySqlParameter("@mat_fengdu", MySqlDbType.Decimal, 16), new MySqlParameter("@mat_state", MySqlDbType.Int32, 10), new MySqlParameter("@mat_colour", MySqlDbType.Int32, 10), new MySqlParameter("@mat_smell", MySqlDbType.Int32, 10), new MySqlParameter("@mat_type", MySqlDbType.Int32, 10), new MySqlParameter("@mat_type_id", MySqlDbType.Int32, 32), new MySqlParameter("@mat_purpose", MySqlDbType.VarChar, 255), new MySqlParameter("@mat_source", MySqlDbType.VarChar, 255), new MySqlParameter("@mat_suanjianxing", MySqlDbType.VarChar, 255), new MySqlParameter("@mat_yuansuzhanbi", MySqlDbType.VarChar, 255), new MySqlParameter("@mat_yuansuliang", MySqlDbType.VarChar, 255), new MySqlParameter("@mat_id", MySqlDbType.Int32, 32) }; parameters[0].Value = model.mat_name; parameters[1].Value = model.mat_father_id; parameters[2].Value = model.mat_create_time; parameters[3].Value = model.mat_fengdu; parameters[4].Value = model.mat_state; parameters[5].Value = model.mat_colour; parameters[6].Value = model.mat_smell; parameters[7].Value = model.mat_type; parameters[8].Value = model.mat_type_id; parameters[9].Value = model.mat_purpose; parameters[10].Value = model.mat_source; parameters[11].Value = model.mat_suanjianxing; parameters[12].Value = model.mat_yuansuzhanbi; parameters[13].Value = model.mat_yuansuliang; parameters[14].Value = model.mat_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }