protected void submit_Click(object sender, EventArgs e)
{
XtmUser userM = new XtmUser();
userM.UserCode = this.txtUsername.Text.Trim();
userM.UserPwd = Encry.Encode(this.txtUserpwd.Text.Trim());
BaseDao baseDao = new BaseDao();
IList <XtmUser> userL = baseDao.List <XtmUser>(userM);
if (userL != null && userL.Count > 0)
{
userM = userL[0];
if (userM.Status != "x")
{
Page.RegisterStartupScript("onclick", "<script>alert('账号已停用')</script>");
}
else
{
CoreCache.SetCache("SysDepartId", userM.DepartId);
CoreCache.SetCache("SysUserType", userM.UserType);
CoreCache.SetCache("SysUserId", userM.Did);
CoreCache.SetCache("SysUserCode", userM.UserCode);
CoreCache.SetCache("SysUserName", userM.UserName);
Response.Redirect("Index/content.htm");
}
}
else
{
Page.RegisterStartupScript("onclick", "<script>alert('账号或密码错误')</script>");
}
}
protected void Depart_SelectedIndexChanged(object sender, EventArgs e)
{
if (Depart.SelectedValue == "")
{
this.YwyCode.Items.Clear();
this.YwyCode.SelectedValue = "";
}
else
{
BaseDao baseDao = new BaseDao();
Hashtable ht = new Hashtable();
XtmDepart de = new XtmDepart();
de.DepartCode = Depart.SelectedValue;
IList <XtmDepart> depL = baseDao.List(de);
if (depL != null && depL.Count > 0)
{
ht.Add("depart", depL[0].Did);
WebUiProcess.InitDropDownList(this.YwyCode, "ddlCbYwy", ht, ref errmsg);
}
}
//if (Depart.SelectedValue == "")
//{
// this.YwyCode.Items.Clear();
// this.YwyCode.SelectedValue = "";
//}
//else
//{
// Hashtable ht = new Hashtable();
// ht.Add("depart", Depart.SelectedValue);
// WebUiProcess.InitDropDownList(this.YwyCode, "ddlCbYwy", ht, ref errmsg);
//}
}
private IList <YwData> GetYwDataList()
{
YwData data = new YwData();
//data.Dzh = "PDAA201635110000060776";
IList <YwData> list = baseD.List(data);
return(list);
}
/// <summary>
/// 创建实体后期动作
/// </summary>
public override void AfterCreateEntity()
{
base.AfterCreateEntity();
if (!IsPostBack)
{
BaseDao baseDao = new BaseDao();
XtmConfig config = new XtmConfig();
IList <XtmConfig> list = baseDao.List(config);
if (list != null && list.Count > 0)
{
this.Entity = list[0];
}
}
}
public IWorkbook ExportData(ref string errmsg)
{
XtmUser param = new XtmUser();
XSSFWorkbook book = new XSSFWorkbook();
ISheet sheet = book.CreateSheet("userExport");
IRow row = sheet.CreateRow(0);
CreateHead(row);
IList <XtmUser> list = baseDao.List(param);
int i = 0;
foreach (XtmUser temp in list)
{
i += 1;
IRow rowT = sheet.CreateRow(i);
CreateRow(rowT, temp);
}
return(book);
}
public XSSFWorkbook Export()
{
XSSFWorkbook book = new XSSFWorkbook();
ISheet sheet = book.CreateSheet("specExport");
IRow row = sheet.CreateRow(0);
CreateHead(row);
YwSpec param = new YwSpec();
IList <YwSpec> list = baseDao.List(param);
int i = 0;
foreach (YwSpec temp in list)
{
i += 1;
IRow rowT = sheet.CreateRow(i);
CreateRow(rowT, temp);
}
return(book);
}
private string LoadMenuJson()
{
BaseDao baseDao = new BaseDao();
XtmMenu menuM = new XtmMenu();
menuM.UserId = int.Parse(Request.QueryString["id"]);
IList <XtmMenu> list = baseDao.List(menuM);
ArrayList jsonList = new System.Collections.ArrayList();
string result = "[";
for (int i = 0; i < list.Count; i++)
{
XtmMenu menuT = list[i];
NodeData mt = new NodeData();
mt.id = menuT.Did.ToString();
mt.code = menuT.MenuCode;
mt.pid = menuT.ParentId.ToString();
mt.name = menuT.MenuName;
mt.open = true;
if (menuT.Pri == "y")
{
mt.@checked = true;
}
else
{
mt.@checked = false;
}
if (i == list.Count - 1)
{
result += JsonHelper.JsonSerializer <NodeData>(mt);
}
else
{
result += JsonHelper.JsonSerializer <NodeData>(mt) + ",";
}
}
result += "]";
return(result);
}
private void DealDownAtt()
{
YwAttach att = new YwAttach();
att.Dataid = Entity.Did;
att.Type = "2";
BaseDao baseDao = new BaseDao();
IList<YwAttach> list = baseDao.List(att);
if (list.Count > 0)
{
YwAttach temp = list[0];
string path = temp.Dic + temp.FileN;
Response.ContentType = "application/x-zip-compressed";
Response.AddHeader("Content-Disposition", "attachment;filename=" + temp.FileN);
string filename = path;
Response.TransmitFile(filename);
}
else
{
errmsg = "没有附件";
}
Task.Submit = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string Cxcs = System.Configuration.ConfigurationManager.AppSettings["Cxcs"].Trim();
WebUiProcess.InitDropDownList(this.Cxcs, Cxcs, ref errmsg);
WebUiProcess.InitDropDownList(this.Depart, "ddlCbDepart", null, ref errmsg);
if (Entity.Depart != null && Entity.Depart != "")
{
BaseDao baseDao = new BaseDao();
Hashtable ht = new Hashtable();
XtmDepart de = new XtmDepart();
de.DepartCode = Entity.Depart;
IList <XtmDepart> depL = baseDao.List(de);
if (depL != null && depL.Count > 0)
{
ht.Add("depart", depL[0].Did);
WebUiProcess.InitDropDownList(this.Ywy, "ddlCbYwy", ht, ref errmsg);
}
}
}
}
private bool YwySubmit(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
this.BeginTran();
try
{
YwData entity = task.Entity as YwData;
BaseDao baseDao = new BaseDao();
YwAttach att = new YwAttach();
att.Type = "1";
att.Dataid = entity.Did;
IList <YwAttach> attList = baseDao.List(att);
if (attList != null && attList.Count > 0)
{
entity.AttachmentCount = attList.Count;
}
else
{
entity.AttachmentCount = 0;
}
entity.Status = "3";
entity.YwySubmit = DateTime.Now;
if (entity.Bbr.Length <= 4)
{
if (entity.Sfypz == "是")
{
YwDataService service = new YwDataService();
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
}
}
else
{
YwDataService service = new YwDataService();
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
}
int count = baseDao.Update(entity);
if (count <= 0)
{
errmsg = "数据在页面显示后被其他人修改过，请重新打开编辑";
task.ParentRebind = true;
task.Rebind = true;
task.IsClose = true;
return(false);
}
//文件压缩
//删除压缩文件
att.Type = "2";
baseDao.DeleteUdf("YwAttachDeleteByType", att);
//重新压缩附件
if (attList != null && attList.Count > 0)
{
string zipdic = attList[0].Dic;
string zipFileN = Guid.NewGuid().ToString() + ".zip";
string path = zipdic + zipFileN;
using (ZipFile zip = ZipFile.Create(@path))
{
zip.BeginUpdate();
foreach (YwAttach attTemp in attList)
{
string pathT = attTemp.Dic + attTemp.FileN;
zip.Add(@pathT, attTemp.FileN);
}
zip.CommitUpdate();
}
att.Type = "2";
att.Dic = zipdic;
att.FileN = zipFileN;
att.RealName = zipFileN;
att.Dataid = entity.Did;
baseDao.Insert(att);
}
if (result == true)
{
errmsg = "保存成功";
task.ParentRebind = true;
task.IsClose = true;
}
this.CommitTran();
}
catch (Exception ex)
{
this.RollbackTran();
errmsg = ex.Message;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
YwAttach att = new YwAttach();
att.Dataid = Entity.Did;
att.Type = "1";
BaseDao baseDao = new BaseDao();
IList<YwAttach> list = baseDao.List(att);
if (list.Count > 0)
{
string pic = System.Configuration.ConfigurationManager.AppSettings["Pic"].Trim();
string[] picArr = pic.Split('|');
int index = 0;
foreach (YwAttach temp in list)
{
index++;
string title = "<hr/><h4>附件" + index + ":" + temp.RealName + "</h4>";
string[] arr = temp.FileN.Split('.');
string tailT = arr[arr.Length - 1].Trim().ToUpper();
string[] pathArr = temp.Dic.Split('\\');
string relPath = "";
bool enter = false;
for (int i = 0; i < pathArr.Length; i++)
{
if (pathArr[i] == "")
{
continue;
}
if (pathArr[i] == "upload" || enter == true)
{
relPath += pathArr[i] + "\\";
enter = true;
}
}
bool isPic = false;
foreach (string picT in picArr)
{
if (tailT == picT)
{
Image img = new Image();
img.ImageUrl = relPath + temp.FileN;
title += "<a href='" + relPath + temp.FileN + "'>下载</a><hr/>";
this.panCon.Controls.Add(new LiteralControl(title));
this.panCon.Controls.Add(img);
isPic = true;
break;
}
}
if (isPic == true)
{
continue;
}
HyperLink link = new HyperLink();
link.NavigateUrl = relPath + temp.FileN;
link.Text = temp.RealName;
title += "<a href='" + relPath + temp.FileN + "'>下载</a><hr/>";
this.panCon.Controls.Add(new LiteralControl(title));
this.panCon.Controls.Add(link);
}
}
else
{
Label lab = new Label();
lab.Text = "没有附件";
this.panCon.Controls.Add(lab);
}
}
}