/// <summary>
/// 向lmShop_CostReportAmount表插入一条数据，返回自增列数值，插入不成功则返回-1
/// </summary>
/// <param name="lmShopCostReportAmount">CostReportAmountInfo</param>
/// <returns></returns>
public bool AddlmShop_CostReportAmount(CostReportAmountInfo lmShopCostReportAmount)
{
string sql = "insert into [lmShop_CostReportAmount]([AmountId],[ReportId],[Num],[Amount],[IsPay],[IsSystem])values(@AmountId,@ReportId,@Num,@Amount,@IsPay,@IsSystem) select @@identity";
SqlParameter[] paras = PrepareCommandParameters(lmShopCostReportAmount);
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql, paras) > 0);
}
/// <summary>
/// 根据lmShop_CostReportAmount表的AmountId字段更新数据
/// </summary>
/// <param name="lmShopCostReportAmount">lmShopCostReportAmount</param>
/// <returns></returns>
public int UpdatelmShop_CostReportAmountByAmountId(CostReportAmountInfo lmShopCostReportAmount)
{
string sql = "update [lmShop_CostReportAmount] set [ReportId] = @ReportId,[Num] = @Num,[Amount] = @Amount,[IsPay] = @IsPay,[IsSystem]=@IsSystem where [AmountId] = @AmountId";
SqlParameter[] paras = PrepareCommandParameters(lmShopCostReportAmount);
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql, paras));
}
/// <summary>
/// prepare parameters
/// </summary>
public SqlParameter[] PrepareCommandParameters(CostReportAmountInfo lmShopCostReportAmount)
{
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@AmountId", lmShopCostReportAmount.AmountId),
new SqlParameter("@ReportId", lmShopCostReportAmount.ReportId),
new SqlParameter("@Num", lmShopCostReportAmount.Num),
new SqlParameter("@Amount", lmShopCostReportAmount.Amount),
new SqlParameter("@IsPay", lmShopCostReportAmount.IsPay),
new SqlParameter("@IsSystem", lmShopCostReportAmount.IsSystem)
};
return(paras);
}
/// <summary>
/// 返回lmShop_CostReportAmount表的所有数据
/// </summary>
/// <returns></returns>
public List <CostReportAmountInfo> GetAlllmShop_CostReportAmount()
{
List <CostReportAmountInfo> lmShopCostReportAmountList = new List <CostReportAmountInfo>();
IDataReader reader = null;
string sql = SQL_SELECT;
reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, null);
while (reader.Read())
{
CostReportAmountInfo lmShopCostReportAmount = new CostReportAmountInfo(reader);
lmShopCostReportAmountList.Add(lmShopCostReportAmount);
}
reader.Close();
return(lmShopCostReportAmountList);
}
/// <summary>
/// 根据lmShop_CostReportAmount表的AmountId字段返回数据
/// </summary>
/// <param name="amountId">AmountId</param>
/// <returns></returns>
public CostReportAmountInfo GetlmShop_CostReportAmountByAmountId(Guid amountId)
{
CostReportAmountInfo lmShopCostReportAmount = null;
IDataReader reader = null;
string sql = SQL_SELECT + "where [AmountId] = @AmountId";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@AmountId", amountId)
};
reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, paras);
if (reader.Read())
{
lmShopCostReportAmount = new CostReportAmountInfo(reader);
}
reader.Close();
return(lmShopCostReportAmount);
}
/// <summary>
/// 根据ReportId返回lmShop_CostReportAmount表的数据
/// </summary>
/// <returns></returns>
public List <CostReportAmountInfo> GetmShop_CostReportAmountByReportId(Guid reportId)
{
List <CostReportAmountInfo> lmShopCostReportAmountList = new List <CostReportAmountInfo>();
string sql = SQL_SELECT + "where [ReportId] = @ReportId";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@ReportId", reportId)
};
var reader = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql, paras);
while (reader.Read())
{
CostReportAmountInfo lmShopCostReportAmount = new CostReportAmountInfo(reader);
lmShopCostReportAmountList.Add(lmShopCostReportAmount);
}
reader.Close();
return(lmShopCostReportAmountList);
}
