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);
}
