public override int Delete() { if (dataGridView1.CurrentCell == null) { MessageBox.Show("请选择要编辑的行"); return(0); } if (dataGridView1.CurrentRow.Cells["id"].Value == null && dataGridView1.CurrentRow.Cells["id"].Value.ToString() == "") { return(0); } FishEntity.ReductionClauseEntity entity = new FishEntity.ReductionClauseEntity(); entity.id = int.Parse(dataGridView1.CurrentRow.Cells["id"].Value.ToString()); if (entity == null) { MessageBox.Show("请选择需要编辑的行"); return(0); } result = _bll.Delete(entity.id); if (result) { MessageBox.Show("成功删除"); dataGridView1.Rows.RemoveAt(selectIdx); dataGridView1.Refresh(); } else { MessageBox.Show("删除失败"); } return(base.Delete()); }
void Add(Hashtable SQLString, StringBuilder strSql, FishEntity.ReductionClauseEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into t_reductionclause("); strSql.Append("proName,country,brand,speci,ratio,priceMY,priceBase,priceDiff,exRate,priceRMB,codeNum)"); strSql.Append(" values ("); strSql.Append("@proName,@country,@brand,@speci,@ratio,@priceMY,@priceBase,@priceDiff,@exRate,@priceRMB,@codeNum)"); MySqlParameter [] parameters = { new MySqlParameter("@proName", MySqlDbType.VarChar, 45), new MySqlParameter("@country", MySqlDbType.VarChar, 45), new MySqlParameter("@brand", MySqlDbType.VarChar, 45), new MySqlParameter("@speci", MySqlDbType.Bit), new MySqlParameter("@ratio", MySqlDbType.VarChar, 45), new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18), new MySqlParameter("@priceBase", MySqlDbType.Bit), new MySqlParameter("@priceDiff", MySqlDbType.Decimal, 18), new MySqlParameter("@exRate", MySqlDbType.Decimal, 18), new MySqlParameter("@priceRMB", MySqlDbType.Decimal, 18), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45) }; parameters [0].Value = model.proName; parameters [1].Value = model.country; parameters [2].Value = model.brand; parameters [3].Value = model.speci; parameters [4].Value = model.ratio; parameters [5].Value = model.priceMY; parameters [6].Value = model.priceBase; parameters [7].Value = model.priceDiff; parameters [8].Value = model.exRate; parameters [9].Value = model.priceRMB; parameters [10].Value = model.codeNum; SQLString.Add(strSql, parameters); }
void Edit(Hashtable SQLString, StringBuilder strSql, FishEntity.ReductionClauseEntity model) { strSql = new StringBuilder( ); strSql.Append("update t_reductionclause set "); strSql.Append("proName=@proName,"); strSql.Append("country=@country,"); strSql.Append("brand=@brand,"); strSql.Append("speci=@speci,"); strSql.Append("ratio=@ratio,"); strSql.Append("priceMY=@priceMY,"); strSql.Append("priceBase=@priceBase,"); strSql.Append("priceDiff=@priceDiff,"); strSql.Append("exRate=@exRate,"); strSql.Append("priceRMB=@priceRMB,"); strSql.Append("codeNum=@codeNum"); strSql.Append(" where id=@id "); MySqlParameter [] parameters = { new MySqlParameter("@proName", MySqlDbType.VarChar, 45), new MySqlParameter("@country", MySqlDbType.VarChar, 45), new MySqlParameter("@brand", MySqlDbType.VarChar, 45), new MySqlParameter("@speci", MySqlDbType.Bit), new MySqlParameter("@ratio", MySqlDbType.VarChar, 45), new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18), new MySqlParameter("@priceBase", MySqlDbType.Bit), new MySqlParameter("@priceDiff", MySqlDbType.Decimal, 18), new MySqlParameter("@exRate", MySqlDbType.Decimal, 18), new MySqlParameter("@priceRMB", MySqlDbType.Decimal, 18), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters [0].Value = model.proName; parameters [1].Value = model.country; parameters [2].Value = model.brand; parameters [3].Value = model.speci; parameters [4].Value = model.ratio; parameters [5].Value = model.priceMY; parameters [6].Value = model.priceBase; parameters [7].Value = model.priceDiff; parameters [8].Value = model.exRate; parameters [9].Value = model.priceRMB; parameters [10].Value = model.codeNum; parameters [11].Value = model.id; SQLString.Add(strSql, parameters); }
public FormReductionClause(string purNum) { InitializeComponent(); ReadColumnConfig(dataGridView1, "Set_138"); model = new FishEntity.ReductionClauseEntity(); _bll = new FishBll.Bll.ReductionClauseBll(); InitDataUtil.BindComboBoxData(brand, FishEntity.Constant.Specification, true); InitDataUtil.BindComboBoxData(proName, FishEntity.Constant.Goods, true); InitDataUtil.BindComboBoxData(country, FishEntity.Constant.CountryType, true); getcode = purNum; if (!string.IsNullOrEmpty(purNum)) { strWhere += " AND codeNum='" + purNum + "'"; } Query(); }
public FishEntity.ReductionClauseEntity getModel(DataRow row) { FishEntity.ReductionClauseEntity model = new FishEntity.ReductionClauseEntity( ); if (row != null) { if (row ["id"] != null && row ["id"].ToString( ) != "") { model.id = int.Parse(row ["id"].ToString( )); } if (row ["proName"] != null) { model.proName = row ["proName"].ToString( ); } if (row ["country"] != null) { model.country = row ["country"].ToString( ); } if (row ["brand"] != null) { model.brand = row ["brand"].ToString( ); } if (row ["speci"] != null && row ["speci"].ToString( ) != "") { if ((row ["speci"].ToString( ) == "1") || (row ["speci"].ToString( ).ToLower( ) == "true")) { model.speci = true; } else { model.speci = false; } } if (row ["ratio"] != null) { model.ratio = row ["ratio"].ToString( ); } if (row ["priceMY"] != null && row ["priceMY"].ToString( ) != "") { model.priceMY = decimal.Parse(row ["priceMY"].ToString( )); } if (row ["priceBase"] != null && row ["priceBase"].ToString( ) != "") { if ((row ["priceBase"].ToString( ) == "1") || (row ["priceBase"].ToString( ).ToLower( ) == "true")) { model.priceBase = true; } else { model.priceBase = false; } } if (row ["priceDiff"] != null && row ["priceDiff"].ToString( ) != "") { model.priceDiff = decimal.Parse(row ["priceDiff"].ToString( )); } if (row ["exRate"] != null && row ["exRate"].ToString( ) != "") { model.exRate = decimal.Parse(row ["exRate"].ToString( )); } if (row ["priceRMB"] != null && row ["priceRMB"].ToString( ) != "") { model.priceRMB = decimal.Parse(row ["priceRMB"].ToString( )); } if (row ["codeNum"] != null) { model.codeNum = row ["codeNum"].ToString( ); } } return(model); }