Beispiel #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Sys_DayCheckLog model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Sys_DayCheckLog set ");

            strSql.Append(" Check_Type = @Check_Type , ");
            strSql.Append(" Check_Status = @Check_Status , ");
            strSql.Append(" Check_Contnet = @Check_Contnet , ");
            strSql.Append(" Check_User = @Check_User , ");
            strSql.Append(" Check_DateTime = @Check_DateTime , ");
            strSql.Append(" Check_IP = @Check_IP , ");
            strSql.Append(" Check_Client = @Check_Client  ");
            strSql.Append(" where id=@id ");

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

            if (row > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #2
0
        /// <summary>
        /// 新增加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(Sys_DayCheckLog model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Sys_DayCheckLog(");
            strSql.Append("Check_Type,Check_Status,Check_Contnet,Check_User,Check_DateTime,Check_IP,Check_Client");
            strSql.Append(") values (");
            strSql.Append("@Check_Type,@Check_Status,@Check_Contnet,@Check_User,@Check_DateTime,@Check_IP,@Check_Client");
            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_DayCheckLog model)
        {
            Sys_DayCheckLogBaseDAL dal = new Sys_DayCheckLogBaseDAL();

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

            return(dal.Add(model));
        }