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