示例#1
0
        /// <summary>
        /// 调用存储过程修改一个
        /// </summary>
        /// <param name="info">实体对象</param>
        /// <returns>更新成功返回ture,否则返回false</returns>
        public static bool Join_ProjectEditNew(Entity.Join_Project info)
        {
            SqlParameter[] prams =
            {
                SqlDB.MakeInParam("@ProjectId",     SqlDbType.Int,        4, info.ProjectId),
                SqlDB.MakeInParam("@ProjectName",   SqlDbType.NVarChar, 500, info.ProjectName),
                SqlDB.MakeInParam("@Content",       SqlDbType.NText,      0, info.Content),
                SqlDB.MakeInParam("@TopPCid",       SqlDbType.Int,        4, info.TopPCid),
                SqlDB.MakeInParam("@PCidList",      SqlDbType.NVarChar, 100, info.PCidList),
                SqlDB.MakeInParam("@PCid",          SqlDbType.Int,        4, info.PCid),
                SqlDB.MakeInParam("@ApplicantFile", SqlDbType.NVarChar, 500, info.ApplicantFile),
                SqlDB.MakeInParam("@IsValid",       SqlDbType.Int,        4, info.IsValid),
                SqlDB.MakeInParam("@IsPause",       SqlDbType.Int,        4, info.IsPause),
                SqlDB.MakeInParam("@AddTime",       SqlDbType.DateTime,   8, info.AddTime),
                SqlDB.MakeInParam("@IsCheck",       SqlDbType.Int,        4, info.IsCheck),
                SqlDB.MakeInParam("@IsHot",         SqlDbType.Int,        4, info.IsHot),
            };
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_ProjectEditNew", prams);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
示例#2
0
        /// <summary>
        /// 暂停该值
        /// </summary>
        /// <param name="ProjectId">自增id的值</param>
        /// <returns>暂停成功返回ture,否则返回false</returns>
        public static bool Join_ProjectPause(Entity.Join_Project info)
        {
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "UPDATE [Join_Project] SET IsPause = " + info.IsPause + "  WHERE ProjectId =  " + info.ProjectId);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
示例#3
0
 /// <summary>
 /// 调用存储过程增加一个
 /// </summary>
 /// <param name="info">实体对象</param>
 /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns>
 public static int Join_ProjectAdd(Entity.Join_Project info)
 {
     SqlParameter[] prams =
     {
         SqlDB.MakeInParam("@ProjectName",   SqlDbType.NVarChar, 1000, info.ProjectName),
         SqlDB.MakeInParam("@Content",       SqlDbType.NText,       0, info.Content),
         SqlDB.MakeInParam("@PCid",          SqlDbType.Int,         4, info.PCid),
         SqlDB.MakeInParam("@ApplicantFile", SqlDbType.NVarChar,  500, info.ApplicantFile),
     };
     return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_ProjectAdd", prams).ToString(), -1));
 }
示例#4
0
        /// <summary>
        /// 获取某一个实体
        /// </summary>
        /// <param name="ProjectId">标识</param>
        /// <returns>返回Entity</returns>
        public static Entity.Join_Project Join_ProjectEntityGet(int ProjectId)
        {
            Entity.Join_Project info = new Entity.Join_Project();
            DataTable           dt   = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [Join_Project] WHERE ProjectId = " + ProjectId + ";").Tables[0];

            if (dt.Rows.Count > 0)
            {
                info.ProjectId     = Basic.Utils.StrToInt(dt.Rows[0]["ProjectId"].ToString(), 0);
                info.ProjectName   = dt.Rows[0]["ProjectName"].ToString();
                info.Content       = dt.Rows[0]["Content"].ToString();
                info.TopPCid       = Basic.Utils.StrToInt(dt.Rows[0]["TopPCid"].ToString(), 0);
                info.PCidList      = dt.Rows[0]["PCidList"].ToString();
                info.PCid          = Basic.Utils.StrToInt(dt.Rows[0]["PCid"].ToString(), 0);
                info.ApplicantFile = dt.Rows[0]["ApplicantFile"].ToString();
                info.IsValid       = Basic.Utils.StrToInt(dt.Rows[0]["IsValid"].ToString(), 0);
                info.IsPause       = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
                info.IsCheck       = Basic.Utils.StrToInt(dt.Rows[0]["IsCheck"].ToString(), 0);
                info.IsHot         = Basic.Utils.StrToInt(dt.Rows[0]["IsHot"].ToString(), 0);
                info.AddTime       = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString());
            }
            return(info);
        }