/// <summary>
/// 向GoodsPriceChange表插入一条数据，返回自增列数值，插入不成功则返回-1
/// </summary>
/// <param name="goodsPriceChange">GoodsPriceChange</param>
/// <returns></returns>
public bool AddGoodsPriceChange(GoodsPriceChange goodsPriceChange)
{
string sql = "insert into [GoodsPriceChange]([Id],[Name],[Datetime],[GoodsId],[GoodsName],[GoodsCode],[SaleFilialeId],[SaleFilialeName],[SalePlatformId],[SalePlatformName],[OldPrice],[NewPrice],[Quota],[Type])values(@Id,@Name,@Datetime,@GoodsId,@GoodsName,@GoodsCode,@SaleFilialeId,@SaleFilialeName,@SalePlatformId,@SalePlatformName,@OldPrice,@NewPrice,@Quota,@Type)";
SqlParameter[] paras = PrepareCommandParameters(goodsPriceChange);
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql, paras) > 0);
}
/// <summary>
/// 根据GoodsPriceChange表的Id字段更新数据
/// </summary>
/// <param name="goodsPriceChange">goodsPriceChange</param>
/// <returns></returns>
public bool UpdateGoodsPriceChangeById(GoodsPriceChange goodsPriceChange)
{
string sql = "update [GoodsPriceChange] set [Name] = @Name,[Datetime] = @Datetime,[GoodsId]=@GoodsId,[GoodsName] = @GoodsName,[GoodsCode] = @GoodsCode,[SaleFilialeId] = @SaleFilialeId,[SaleFilialeName] = @SaleFilialeName,[SalePlatformId] = @SalePlatformId,[SalePlatformName] = @SalePlatformName,[OldPrice] = @OldPrice,[NewPrice] = @NewPrice,[Quota] = @Quota,[Type] = @Type where [Id] = @Id";
SqlParameter[] paras = PrepareCommandParameters(goodsPriceChange);
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql, paras) > 0);
}
/// <summary>
/// 返回GoodsPriceChange表的所有数据
/// </summary>
/// <returns></returns>
public List <GoodsPriceChange> GetAllGoodsPriceChange()
{
List <GoodsPriceChange> goodsPriceChangeList = new List <GoodsPriceChange>();
string sql = SQL_SELECT;
var reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, null);
while (reader.Read())
{
GoodsPriceChange goodsPriceChange = new GoodsPriceChange(reader);
goodsPriceChangeList.Add(goodsPriceChange);
}
reader.Close();
return(goodsPriceChangeList);
}
/// <summary>
/// 根据GoodsPriceChange表的Id字段返回数据
/// </summary>
/// <param name="id">Id</param>
/// <returns></returns>
public GoodsPriceChange GetGoodsPriceChangeById(Guid id)
{
GoodsPriceChange goodsPriceChange = null;
IDataReader reader = null;
const string SQL = SQL_SELECT + "where [Id] = @Id";
SqlParameter[] paras =
{
new SqlParameter("@Id", id)
};
reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL, paras);
if (reader.Read())
{
goodsPriceChange = new GoodsPriceChange(reader);
}
reader.Close();
return(goodsPriceChange);
}
/// <summary>
/// prepare parameters
/// </summary>
public SqlParameter[] PrepareCommandParameters(GoodsPriceChange goodsPriceChange)
{
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Id", goodsPriceChange.Id),
new SqlParameter("@Name", goodsPriceChange.Name),
new SqlParameter("@Datetime", goodsPriceChange.Datetime),
new SqlParameter("@GoodsId", goodsPriceChange.GoodsId),
new SqlParameter("@GoodsName", goodsPriceChange.GoodsName),
new SqlParameter("@GoodsCode", goodsPriceChange.GoodsCode),
new SqlParameter("@SaleFilialeId", goodsPriceChange.SaleFilialeId),
new SqlParameter("@SaleFilialeName", goodsPriceChange.SaleFilialeName),
new SqlParameter("@SalePlatformId", goodsPriceChange.SalePlatformId),
new SqlParameter("@SalePlatformName", goodsPriceChange.SalePlatformName),
new SqlParameter("@OldPrice", goodsPriceChange.OldPrice),
new SqlParameter("@NewPrice", goodsPriceChange.NewPrice),
new SqlParameter("@Quota", goodsPriceChange.Quota),
new SqlParameter("@Type", goodsPriceChange.Type)
};
return(paras);
}
/// <summary>
/// 根据GoodsPriceChange表的Id字段更新数据
/// </summary>
/// <param name="goodsPriceChange">goodsPriceChange</param>
/// <returns>返回受影响的行数</returns>
public bool UpdateGoodsPriceChangeById(GoodsPriceChange goodsPriceChange)
{
return(_goodsPriceChange.UpdateGoodsPriceChangeById(goodsPriceChange));
}
/// <summary>
/// 向GoodsPriceChange表插入一条数据，插入成功则返回自增列数值，插入不成功则返回-1
/// </summary>
/// <param name="goodsPriceChange">GoodsPriceChange</param>
/// <returns></returns>
public bool AddGoodsPriceChange(GoodsPriceChange goodsPriceChange)
{
return(_goodsPriceChange.AddGoodsPriceChange(goodsPriceChange));
}
