/// <summary>
/// 更新紗價
/// </summary>
/// <param name="yarnPrice"></param>
/// <returns></returns>
public int EditYarnPrice(YarnPrice yarnPrice)
{
string sqlCmd = @"UPDATE [dbo].[YarnPrice]
SET [Ingredient] = @Ingredient
,[YarnCount] = @YarnCount
,[Color] = @Color
,[Price] = @Price
,[PiecePrice] = @PiecePrice
,[YarnMerchant] = @YarnMerchant
,[UpdateDate] = GETDATE()
WHERE [YarnPriceNo] = @YarnPriceNo";
int count = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, yarnPrice);
return(count);
}
/// <summary>
/// 新增紗價
/// </summary>
/// <param name="yarnPrice"></param>
/// <returns></returns>
public int InsertYarnPrice(YarnPrice yarnPrice)
{
string sqlCmd = @"INSERT INTO [dbo].[YarnPrice]
([YarnSpecificationNo]
,[YarnMerchant]
,[Brand]
,[Price]
,[PiecePrice])
VALUES
(@YarnSpecificationNo
,@YarnMerchant
,@Brand
,@Price
,@PiecePrice)";
int count = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, yarnPrice);
return(count);
}
/// <summary>
/// 更新紗價
/// </summary>
/// <param name="yarnPrice"></param>
/// <returns></returns>
public bool EditYarnPrice(YarnPrice yarnPrice)
{
int count = FabricAdapter.EditYarnPrice(yarnPrice);
return(count == 1);
}
/// <summary>
/// 新增紗價
/// </summary>
/// <param name="yarnPrice"></param>
/// <returns></returns>
public bool InsertYarnPrice(YarnPrice yarnPrice)
{
int count = FabricAdapter.InsertYarnPrice(yarnPrice);
return(count == 1);
}
