/// <summary> /// 更新一条数据 /// </summary> public bool Update(Sys_VisitSms model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_VisitSms set "); strSql.Append(" accid = @accid , "); strSql.Append(" phoneNum = @phoneNum , "); strSql.Append(" systype = @systype , "); strSql.Append(" smsContent = @smsContent , "); strSql.Append(" sendtime = @sendtime , "); strSql.Append(" sendStatus = @sendStatus , "); strSql.Append(" smsChannel = @smsChannel , "); strSql.Append(" priority = @priority , "); strSql.Append(" realCnt = @realCnt , "); strSql.Append(" recordVisit = @recordVisit , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" insertime = @insertime "); strSql.Append(" where id=@id "); int row = DapperHelper.Execute(strSql.ToString(), model); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 新增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Sys_VisitSms model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_VisitSms("); strSql.Append("accid,phoneNum,systype,smsContent,sendtime,sendStatus,smsChannel,priority,realCnt,recordVisit,Remark,insertime"); strSql.Append(") values ("); strSql.Append("@accid,@phoneNum,@systype,@smsContent,@sendtime,@sendStatus,@smsChannel,@priority,@realCnt,@recordVisit,@Remark,@insertime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model); if (obj != null) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Sys_VisitSms model) { Sys_VisitSmsBaseDAL dal = new Sys_VisitSmsBaseDAL(); return(dal.Update(model)); }
/// <summary> /// 新增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Add(Sys_VisitSms model) { Sys_VisitSmsBaseDAL dal = new Sys_VisitSmsBaseDAL(); return(dal.Add(model)); }