protected void btn_Save_Click(object sender, EventArgs e) { try { NewID = (int)Session["NewID"]; Web_News news = Web_News.Load(NewID); news.News_Content = Server.HtmlEncode(tb_Content.Value.Trim()); news.News_Title = tb_Title.Text; news.Module_Code = ddl_Module.SelectedValue; news.News_PubDate = DateTime.Now; news.Manager_Code = "zhujianjie"; news.Save(); CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName + "修改了新闻:" + tb_Title.Text; log.Log_DateCreated = DateTime.Now; log.Save(); lb_err.Text = "修改成功"; } catch (Exception ex) { lb_err.Text = ex.Message; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string code = textmanagerID.Text.Trim(); string pass = textpass.Text.Trim(); pass = CY.CYWebsite.Core.Business.PasswordEncrypt.DESEncryptMethod(pass); CY.CYWebsite.Core.Business.Web_Manager manager = new CY.CYWebsite.Core.Business.Web_Manager(); IList<CY.CYWebsite.Core.Business.Web_Manager> list = manager.GetListByName(code); if (list.Count == 0 || list == null) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('该管理员信息不存在!');</script>"); textmanagerID.Text = string.Empty; textmanagerID.Focus(); } else if (pass == list[0].Manage_Pass) { Session["ManagerId"] = list[0].Id;//自增标识符:ID Session["ManagerCode"] = list[0].Manager_Code;//用户名 Session["Manager"] = list[0]; CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = list[0].Manager_Code; log.Log_Message = list[0].Manage_RealName + "登录了系统"; log.Log_DateCreated = DateTime.Now; log.Save(); Response.Redirect("/Struct/Mine.aspx");//成功,页面跳转 } else { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('密码输入不正确!');</script>"); } }
protected void btn_Del_Click(object sender, EventArgs e) { CheckBox cb; CY.CYWebsite.Core.Business.Web_News news; for (int i = 0; i < gv_NewsList.Rows.Count; i++) { cb = (CheckBox)gv_NewsList.Rows[i].FindControl("CBSelect"); if (cb.Checked) { int iID = int.Parse(gv_NewsList.DataKeys[i].Value.ToString()); news = CY.CYWebsite.Core.Business.Web_News.Load(iID); if (news != null) { news.DeleteOnSave(); news.Save(); CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName + "删除了新闻:" + news.News_Title; log.Log_DateCreated = DateTime.Now; log.Save(); } } } BindData(); }
protected void btnAdd_Click(object sender, EventArgs e) { CY.CYWebsite.Core.Business.Web_Manager manager = new CY.CYWebsite.Core.Business.Web_Manager(); if (!manager.IsExistCode(TextManager_Code.Text.Trim())) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('此管理员编号已经存在');</script>"); TextManager_Code.Text = string.Empty; TextManager_Code.Focus(); } else { manager.Manager_Code = TextManager_Code.Text.Trim();//管理员编号 manager.Manage_Pass = "******"; //默认密码888888 // TextManage_Pass.Text.Trim();//密码 manager.Manage_Pass = CY.CYWebsite.Core.Business.PasswordEncrypt.DESEncryptMethod(manager.Manage_Pass);//加密 manager.Manage_RealName = TextManage_RealName.Text.Trim();//真实姓名 manager.Manager_AddDate = DateTime.Now;//添加日期 try { manager.Save(); CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName +"添加了管理员:" + manager.Manager_Code; log.Log_DateCreated = DateTime.Now; log.Save(); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('增加管理员信息成功!');</script>"); } catch (Exception ex) { throw ex; } } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void cancleManager_Click(object sender, EventArgs e) { CheckBox chk; bool success = false; CY.CYWebsite.Core.Business.Web_Manager managerOther; for (int i = 0; i < gvManager.Rows.Count; i++) { chk =(CheckBox)gvManager.Rows[i].FindControl("chk"); if (chk.Checked) { int id =int.Parse(gvManager.DataKeys[i].Value.ToString()); managerOther = CY.CYWebsite.Core.Business.Web_Manager.Load(id); try { managerOther.DeleteOnSave(); managerOther.Save(); CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName + "删除了管理员:" + managerOther.Manager_Code; log.Log_DateCreated = DateTime.Now; log.Save(); success = true; } catch (Exception ex) { throw ex; } } } if (success == true) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('删除管理员信息成功!');</script>"); Bind(); } }
public IList<CY.CYWebsite.Core.Business.Web_Log> FillLogsByCondition(string managerCode, string dateStart, string dateEnd) { String SqlSelect = "SELECT [Log_ID],[Log_Message],[Log_DateCreated],[ManagerCode] FROM [Web_Log] where "; SqlServerUtility db = new SqlServerUtility(); IList<CY.CYWebsite.Core.Business.Web_Log> results = new List<CY.CYWebsite.Core.Business.Web_Log>(); if (managerCode != "") { SqlSelect += " [ManagerCode]=@ManagerCode and "; db.AddParameter("@ManagerCode", SqlDbType.NVarChar, managerCode); } DateTime dtTemp = new DateTime(); if (dateStart != "" && DateTime.TryParse(dateStart, out dtTemp)) { SqlSelect += " [Log_DateCreated]>@Log_DateStart and "; db.AddParameter("@Log_DateStart", SqlDbType.DateTime, dateStart); } if (dateEnd != "" && DateTime.TryParse(dateEnd, out dtTemp)) { dtTemp = dtTemp.AddDays(1); SqlSelect += " [Log_DateCreated]<@Log_DateEnd and "; db.AddParameter("@Log_DateEnd", SqlDbType.DateTime, dtTemp.ToLongDateString()); } SqlSelect += " 1=1 "; SqlSelect += SqlOrder; SqlDataReader reader = db.ExecuteSqlReader(SqlSelect); if (reader != null) { while (reader.Read()) { CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); if (!reader.IsDBNull(0)) log.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) log.Log_Message = reader.GetString(1); if (!reader.IsDBNull(2)) log.Log_DateCreated = reader.GetDateTime(2); if (!reader.IsDBNull(3)) log.ManagerCode = reader.GetString(3); results.Add(log); } reader.Close(); } return results; }
protected void searchLog_Click(object sender, EventArgs e) { lb_err.Text = ""; try { CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); string strDateStart = tb_DateStart.Text.Trim(); string strDateEnd = tb_DateEnd.Text.Trim(); IList<CY.CYWebsite.Core.Business.Web_Log> list = CY.CYWebsite.Core.Business.Web_Log.FillLogsByCondition(ddl_Manager.SelectedValue.ToString(), strDateStart, strDateEnd); ; gv_LogList.DataSource = list; gv_LogList.DataBind(); } catch (Exception ex) { lb_err.Text = ex.Message; } }
protected void btnEdit_Click(object sender, EventArgs e) { int id = int.Parse(Request.QueryString["ManagerId"]); CY.CYWebsite.Core.Business.Web_Manager managerother = CY.CYWebsite.Core.Business.Web_Manager.Load(id); managerother.Manage_RealName = TextManage_RealName.Text.Trim();//真实姓名 try { managerother.Save(); CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName + "修改了管理员:" + managerother.Manager_Code; log.Log_DateCreated = DateTime.Now; log.Save(); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('更新管理员信息成功!');window.location.href='ManagePreview.aspx?ManagerId=" + id + "'</script>"); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvModule_RowUpdating(object sender, GridViewUpdateEventArgs e) { lb_err.Text = ""; int id = int.Parse(gvModule.DataKeys[e.RowIndex].Value.ToString()); CY.CYWebsite.Core.Business.Web_Module module = CY.CYWebsite.Core.Business.Web_Module.Load(id); module.Module_Code = (gvModule.Rows[e.RowIndex].Cells[0].Controls[0] as TextBox).Text.Trim(); module.Module_Name = (gvModule.Rows[e.RowIndex].Cells[1].Controls[0] as TextBox).Text.Trim(); try { module.Save(); lb_err.Text = "修改成功"; CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName + "修改了模块:" + module.Module_Name; log.Log_DateCreated = DateTime.Now; log.Save(); } catch (Exception ex) { lb_err.Text = ex.Message; } gvModule.EditIndex = -1; gvBind(); }