public ActionResult EditInfo(Model.ChangingFlowerExpenses ChangingFlowerExpenses)
{
Business.Sys_ChangingFlowerExpenses Sys_ChangingFlowerExpenses = new Business.Sys_ChangingFlowerExpenses();
if (Sys_ChangingFlowerExpenses.UpdateChangingFlowerExpenses(ChangingFlowerExpenses))
{
return(Content("1"));
}
return(Content("0"));
}
public bool InsertChangingFlowerExpenses(Model.ChangingFlowerExpenses ChangingFlowerExpenses)
{
const string sql =
@"INSERT INTO ChangingFlowerExpenses(FlowerName,FlowerNUm,Number,CostPrice,SalePrice,ChangeAddress,ReplacementReason,replacementName,
ReplacementTelephone,ReplacementUnit) VALUES(@FlowerName,@FlowerNUm,@Number,@CostPrice,@SalePrice,@ChangeAddress,@ReplacementReason,
@replacementName,@ReplacementTelephone,@ReplacementUnit)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
ChangingFlowerExpenses.FlowerName,
ChangingFlowerExpenses.FlowerNUm,
ChangingFlowerExpenses.Number,
ChangingFlowerExpenses.CostPrice,
ChangingFlowerExpenses.SalePrice,
ChangingFlowerExpenses.ChangeAddress,
ChangingFlowerExpenses.ReplacementReason,
ChangingFlowerExpenses.replacementName,
ChangingFlowerExpenses.ReplacementTelephone,
ChangingFlowerExpenses.ReplacementUnit,
})));
}
public bool UpdateChangingFlowerExpenses(Model.ChangingFlowerExpenses ChangingFlowerExpenses)
{
const string sql =
@"UPDATE ChangingFlowerExpenses SET FlowerName=@FlowerName,FlowerNUm=@FlowerNUm,Number=@Number,CostPrice=@CostPrice,
SalePrice=@SalePrice,ChangeAddress=@ChangeAddress,ReplacementReason=@ReplacementReason,replacementName=@replacementName,
ReplacementTelephone=@ReplacementTelephone,ReplacementUnit=@ReplacementUnit WHERE ID=@ID";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
ChangingFlowerExpenses.FlowerName,
ChangingFlowerExpenses.FlowerNUm,
ChangingFlowerExpenses.Number,
ChangingFlowerExpenses.CostPrice,
ChangingFlowerExpenses.SalePrice,
ChangingFlowerExpenses.ChangeAddress,
ChangingFlowerExpenses.ReplacementReason,
ChangingFlowerExpenses.replacementName,
ChangingFlowerExpenses.ReplacementTelephone,
ChangingFlowerExpenses.ReplacementUnit,
ChangingFlowerExpenses.ID
})));
}
