コード例 #1
0
        public int UpdateTbl_InfoById(Tbl_Info tbl_info)
        {
            string sql = "update [Tbl_Info] set [UserName]=@UserName,[ClassID]=@ClassID,[I_Title]=@I_Title,[I_Keyword]=@I_Keyword,[I_Description]=@I_Description,[I_Content]=@I_Content,[I_Pic]=@I_Pic,[I_File]=@I_File,[I_Type]=@I_Type,[OrderNum]=@OrderNum,[UserNameTo]=@UserNameTo,[NodeStatus]=@NodeStatus,[NodeUser]=@NodeUser,[Status]=@Status,[DealTime]=@DealTime where DealFlag=0 and [ID]=@ID";

            SqlParameter[] sp = new SqlParameter[]
            {
                new SqlParameter("@UserName", tbl_info.UserName),
                new SqlParameter("@ClassID", tbl_info.ClassID),
                new SqlParameter("@I_Title", tbl_info.I_Title),
                new SqlParameter("@I_Keyword", tbl_info.I_Keyword),
                new SqlParameter("@I_Description", tbl_info.I_Description),
                new SqlParameter("@I_Content", tbl_info.I_Content),
                new SqlParameter("@I_Pic", tbl_info.I_Pic),
                new SqlParameter("@I_File", tbl_info.I_File),
                new SqlParameter("@I_Type", tbl_info.I_Type),
                new SqlParameter("@OrderNum", tbl_info.OrderNum),
                new SqlParameter("@UserNameTo", tbl_info.UserNameTo),
                new SqlParameter("@NodeStatus", tbl_info.NodeStatus),
                new SqlParameter("@NodeUser", tbl_info.NodeUser),
                new SqlParameter("@Status", tbl_info.Status),
                new SqlParameter("@DealUser", tbl_info.DealUser),
                new SqlParameter("@DealTime", tbl_info.DealTime.ToString()),
                new SqlParameter("@ID", tbl_info.ID)
            };
            return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
        }
コード例 #2
0
        /// <summary>
        ///根据SQL语句返回集合
        /// </summary>
        private IList <Tbl_Info> getTbl_InfosBySql(string sql)
        {
            IList <Tbl_Info> list = new List <Tbl_Info>();
            DataSet          ds   = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);

            if (ds.Tables.Count > 0)
            {
                DataTable dt = ds.Tables[0];
                foreach (DataRow dr in dt.Rows)
                {
                    Tbl_Info tbl_info = new Tbl_Info();
                    tbl_info.ID            = Convert.ToInt32(dr["ID"]);
                    tbl_info.UserName      = Convert.ToString(dr["UserName"]);
                    tbl_info.ClassID       = Convert.ToString(dr["ClassID"]);
                    tbl_info.I_Title       = Convert.ToString(dr["I_Title"]);
                    tbl_info.I_Keyword     = Convert.ToString(dr["I_Keyword"]);
                    tbl_info.I_Description = Convert.ToString(dr["I_Description"]);
                    tbl_info.I_Content     = Convert.ToString(dr["I_Content"]);
                    tbl_info.I_Pic         = Convert.ToString(dr["I_Pic"]);
                    tbl_info.I_File        = Convert.ToString(dr["I_File"]);
                    tbl_info.I_Type        = Convert.ToString(dr["I_Type"]);
                    tbl_info.OrderNum      = Convert.ToInt32(dr["OrderNum"]);
                    tbl_info.UserNameTo    = Convert.ToString(dr["UserNameTo"]);
                    tbl_info.NodeStatus    = Convert.ToString(dr["NodeStatus"]);
                    tbl_info.NodeUser      = Convert.ToString(dr["NodeUser"]);
                    tbl_info.Status        = Convert.ToString(dr["Status"]);
                    tbl_info.DealFlag      = Convert.ToInt32(dr["DealFlag"]);
                    tbl_info.DealUser      = Convert.ToString(dr["DealUser"]);
                    tbl_info.DealTime      = Convert.ToDateTime(dr["DealTime"]);
                    tbl_info.AddDate       = Convert.ToDateTime(dr["AddDate"]);
                    list.Add(tbl_info);
                }
            }
            return(list);
        }
コード例 #3
0
        public static int AddTbl_Info(Tbl_Info tbl_info)
        {
            WebCommon.Public.WriteLog("添加信息:" + tbl_info.I_Title);
            int InfoID = new Tbl_InfoService().AddTbl_Info(tbl_info);

            foreach (var obj in tbl_info.NodeUser.Split(','))
            {
                WebCommon.Public.WriteAlert(obj, "待审信息", tbl_info.I_Title, "views/Info_Detail.aspx?ID=" + InfoID.ToString());
            }
            return(InfoID);
        }
コード例 #4
0
        public static int UpdateTbl_Info(Tbl_Info tbl_info)
        {
            WebCommon.Public.WriteLog("修改信息:" + tbl_info.I_Title);
            tbl_info.DealUser = WebCommon.Public.GetUserName();
            tbl_info.DealTime = DateTime.Now;
            int InfoID = new Tbl_InfoService().UpdateTbl_InfoById(tbl_info);

            if (tbl_info.Status == "已审核")
            {
                foreach (var obj in tbl_info.UserNameTo.Split(','))
                {
                    WebCommon.Public.WriteAlert(obj, tbl_info.I_Type, tbl_info.I_Title, "views/Info_Detail.aspx?ID=" + tbl_info.ID.ToString());
                }
            }
            return(InfoID);
        }
コード例 #5
0
        public int AddTbl_Info(Tbl_Info tbl_info)
        {
            string sql = "insert into [Tbl_Info] ([UserName],[ClassID],[I_Title],[I_Keyword],[I_Description],[I_Content],[I_Pic],[I_File],[I_Type],[OrderNum],[UserNameTo],[NodeStatus],[NodeUser],[Status],[DealUser]) values (@UserName,@ClassID,@I_Title,@I_Keyword,@I_Description,@I_Content,@I_Pic,@I_File,@I_Type,@OrderNum,@UserNameTo,@NodeStatus,@NodeUser,@Status,@DealUser)";

            SqlParameter[] sp = new SqlParameter[]
            {
                new SqlParameter("@UserName", tbl_info.UserName),
                new SqlParameter("@ClassID", tbl_info.ClassID),
                new SqlParameter("@I_Title", tbl_info.I_Title),
                new SqlParameter("@I_Keyword", tbl_info.I_Keyword),
                new SqlParameter("@I_Description", tbl_info.I_Description),
                new SqlParameter("@I_Content", tbl_info.I_Content),
                new SqlParameter("@I_Pic", tbl_info.I_Pic),
                new SqlParameter("@I_File", tbl_info.I_File),
                new SqlParameter("@I_Type", tbl_info.I_Type),
                new SqlParameter("@OrderNum", tbl_info.OrderNum),
                new SqlParameter("@UserNameTo", tbl_info.UserNameTo),
                new SqlParameter("@NodeStatus", tbl_info.NodeStatus),
                new SqlParameter("@NodeUser", tbl_info.NodeUser),
                new SqlParameter("@Status", tbl_info.Status),
                new SqlParameter("@DealUser", tbl_info.DealUser)
            };
            return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
        }