示例#1
0
 protected void pubbtn_Click(object sender, EventArgs e)
 {
     try
     {
         travel_record record = new travel_record();
         record.user_id       = 3;
         record.record_author = "11";
         record.record_title  = title.Text.Trim();
         record.record_cont   = "11";
         record.pub_time      = DateTime.Now.ToLocalTime();
         record.col_count     = 0;
         record.comt_count    = 0;
         record.like_count    = 0;
         record.record_cover  = "ww";
         int result = Travel_recordManager.InsertTravel_record(record);
         if (result >= 1)
         {
             Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('游记发表成功!');</script>");
         }
     }
     catch (Exception)
     {
         Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('发布失败!请仔细检查');</script>");
     }
 }
示例#2
0
        public int InsertTravel_record(travel_record travel_Record)
        {
            string sql = "insert into travel_record(user_id,record_author,record_title,record_cont,record_cover) values (@user_id,@record_author,@record_title,@record_cont,@record_cover)";

            SqlParameter[] para =
            {
                new SqlParameter("@user_id",       travel_Record.user_id),
                new SqlParameter("@record_author", travel_Record.record_author),
                new SqlParameter("@record_title",  travel_Record.record_title),
                new SqlParameter("@record_cont",   travel_Record.record_cont),
                new SqlParameter("@record_cover",  travel_Record.record_cover)
            };
            return(DBHelper.GetExcuteNonQuery(sql, para));
        }
示例#3
0
 public static int InsertTravel_record(travel_record travel_Record)
 {
     return(itravel_record.InsertTravel_record(travel_Record));
 }