Esempio n. 1
0
        /// <summary>
        /// 新增加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(Sys_VisitEmailSnap model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Sys_VisitEmailSnap(");
            strSql.Append("accid,accountName,email,systype,emailTitle,emailContent,sendtime,sendStatus,emailChannel,priority,recordVisit,remark,insertime,EmailAisle,ContentTemplate,SendOk,SendNo,SendNumber");
            strSql.Append(") values (");
            strSql.Append("@accid,@accountName,@email,@systype,@emailTitle,@emailContent,@sendtime,@sendStatus,@emailChannel,@priority,@recordVisit,@remark,@insertime,@EmailAisle,@ContentTemplate,@SendOk,@SendNo,@SendNumber");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model);

            if (obj != null)
            {
                return(Convert.ToInt32(obj));
            }
            else
            {
                return(0);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Sys_VisitEmailSnap model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Sys_VisitEmailSnap set ");

            strSql.Append(" accid = @accid , ");
            strSql.Append(" accountName = @accountName , ");
            strSql.Append(" email = @email , ");
            strSql.Append(" systype = @systype , ");
            strSql.Append(" emailTitle = @emailTitle , ");
            strSql.Append(" emailContent = @emailContent , ");
            strSql.Append(" sendtime = @sendtime , ");
            strSql.Append(" sendStatus = @sendStatus , ");
            strSql.Append(" emailChannel = @emailChannel , ");
            strSql.Append(" priority = @priority , ");
            strSql.Append(" recordVisit = @recordVisit , ");
            strSql.Append(" remark = @remark , ");
            strSql.Append(" insertime = @insertime , ");
            strSql.Append(" EmailAisle = @EmailAisle , ");
            strSql.Append(" ContentTemplate = @ContentTemplate , ");
            strSql.Append(" SendOk = @SendOk , ");
            strSql.Append(" SendNo = @SendNo , ");
            strSql.Append(" SendNumber = @SendNumber  ");
            strSql.Append(" where id=@id ");

            int row = DapperHelper.Execute(strSql.ToString(), model);

            if (row > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public static bool Update(Sys_VisitEmailSnap model)
        {
            Sys_VisitEmailSnapBaseDAL dal = new Sys_VisitEmailSnapBaseDAL();

            return(dal.Update(model));
        }
        /// <summary>
        /// 新增加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static int Add(Sys_VisitEmailSnap model)
        {
            Sys_VisitEmailSnapBaseDAL dal = new Sys_VisitEmailSnapBaseDAL();

            return(dal.Add(model));
        }