Example #1
0
        /// <summary>
        /// 暂停该值
        /// </summary>
        /// <param name="Id">自增id的值</param>
        /// <returns>暂停成功返回ture,否则返回false</returns>
        public static bool ShiPinPause(Entity.ShiPin info)
        {
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [ShiPin] SET IsPause = " + info.IsPause + "  WHERE Id =  " + info.Id);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
Example #2
0
 /// <summary>
 /// 调用存储过程增加一个
 /// </summary>
 /// <param name="info">实体对象</param>
 /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns>
 public static int ShiPinAdd(Entity.ShiPin info)
 {
     SqlParameter[] prams =
     {
         SqlDB.MakeInParam("@Title",    SqlDbType.NVarChar, 200, info.Title),
         SqlDB.MakeInParam("@Content",  SqlDbType.NText,      0, info.Content),
         SqlDB.MakeInParam("@Video",    SqlDbType.NText,      0, info.Video),
         SqlDB.MakeInParam("@TypeName", SqlDbType.NVarChar, 100, info.TypeName),
         SqlDB.MakeInParam("@TypeId",   SqlDbType.Int,        4, info.TypeId),
         SqlDB.MakeInParam("@AddTime",  SqlDbType.DateTime,   8, info.AddTime),
         SqlDB.MakeInParam("@IsPause",  SqlDbType.Int,        4, info.IsPause),
     };
     return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "ShiPinAdd", prams).ToString(), -1));
 }
Example #3
0
        /// <summary>
        /// 调用存储过程修改一个
        /// </summary>
        /// <param name="info">实体对象</param>
        /// <returns>更新成功返回ture,否则返回false</returns>
        public static bool ShiPinEdit(Entity.ShiPin info)
        {
            SqlParameter[] prams =
            {
                SqlDB.MakeInParam("@Id",       SqlDbType.Int,        4, info.Id),
                SqlDB.MakeInParam("@Title",    SqlDbType.NVarChar, 200, info.Title),
                SqlDB.MakeInParam("@Content",  SqlDbType.NText,      0, info.Content),
                SqlDB.MakeInParam("@Video",    SqlDbType.NText,      0, info.Video),
                SqlDB.MakeInParam("@TypeName", SqlDbType.NVarChar, 100, info.TypeName),
                SqlDB.MakeInParam("@TypeId",   SqlDbType.Int,        4, info.TypeId),
                SqlDB.MakeInParam("@AddTime",  SqlDbType.DateTime,   8, info.AddTime),
                SqlDB.MakeInParam("@IsPause",  SqlDbType.Int,        4, info.IsPause),
            };
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "ShiPinEdit", prams);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
Example #4
0
        /// <summary>
        /// 获取某一个实体
        /// </summary>
        /// <param name="Id">标识</param>
        /// <returns>返回Entity</returns>
        public static Entity.ShiPin ShiPinEntityGet(int Id)
        {
            Entity.ShiPin info = new Entity.ShiPin();
            DataTable     dt   = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [ShiPin] WHERE Id = " + Id + ";").Tables[0];

            if (dt.Rows.Count > 0)
            {
                info.Id       = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0);
                info.Title    = dt.Rows[0]["Title"].ToString();
                info.Content  = dt.Rows[0]["Content"].ToString();
                info.Video    = dt.Rows[0]["Video"].ToString();
                info.TypeName = dt.Rows[0]["TypeName"].ToString();
                info.TypeId   = Basic.Utils.StrToInt(dt.Rows[0]["TypeId"].ToString(), 0);
                info.IsPause  = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
                info.AddTime  = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString());
                return(info);
            }
            else
            {
                return(null);
            }
        }