protected void Page_Load(object sender, EventArgs e) { try { if (Global.CurrentUser != null) { AccessRight = Global.CurrentUser.AccessRight.ToString(); } JsonContent = ""; DztzDataContext dbContext = new DztzDataContext(); var id = Convert.ToInt32(Request["ledgerNodeId"]); var itemId = Convert.ToInt32(Request["ledgerNodeItemId"]); var node = dbContext.LedgerNodes.First(ln => ln.Id == id); if (node != null) { LedgerNodeId = id.ToString(); Content = node.TemplateContent; Global.CurrentSelectedLedger = id; } var action = Request["action"]; if (action != null) { LedgerItemId = "0"; if (action == "1") { //display template to let user to fill data, // Use ajax to save data. Title = node.LedgerNodeType + " -- " + node.LedgerNodeName + " -- 新建"; } else if (action == "2") { // display template to display the data. if (itemId == 0) { Response.Redirect("search.aspx?action=2&ledgerNodeId=" + id.ToString()); } else { var nodeItem = dbContext.LedgerNodeItems.FirstOrDefault <LedgerNodeItem>(ln => ln.LedgerNodeId == id && ln.Id == itemId); if (nodeItem != null) { LedgerItemId = nodeItem.Id.ToString(); JsonContent = HttpUtility.UrlEncode(nodeItem.TemplateValue, Encoding.UTF8); } else { Response.Redirect("task.aspx?action=1&ledgerNodeId=" + id.ToString()); } Title = node.LedgerNodeType + " -- " + node.LedgerNodeName + " -- 修改"; } } } } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { try { var action = Request["action"]; Action = action; if (action != null) { if (action == "1") { (LedgerItemsGridView.Columns[7] as CommandField).SelectText = "查看"; } else if (action == "2") { (LedgerItemsGridView.Columns[7] as CommandField).SelectText = "修改"; } } var id = Convert.ToInt32(Request["ledgerNodeId"]); DztzDataContext dbContext = new DztzDataContext(); var q = from ln in dbContext.LedgerNodes where ln.Id == id select new { type = ln.LedgerNodeType, name = ln.LedgerNodeName }; Title = q.First().type + " -- " + q.First().name + " -- 查询"; Global.CurrentSelectedLedger = id; } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } }
protected void Upload_Click(object sender, EventArgs e) { var ledgerNodeType = LedgerTypeList.SelectedValue; var accessRight = Convert.ToInt64(Convert.ToInt64(Request.Form["accessRight"].ToString())); if (FileUploadCtrl.HasFile) { StreamReader sr = new StreamReader(FileUploadCtrl.FileContent); string templateContent = sr.ReadToEnd(); sr.Dispose(); DztzDataContext dbContext = new DztzDataContext(); string time = DateTime.Now.ToString(); dbContext.LedgerNodes.InsertOnSubmit(new LedgerNode() { LedgerNodeType = ledgerNodeType, LedgerNodeName = LedgerNodeName.Text == ""?FileUploadCtrl.FileName:LedgerNodeName.Text, AccessRight = accessRight, CreateTime = time, CreateUser = Global.CurrentUser.UserName, ModifyTime = time, ModifyUser = Global.CurrentUser.UserName, TemplateFileName = FileUploadCtrl.FileName, TemplateContent = templateContent }); dbContext.SubmitChanges(); } else { ; } Response.Redirect("AddNode.aspx"); }
protected void Page_Load(object sender, EventArgs e) { try { DztzDataContext dbContext = new DztzDataContext(); var accessLevel = Convert.ToInt64(Request["accessLevel"]); var node = dbContext.AccessLevels.SingleOrDefault(ln => ln.ALValue == accessLevel); if (node != null) { if (!Page.IsPostBack) { this.AccessLevelName.Text = node.ALName; } currentSelectedAccessLevel = accessLevel; this.SaveBttn.Text = "更新"; } else { if (!Page.IsPostBack) { this.AccessLevelName.Text = ""; } this.SaveBttn.Text = "新建"; } } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { try { JsonContent = ""; DztzDataContext dbContext = new DztzDataContext(); var id = Convert.ToInt32(Request["ledgerNodeId"]); var itemId = Convert.ToInt32(Request["ledgerNodeItemId"]); var node = dbContext.LedgerNodes.First(ln => ln.Id == id); if (node != null) { LedgerNodeId = id.ToString(); Content = node.TemplateContent; Global.CurrentSelectedLedger = id; } var nodeItem = dbContext.LedgerNodeItems.FirstOrDefault <LedgerNodeItem>(ln => ln.LedgerNodeId == id && ln.Id == itemId); if (nodeItem != null) { LedgerItemId = nodeItem.Id.ToString(); JsonContent = HttpUtility.UrlEncode(nodeItem.TemplateValue, Encoding.UTF8); } else { Response.Redirect("task.aspx?action=1&ledgerNodeId=" + id.ToString()); } Title = node.LedgerNodeType + " -- " + node.LedgerNodeName + " -- 查看"; } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { DztzDataContext dbContext = new DztzDataContext(); if (dbContext.Users.Count() == 0) { RegisterBttn.Enabled = true; } else { RegisterBttn.Enabled = false; } }
protected void Save_Click(object sender, EventArgs e) { try { if (this.tbPassword.Text != this.tbRePasswird.Text) { Response.Write("2次输入的密码不一致"); return; } var loginName = this.tbLoginName.Text; DztzDataContext dbContext = new DztzDataContext(); string time = DateTime.Now.ToString(); var node = dbContext.Users.SingleOrDefault(u => u.LoginName == this.tbLoginName.Text); if (node != null) { Response.Write("用户已存在,不能新建"); return; } else { dbContext.Users.InsertOnSubmit(new User() { LoginName = this.tbLoginName.Text, UserPassword = this.tbPassword.Text, UserName = this.tbUserName.Text, MobilePhone = this.tbMobilePhone.Text, Email = this.tbEmail.Text, Department = this.tbDepartment.Text, Occupation = this.tbOccupation.Text, Description = this.tbDescription.Text, AccessRight = Convert.ToInt64(Request.Form["accessRight"].ToString()), Superior = Convert.ToInt64(this.tbSuperior.Text), CreateTime = DateTime.Now, LoginCount = 0 }); } dbContext.SubmitChanges(); } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } Response.Redirect("Login.aspx"); }
protected void Page_Load(object sender, EventArgs e) { try { DztzDataContext dbContext = new DztzDataContext(); foreach (var n in dbContext.AccessLevels) { AccessRight += n.ALValue; } this.AccessRightContent = AccessLevel.GetUIString(AccessRight); this.SaveBttn.Text = "提交"; } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Global.CurrentUser != null) { SqlDataSource1.SelectParameters["CurrentLoginUser"].DefaultValue = Global.CurrentUser.UserId.ToString(); } DztzDataContext dbContext = new DztzDataContext(); SelectedUserId = Convert.ToInt64(Request["userId"]); var node = dbContext.Users.SingleOrDefault(ln => ln.UserId == SelectedUserId); if (node != null) { if (!Page.IsPostBack) { AccessRight = node.AccessRight; this.tbLoginName.Text = node.LoginName; this.tbPassword.Attributes["value"] = node.UserPassword; this.tbRePasswird.Attributes["value"] = node.UserPassword; this.tbUserName.Text = node.UserName; this.tbMobilePhone.Text = node.MobilePhone; this.tbEmail.Text = node.Email; this.tbDepartment.Text = node.Department; this.tbOccupation.Text = node.Occupation; this.tbSuperior.Text = node.Superior.ToString(); this.AccessRightContent = AccessLevel.GetUIString(node.AccessRight); this.tbDescription.Text = node.Description; } this.SaveBttn.Text = "更新"; } else { AccessRight = Global.CurrentUser.AccessRight; this.AccessRightContent = AccessLevel.GetUIString(Global.CurrentUser.AccessRight); this.SaveBttn.Text = "新建"; } } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } }
protected void LoginBttn_Click(object sender, EventArgs e) { DztzDataContext dbContext = new DztzDataContext(); var node = dbContext.Users.SingleOrDefault(ln => ln.LoginName == txtName.Text); if (node != null && node.UserPassword == txtPassword.Text) { Global.CurrentUser = node; node.LoginCount += 1; node.LastLoginTime = node.LoginTime; node.LoginTime = DateTime.Now; dbContext.SubmitChanges(); Response.Redirect("Index.aspx"); } else { Response.Redirect("Login.aspx"); } }
static public string GetUIString(long accessRight) { string html = "<tr><td class=\"auto-style1\">访问权限: </td><td><input id=\"accessRight\" name=\"accessRight\" value=\"" + accessRight.ToString() + "\"></td></tr><tr><td></td><td><table>"; DztzDataContext dbContext = new DztzDataContext(); foreach (var accessLevel in dbContext.AccessLevels) { if ((accessLevel.ALValue & accessRight) == accessLevel.ALValue) { html += "<p><input id=\"al_" + accessLevel.ALValue.ToString() + "\" type=\"checkbox\" Height=\"20px\" Width=\"500px\" checked=\"true\" onclick=\"updateAccessRight(this.id);\"/><label for=\"al_" + accessLevel.ALValue.ToString() + "\">" + accessLevel.ALName + "</label></p>"; } } html += "</table></td></tr>"; return(html); }
protected void Save_Click(object sender, EventArgs e) { try { var accesslevelName = this.AccessLevelName.Text; DztzDataContext dbContext = new DztzDataContext(); string time = DateTime.Now.ToString(); var node = dbContext.AccessLevels.SingleOrDefault(ln => ln.ALName == accesslevelName); if (node != null) { Response.Redirect("AccessLevel.aspx?accessLevel=0"); } else { if (SaveBttn.Text == "新建")//新建 { var q = dbContext.AccessLevels.Max(x => x.ALValue); dbContext.AccessLevels.InsertOnSubmit(new AccessLevel() { ALName = accesslevelName, ALValue = q * 2 }); } else//更新 { var q = dbContext.AccessLevels.SingleOrDefault(c => c.ALValue == currentSelectedAccessLevel); q.ALName = accesslevelName; } dbContext.SubmitChanges(); } } catch (Exception exp) { Console.Out.WriteLine(exp.ToString()); } Response.Redirect("AccessLevel.aspx?accessLevel=0"); }
protected void Page_Load(object sender, EventArgs e) { if (Global.CurrentUser == null) { Response.Redirect("login.aspx"); } LeftMenuContent = "<aside class=\"Hui-admin-aside-wrapper\"><div class=\"Hui-admin-logo-wrapper\"><a class=\"logo navbar-logo\" href=\"./\"><i class=\"va-m iconpic global-logo\"></i></a><a href =\"index.aspx?action=1\">电子台账 </a></div>"; DztzDataContext dbContext = new DztzDataContext(); var q = from ln in dbContext.LedgerNodes where (ln.AccessRight & Global.CurrentUser.AccessRight) == ln.AccessRight orderby ln.LedgerNodeType select new { id = ln.Id, type = ln.LedgerNodeType, name = ln.LedgerNodeName }; string type = ""; string selectedtype = ""; foreach (var ledgerNode in q) { if (Global.CurrentSelectedLedger == ledgerNode.id) { selectedtype = ledgerNode.type; break; } } foreach (var ledgerNode in q) { if (type == "") { type = ledgerNode.type; if (Global.CurrentSelectedLedger == ledgerNode.id) { LeftMenuContent += "<div class=\"Hui-admin-menu-dropdown bk_2\"><dl id = \"menu-article\" class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title selected\">" + ledgerNode.type + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\" style=\"display: block;\"><ul><li><dl class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title selected\">" + ledgerNode.name + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\" style=\"display: block;\"><ul>" + "<li><a href =\"task.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\">填写 </a></li>" + "<li><a href=\"task.aspx?action=2&ledgerNodeId=" + ledgerNode.id.ToString() + "&ledgerNodeItemId=0\">修改</a></li>" + "<li><a href = \"search.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\"> 查询 </a></li>" + "</ul></dd></dl>"; } else { LeftMenuContent += "<div class=\"Hui-admin-menu-dropdown bk_2\"><dl id = \"menu-article\" class=\"Hui-menu\">" + (selectedtype == ledgerNode.type ? "<dt class=\"Hui-menu-title selected\">" : "<dt class=\"Hui-menu-title\">") + ledgerNode.type + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\"" + (selectedtype == ledgerNode.type ? " style=\"display: block;\"" : "") + "><ul><li><dl class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title\">" + ledgerNode.name + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\"><ul>" + "<li><a href =\"task.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\">填写 </a></li>" + "<li><a href=\"task.aspx?action=2&ledgerNodeId=" + ledgerNode.id.ToString() + "&ledgerNodeItemId=0\">修改</a></li>" + "<li><a href = \"search.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\"> 查询 </a></li>" + "</ul></dd></dl>"; } } else if (type != ledgerNode.type) { type = ledgerNode.type; LeftMenuContent += "</li></ul></dd></dl></div>"; if (Global.CurrentSelectedLedger == ledgerNode.id) { LeftMenuContent += "<div class=\"Hui-admin-menu-dropdown bk_2\"><dl id = \"menu-article\" class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title selected\">" + ledgerNode.type + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\" style=\"display: block;\"><ul><li><dl class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title selected\">" + ledgerNode.name + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\" style=\"display: block;\"><ul>" + "<li><a href =\"task.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\">填写 </a></li>" + "<li><a href=\"task.aspx?action=2&ledgerNodeId=" + ledgerNode.id.ToString() + "&ledgerNodeItemId=0\">修改</a></li>" + "<li><a href = \"search.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\"> 查询 </a></li>" + "</ul></dd></dl>"; } else { LeftMenuContent += "<div class=\"Hui-admin-menu-dropdown bk_2\"><dl id = \"menu-article\" class=\"Hui-menu\">" + (selectedtype == ledgerNode.type ? "<dt class=\"Hui-menu-title selected\">" : "<dt class=\"Hui-menu-title\">") + ledgerNode.type + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\"" + (selectedtype == ledgerNode.type ? " style=\"display: block;\"" : "") + "><ul><li><dl class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title\">" + ledgerNode.name + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\"><ul>" + "<li><a href =\"task.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\">填写 </a></li>" + "<li><a href=\"task.aspx?action=2&ledgerNodeId=" + ledgerNode.id.ToString() + "&ledgerNodeItemId=0\">修改</a></li>" + "<li><a href = \"search.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\"> 查询 </a></li>" + "</ul></dd></dl>"; } } else { if (Global.CurrentSelectedLedger == ledgerNode.id) { LeftMenuContent += "<dl class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title selected\">" + ledgerNode.name + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\" style=\"display: block;\"><ul>" + "<li><a href =\"task.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\">填写 </a></li>" + "<li><a href=\"task.aspx?action=2&ledgerNodeId=" + ledgerNode.id.ToString() + "&ledgerNodeItemId=0\">修改</a></li>" + "<li><a href = \"search.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\"> 查询 </a></li>" + "</ul></dd></dl>"; } else { LeftMenuContent += "<dl class=\"Hui-menu\">" + "<dt class=\"Hui-menu-title\">" + ledgerNode.name + "<i class=\"Hui-iconfont Hui-admin-menu-dropdown-arrow\"></i></dt>" + "<dd class=\"Hui-menu-item\"><ul>" + "<li><a href =\"task.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\">填写 </a></li>" + "<li><a href=\"task.aspx?action=2&ledgerNodeId=" + ledgerNode.id.ToString() + "&ledgerNodeItemId=0\">修改</a></li>" + "<li><a href = \"search.aspx?action=1&ledgerNodeId=" + ledgerNode.id.ToString() + "\"> 查询 </a></li>" + "</ul></dd></dl>"; } } } if (type != "") { LeftMenuContent += "</li></ul></dd></dl></div>"; } LeftMenuContent += "<dl id=\"menu-home\" class=\"Hui-menu\"><dd class=\"Hui-menu-item-frist\"><ul><li style=\"margin: 0 0 0 25px; color: #20DA01\"><a href=\"AddNode.aspx\">账簿模板管理</a></li></ul></dd></dl>"; LeftMenuContent += "<dl id=\"menu-home\" class=\"Hui-menu\"><dd class=\"Hui-menu-item-frist\"><ul><li style=\"margin: 0 0 0 25px; color: #20DA01\"><a href=\"UserManagement.aspx\">属下用户管理</a></li></ul></dd></dl>"; if (Global.CurrentUser != null && ((Global.CurrentUser.AccessRight & 1) == 1)) { LeftMenuContent += "<dl id=\"menu-home\" class=\"Hui-menu\"><dd class=\"Hui-menu-item-frist\"><ul><li style=\"margin: 0 0 0 25px; color: #20DA01\"><a href=\"AccessLevel.aspx?accessLevel=0\">访问权限管理</a></li></ul></dd></dl>"; } LeftMenuContent += "</aside>"; }
public void ProcessRequest(HttpContext context) { // Use ajax to get/post/update/delete data. //https://api.jquery.com/jQuery.ajax/ //$.ajax('Server.ashx',) if (!string.IsNullOrEmpty(context.Request["ledgerItemId"])) { try { int id = Convert.ToInt32(context.Request["ledgerItemId"]); DztzDataContext dztz = new DztzDataContext(); if (id > 0) { var ledgerNodeItem = dztz.LedgerNodeItems.SingleOrDefault <LedgerNodeItem>(s => s.Id == id); if (ledgerNodeItem != null) // update row { if (context.Request["name"] == "save") { ledgerNodeItem.Status = 0; context.Response.Write("save ok"); } else if (context.Request["name"] == "finish") { ledgerNodeItem.Status = 1; context.Response.Write("finish ok"); } string data = context.Request["content"]; ledgerNodeItem.ModifyTime = DateTime.Now.ToString(); ledgerNodeItem.ModifyUser = Global.CurrentUser.UserName;//current login user ledgerNodeItem.TemplateValue = data; dztz.SubmitChanges(); } else { context.Response.Write("找不到需要更新的账簿。"); } } else // insert new row { var ledgerNodeItem = new LedgerNodeItem(); if (context.Request["name"] == "save") { ledgerNodeItem.Status = 0; context.Response.Write("save ok"); } else if (context.Request["name"] == "finish") { ledgerNodeItem.Status = 1; context.Response.Write("finish ok"); } string data = context.Request["content"]; ledgerNodeItem.LedgerNodeId = Convert.ToInt32(context.Request["ledgerNodeId"]); //current ledgernode id ledgerNodeItem.LedgerNodeName = dztz.LedgerNodes.SingleOrDefault <LedgerNode>(s => s.Id == ledgerNodeItem.LedgerNodeId).LedgerNodeName; ledgerNodeItem.CreateUser = Global.CurrentUser.UserName; //current login user ledgerNodeItem.CreateTime = DateTime.Now.ToString(); ledgerNodeItem.ModifyTime = DateTime.Now.ToString(); ledgerNodeItem.ModifyUser = Global.CurrentUser.UserName;//current login user ledgerNodeItem.TemplateValue = data; dztz.LedgerNodeItems.InsertOnSubmit(ledgerNodeItem); dztz.SubmitChanges(); if (ledgerNodeItem.Status == 0) { context.Response.Redirect("task.aspx?action=2&ledgerNodeId=" + ledgerNodeItem.LedgerNodeId.ToString()); } } } catch (Exception e) { context.Response.Write(e.ToString()); } } else { context.Response.Write("not processed"); } context.Response.ContentType = "text/plain"; context.Response.End(); }