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