public bool insertStory(String user_id, String password, String title, String content)
        {
            int count = 0;

            Model.StoryModel sm = new Model.StoryModel();
            if (dbOperation.queryExistUser(user_id, password))
            {
                count = dbOperation.countStory(user_id);
                if (count != -1)
                {
                    string id = count.ToString();
                    while (id.Length < 5)
                    {
                        id = "0" + id;
                    }
                    id          = "S" + user_id.Substring(1) + id;
                    sm.user_id  = user_id;
                    sm.story_id = id;
                    sm.title    = title;
                    sm.content  = content;
                    if (dbOperation.insertStory(sm))
                    {
                        return(true);
                    }
                }
            }
            return(false);
        }
示例#2
0
        public bool insertStory(String user_id, String photo, String content)
        {
            int count = 0;

            Model.StoryModel sm = new Model.StoryModel();
            count = dbOperation.countStory(user_id);
            if (count != -1)
            {
                string id = count.ToString();
                while (id.Length < 5)
                {
                    id = "0" + id;
                }
                id = "S" + user_id.Substring(1) + id;
                Byte[] buffer = Convert.FromBase64String(photo);
                sm.user_id  = user_id;
                sm.story_id = id;
                sm.photo    = buffer;
                sm.content  = content;
                if (dbOperation.insertStory(sm))
                {
                    return(true);
                }
            }
            return(false);
        }
 public bool updateStoryState(String user_id, String password, String story_id, String state, String mshow)
 {
     if (dbOperation.queryExistUserStory(user_id, story_id, password))
     {
         Model.StoryModel sm = new Model.StoryModel();
         sm.user_id  = user_id;
         sm.story_id = story_id;
         sm.state    = state.ElementAt(0);
         sm.mshow    = mshow.ElementAt(0);
         return(dbOperation.updateStoryState(sm));
     }
     return(false);
 }
 public bool updateStory(String user_id, String password, String story_id, String title, String content)
 {
     if (dbOperation.queryExistUserStory(user_id, story_id, password))
     {
         Model.StoryModel sm = new Model.StoryModel();
         sm.user_id  = user_id;
         sm.story_id = story_id;
         sm.title    = title;
         sm.content  = content;
         return(dbOperation.updateStory(sm));
     }
     return(false);
 }
示例#5
0
        public List <Model.StoryModel> queryOneStory(String story_id)
        {
            List <Model.StoryModel> list = new List <Model.StoryModel>();

            try
            {
                string sql = "select story_id,user_id,title,content,state,mshow,edittime from story where story_id = '"
                             + story_id + "'";
                MySqlCommand     cmd    = new MySqlCommand(sql, sqlCon);
                MySqlDataReader  reader = cmd.ExecuteReader();
                Model.StoryModel sm     = null;
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        sm          = new StoryModel();
                        sm.story_id = reader[0].ToString();
                        sm.user_id  = reader[1].ToString();
                        sm.title    = reader[2].ToString();
                        sm.content  = reader[3].ToString();
                        sm.state    = reader[4].ToString().ElementAt(0);
                        sm.mshow    = reader[5].ToString().ElementAt(0);
                        string date = reader[6].ToString();
                        if (date != "")
                        {
                            sm.editTime = DateTime.Parse(date);
                        }

                        list.Add(sm);
                    }
                }
                reader.Close();
                cmd.Dispose();
            }
            catch (Exception e)
            {
            }
            return(list);
        }