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