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

            strSql.Append("update Sys_DayCheckType set ");

            strSql.Append(" Check_Title = @Check_Title , ");
            strSql.Append(" Check_Describe = @Check_Describe , ");
            strSql.Append(" Check_Type = @Check_Type , ");
            strSql.Append(" Check_Priority = @Check_Priority , ");
            strSql.Append(" Check_ConditionStatus = @Check_ConditionStatus , ");
            strSql.Append(" Check_Condition = @Check_Condition  ");
            strSql.Append(" where id=@id ");

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

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

            strSql.Append("insert into Sys_DayCheckType(");
            strSql.Append("Check_Title,Check_Describe,Check_Type,Check_Priority,Check_ConditionStatus,Check_Condition");
            strSql.Append(") values (");
            strSql.Append("@Check_Title,@Check_Describe,@Check_Type,@Check_Priority,@Check_ConditionStatus,@Check_Condition");
            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_DayCheckType model)
        {
            Sys_DayCheckTypeBaseDAL dal = new Sys_DayCheckTypeBaseDAL();

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

            return(dal.Add(model));
        }