private FrmAttachmentDBs LoadAttach(BP.Sys.FrmAttachment athDesc)
{
BP.Sys.FrmAttachmentDBs dbs = new BP.Sys.FrmAttachmentDBs();
if (athDesc.HisCtrlWay == AthCtrlWay.PWorkID)
{
string pWorkID = BP.DA.DBAccess.RunSQLReturnValInt("SELECT PWorkID FROM WF_GenerWorkFlow WHERE WorkID=" + this.PKVal, 0).ToString();
if (pWorkID == null || pWorkID == "0")
{
pWorkID = this.PKVal;
}
if (athDesc.AthUploadWay == AthUploadWay.Inherit)
{
/* 继承模式 */
BP.En.QueryObject qo = new BP.En.QueryObject(dbs);
qo.AddWhere(FrmAttachmentDBAttr.RefPKVal, pWorkID);
qo.addOr();
qo.AddWhere(FrmAttachmentDBAttr.RefPKVal, int.Parse(this.PKVal));
qo.addOrderBy("Idx");
qo.DoQuery();
}
if (athDesc.AthUploadWay == AthUploadWay.Interwork)
{
/*共享模式*/
//dbs.Retrieve(FrmAttachmentDBAttr.RefPKVal, pWorkID);
BP.En.QueryObject qo = new BP.En.QueryObject(dbs);
qo.AddWhere(FrmAttachmentDBAttr.RefPKVal, pWorkID);
qo.addOrderBy("Idx");
qo.DoQuery();
}
}
else
{
int num = dbs.Retrieve(FrmAttachmentDBAttr.FK_FrmAttachment, this.FK_FrmAttachment,
FrmAttachmentDBAttr.RefPKVal, this.PKVal, "Idx");
if (num == 0 && this.IsCC == "1")
{
CCList cc = new CCList();
int nnn = cc.Retrieve(CCListAttr.FK_Node, this.FK_Node, CCListAttr.WorkID, this.WorkID, CCListAttr.CCTo, WebUser.No);
if (cc.NDFrom != 0)
{
this._fk_node = cc.NDFrom;
dbs.Retrieve(FrmAttachmentDBAttr.FK_FrmAttachment, this.FK_FrmAttachmentExt,
FrmAttachmentDBAttr.FK_MapData, "ND" + cc.NDFrom, FrmAttachmentDBAttr.RefPKVal, this.WorkID.ToString());
//重新设置文件描述。
athDesc.Retrieve(FrmAttachmentAttr.FK_MapData, this.FK_MapData, FrmAttachmentAttr.NoOfObj, "DocMultiAth");
}
}
}
return(dbs);
}
/// <summary>
/// 测试抄送
/// </summary>
public void TestCC()
{
string sUser = "******";
BP.WF.Dev2Interface.Port_Login(sUser);
//创建.
workID = BP.WF.Dev2Interface.Node_CreateBlankWork(fl.No, null, null, WebUser.No, null, 0, null);
//执行发送.
BP.WF.Dev2Interface.Node_SendWork(fl.No, workID);
//执行移交.
BP.WF.Dev2Interface.Node_CC(fl.No, workID, "zhoushengyu", "移交测试");
//让 zhoushengyu 登陆.
BP.WF.Dev2Interface.Port_Login("zhoushengyu");
#region 检查预期结果.
sql = "SELECT FK_Emp FROM WF_EmpWorks WHERE WorkID=" + workID;
dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count == 0)
{
throw new Exception("@移交后待办丢失。");
}
if (dt.Rows.Count != 1)
{
throw new Exception("@应该只有一个人处于待办状态。");
}
if (dt.Rows[0][0].ToString() != "zhoupeng")
{
throw new Exception("@应该是:zhoupeng 现在是:" + dt.Rows[0][0].ToString());
}
CCList list = new CCList();
int num = list.Retrieve(CCListAttr.Rec, sUser, CCListAttr.WorkID, workID);
if (num <= 0)
{
throw new Exception("@没有写入抄送数据在 WF_CCList 表中,查询的数量是:" + num);
}
#endregion 检查预期结果
}
protected void Page_Load(object sender, EventArgs e)
{
MapData md = new MapData(this.FK_MapData);
FrmAttachment athDesc = new FrmAttachment();
int i = athDesc.Retrieve(FrmAttachmentAttr.FK_MapData,
this.FK_MapData, FrmAttachmentAttr.NoOfObj, "DocMainAth");
if (i == 0)
{
/*如果没有数据.*/
/*如果没有查询到它,就有可能是公文多附件被删除了.*/
athDesc.NoOfObj = "DocMainAth";
athDesc.Exts = "doc,docx,xls,xlsx";
athDesc.MyPK = athDesc.FK_MapData + "_" + athDesc.NoOfObj;
athDesc.FK_MapData = this.FK_MapData;
//存储路径.
string path = Server.MapPath("/DataUser/UploadFile/");
path += "\\F" + this.FK_Flow + "MainAth";
athDesc.SaveTo = path;
//位置.
athDesc.X = (float)94.09;
athDesc.Y = (float)140.18;
athDesc.W = (float)626.36;
athDesc.H = (float)150;
//多附件.
athDesc.UploadType = AttachmentUploadType.Single;
athDesc.Name = "公文正文(系统自动增加)";
athDesc.SetValByKey("AtPara",
"@IsWoEnablePageset=1@IsWoEnablePrint=1@IsWoEnableViewModel=1@IsWoEnableReadonly=0@IsWoEnableSave=1@IsWoEnableWF=1@IsWoEnableProperty=1@IsWoEnableRevise=1@IsWoEnableIntoKeepMarkModel=1@FastKeyIsEnable=0@IsWoEnableViewKeepMark=1@FastKeyGenerRole=@IsWoEnableTemplete=1");
athDesc.Insert();
//有可能在其其它的节点上没有这个附件，所以也要循环增加上它.
BP.WF.Nodes nds = new Nodes(this.FK_Flow);
foreach (Node nd in nds)
{
athDesc.FK_MapData = "ND" + nd.NodeID;
athDesc.MyPK = athDesc.FK_MapData + "_" + athDesc.NoOfObj;
if (athDesc.IsExits == true)
{
continue;
}
athDesc.Insert();
}
//重新查询一次，把默认值加上.
athDesc.RetrieveFromDBSources();
}
FrmAttachmentDBs athDBs = null;
athDBs = new FrmAttachmentDBs(this.FK_MapData, this.WorkID.ToString());
FrmAttachmentDB athDB = null;
if (athDBs.Count == 0 && this.IsCC == "1")
{
/*如果是抄送过来的, 有可能是抄送到的节点不是发送到的节点，导致附件数据没有copy。
* 也就是说，发给b节点，但是抄送到c节点上去了，导致c节点上的人看不到附件数据。*/
CCList cc = new CCList();
int nnn = cc.Retrieve(CCListAttr.FK_Node, this.FK_Node, CCListAttr.WorkID, this.WorkID, CCListAttr.CCTo, WebUser.No);
this._fk_node = cc.NDFrom;
if (cc.NDFrom != 0)
{
athDBs.Retrieve(FrmAttachmentDBAttr.FK_MapData, "ND" + cc.NDFrom, FrmAttachmentDBAttr.RefPKVal, this.WorkID.ToString());
string ndFromMapdata = athDesc.MyPK.Replace(athDesc.FK_MapData, "ND" + cc.NDFrom);
athDB = athDBs.GetEntityByKey(FrmAttachmentDBAttr.FK_FrmAttachment, ndFromMapdata) as FrmAttachmentDB;
//重新设置文件描述。
athDesc.Retrieve(FrmAttachmentAttr.FK_MapData, this.FK_MapData, FrmAttachmentAttr.NoOfObj, "DocMainAth");
}
}
else
{
/* 单个文件 */
athDB = athDBs.GetEntityByKey(FrmAttachmentDBAttr.FK_FrmAttachment, athDesc.MyPK) as FrmAttachmentDB;
}
Label lab = new Label();
lab.ID = "Lab" + athDesc.MyPK;
this.Pub1.Add(lab);
if (athDB != null)
{
if (athDB.FileExts == "ceb")
{
athDB.FileExts = "pdf";
}
if (athDesc.IsWoEnableWF)
{
lab.Text = "<a href=\"javascript:OpenOfiice('" + athDB.FK_FrmAttachment + "','" + this.WorkID + "','" + athDB.MyPK + "','" + this.FK_MapData + "','" + athDesc.NoOfObj + "','" + this.FK_Node + "')\"><img src='" + BP.WF.Glo.CCFlowAppPath + "WF/Img/FileType/" + athDB.FileExts + ".gif' border=0/>" + athDB.FileName + "</a>";
}
else
{
lab.Text = "<img src='" + BP.WF.Glo.CCFlowAppPath + "WF/Img/FileType/" + athDB.FileExts + ".gif' border=0/>" + athDB.FileName;
}
}
#region 处理权限问题.
// 处理权限问题, 有可能当前节点是可以上传或者删除，但是当前节点上不能让此人执行工作。
bool isDel = athDesc.IsDeleteInt == 0 ? false : true;
bool isUpdate = athDesc.IsUpload;
if (isDel == true || isUpdate == true)
{
if (this.WorkID != 0 &&
string.IsNullOrEmpty(this.FK_Flow) == false)
{
isDel = BP.WF.Dev2Interface.Flow_IsCanDoCurrentWork(this.FK_Flow, this.FK_Node, this.WorkID, WebUser.No);
if (isDel == false)
{
isUpdate = false;
}
}
}
#endregion 处理权限问题.
Button mybtn = new Button();
mybtn.CssClass = "Btn";
if (athDesc.IsUpload && isUpdate == true)
{
FileUpload fu = new FileUpload();
fu.ID = athDesc.MyPK;
Btn_Upload.ID = "Btn_Upload_" + athDesc.MyPK + "_" + this.WorkID;
fu.Attributes["Width"] = athDesc.W.ToString();
fu.Attributes["onchange"] = "UploadChange('" + mybtn.ID + "');";
this.Pub1.Add(fu);
}
if (athDesc.IsDownload)
{
mybtn = new Button();
mybtn.Text = "下载";
mybtn.CssClass = "Btn";
mybtn.ID = "Btn_Download_" + athDesc.MyPK + "_" + this.WorkID;
mybtn.Click += new EventHandler(btnUpload_Click);
mybtn.CssClass = "bg";
if (athDB == null)
{
mybtn.Visible = false;
}
else
{
mybtn.Visible = true;
}
this.Pub1.Add(mybtn);
}
if (this.IsReadonly == false)
{
if (athDesc.IsDeleteInt != 0 && isDel == true)
{
bool isDeleteBtn = true;
if (athDesc.IsDeleteInt == 2)
{
if (!athDB.Rec.Equals(WebUser.No))
{
isDeleteBtn = false;
}
}
if (isDeleteBtn)
{
mybtn = new Button();
mybtn.CssClass = "Btn";
mybtn.Text = "删除";
mybtn.Attributes["onclick"] = " return confirm('您确定要执行删除吗？');";
mybtn.ID = "Btn_Delete_" + athDesc.MyPK + "_" + this.WorkID;
mybtn.Click += new EventHandler(btnUpload_Click);
mybtn.CssClass = "bg";
if (athDB == null)
{
mybtn.Visible = false;
}
else
{
mybtn.Visible = true;
}
this.Pub1.Add(mybtn);
}
}
if (athDesc.IsWoEnableWF)
{
mybtn = new Button();
mybtn.CssClass = "Btn";
mybtn.Text = "打开";
mybtn.ID = "Btn_Open_" + athDesc.MyPK + "_" + this.WorkID;
mybtn.Click += new EventHandler(btnUpload_Click);
mybtn.CssClass = "bg";
if (athDB == null)
{
mybtn.Visible = false;
}
else
{
mybtn.Visible = true;
}
this.Pub1.Add(mybtn);
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
Response.AddHeader("P3P", "CP=CAO PSA OUR");
Response.AddHeader("Cache-Control", "no-store");
Response.AddHeader("Expires", "0");
Response.AddHeader("Pragma", "no-cache");
string url = this.Request.RawUrl;
if (url.Contains("DTT=") == false)
{
//this.Response.Redirect(url + "&DTT=" + DateTime.Now.ToString("mmDDhhmmss"), true);
//return;
}
try
{
switch (this.ActionType)
{
case "Focus": //把任务放入任务池.
BP.WF.Dev2Interface.Flow_Focus(Int64.Parse(this.Request.QueryString["WorkID"]));
this.WinClose("ss");
break;
case "PutOne": //把任务放入任务池.
Int64 workid42 = Int64.Parse(this.Request.QueryString["WorkID"]);
BP.WF.Dev2Interface.Node_TaskPoolPutOne(workid42);
this.WinClose("ss");
break;
case "DoAppTask": // 申请任务.
Int64 workid2 = Int64.Parse(this.Request.QueryString["WorkID"]);
BP.WF.Dev2Interface.Node_TaskPoolTakebackOne(workid2);
this.WinClose("ss");
return;
case "DoOpenCC":
string fk_flow1 = this.Request.QueryString["FK_Flow"];
string fk_node1 = this.Request.QueryString["FK_Node"];
string workid1 = this.Request.QueryString["WorkID"];
string fid1 = this.Request.QueryString["FID"];
string Sta = this.Request.QueryString["Sta"];
if (Sta == "0")
{
BP.WF.Template.CCList cc1 = new BP.WF.Template.CCList();
cc1.MyPK = this.Request.QueryString["MyPK"];
cc1.Retrieve();
cc1.HisSta = CCSta.Read;
cc1.Update();
}
this.Response.Redirect("./WorkOpt/OneWork/Track.aspx?FK_Flow=" + fk_flow1 + "&FK_Node=" + fk_node1 + "&WorkID=" + workid1 + "&FID=" + fid1, false);
return;
case "DelCC": //删除抄送.
CCList cc = new CCList();
cc.MyPK = this.MyPK;
cc.Retrieve();
cc.HisSta = CCSta.Del;
cc.Update();
this.WinClose();
break;
case "DelSubFlow": //删除进程。
try
{
BP.WF.Dev2Interface.Flow_DeleteSubThread(this.FK_Flow, this.WorkID, "手工删除");
this.WinClose();
}
catch (Exception ex)
{
this.WinCloseWithMsg(ex.Message);
}
break;
case "DownBill":
Bill b = new Bill(this.MyPK);
b.DoOpen();
break;
case "DelDtl":
GEDtls dtls = new GEDtls(this.EnsName);
GEDtl dtl = (GEDtl)dtls.GetNewEntity;
dtl.OID = this.RefOID;
if (dtl.RetrieveFromDBSources() == 0)
{
this.WinClose();
break;
}
FrmEvents fes = new FrmEvents(this.EnsName); //获得事件.
// 处理删除前事件.
try
{
fes.DoEventNode(BP.WF.XML.EventListDtlList.DtlItemDelBefore, dtl);
}
catch (Exception ex)
{
this.WinCloseWithMsg(ex.Message);
break;
}
dtl.Delete();
// 处理删除后事件.
try
{
fes.DoEventNode(BP.WF.XML.EventListDtlList.DtlItemDelAfter, dtl);
}
catch (Exception ex)
{
this.WinCloseWithMsg(ex.Message);
break;
}
this.WinClose();
break;
case "EmpDoUp":
BP.WF.Port.WFEmp ep = new BP.WF.Port.WFEmp(this.RefNo);
ep.DoUp();
BP.WF.Port.WFEmps emps111 = new BP.WF.Port.WFEmps();
// emps111.RemoveCash();
emps111.RetrieveAll();
this.WinClose();
break;
case "EmpDoDown":
BP.WF.Port.WFEmp ep1 = new BP.WF.Port.WFEmp(this.RefNo);
ep1.DoDown();
BP.WF.Port.WFEmps emps11441 = new BP.WF.Port.WFEmps();
// emps11441.RemoveCash();
emps11441.RetrieveAll();
this.WinClose();
break;
case "Track": //通过一个串来打开一个工作.
string mySid = this.Request.QueryString["SID"];
string[] mystrs = mySid.Split('_');
Int64 myWorkID = int.Parse(mystrs[1]);
string fk_emp = mystrs[0];
int fk_node = int.Parse(mystrs[2]);
Node mynd = new Node();
mynd.NodeID = fk_node;
mynd.RetrieveFromDBSources();
string fk_flow = mynd.FK_Flow;
string myurl = "./WorkOpt/OneWork/Track.aspx?FK_Node=" + mynd.NodeID + "&WorkID=" + myWorkID + "&FK_Flow=" + fk_flow;
Web.WebUser.SignInOfGener(new BP.Port.Emp(fk_emp), true);
this.Response.Write("<script> window.location.href='" + myurl + "'</script> *^_^* <br><br>正在进入系统请稍后，如果长时间没有反应，请<a href='" + myurl + "'>点这里进入。</a>");
return;
case "OF": //通过一个串来打开一个工作.
string sid = this.Request.QueryString["SID"];
string[] strs = sid.Split('_');
GenerWorkerList wl = new GenerWorkerList();
int i = wl.Retrieve(GenerWorkerListAttr.FK_Emp, strs[0],
GenerWorkerListAttr.WorkID, strs[1],
GenerWorkerListAttr.FK_Node, strs[2]);
if (i == 0)
{
this.Response.Write("<h2>提示</h2>此工作已经被别人处理或者此流程已删除。");
return;
}
BP.Port.Emp empOF = new BP.Port.Emp(wl.FK_Emp);
Web.WebUser.SignInOfGener(empOF, true);
string u = "MyFlow.aspx?FK_Flow=" + wl.FK_Flow + "&WorkID=" + wl.WorkID + "&FK_Node=" + wl.FK_Node + "&FID=" + wl.FID;
this.Response.Write("<script> window.location.href='" + u + "'</script> *^_^* <br><br>正在进入系统请稍后，如果长时间没有反应，请<a href='" + u + "'>点这里进入。</a>");
return;
case "ExitAuth":
BP.Port.Emp emp = new BP.Port.Emp(this.FK_Emp);
//首先退出，再进行登录
BP.Web.WebUser.Exit();
BP.Web.WebUser.SignInOfGenerLang(emp, WebUser.SysLang);
this.WinClose();
return;
case "LogAs":
BP.WF.Port.WFEmp wfemp = new BP.WF.Port.WFEmp(this.FK_Emp);
if (wfemp.AuthorIsOK == false)
{
this.WinCloseWithMsg("授权失败");
return;
}
BP.Port.Emp emp1 = new BP.Port.Emp(this.FK_Emp);
BP.Web.WebUser.SignInOfGener(emp1, WebUser.SysLang, WebUser.No, true, false);
this.WinClose();
return;
case "TakeBack": // 取消授权。
BP.WF.Port.WFEmp myau = new BP.WF.Port.WFEmp(WebUser.No);
BP.DA.Log.DefaultLogWriteLineInfo("取消授权:" + WebUser.No + "取消了对(" + myau.Author + ")的授权。");
myau.Author = "";
myau.AuthorWay = 0;
myau.Update();
this.WinClose();
return;
case "AutoTo": // 执行授权。
BP.WF.Port.WFEmp au = new BP.WF.Port.WFEmp();
au.No = WebUser.No;
au.RetrieveFromDBSources();
au.AuthorDate = BP.DA.DataType.CurrentData;
au.Author = this.FK_Emp;
au.AuthorWay = 1;
au.Save();
BP.DA.Log.DefaultLogWriteLineInfo("执行授权:" + WebUser.No + "执行了对(" + au.Author + ")的授权。");
this.WinClose();
return;
case "UnSend": //执行撤消发送。
this.Response.Redirect("./WorkOpt/UnSend.aspx?WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow, false);
return;
case "SetBillState":
break;
case "WorkRpt":
Bill bk1 = new Bill(this.Request.QueryString["OID"]);
Node nd = new Node(bk1.FK_Node);
this.Response.Redirect("WFRpt.aspx?WorkID=" + bk1.WorkID + "&FID=" + bk1.FID + "&FK_Flow=" + nd.FK_Flow + "&NodeId=" + bk1.FK_Node, false);
//this.WinOpen();
//this.WinClose();
break;
case "PrintBill":
//Bill bk2 = new Bill(this.Request.QueryString["OID"]);
//Node nd2 = new Node(bk2.FK_Node);
//this.Response.Redirect("NodeRefFunc.aspx?NodeId=" + bk2.FK_Node + "&FlowNo=" + nd2.FK_Flow + "&NodeRefFuncOID=" + bk2.FK_NodeRefFunc + "&WorkFlowID=" + bk2.WorkID);
////this.WinClose();
break;
//删除流程中第一个节点的数据，包括待办工作
case "DeleteFlow":
string fk_flowDel = this.Request.QueryString["FK_Flow"];
Int64 workid = Int64.Parse(this.Request.QueryString["WorkID"]);
//调用DoDeleteWorkFlowByReal方法
WorkFlow wf = new WorkFlow(new Flow(fk_flowDel), workid);
wf.DoDeleteWorkFlowByReal(true);
// Glo.ToMsg("流程删除成功");
BP.WF.Glo.ToMsg("流程删除成功");
//this.ToWFMsgPage("流程删除成功");
break;
default:
throw new Exception("ActionType error" + this.ActionType);
}
}
catch (Exception ex)
{
this.ToErrorPage("执行其间如下异常：<BR>" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.Response.ContentEncoding = System.Text.UTF8Encoding.UTF8;
this.Request.ContentEncoding = System.Text.UTF8Encoding.UTF8;
#region 功能执行.
if (this.DoType == "Del")
{
FrmAttachmentDB delDB = new FrmAttachmentDB();
delDB.MyPK = this.DelPKVal == null ? this.MyPK : this.DelPKVal;
delDB.DirectDelete();
}
if (this.DoType == "Down")
{
FrmAttachmentDB downDB = new FrmAttachmentDB();
downDB.MyPK = this.DelPKVal == null ? this.MyPK : this.DelPKVal;
downDB.Retrieve();
string downpath = GetRealPath(downDB.FileFullName);
BP.Sys.PubClass.DownloadFile(downpath, downDB.FileName);
this.WinClose();
return;
}
if (this.DoType == "WinOpen")
{
FrmAttachmentDB downDB = new FrmAttachmentDB();
downDB.MyPK = this.MyPK;
downDB.Retrieve();
Response.ContentType = "Application/pdf";
string downpath = GetRealPath(downDB.FileFullName);
Response.WriteFile(downpath);
Response.End();
return;
}
#endregion 功能执行.
#region 处理权限控制.
BP.Sys.FrmAttachment athDesc = new BP.Sys.FrmAttachment();
athDesc.MyPK = this.FK_FrmAttachment;
if (this.FK_Node == null || this.FK_Flow == null)
{
athDesc.RetrieveFromDBSources();
}
else
{
#region 判断是否可以查询出来，如果查询不出来，就可能是公文流程。
athDesc.MyPK = this.FK_FrmAttachment;
if (athDesc.RetrieveFromDBSources() == 0 && string.IsNullOrEmpty(this.FK_Flow) == false)
{
/*如果没有查询到它,就有可能是公文多附件被删除了.*/
athDesc.MyPK = this.FK_FrmAttachment;
athDesc.NoOfObj = "DocMultiAth";
athDesc.FK_MapData = this.FK_MapData;
athDesc.Exts = "*.*";
//存储路径.
athDesc.SaveTo = "/DataUser/UploadFile/";
athDesc.IsNote = false; //不显示note字段.
athDesc.IsVisable = false; // 让其在form 上不可见.
//位置.
athDesc.X = (float)94.09;
athDesc.Y = (float)333.18;
athDesc.W = (float)626.36;
athDesc.H = (float)150;
//多附件.
athDesc.UploadType = AttachmentUploadType.Multi;
athDesc.Name = "公文多附件(系统自动增加)";
athDesc.SetValByKey("AtPara",
"@IsWoEnablePageset=1@IsWoEnablePrint=1@IsWoEnableViewModel=1@IsWoEnableReadonly=0@IsWoEnableSave=1@IsWoEnableWF=1@IsWoEnableProperty=1@IsWoEnableRevise=1@IsWoEnableIntoKeepMarkModel=1@FastKeyIsEnable=0@IsWoEnableViewKeepMark=1@FastKeyGenerRole=@IsWoEnableTemplete=1");
athDesc.Insert();
//有可能在其其它的节点上没有这个附件，所以也要循环增加上它.
BP.WF.Nodes nds = new BP.WF.Nodes(this.FK_Flow);
foreach (BP.WF.Node nd in nds)
{
athDesc.FK_MapData = "ND" + nd.NodeID;
athDesc.MyPK = athDesc.FK_MapData + "_" + athDesc.NoOfObj;
if (athDesc.IsExits == true)
{
continue;
}
athDesc.Insert();
}
//重新查询一次，把默认值加上.
athDesc.RetrieveFromDBSources();
}
#endregion 判断是否可以查询出来，如果查询不出来，就可能是公文流程。
#region 处理权限方案。
/*首先判断是否具有权限方案*/
string at = BP.Sys.SystemConfig.AppCenterDBVarStr;
Paras ps = new BP.DA.Paras();
ps.SQL = "SELECT FrmSln FROM WF_FrmNode WHERE FK_Node=" + at + "FK_Node AND FK_Flow=" + at + "FK_Flow AND FK_Frm=" + at + "FK_Frm";
ps.Add("FK_Node", this.FK_Node);
ps.Add("FK_Flow", this.FK_Flow);
ps.Add("FK_Frm", this.FK_MapData);
DataTable dt = DBAccess.RunSQLReturnTable(ps);
if (dt.Rows.Count == 0)
{
athDesc.RetrieveFromDBSources();
}
else
{
int sln = int.Parse(dt.Rows[0][0].ToString());
if (sln == 0)
{
athDesc.RetrieveFromDBSources();
}
else
{
int result = athDesc.Retrieve(FrmAttachmentAttr.FK_MapData, this.FK_MapData,
FrmAttachmentAttr.FK_Node, this.FK_Node, FrmAttachmentAttr.NoOfObj, this.Ath);
if (result == 0) /*如果没有定义，就获取默认的.*/
{
athDesc.RetrieveFromDBSources();
}
// throw new Exception("@该流程表单在该节点("+this.FK_Node+")使用的是自定义的权限控制，但是没有定义该附件的权限。");
}
}
#endregion 处理权限方案。
}
BP.Sys.FrmAttachmentDBs dbs = new BP.Sys.FrmAttachmentDBs();
if (athDesc.HisCtrlWay == AthCtrlWay.PWorkID)
{
string pWorkID = BP.DA.DBAccess.RunSQLReturnValInt("SELECT PWorkID FROM WF_GenerWorkFlow WHERE WorkID=" + this.PKVal, 0).ToString();
if (pWorkID == null || pWorkID == "0")
{
pWorkID = this.PKVal;
}
if (athDesc.AthUploadWay == AthUploadWay.Inherit)
{
/* 继承模式 */
BP.En.QueryObject qo = new BP.En.QueryObject(dbs);
qo.AddWhere(FrmAttachmentDBAttr.RefPKVal, pWorkID);
qo.addOr();
qo.AddWhere(FrmAttachmentDBAttr.RefPKVal, int.Parse(this.PKVal));
qo.addOrderBy("RDT");
qo.DoQuery();
}
if (athDesc.AthUploadWay == AthUploadWay.Interwork)
{
/*共享模式*/
dbs.Retrieve(FrmAttachmentDBAttr.RefPKVal, pWorkID);
}
}
else
{
int num = dbs.Retrieve(FrmAttachmentDBAttr.FK_FrmAttachment, this.FK_FrmAttachment,
FrmAttachmentDBAttr.RefPKVal, this.PKVal, "RDT");
if (num == 0 && this.IsCC == "1")
{
CCList cc = new CCList();
int nnn = cc.Retrieve(CCListAttr.FK_Node, this.FK_Node, CCListAttr.WorkID, this.WorkID, CCListAttr.CCTo, WebUser.No);
if (cc.NDFrom != 0)
{
this._fk_node = cc.NDFrom;
dbs.Retrieve(FrmAttachmentDBAttr.FK_FrmAttachment, this.FK_FrmAttachmentExt,
FrmAttachmentDBAttr.FK_MapData, "ND" + cc.NDFrom, FrmAttachmentDBAttr.RefPKVal, this.WorkID.ToString());
//重新设置文件描述。
athDesc.Retrieve(FrmAttachmentAttr.FK_MapData, this.FK_MapData, FrmAttachmentAttr.NoOfObj, "DocMultiAth");
}
}
}
#endregion 处理权限控制.
#region 生成表头表体.
this.Title = athDesc.Name;
#region 如果图片显示.
if (athDesc.FileShowWay == FileShowWay.Pict)
{
/* 如果是图片轮播，就在这里根据数据输出轮播的html代码.*/
if (dbs.Count == 0 && athDesc.IsUpload == true)
{
/*没有数据并且，可以上传,就转到上传的界面上去.*/
this.Response.Redirect("AttachmentUploadImg.aspx?1=1" + this.RequestParas, true);
return;
}
if (dbs.Count != 0)
{
/*有数据，就输出.*/
this.Pub1.Add("<div class='slideBox' id='" + athDesc.MyPK + "' style='width:" + athDesc.W + "px;height:" + athDesc.H + "px; position:relative; overflow:hidden;'>");
this.Pub1.Add("<ul class='items'> ");
foreach (FrmAttachmentDB db in dbs)
{
if (BP.DA.DataType.IsImgExt(db.FileExts) == false)
{
continue;
}
if (athDesc.IsDelete != false)
{
if (athDesc.IsDelete == true)
{
this.Pub1.Add("<li> <a title='" + db.MyNote + "'><img src = '" + db.FileFullName + "' width=" + athDesc.W + " height=" + athDesc.H + "/></a> | <a href=\"javascript:Del('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">删除</a></li>");
}
else if (athDesc.IsDeleteInt == 2)
{
if (db.Rec.Equals(WebUser.No))
{
this.Pub1.Add("<li> <a title='" + db.MyNote + "'><img src = '" + db.FileFullName + "' width=" + athDesc.W + " height=" + athDesc.H + "/></a> | <a href=\"javascript:Del('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">删除</a></li>");
}
}
else
{
this.Pub1.Add("<li> <a title='" + db.MyNote + "'><img src = '" + db.FileFullName + "' width=" + athDesc.W + " height=" + athDesc.H + "/></a> </li>");
}
}
else
{
this.Pub1.Add("<li> <a title='" + db.MyNote + "'><img src = '" + db.FileFullName + "' width=" + athDesc.W + " height=" + athDesc.H + "/></a> </li>");
}
}
this.Pub1.Add("</ul>");
this.Pub1.Add("</div>");
this.Pub1.Add("<script>$(function(){$('#" + athDesc.MyPK + "').slideBox({duration : 0.3,easing : 'linear',delay : 5,hideClickBar : false,clickBarRadius : 10});})</script>");
}
if (athDesc.IsUpload == true)
{
/*可以上传,就显示上传的按钮.. */
this.Pub1.Add("<a href='AttachmentUploadImg.aspx?1=1" + this.RequestParas + "' >上传</a>");
}
return;
}
#endregion 如果图片显示.
float athWidth = athDesc.W - 20;
// 执行装载模版.
if (dbs.Count == 0 && athDesc.IsWoEnableTemplete == true)
{
/*如果数量为0,就检查一下是否有模版如果有就加载模版文件.*/
string templetePath = BP.Sys.SystemConfig.PathOfDataUser + "AthTemplete\\" + athDesc.NoOfObj.Trim();
if (Directory.Exists(templetePath) == false)
{
Directory.CreateDirectory(templetePath);
}
/*有模版文件夹*/
DirectoryInfo mydir = new DirectoryInfo(templetePath);
FileInfo[] fls = mydir.GetFiles();
if (fls.Length == 0)
{
throw new Exception("@流程设计错误，该多附件启用了模版组件，模版目录:" + templetePath + "里没有模版文件.");
}
foreach (FileInfo fl in fls)
{
if (System.IO.Directory.Exists(athDesc.SaveTo) == false)
{
System.IO.Directory.CreateDirectory(athDesc.SaveTo);
}
int oid = BP.DA.DBAccess.GenerOID();
string saveTo = athDesc.SaveTo + "\\" + oid + "." + fl.Name.Substring(fl.Name.LastIndexOf('.') + 1);
if (saveTo.Contains("@") == true || saveTo.Contains("*") == true)
{
/*如果有变量*/
saveTo = saveTo.Replace("*", "@");
if (saveTo.Contains("@") && this.FK_Node != null)
{
/*如果包含 @ */
BP.WF.Flow flow = new BP.WF.Flow(this.FK_Flow);
BP.WF.Data.GERpt myen = flow.HisGERpt;
myen.OID = this.WorkID;
myen.RetrieveFromDBSources();
saveTo = BP.WF.Glo.DealExp(saveTo, myen, null);
}
if (saveTo.Contains("@") == true)
{
throw new Exception("@路径配置错误,变量没有被正确的替换下来." + saveTo);
}
}
fl.CopyTo(saveTo);
FileInfo info = new FileInfo(saveTo);
FrmAttachmentDB dbUpload = new FrmAttachmentDB();
dbUpload.CheckPhysicsTable();
dbUpload.MyPK = athDesc.FK_MapData + oid.ToString();
dbUpload.NodeID = FK_Node.ToString();
dbUpload.FK_FrmAttachment = this.FK_FrmAttachment;
if (athDesc.AthUploadWay == AthUploadWay.Inherit)
{
/*如果是继承，就让他保持本地的PK. */
dbUpload.RefPKVal = this.PKVal.ToString();
}
if (athDesc.AthUploadWay == AthUploadWay.Interwork)
{
/*如果是协同，就让他是PWorkID. */
string pWorkID = BP.DA.DBAccess.RunSQLReturnValInt("SELECT PWorkID FROM WF_GenerWorkFlow WHERE WorkID=" + this.PKVal, 0).ToString();
if (pWorkID == null || pWorkID == "0")
{
pWorkID = this.PKVal;
}
dbUpload.RefPKVal = pWorkID;
}
dbUpload.FK_MapData = athDesc.FK_MapData;
dbUpload.FK_FrmAttachment = this.FK_FrmAttachment;
dbUpload.FileExts = info.Extension;
dbUpload.FileFullName = saveTo;
dbUpload.FileName = fl.Name;
dbUpload.FileSize = (float)info.Length;
dbUpload.RDT = DataType.CurrentDataTime;
dbUpload.Rec = BP.Web.WebUser.No;
dbUpload.RecName = BP.Web.WebUser.Name;
//if (athDesc.IsNote)
// dbUpload.MyNote = this.Pub1.GetTextBoxByID("TB_Note").Text;
//if (athDesc.Sort.Contains(","))
// dbUpload.Sort = this.Pub1.GetDDLByID("ddl").SelectedItemStringVal;
dbUpload.Insert();
dbs.AddEntity(dbUpload);
}
//BP.Sys.FrmAttachmentDBs dbs = new BP.Sys.FrmAttachmentDBs();
}
#region 处理权限问题.
// 处理权限问题, 有可能当前节点是可以上传或者删除，但是当前节点上不能让此人执行工作。
bool isDel = athDesc.IsDeleteInt == 0 ? false : true;
bool isUpdate = athDesc.IsUpload;
if (isDel == true || isUpdate == true)
{
if (this.WorkID != 0 &&
string.IsNullOrEmpty(this.FK_Flow) == false &&
this.FK_Node != 0)
{
isDel = BP.WF.Dev2Interface.Flow_IsCanDoCurrentWork(this.FK_Flow, this.FK_Node, this.WorkID, WebUser.No);
if (isDel == false)
{
isUpdate = false;
}
}
}
#endregion 处理权限问题.
if (athDesc.FileShowWay == FileShowWay.Free)
{
this.Pub1.AddTable("border='0' cellspacing='0' cellpadding='0' style='width:" + athWidth + "px'");
foreach (FrmAttachmentDB db in dbs)
{
this.Pub1.AddTR();
if (CanEditor(db.FileExts))
{
if (athDesc.IsWoEnableWF)
{
this.Pub1.AddTD("<a href=\"javascript:OpenOfiice('" + this.FK_FrmAttachment + "','" +
this.WorkID + "','" + db.MyPK + "','" + this.FK_MapData + "','" + this.Ath +
"','" + this.FK_Node + "')\"><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
else
{
this.Pub1.AddTD("<a href=\"javascript:OpenView('" + this.PKVal + "','" + db.MyPK +
"')\"><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
}
else if (DataType.IsImgExt(db.FileExts) || db.FileExts.ToUpper() == "PDF" || db.FileExts.ToUpper() == "CEB")
{
this.Pub1.AddTD("<a href=\"javascript:OpenView('" + this.PKVal + "','" + db.MyPK +
"')\"><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
else
{
this.Pub1.AddTD("<a href='AttachmentUpload.aspx?DoType=Down&MyPK=" + db.MyPK +
"' target=_blank ><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
if (athDesc.IsDownload)
{
this.Pub1.AddTD("<a href=\"javascript:Down('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">下载</a>");
}
else
{
this.Pub1.AddTD("");
}
if (this.IsReadonly != "1")
{
if (athDesc.IsDelete != false)
{
if (athDesc.IsDelete == true)
{
this.Pub1.AddTD("style='border:0px'", "<a href=\"javascript:Del('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">删除</a>");
}
else if (athDesc.IsDeleteInt == 2)
{
if (db.Rec.Equals(WebUser.No))
{
this.Pub1.AddTD("style='border:0px'", "<a href=\"javascript:Del('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">删除</a>");
}
}
else
{
this.Pub1.AddTD("");
}
}
else
{
this.Pub1.AddTD("");
}
}
else
{
this.Pub1.AddTD("");
this.Pub1.AddTD("");
}
this.Pub1.AddTREnd();
}
AddFileUpload(isUpdate, athDesc);
this.Pub1.AddTableEnd();
return;
}
this.Pub1.AddTable("border='0' cellspacing='0' cellpadding='0' style='width:" + athWidth + "px'");
if (athDesc.IsShowTitle == true)
{
this.Pub1.AddTR("style='border:0px'");
this.Pub1.AddTDTitleExt("序号");
if (athDesc.Sort.Contains(","))
{
this.Pub1.AddTD("style='background:#f4f4f4; font-size:12px; padding:3px;'", "类别");
}
this.Pub1.AddTDTitleExt("文件名");
this.Pub1.AddTDTitleExt("大小KB");
this.Pub1.AddTDTitleExt("上传时间");
this.Pub1.AddTDTitleExt("上传人");
this.Pub1.AddTDTitleExt("操作");
this.Pub1.AddTREnd();
}
int i = 0;
StringBuilder picHtml = new StringBuilder();
foreach (FrmAttachmentDB db in dbs)
{
i++;
this.Pub1.AddTR();
this.Pub1.AddTDIdx(i);
if (athDesc.Sort.Contains(","))
{
this.Pub1.AddTD(db.Sort);
}
// this.Pub1.AddTDIdx(i++);
if (athDesc.IsDownload)
{
if (athDesc.IsWoEnableWF && CanEditor(db.FileExts))
{
this.Pub1.AddTD("<a href=\"javascript:OpenOfiice('" + this.FK_FrmAttachment + "','" + this.WorkID + "','" + db.MyPK + "','" + this.FK_MapData + "','" + this.Ath + "','" + this.FK_Node + "')\"><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
else if (db.FileExts.ToUpper() == "TXT" || db.FileExts.ToUpper() == "JPG" || db.FileExts.ToUpper() == "JPEG" || db.FileExts.ToUpper() == "GIF" || db.FileExts.ToUpper() == "PNG" || db.FileExts.ToUpper() == "BMP" || db.FileExts.ToUpper() == "PDF" || db.FileExts.ToUpper() == "CEB")
{
this.Pub1.AddTD("<a href=\"javascript:OpenView('" + this.PKVal + "','" + db.MyPK + "')\"><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
else
{
this.Pub1.AddTD("<a href='AttachmentUpload.aspx?DoType=Down&MyPK=" + db.MyPK + "' target=_blank ><img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName + "</a>");
}
}
else
{
this.Pub1.AddTD("<img src='../Img/FileType/" + db.FileExts + ".gif' border=0 onerror=\"src='../Img/FileType/Undefined.gif'\" />" + db.FileName);
}
this.Pub1.AddTD(db.FileSize);
this.Pub1.AddTD(db.RDT);
this.Pub1.AddTD(db.RecName);
//输出操作部分.
this.Pub1.AddTDBegin();
if (athDesc.IsDownload)
{
this.Pub1.Add("<a href=\"javascript:Down('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">下载</a>");
}
if (this.IsReadonly != "1")
{
string op = null;
if (isDel == true)
{
if (athDesc.IsDelete == true)
{
op = " <a href=\"javascript:Del('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">删除</a>";
}
else if (athDesc.IsDeleteInt == 2)
{
if (db.Rec.Equals(WebUser.No))
{
op = " <a href=\"javascript:Del('" + this.FK_FrmAttachment + "','" + this.PKVal + "','" + db.MyPK + "')\">删除</a>";
}
}
}
this.Pub1.Add(op);
}
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
}
if (i == 0)
{
this.Pub1.AddTR();
this.Pub1.AddTD("0");
if (athDesc.Sort.Contains(","))
{
this.Pub1.AddTD("  ");
}
this.Pub1.AddTD("style='width:100px'", "<span style='color:red;' >上传附件</span>");
this.Pub1.AddTD("  ");
this.Pub1.AddTD("  ");
this.Pub1.AddTD("  ");
this.Pub1.AddTD("  ");
this.Pub1.AddTREnd();
}
AddFileUpload(isUpdate, athDesc);
this.Pub1.AddTableEnd();
#endregion 生成表头表体.
}
