public static List<Idea_Discussion> GetList(int idea_Id) { List<Idea_Discussion> list = new List<Idea_Discussion>(); Idea_Discussion model = null; string sql = "select * from PSS_Idea_Discussion where Idea_Disc_Idea_Id = " + idea_Id + " order by Idea_Disc_Time asc"; DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Idea_Discussion"); foreach (DataRow dr in ds.Tables["PSS_Idea_Discussion"].Rows) { model = new Idea_Discussion(); if (!string.IsNullOrEmpty(dr["Idea_Disc_Id"].ToString())) { model.Idea_Disc_Id = int.Parse(dr["Idea_Disc_Id"].ToString()); } if (!string.IsNullOrEmpty(dr["Idea_Disc_User_Id"].ToString())) { model.Idea_Disc_User_Id = int.Parse(dr["Idea_Disc_User_Id"].ToString()); } if (!string.IsNullOrEmpty(dr["Idea_Disc_Idea_Id"].ToString())) { model.Idea_Disc_Idea_Id = int.Parse(dr["Idea_Disc_Idea_Id"].ToString()); } model.Idea_Disc_Content = dr["Idea_Disc_Content"].ToString(); if (!string.IsNullOrEmpty(dr["Idea_Disc_Time"].ToString())) { model.Idea_Disc_Time = DateTime.Parse(dr["Idea_Disc_Time"].ToString()); model.Disc_Time = model.Idea_Disc_Time.ToString("dd/MM/yyyy HH:mm:ss"); } list.Add(model); }; return list; }
public static void Save(Idea_Discussion model) { string sql = "select * from PSS_Idea_Discussion where 1<>1"; DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Idea_Discussion"); DataRow dr = ds.Tables["PSS_Idea_Discussion"].NewRow(); int maxId = SqlHelper.GetMaxId("select max(Idea_Disc_Id) from PSS_Idea_Discussion"); dr["Idea_Disc_Id"] = ++maxId; dr["Idea_Disc_User_Id"] = model.Idea_Disc_User_Id; dr["Idea_Disc_Idea_Id"] = model.Idea_Disc_Idea_Id; dr["Idea_Disc_Time"] = model.Idea_Disc_Time; dr["Idea_Disc_Content"] = model.Idea_Disc_Content; ds.Tables["PSS_Idea_Discussion"].Rows.Add(dr); SqlHelper.UpdateDataSet(ds, sql, "PSS_Idea_Discussion"); if (ds != null) ds.Dispose(); }
public ContentResult IdeaDiscSave(Idea_Discussion model, int ideaId) { JsonDataGridResult jsonResult = new JsonDataGridResult(); try { Idea_Discussion ideaDisc = new Idea_Discussion(); ideaDisc.Idea_Disc_Idea_Id = ideaId; ideaDisc.Idea_Disc_Content = model.Idea_Disc_Content; ideaDisc.Idea_Disc_Time = DateTime.Now; ideaDisc.Idea_Disc_User_Id = Convert.ToInt32(User.Identity.Name.Split(',')[0]); IdeaDiscussionService.Save(ideaDisc); jsonResult.result = true; jsonResult.message = ""; } catch (Exception ex) { jsonResult.result = false; jsonResult.message = ex.Message; } string result = JsonConvert.SerializeObject(jsonResult); return Content(result); }