public bool SaveRevenueDataDapper(string act, int revenueId, string revenueYear, decimal revenueAmt, string remark) { RevenueDAL rvDAL = new RevenueDAL(dbRetail); var RevenueEntityRecord = new MyRevenueEntity(); RevenueEntityRecord.R_ID = revenueId; RevenueEntityRecord.R_YEAR = revenueYear; RevenueEntityRecord.REVENUE = revenueAmt; RevenueEntityRecord.REMARK = remark; RevenueEntityRecord.CREATE_DATE = DateTime.Now; bool rFlag = rvDAL.SaveRevenueDataDapper(act, RevenueEntityRecord); return(rFlag); }
//使用Dapper public bool SaveRevenueDataDapper(string act, MyRevenueEntity RevenueEntityRecord) { // 也可以傳入entity的集合, List<MyRevenueEntity> RevenueEntityRecords //List<MyRevenueEntity> RevenueEntityRecords = new List<MyRevenueEntity>(); try { StringBuilder sbSql = new StringBuilder(); if (act == "Add") { sbSql.Append(" insert into MY_REVENUE "); sbSql.Append(" (R_YEAR,REVENUE,REMARK,CREATE_DATE) "); sbSql.Append(" values "); sbSql.Append(" (@R_YEAR,@REVENUE,@REMARK,@CREATE_DATE) "); } else if (act == "Mod") { sbSql.Append(" update MY_REVENUE "); sbSql.Append(" set R_YEAR = @R_YEAR "); sbSql.Append(" , REVENUE = @REVENUE "); sbSql.Append(" , REMARK = @REMARK "); sbSql.Append(" where R_ID = @R_ID "); } else if (act == "Del") { sbSql.Append(" delete MY_REVENUE "); sbSql.Append(" where R_ID = @R_ID "); } //如果是一次多筆可以傳入List<Entity> //if (conn.Execute(sbSql.ToString(), RevenueEntityRecords) <= RevenueEntityRecords.Count) if (conn.Execute(sbSql.ToString(), RevenueEntityRecord) <= 0) { return(false); } return(true); } catch (Exception ex) { throw ex; } }