protected void ZButton1_Click(object sender, EventArgs e) { SysDepartment sd = new SysDepartment(); sd.DepartmentID = bd.GetMaxID() + 1; sd.DepartmentName = PubCom.CheckString(txtDepartmentName.Text.Trim()); sd.IsUse = cbIsUse.Checked; if (bd.Insert(sd) != 1) { Message.ShowWrong(this, "添加失败"); return; } else { // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.部门信息.ToString(); log.LogObjectID = sd.DepartmentID.ToString(); log.LogObjectName = sd.DepartmentName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "部门添加"; log.LogAfterObject = JsonHelper.Obj2Json(sd); bsol.Insert(log); Message.ShowOK(this, "添加成功"); BindList(); } }
protected void ZButton1_Click(object sender, EventArgs e) { SysRole sr = new SysRole(); sr.RoleID = br.GetMaxID() + 1; sr.RoleName = PubCom.CheckString(txtRoleName.Text.Trim()); sr.IsUse = cbIsUse.Checked; if (br.Insert(sr) != 1) { Message.ShowWrong(this, "添加失败"); return; } else { // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.角色信息.ToString(); log.LogObjectID = sr.RoleID.ToString(); log.LogObjectName = sr.RoleName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "角色添加"; log.LogAfterObject = JsonHelper.Obj2Json <SysRole>(sr); bsol.Insert(log); Message.ShowOK(this, "添加成功"); BindRoleList(); } }
void BindList() { Query q = Query.Build(new { SortFields = "Regdate desc" }); //q.Add("UserStatus", UserStatus.审核通过.ToString()); q.In("UserID", bur.GetVistorUserID().Select(p => p.UserID).Distinct().ToArray()); q.Add("UserType", UserType.访客.ToString()); string username = PubCom.CheckString(txtUserName.Text.Trim()); if (username != "") { q.Add("UserName", username); } string userloginname = PubCom.CheckString(txtUserLoginName.Text.Trim()); if (userloginname != "") { q.Add("UserLoginName", userloginname); } string orgname = PubCom.CheckString(txtOrgName.Text.Trim()); if (orgname != "") { q.Add("OrgName", orgname); } if (dpUserRole.SelectedValue != "全部") { q.Append("UserID in(select UserID from SysUserRole where RoleID='" + dpUserRole.SelectedValue + "')"); } if (dpUserStatus.SelectedValue != "全部") { if (dpUserStatus.SelectedValue == "启用") { q.Add("IsUse", true); } else { q.Add("IsUse", false); } } int rec = 0; rplist.DataSource = bu.GetUserList(q, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out rec); rplist.DataBind(); AspNetPager1.RecordCount = rec; // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.帐户信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "用户查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(q.GetCondition(true)); bsol.Insert(log); }
private void BindingList() { Query qm = Query.Build(new { SortFields = "MemberID" }); qm.Add("MemberType", MemberType.普通学生.ToString()); string Name = PubCom.CheckString(txtName.Text.Trim()); if (Name != "") { qm.Add("MemberName", Name); } string Phone = PubCom.CheckString(txtPhone.Text.Trim()); if (Phone != "") { qm.Add("Phone", Phone); } string Email = PubCom.CheckString(txtEmail.Text.Trim()); if (Email != "") { qm.Add("Email", Email); } string Qualification = PubCom.CheckString(txtQualification.Text.Trim()); if (Qualification != "") { qm.Add("Qualification", Qualification); } string Organization = PubCom.CheckString(txtOrganization.Text.Trim()); if (Organization != "") { qm.Add("Organization", Organization); } int ret = 0; rplist.DataSource = bm.GetMembersList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret); rplist.DataBind(); AspNetPager1.RecordCount = ret; // 插入日志 query SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.普通学生信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "普通学生信息查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }
private void BindingList() { Query qm = Query.Build(new { SortFields = "IsTop Desc,IsHot Desc,SubmitTime Desc" }); string Title = PubCom.CheckString(txtTitle.Text.Trim()); if (Title != "") { qm.Add("Title", Title); } string Author = PubCom.CheckString(txtAuthor.Text.Trim()); if (Author != "") { qm.Add("Uploader", Author); } string Subtime = PubCom.CheckString(StarTime.Text.Trim()); if (Subtime != "") { qm.Add("Subtime", DateTime.Parse(Subtime)); } if (dpIsTop.SelectedValue != "") { qm.Add("IsTop", dpIsTop.SelectedValue == "1"); } if (dpIsHot.SelectedValue != "") { qm.Add("IsHot", dpIsHot.SelectedValue == "1"); } int ret = 0; rplist.DataSource = bn.GetNewsList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret); rplist.DataBind(); AspNetPager1.RecordCount = ret; // 插入日志 query SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.新闻信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "用户查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }
protected void btnAdd_OnClick(object sender, EventArgs e) { var usermodel = bu.GetUserByUserID(userID); if (usermodel.UserPassword == EncryptHelper.EncryptPassword(PubCom.CheckString(txtOldPsw.Text.Trim()), Constants.PassWordEncodeType)) { string newpsw = EncryptHelper.EncryptPassword(PubCom.CheckString(txtNewPsw.Text.Trim()), Constants.PassWordEncodeType);//new密码 if (bu.Update(new SysUser() { UserID = userID, UserPassword = newpsw }) == 1) { // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.帐户信息.ToString(); log.LogObjectID = userID; log.LogObjectName = "[" + usermodel.UserLoginName + "]" + usermodel.UserName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "密码重置"; log.LogBeforeObject = JsonHelper.Obj2Json <string>("[原密码:]" + usermodel.UserPassword); log.LogAfterObject = JsonHelper.Obj2Json <string>("[新密码:]" + EncryptHelper.Encode(newpsw)); bsol.Insert(log); Message.ShowOKAndBack(this, "修改密码成功!"); } } else { Message.ShowWrong(this, "用户密码错误,请重试!"); } }
protected void btnAdd_Click(object sender, EventArgs e) { SysCode sc = new SysCode(); sc.CodeID = bsc.GetMaxID() + 1; sc.CodeName = PubCom.CheckString(txtCodeName.Text.Trim()); sc.CodeText = PubCom.CheckString(txtCodeText.Text.Trim()); sc.CodeValue = PubCom.CheckString(txtCodeValue.Text.Trim()); sc.SortNo = int.Parse(txtSortNo.Text.Trim()); if (bsc.Insert(sc) != 1) { Message.ShowWrong(this, "添加失败"); return; } else { //// 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.数据字典.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "数据新增"; log.LogAfterObject = JsonHelper.Obj2Json(sc); bsol.Insert(log); Message.ShowOKAndReflashParent(this, "添加成功", "zbquery"); } }
protected void btnAdd_OnClick(object sender, EventArgs e) { Dynamic d = new Dynamic(); d.DynamicID = bd.GetMaxID() + 1; d.DynamicType = DynamicType.团队动态.ToString(); d.IsTop = CbIstop.Checked; d.Content = container.Text; d.SubTime = DateTime.Now; d.Uploader = GetLogUserName(); d.Title = PubCom.CheckString(txtTitle.Text.Trim()); if (bd.Insert(d) != 1) { Message.ShowWrong(this, "添加团队动态失败!"); } else { //// 插入日志 add SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.团队动态信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "团队动态信息新增"; log.LogAfterObject = JsonHelper.Obj2Json(d); bsol.Insert(log); Message.ShowOKAndRedirect(this, "添加团队动态成功", "TDDynamicManage.aspx"); } }
protected void btnAdd_OnClick(object sender, EventArgs e) { Notice n = new Notice(); Notice nold = bn.GetNoticesByID(Utils.StrToInt(hfNoticeID.Value, 0)); n.NoticeID = Utils.StrToInt(hfNoticeID.Value, 0); n.NoticeTitle = PubCom.CheckString(txtTitle.Text.Trim()); n.NoticeStatus = dpStatus.SelectedValue; n.NoticeContent = container.Text; n.LastUpdateDate = DateTime.Now; if (bn.Update(n) != 1) { Message.ShowWrong(this, "修改公告失败!"); } else { //// 插入日志 add SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.公告信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "公告信息修改"; log.LogBeforeObject = JsonHelper.Obj2Json(nold); log.LogAfterObject = JsonHelper.Obj2Json(n); bsol.Insert(log); Message.ShowOKAndRedirect(this, "修改公告信息成功", "NoticeManage.aspx"); } }
void BindList() { Query q = Query.Build(new { SortFields = "AreaID" }); string name = PubCom.CheckString(txtAreaName.Text.Trim()); if (name != "") { q.Add("AreaName", name); } int rec = 0; //获取数据列表 rplist.DataSource = ba.GetAreaList(q, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out rec); rplist.DataBind(); //赋值起始页 AspNetPager1.RecordCount = rec; //// 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.地区信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "地区查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(q.GetCondition(true)); bsol.Insert(log); }
protected void zbupdate_Click(object sender, EventArgs e) { for (int i = 0; i < rpoperate.Items.Count; i++) { CheckBox cb = rpoperate.Items[i].FindControl("cboperate") as CheckBox; if (cb.Checked) { if (!bo.IsHaveOperareName(mid, cb.Text.Trim())) { SysOperate so = new SysOperate(); so.MenuID = mid; so.OperateID = bo.GetMaxID() + 1; so.OperateName = cb.Text.Trim(); bo.Insert(so); //bo.Insert(new SysOperate() { MenuID = mid, OperateID = bo.GetMaxID() + 1, OperateName = cb.Text.Trim() }); SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.菜单信息.ToString(); log.LogObjectID = mid.ToString(); log.LogObjectName = bm.GetSysMenuByID(mid).MenuName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "设置操作"; log.LogAfterObject = JsonHelper.Obj2Json(so); log.LogRemark = "添加的菜单操作"; bsol.Insert(log); } } } Response.Redirect("MenuManage.aspx"); }
protected void ZButton1_Click(object sender, EventArgs e) { bro.DeleteByRoleID(roleid); for (int i = 0; i < rproleoperate.Items.Count; i++) { CheckBoxList cbl = rproleoperate.Items[i].FindControl("cboperate") as CheckBoxList; foreach (ListItem li in cbl.Items) { if (li.Selected) { SysRoleOperate sro = new SysRoleOperate(); sro.OperateID = int.Parse(li.Value); sro.RoleID = roleid; bro.Insert(sro); // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.角色信息.ToString(); log.LogObjectID = sro.RoleID.ToString(); log.LogObjectName = br.GetRoleByID(sro.RoleID).RoleName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "角色设置操作添加"; log.LogAfterObject = JsonHelper.Obj2Json(sro); bsol.Insert(log); } } } BUser bu = new BUser(); bu.ReSetUserRoleOperate(roleid);//没有方法 Message.ShowOKAndRedirect(this, "修改成功", "RoleManage.aspx"); }
private void BindingList() { Query qm = Query.Build(new { SortFields = "LastUpdateDate Desc" }); string Title = PubCom.CheckString(txtTitle.Text.Trim()); if (Title != "") { qm.Add("NoticeTitle", Title); } string CreateUser = PubCom.CheckString(txtCreateUser.Text.Trim()); if (CreateUser != "") { qm.Add("CreateUser", CreateUser); } string Subtime = PubCom.CheckString(StarTime.Text.Trim()); if (Subtime != "") { qm.Add("CreateDate", DateTime.Parse(Subtime)); } if (dpNoticeStatus.SelectedValue != "") { qm.Add("NoticeStatus", dpNoticeStatus.SelectedValue); } int ret = 0; rplist.DataSource = bn.GetNoticesList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret); rplist.DataBind(); AspNetPager1.RecordCount = ret; // 插入日志 query SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.公告信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "公告信息查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }
protected void btnAdd_Click(object sender, EventArgs e) { SysUser su = new SysUser(); su.UserID = System.Guid.NewGuid().ToString("N");//ID生成策略 su.UserLoginName = txtUserLoginName.Text.Trim(); su.UserName = txtUserName.Text.Trim(); su.UserPassword = EncryptHelper.EncryptPassword(Constants.DefaultPassword, Constants.PassWordEncodeType);//默认密码 su.Tel = txtTel.Text.Trim(); su.Sex = rbsex.SelectedValue; su.RegDate = DateTime.Now; su.Phone = txtPhone.Text.Trim(); su.IsMain = true; su.Email = txtMail.Text.Trim(); su.IsUse = true; su.UserType = UserType.普通管理员.ToString(); su.UserStatus = UserStatus.审核通过.ToString(); if (bu.GetUserByUserLoginName(su.UserLoginName) != null) { Message.ShowWrong(this, "用户登录名已经存在"); txtUserLoginName.Focus(); return; } int rec = bu.Insert(su); if (rec == 1) { foreach (ListItem li in lbseleted.Items) { bur.Insert(new SysUserRole() { RoleID = int.Parse(li.Value.Trim()), UserID = su.UserID }); } // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.帐户信息.ToString(); log.LogObjectID = su.UserID; log.LogObjectName = "[" + su.UserLoginName + "]" + su.UserName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "用户添加"; log.LogAfterObject = JsonHelper.Obj2Json <SysUser>(su); bsol.Insert(log); Message.ShowOKAndRedirect(this, "添加成功,初始密码为:" + Constants.DefaultPassword, "UserManage.aspx"); } else { Message.ShowWrong(this, "添加失败"); } }
protected void btnAdd_Click(object sender, EventArgs e) { SysUser oldsu = bu.GetUserByUserID(hfID.Value); SysUser su = new SysUser(); su.UserID = hfID.Value; su.UserLoginName = txtUserLoginName.Text.Trim(); su.UserName = txtUserName.Text.Trim(); su.Phone = txtPhone.Text.Trim(); su.Tel = txtTel.Text.Trim(); su.Sex = rbsex.SelectedValue; su.Email = txtMail.Text.Trim(); su.IsUse = true; if (bu.GetUserByUserLoginName(su.UserLoginName) != null && su.UserLoginName != oldsu.UserLoginName) { Message.ShowWrong(this, "用户登录名已经存在"); txtUserLoginName.Focus(); return; } int rec = bu.Update(su); if (rec == 1) { bur.DeleteByUserID(UserID); foreach (ListItem li in lbseleted.Items) { bur.Insert(new SysUserRole() { RoleID = int.Parse(li.Value.Trim()), UserID = su.UserID }); } // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.帐户信息.ToString(); log.LogObjectID = su.UserID; log.LogObjectName = "[" + su.UserLoginName + "]" + su.UserName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "用户修改"; log.LogBeforeObject = JsonHelper.Obj2Json <SysUser>(oldsu); log.LogAfterObject = JsonHelper.Obj2Json <SysUser>(su); bsol.Insert(log); Message.ShowOKAndRedirect(this, "修改成功", "UserManage.aspx"); } else { Message.ShowWrong(this, "修改失败"); } }
protected void btnAdd_OnClick(object sender, EventArgs e) { Project p = new Project(); p.ProjectID = bp.GetMaxID() + 1; p.ProjectName = PubCom.CheckString(txtName.Text.Trim()); p.ProjectContent = PubCom.CheckString(txtContent.Text.Trim()); p.ProjectPeriod = DpProjectPeriod.SelectedValue; p.OrgName = PubCom.CheckString(txtOrgName.Text.Trim()); p.StartTime = DateTime.Parse(StarTime.Text.Trim()); p.EndTime = DateTime.Parse(EndTime.Text.Trim()); string str = txtProjectStage.Text.Trim(); str = str.Replace("<", "<"); str = str.Replace(">", ">"); str = str.Replace(" ", " "); str = str.Replace("\r\n", "<br>"); p.ProjectStage = str; if (dpExpert.SelectedValue != "") { p.ExpertID = Utils.StrToInt(dpExpert.SelectedValue, 0); } if (dpLm.SelectedValue != "") { p.LmMemberID = Utils.StrToInt(dpLm.SelectedValue, 0); } if (dpTd.SelectedValue != "") { p.TdMemberID = Utils.StrToInt(dpTd.SelectedValue, 0); } if (dpstu.SelectedValue != "") { p.StuMemberID = Utils.StrToInt(dpstu.SelectedValue, 0); } if (bp.Insert(p) == 1) { //// 插入日志 add SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.项目信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "项目新增"; log.LogAfterObject = JsonHelper.Obj2Json(p); bsol.Insert(log); Message.ShowOKAndRedirect(this, "添加项目成功", "ProjectManage.aspx"); } else { Message.ShowWrong(this, "添加项目失败!"); return; } }
protected void btnAdd_Click(object sender, EventArgs e) { Tool a = new Tool(); a.ToolID = ba.GetMaxID() + 1; a.ToolName = PubCom.CheckString(txtToolName.Text.Trim()); a.UploadTime = DateTime.Now; a.Uploader = GetLogUserName(); a.ToolType = dpToolType.SelectedValue; a.PathType = dppathtype.SelectedValue; a.ToolPath = PubCom.CheckString(txtToolPath.Text.Trim()); string Extension = Path.GetExtension(PubCom.CheckString(txtToolName.Text.Trim())); //扩展名 ".aspx" if (string.IsNullOrEmpty(Extension)) { Message.ShowWrong(this, "请输入文件后缀名!如.mp4"); return; } else { a.ToolSuffix = Extension.Substring(1, Extension.Length); } //int ret = 0; //if (rec == 1) //{ // HttpFileCollection htf = Request.Files; // ret = ba.UploadFile(htf[0], PicFilePath, a.ToolID,dpToolType.SelectedValue); //} if (ba.Update(a) == 1) { //// 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.工具信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "修改建构工具"; log.LogAfterObject = JsonHelper.Obj2Json(a);//不包含附件 log.LogRemark = ""; bsol.Insert(log); Message.ShowOKAndRedirect(this, "修改成功", "ToolManage.aspx"); } else { Message.ShowWrong(this, "修改失败"); } }
void BindList() { var qm = Query.Build(new { SortFields = "CodeName desc,SortNo" }); string name = PubCom.CheckString(txtCodeName.Text.Trim()); if (name != "") { qm.Add("CodeName", name); } string text = PubCom.CheckString(txtCodeText.Text.Trim()); if (text != "") { qm.Add("CodeText", text); } string value = PubCom.CheckString(txtCodeValue.Text.Trim()); if (value != "") { qm.Add("CodeValue", value); } int rec = 0; rplist.DataSource = bsc.GetSysCodeList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out rec); rplist.DataBind(); AspNetPager1.RecordCount = rec; //// 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.数据字典.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "数据查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }
protected void btnAdd_OnClick(object sender, EventArgs e) { New n = new New(); BNew bn = new BNew(); BSysOperateLog bsol = new BSysOperateLog(); n.NewsID = bn.GetMaxID() + 1; n.IsTop = CbIstop.Checked; n.IsHot = CbIsHot.Checked; n.NewsContent = container.Text; n.SubmitTime = DateTime.Now; //n.SavePath = "details" + DateTime.Now.Year + "_" + DateTime.Now.Month + "/" +DateTime.Now.Day; n.Uploader = PubCom.CheckString(txtauthor.Text.Trim()); n.Title = PubCom.CheckString(txtTitle.Text.Trim()); n.summary = PubCom.CheckString(txtsummary.Text.Trim()); n.NewsType = dpNewstype.SelectedValue; n.StaticType = dpstatictype.SelectedValue; //string PicUrl = ""; //if (UploadValidate(out PicUrl)) //{ // n.IsImg = 1; // mp.Id = mpm.GetMaxID() + 1; // mp.NewsId = n.Id; // mp.Title = pic_upload.FileName; // mp.PicUrl = PicUrl; // mpm.Insert(mp); //} //else //{ // n.IsImg = 1; //}NewsManage if (bn.Insert(n) != 1) { Message.ShowWrong(this, "添加文章失败!"); } else { bn.UploadValidate(pic_upload, lbl_pic, PicFilePath, n.NewsID); //// 插入日志 add SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.新闻信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "新闻新增"; log.LogAfterObject = JsonHelper.Obj2Json(n); bsol.Insert(log); Message.ShowOKAndRedirect(this, "添加文章成功", "NewsManage.aspx"); } }
private void BindingList() { Query qm = Query.Build(new { SortFields = "IsTop, Sort" }); string Name = PubCom.CheckString(txtExpertName.Text.Trim()); if (Title != "") { qm.Add("EName", Name); } string country = PubCom.CheckString(txtCountry.Text.Trim()); if (country != "") { qm.Add("ECountry", country); } if (dpIsTop.SelectedValue != "") { qm.Append(dpIsTop.SelectedValue == "0" ? "IsTop=0" : "IsTop=1 or IsTop is null"); } int ret = 0; rplist.DataSource = be.GetExpertsList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret); rplist.DataBind(); AspNetPager1.RecordCount = ret; // 插入日志 query SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.专家信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "专家查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }
protected void ZButton1_Click(object sender, EventArgs e) { SysMenu sm = new SysMenu(); sm.MenuID = bm.GetMaxID() + 1; sm.MenuName = PubCom.CheckString(txtMenuName.Text.Trim()); sm.MenuSort = int.Parse(PubCom.CheckString(txtMenuSort.Text.Trim())); sm.ParentMenuID = int.Parse(PubCom.CheckString(txtParentMenuID.Text.Trim())); sm.MenuType = ""; sm.ModuleCode = PubCom.CheckString(txtModuleCode.Text.Trim()); sm.PageUrl = txtPageUrl.Text.Trim(); sm.IsLeaf = cbIsLeaf.Checked; sm.IsVisiable = cbIsVisiable.Checked; if (bm.Insert(sm) != 1) { Message.ShowWrong(this, "添加失败"); return; } else { // 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.菜单信息.ToString(); log.LogObjectID = sm.MenuID.ToString(); log.LogObjectName = sm.MenuName; log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "菜单添加"; log.LogAfterObject = JsonHelper.Obj2Json <SysMenu>(sm); bsol.Insert(log); Message.ShowOK(this, "添加成功"); BindMenu(); } }
private void BindingList() { Query qm = new Query(); qm.OrderBy("CHARINDEX(RTRIM(CAST(ToolType as NCHAR)),'视频文件,文本文件,压缩文件'), UploadTime desc"); string name = PubCom.CheckString(txtName.Text.Trim()); if (name != "") { qm.Add("ToolName", name); } if (dpToolType.SelectedValue != "") { qm.Add("ToolType", dpToolType.SelectedValue); } int ret = 0; rplist.DataSource = bn.GetToolsList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret); rplist.DataBind(); AspNetPager1.RecordCount = ret; // 插入日志 query SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.工具信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "工具信息查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }
protected void btnAdd_Click(object sender, EventArgs e) { Tool a = new Tool(); a.ToolID = ba.GetMaxID() + 1; a.ToolName = PubCom.CheckString(txtToolName.Text.Trim()); a.UploadTime = DateTime.Now; a.Uploader = GetLogUserName(); a.ToolType = dpToolType.SelectedValue; //做个判定 a.PathType = dppathtype.SelectedValue; a.ToolPath = PubCom.CheckString(txtToolPath.Text.Trim()); string Extension = Path.GetExtension(PubCom.CheckString(txtToolPath.Text.Trim())); //扩展名 ".aspx" if (string.IsNullOrEmpty(Extension)) { Message.ShowWrong(this, "请输入文件后缀名!如.mp4"); return; } else { a.ToolSuffix = Extension.Substring(1); } if (ba.Insert(a) == 1) { //// 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.工具信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "新增建构工具"; log.LogAfterObject = JsonHelper.Obj2Json(a); //不包含附件 log.LogRemark = ""; bsol.Insert(log); Message.ShowOKAndRedirect(this, "添加成功", "ToolManage.aspx"); } else { Message.ShowWrong(this, "添加失败"); } }
protected void btnAdd_OnClick(object sender, EventArgs e) { string savepath = DateTime.Now.Year + "_" + DateTime.Now.Month + "/" + DateTime.Now.Day; Expert exold = be.GetExpertsByID(Utils.StrToInt(hfexpertid.Value, 0)); Expert ex = new Expert(); ex.ExpertID = Utils.StrToInt(hfexpertid.Value, 0); ex.EName = PubCom.CheckString(txtEName.Text.Trim()); ex.ECountry = PubCom.CheckString(txtECountry.Text.Trim()); ex.ESummary = PubCom.CheckString(txtESummary.Text.Trim()); if (dpIstop.SelectedValue != "") { ex.Istop = dpIstop.SelectedValue == "1"; } if (dpEIdentification.SelectedValue != "") { ex.EIdentification = dpEIdentification.SelectedValue; } if (be.Update(ex) == 1) { be.UploadValidate(pic_upload, lbl_pic, PicFilePath, savepath, ex.ExpertID); // 插入日志 update Expert exnew = be.GetExpertsByID(Utils.StrToInt(hfexpertid.Value, 0)); SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.专家信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "专家修改"; log.LogBeforeObject = JsonHelper.Obj2Json(exold); log.LogAfterObject = JsonHelper.Obj2Json(exnew); bsol.Insert(log); Message.ShowOKAndRedirect(this, "修改专家成功", "ExpertManage.aspx"); } else { Message.ShowWrong(this, "修改专家失败!"); return; } }
private void BindList() { Query q = Query.Build(new { SortFields = "OperateDate desc" }); string LogTypes = PubCom.CheckString(dpLogType.SelectedValue.Trim()); string OperateUser = PubCom.CheckString(txtOperateUser.Text.Trim()); if (LogTypes != "==请选择==") { q.Add("LogType", LogTypes); } //处理日期类 if (StarTime.Text.Trim() != "") { q.Gt("OperateDate", StarTime.Text.Trim()); } if (EndTime.Text.Trim() != "") { q.Lt("OperateDate", EndTime.Text.Trim()); } if (OperateUser != "") { q.Add("OperateUser", OperateUser); } int rec = 0; rplist.DataSource = bsol.GetSysOperateLogList(q, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out rec); rplist.DataBind(); AspNetPager1.RecordCount = rec; //// 插入日志 SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.日志信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "日志信息查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(q.GetCondition(true)); bsol.Insert(log); }
protected void btnEdit_OnClick(object sender, EventArgs e) { New oldn = bn.GetNewsByID(Utils.StrToInt(ID, 0)); if (bn.Update(new New { NewsID = Utils.StrToInt(hfNewsID.Value, 0), Title = PubCom.CheckString(txtTitle.Text.Trim()), NewsContent = container.Text, summary = PubCom.CheckString(txtsummary.Text.Trim()), Uploader = txtauthor.Text.Trim(), SubmitTime = DateTime.Now, IsHot = CbIsHot.Checked, IsTop = CbIstop.Checked, NewsType = dpNewstype.SelectedValue, StaticType = dpstatictype.SelectedValue }) != 1) { Message.ShowWrong(this, "更新文章失败"); } else { bn.UploadValidate(pic_upload, lbl_pic, PicFilePath, Utils.StrToInt(hfNewsID.Value, 0)); New n = bn.GetNewsByID(Utils.StrToInt(ID, 0)); SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.新闻信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "新闻修改"; log.LogBeforeObject = JsonHelper.Obj2Json(oldn); log.LogAfterObject = JsonHelper.Obj2Json(n); bsol.Insert(log); Message.ShowOKAndRedirect(this, "更新新闻成功", "NewsManage.aspx"); } }
protected void btnAdd_OnClick(object sender, EventArgs e) { Member m = new Member(); m.MemberID = Utils.StrToInt(hfMemberID.Value, 0); m.MemberName = PubCom.CheckString(txtMName.Text.Trim()); m.Phone = PubCom.CheckString(txtPhone.Text.Trim()); m.Email = PubCom.CheckString(txtMail.Text.Trim()); m.Organization = PubCom.CheckString(ttxOrgName.Text.Trim()); m.Qualification = PubCom.CheckString(txtQualification.Text.Trim()); Utils.ObjToInt(dpgrade.SelectedValue, 0); Member mold = bm.GetMembersByID(Utils.StrToInt(hfMemberID.Value, 0)); if (bm.Update(m) == 1) { //插入图片 bm.UploadValidate(pic_upload, lbl_pic, PicFilePath, m.MemberID, MemberType.普通学生); //// 插入日志 add SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.普通学生信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "普通学生信息修改"; log.LogBeforeObject = JsonHelper.Obj2Json(mold); log.LogAfterObject = JsonHelper.Obj2Json(m); bsol.Insert(log); Message.ShowOKAndRedirect(this, "普通学生信息成功", "StuMemberManage.aspx"); } else { Message.ShowWrong(this, "普通学生信息失败!"); return; } }
protected void btnAdd_OnClick(object sender, EventArgs e) { Dynamic d = new Dynamic(); Dynamic dold = bd.GetDynamicsByID(Utils.StrToInt(hfdynamicID.Value, 0)); d.DynamicID = Utils.StrToInt(hfdynamicID.Value, 0); d.IsTop = CbIstop.Checked; d.Content = container.Text; d.SubTime = DateTime.Now; d.Uploader = GetLogUserName(); d.Title = PubCom.CheckString(txtTitle.Text.Trim()); if (bd.Update(d) != 1) { Message.ShowWrong(this, "修改联盟动态失败!"); } else { // 插入日志 update Dynamic dnew = bd.GetDynamicsByID(Utils.StrToInt(hfdynamicID.Value, 0)); SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.联盟动态信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "联盟动态信息修改"; log.LogBeforeObject = JsonHelper.Obj2Json(dold); log.LogAfterObject = JsonHelper.Obj2Json(dnew); bsol.Insert(log); Message.ShowOKAndRedirect(this, "修改联盟动态成功", "LMDynamicManage.aspx"); } }
protected void btnAdd_OnClick(object sender, EventArgs e) { Member m = new Member(); m.MemberID = bm.GetMaxID() + 1; m.MemberType = MemberType.联盟成员.ToString(); m.MemberName = PubCom.CheckString(txtMName.Text.Trim()); m.Phone = PubCom.CheckString(txtPhone.Text.Trim()); m.Email = PubCom.CheckString(txtMail.Text.Trim()); m.Organization = PubCom.CheckString(ttxOrgName.Text.Trim()); m.Qualification = PubCom.CheckString(txtQualification.Text.Trim()); if (bm.Insert(m) == 1) { //插入图片 bm.UploadValidate(pic_upload, lbl_pic, PicFilePath, m.MemberID, MemberType.联盟成员); //// 插入日志 add SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.联盟成员信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "联盟成员新增"; log.LogAfterObject = JsonHelper.Obj2Json(m); bsol.Insert(log); Message.ShowOKAndRedirect(this, "添加联盟成员成功", "LMMemberManage.aspx"); } else { Message.ShowWrong(this, "添加联盟成员失败!"); return; } }
private void BindingList() { Query qm = Query.Build(new { SortFields = "FinishTime Desc" }); //6个dpdownlist if (dpExpert.SelectedValue != "") { qm.Add("e.ExpertID", dpExpert.SelectedValue); } if (dpLm.SelectedValue != "") { qm.Add("m.LmMemberID", dpLm.SelectedValue); } if (dpTd.SelectedValue != "") { qm.Add("m.TdMemberID", dpTd.SelectedValue); } if (dpProject.SelectedValue != "") { qm.Add("p.ProjectID", dpProject.SelectedValue); } string Name = PubCom.CheckString(txtBookName.Text.Trim()); if (Name != "") { qm.Add("t.TreatiseName", Name); } string author = PubCom.CheckString(txtAuthor.Text.Trim()); if (author != "") { qm.Add("t.Author", author); } string Subtime = PubCom.CheckString(StarTime.Text.Trim()); if (Subtime != "") { qm.Add("t.FinishTime", DateTime.Parse(Subtime)); } string publication = PubCom.CheckString(txtPublish.Text.Trim()); if (publication != "") { qm.Add("t.Publishing", publication); } int ret = 0; rplist.DataSource = bt.GetTreatisesList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret); rplist.DataBind(); AspNetPager1.RecordCount = ret; // 插入日志 query SysOperateLog log = new SysOperateLog(); log.LogID = StringHelper.getKey(); log.LogType = LogType.专著信息.ToString(); log.OperateUser = GetLogUserName(); log.OperateDate = DateTime.Now; log.LogOperateType = "专著查询"; log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true)); bsol.Insert(log); }