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 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 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");
}
}
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");
}
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();
}
