protected void btnDel_Click(object sender, EventArgs e) { if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0) { string strSelectID = "0"; for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++) { int rowIndex = grid1.SelectedRowIndexArray[i]; foreach (object key in grid1.DataKeys[rowIndex]) { strSelectID = key.ToString(); } } #region 除逻辑 zlzw.BLL.NewsListBLL newsListBLL = new zlzw.BLL.NewsListBLL(); zlzw.Model.NewsListModel newsListModel = newsListBLL.GetModel(int.Parse(strSelectID)); //DataTable dt = newsListBLL.GetList("NewsGUID='" + strSelectID + "'").Tables[0]; //zlzw.Model.NewsListModel newsListModel = newsListBLL.GetModel(int.Parse(dt.Rows[0]["NewsID"].ToString())); newsListModel.IsEnable = 0; newsListBLL.Update(newsListModel); NewsList_BindGrid(); #endregion } else { return; } }
private void LoadData(string strType) { if (strType == "1") { string strID = Request.QueryString["value"];//操作ID zlzw.BLL.NewsListBLL newsListBLL = new zlzw.BLL.NewsListBLL(); zlzw.Model.NewsListModel newsListModel = newsListBLL.GetModel(int.Parse(strID)); txbNewsTitle.Text = newsListModel.NewsTitle; //新闻标题 drpNewsType.SelectedValue = newsListModel.DictionaryKey; //新闻类型 txbNewsSummary.Text = newsListModel.NewsSummary; //新闻简介 FCKeditor1.Value = newsListModel.NewsContent; //新闻正文 if (newsListModel.IsHot == 1) { ckbIsHot.Checked = true; } else { ckbIsHot.Checked = false; } ViewState["PublishDate"] = newsListModel.PublishDate.ToString(); ViewState["NewsID"] = newsListModel.NewsID; ViewState["NewsGUID"] = newsListModel.NewsGUID; ToolbarText2.Text = "编辑新闻"; } btnClose.OnClientClick = ActiveWindow.GetConfirmHideReference(); }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.NewsListModel newsListModal = new zlzw.Model.NewsListModel(); newsListModal.NewsTitle = txbNewsTitle.Text; newsListModal.DictionaryKey = drpNewsType.SelectedValue; newsListModal.PublishUserGUID = new Guid(Request.Cookies["AdminID"].Value); newsListModal.IsEnable = 1; if (ckbIsHot.Checked) { newsListModal.IsHot = 1; } else { newsListModal.IsHot = 0; } newsListModal.NewsSummary = txbNewsSummary.Text; newsListModal.NewsContent = FCKeditor1.Value; newsListModal.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); newsListModal.NewsGUID = new Guid(ViewState["NewsGUID"].ToString()); newsListModal.NewsID = int.Parse(ViewState["NewsID"].ToString()); zlzw.BLL.NewsListBLL newsListBLL = new zlzw.BLL.NewsListBLL(); newsListBLL.Update(newsListModal); } else { //添加保存 zlzw.Model.NewsListModel newsListModal = new zlzw.Model.NewsListModel(); newsListModal.NewsTitle = txbNewsTitle.Text; newsListModal.DictionaryKey = drpNewsType.SelectedValue; newsListModal.PublishUserGUID = new Guid(Request.Cookies["AdminID"].Value); newsListModal.IsEnable = 1; if (ckbIsHot.Checked) { newsListModal.IsHot = 1; } else { newsListModal.IsHot = 0; } newsListModal.NewsSummary = txbNewsSummary.Text; newsListModal.NewsContent = FCKeditor1.Value; newsListModal.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); zlzw.BLL.NewsListBLL newsListBLL = new zlzw.BLL.NewsListBLL(); newsListBLL.Add(newsListModal); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.NewsListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@NewsID", SqlDbType.Int, 4), new SqlParameter("@NewsGUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@DictionaryKey", SqlDbType.NVarChar, 50), new SqlParameter("@NewsTitle", SqlDbType.NVarChar, 200), new SqlParameter("@NewsTag", SqlDbType.NVarChar, 50), new SqlParameter("@NewsSummary", SqlDbType.NVarChar), new SqlParameter("@NewsContent", SqlDbType.NVarChar), new SqlParameter("@NewsSource", SqlDbType.NVarChar, 50), new SqlParameter("@NewsSourceLink", SqlDbType.NVarChar, 200), new SqlParameter("@PublishUserGUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int, 4), new SqlParameter("@IsHot", SqlDbType.Int, 4), new SqlParameter("@ViewCount", SqlDbType.Int, 4), new SqlParameter("@Other01", SqlDbType.NVarChar, 50), new SqlParameter("@Other02", SqlDbType.NVarChar, 50), new SqlParameter("@Other03", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.NewsID; parameters[1].Value = model.NewsGUID; parameters[2].Value = model.DictionaryKey; parameters[3].Value = model.NewsTitle; parameters[4].Value = model.NewsTag; parameters[5].Value = model.NewsSummary; parameters[6].Value = model.NewsContent; parameters[7].Value = model.NewsSource; parameters[8].Value = model.NewsSourceLink; parameters[9].Value = model.PublishUserGUID; parameters[10].Value = model.PublishDate; parameters[11].Value = model.IsEnable; parameters[12].Value = model.IsHot; parameters[13].Value = model.ViewCount; parameters[14].Value = model.Other01; parameters[15].Value = model.Other02; parameters[16].Value = model.Other03; DbHelperSQL.RunProcedure("NewsList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public zlzw.Model.NewsListModel GetModel(int NewsID) { SqlParameter[] parameters = { new SqlParameter("@NewsID", SqlDbType.Int, 4) }; parameters[0].Value = NewsID; zlzw.Model.NewsListModel model = new zlzw.Model.NewsListModel(); DataSet ds = DbHelperSQL.RunProcedure("NewsList_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["NewsID"] != null && ds.Tables[0].Rows[0]["NewsID"].ToString() != "") { model.NewsID = int.Parse(ds.Tables[0].Rows[0]["NewsID"].ToString()); } if (ds.Tables[0].Rows[0]["NewsGUID"] != null && ds.Tables[0].Rows[0]["NewsGUID"].ToString() != "") { model.NewsGUID = new Guid(ds.Tables[0].Rows[0]["NewsGUID"].ToString()); } if (ds.Tables[0].Rows[0]["DictionaryKey"] != null && ds.Tables[0].Rows[0]["DictionaryKey"].ToString() != "") { model.DictionaryKey = ds.Tables[0].Rows[0]["DictionaryKey"].ToString(); } if (ds.Tables[0].Rows[0]["NewsTitle"] != null && ds.Tables[0].Rows[0]["NewsTitle"].ToString() != "") { model.NewsTitle = ds.Tables[0].Rows[0]["NewsTitle"].ToString(); } if (ds.Tables[0].Rows[0]["NewsTag"] != null && ds.Tables[0].Rows[0]["NewsTag"].ToString() != "") { model.NewsTag = ds.Tables[0].Rows[0]["NewsTag"].ToString(); } if (ds.Tables[0].Rows[0]["NewsSummary"] != null && ds.Tables[0].Rows[0]["NewsSummary"].ToString() != "") { model.NewsSummary = ds.Tables[0].Rows[0]["NewsSummary"].ToString(); } if (ds.Tables[0].Rows[0]["NewsContent"] != null && ds.Tables[0].Rows[0]["NewsContent"].ToString() != "") { model.NewsContent = ds.Tables[0].Rows[0]["NewsContent"].ToString(); } if (ds.Tables[0].Rows[0]["NewsSource"] != null && ds.Tables[0].Rows[0]["NewsSource"].ToString() != "") { model.NewsSource = ds.Tables[0].Rows[0]["NewsSource"].ToString(); } if (ds.Tables[0].Rows[0]["NewsSourceLink"] != null && ds.Tables[0].Rows[0]["NewsSourceLink"].ToString() != "") { model.NewsSourceLink = ds.Tables[0].Rows[0]["NewsSourceLink"].ToString(); } if (ds.Tables[0].Rows[0]["PublishUserGUID"] != null && ds.Tables[0].Rows[0]["PublishUserGUID"].ToString() != "") { model.PublishUserGUID = new Guid(ds.Tables[0].Rows[0]["PublishUserGUID"].ToString()); } if (ds.Tables[0].Rows[0]["PublishDate"] != null && ds.Tables[0].Rows[0]["PublishDate"].ToString() != "") { model.PublishDate = DateTime.Parse(ds.Tables[0].Rows[0]["PublishDate"].ToString()); } if (ds.Tables[0].Rows[0]["IsEnable"] != null && ds.Tables[0].Rows[0]["IsEnable"].ToString() != "") { model.IsEnable = int.Parse(ds.Tables[0].Rows[0]["IsEnable"].ToString()); } if (ds.Tables[0].Rows[0]["IsHot"] != null && ds.Tables[0].Rows[0]["IsHot"].ToString() != "") { model.IsHot = int.Parse(ds.Tables[0].Rows[0]["IsHot"].ToString()); } if (ds.Tables[0].Rows[0]["ViewCount"] != null && ds.Tables[0].Rows[0]["ViewCount"].ToString() != "") { model.ViewCount = int.Parse(ds.Tables[0].Rows[0]["ViewCount"].ToString()); } if (ds.Tables[0].Rows[0]["Other01"] != null && ds.Tables[0].Rows[0]["Other01"].ToString() != "") { model.Other01 = ds.Tables[0].Rows[0]["Other01"].ToString(); } if (ds.Tables[0].Rows[0]["Other02"] != null && ds.Tables[0].Rows[0]["Other02"].ToString() != "") { model.Other02 = ds.Tables[0].Rows[0]["Other02"].ToString(); } if (ds.Tables[0].Rows[0]["Other03"] != null && ds.Tables[0].Rows[0]["Other03"].ToString() != "") { model.Other03 = ds.Tables[0].Rows[0]["Other03"].ToString(); } return(model); } else { return(null); } }