/// <summary>
/// 向GoodsInfoForGoodsDaySalesLogs表插入一条数据，返回自增列数值，插入不成功则返回-1
/// </summary>
/// <param name="goodsInfoForGoodsDaySalesLogs">GoodsInfoForGoodsDaySalesLogs</param>
/// <returns></returns>
public bool AddGoodsInfoForGoodsDaySalesLogs(GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs)
{
string sql = "insert into [GoodsInfoForGoodsDaySalesLogs]([Id],[GoodsId],[GoodsInfoValue],[Type],[State],[CreateTime])values(@Id,@GoodsId,@GoodsInfoValue,@Type,@State,@CreateTime)";
SqlParameter[] paras = PrepareCommandParameters(goodsInfoForGoodsDaySalesLogs);
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql, paras) > 0);
}
/// <summary>
/// 根据GoodsInfoForGoodsDaySalesLogs表的Id字段更新数据
/// </summary>
/// <param name="goodsInfoForGoodsDaySalesLogs">GoodsInfoForGoodsDaySalesLogs</param>
/// <returns></returns>
public bool UpdateGoodsInfoForGoodsDaySalesLogsById(GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs)
{
string sql = "update [GoodsInfoForGoodsDaySalesLogs] set [GoodsId] = @GoodsId,[GoodsInfoValue] = @GoodsInfoValue,[Type] = @Type,[State] = @State,[CreateTime] = @CreateTime where [Id] = @Id";
SqlParameter[] paras = PrepareCommandParameters(goodsInfoForGoodsDaySalesLogs);
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql, paras) > 0);
}
/// <summary>
/// prepare parameters
/// </summary>
public static SqlParameter[] PrepareCommandParameters(GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs)
{
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Id", goodsInfoForGoodsDaySalesLogs.Id),
new SqlParameter("@GoodsId", goodsInfoForGoodsDaySalesLogs.GoodsId),
new SqlParameter("@GoodsInfoValue", goodsInfoForGoodsDaySalesLogs.GoodsInfoValue),
new SqlParameter("@Type", goodsInfoForGoodsDaySalesLogs.Type),
new SqlParameter("@State", goodsInfoForGoodsDaySalesLogs.State),
new SqlParameter("@CreateTime", goodsInfoForGoodsDaySalesLogs.CreateTime)
};
return(paras);
}
/// <summary>
/// 返回GoodsInfoForGoodsDaySalesLogs表的所有数据
/// </summary>
/// <returns></returns>
public List <GoodsInfoForGoodsDaySalesLogs> GetAllGoodsInfoForGoodsDaySalesLogs()
{
List <GoodsInfoForGoodsDaySalesLogs> goodsInfoForGoodsDaySalesLogsList = new List <GoodsInfoForGoodsDaySalesLogs>();
string sql = SQL_SELECT;
var reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, null);
while (reader.Read())
{
GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs = new GoodsInfoForGoodsDaySalesLogs(reader);
goodsInfoForGoodsDaySalesLogsList.Add(goodsInfoForGoodsDaySalesLogs);
}
reader.Close();
return(goodsInfoForGoodsDaySalesLogsList);
}
/// <summary>
/// 根据GoodsInfoForGoodsDaySalesLogs表的Id字段返回数据
/// </summary>
/// <param name="id">Id</param>
/// <returns></returns>
public GoodsInfoForGoodsDaySalesLogs GetGoodsInfoForGoodsDaySalesLogsById(System.Guid id)
{
GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs = null;
string sql = SQL_SELECT + "where [Id] = @Id";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Id", id)
};
var reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, paras);
if (reader.Read())
{
goodsInfoForGoodsDaySalesLogs = new GoodsInfoForGoodsDaySalesLogs(reader);
}
reader.Close();
return(goodsInfoForGoodsDaySalesLogs);
}
/// <summary>
/// 根据GoodsInfoForGoodsDaySalesLogs表的goodsId、type、state字段返回数据
/// </summary>
/// <param name="goodsId"></param>
/// <param name="type">0:GoodsName(商品名称);1:GoodsCode(商品编码);2:BrandId(品牌id);3:ClassId(直属分类id)</param>
/// <param name="state">0:未处理;1:已处理;</param>
/// <returns></returns>
public GoodsInfoForGoodsDaySalesLogs GetGoodsInfoForGoodsDaySalesLogsByGoodsIdAndTypeAndState(Guid goodsId, int type, int state)
{
GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs = null;
string sql = SQL_SELECT + "where [GoodsId] = @GoodsId and [Type] = @Type and [State] = @State";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@GoodsId", goodsId),
new SqlParameter("@Type", type),
new SqlParameter("@State", state)
};
var reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, paras);
if (reader.Read())
{
goodsInfoForGoodsDaySalesLogs = new GoodsInfoForGoodsDaySalesLogs(reader);
}
reader.Close();
return(goodsInfoForGoodsDaySalesLogs);
}
/// <summary>
/// 向GoodsInfoForGoodsDaySalesLogs表插入一条数据，插入成功则返回自增列数值，插入不成功则返回-1
/// </summary>
/// <param name="goodsInfoForGoodsDaySalesLogs">GoodsInfoForGoodsDaySalesLogs</param>
/// <returns></returns>
public bool AddGoodsInfoForGoodsDaySalesLogs(GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs)
{
return(_goodsInfoForGoodsDaySalesLogsDal.AddGoodsInfoForGoodsDaySalesLogs(goodsInfoForGoodsDaySalesLogs));
}
/// <summary>
/// 根据GoodsInfoForGoodsDaySalesLogs表的Id字段更新数据
/// </summary>
/// <param name="goodsInfoForGoodsDaySalesLogs">goodsInfoForGoodsDaySalesLogs</param>
/// <returns>返回受影响的行数</returns>
public bool UpdateGoodsInfoForGoodsDaySalesLogsById(GoodsInfoForGoodsDaySalesLogs goodsInfoForGoodsDaySalesLogs)
{
return(_goodsInfoForGoodsDaySalesLogsDal.UpdateGoodsInfoForGoodsDaySalesLogsById(goodsInfoForGoodsDaySalesLogs));
}
