public void BindWap() { this.Clear(); this.AddFieldSet("<img src='/WF/Img/Home.gif' ><a href='Home.aspx' >Home</a>-<img src='/WF/Img/EmpWorks.gif' >在途工作"); string sql = " SELECT a.WorkID FROM WF_GenerWorkFlow A, WF_GenerWorkerlist B WHERE A.WorkID=B.WorkID AND B.FK_EMP='" + BP.Web.WebUser.No + "' AND B.IsEnable=1"; GenerWorkFlows gwfs = new GenerWorkFlows(); gwfs.RetrieveInSQL(GenerWorkFlowAttr.WorkID, "(" + sql + ")"); int i = 0; bool is1 = true; //this.Add("<Table border=0 width='100%'>"); this.AddUL(); foreach (GenerWorkFlow gwf in gwfs) { i++; is1 = this.AddTR(is1); this.AddTDBegin("border=0"); //this.AddUL(); // this.AddLi("MyFlow.aspx?WorkID=" + gwf.WorkID + "&FK_Flow=" + gwf.FK_Flow, gwf.Title + gwf.NodeName); this.AddLi(gwf.Title + gwf.NodeName); this.Add("<a href=\"javascript:Do('您确认吗?','MyFlowInfo" + Glo.FromPageType + ".aspx?DoType=UnSend&FID=" + gwf.FID + "&WorkID=" + gwf.WorkID + "&FK_Flow=" + gwf.FK_Flow + "');\" ><img src='/WF/Img/btn/delete.gif' border=0 />撤消</a>"); this.Add("<a href=\"javascript:WinOpen('./../WF/WFRpt.aspx?WorkID=" + gwf.WorkID + "&FK_Flow=" + gwf.FK_Flow + "&FID=0')\" ><img src='/WF/Img/btn/rpt.gif' border=0 />报告</a>"); } this.AddULEnd(); this.AddFieldSetEnd(); }
public void BindWap_bal() { this.Clear(); int colspan = 7; this.AddTable("width='100%' align=center"); this.AddTR(); this.Add("<TD class=TitleTop colspan=" + colspan + "></TD>"); this.AddTREnd(); this.AddTR(); if (WebUser.IsWap) { this.Add("<TD align=left class=TitleMsg colspan=" + colspan + "><img src='/WF/Img/Home.gif' ><a href='Home.aspx' >Home</a>-<img src='/WF/Img/EmpWorks.gif' >在途工作</TD>"); } else { this.Add("<TD class=TitleMsg colspan=" + colspan + " align=left><img src='/WF/Img/Runing.gif' ><b>在途工作</b></TD>"); } this.AddTREnd(); this.AddTR(); this.AddTDTitle("nowarp=true", "序"); this.AddTDTitle("nowarp=true", "名称"); this.AddTDTitle("nowarp=true", "当前节点"); this.AddTDTitle("nowarp=true", "发起日期"); this.AddTDTitle("nowarp=true", "发起人"); this.AddTDTitle("nowarp=true", "操作"); this.AddTDTitle("nowarp=true", "报告"); this.AddTREnd(); string sql = " SELECT a.WorkID FROM WF_GenerWorkFlow A, WF_GenerWorkerlist B WHERE A.WorkID=B.WorkID AND B.FK_EMP='" + BP.Web.WebUser.No + "' AND B.IsEnable=1"; GenerWorkFlows gwfs = new GenerWorkFlows(); gwfs.RetrieveInSQL(GenerWorkFlowAttr.WorkID, "(" + sql + ")"); int i = 0; bool is1 = false; foreach (GenerWorkFlow gwf in gwfs) { i++; is1 = this.AddTR(is1); this.AddTD(i); this.AddTDA("MyFlow.aspx?WorkID=" + gwf.WorkID + "&FK_Flow=" + gwf.FK_Flow, gwf.Title); this.AddTD(gwf.NodeName); this.AddTD(gwf.RDT); this.AddTD(gwf.StarterName); this.AddTD("<a href=\"javascript:Do('您确认吗?','MyFlowInfo" + Glo.FromPageType + ".aspx?DoType=UnSend&FID=" + gwf.FID + "&WorkID=" + gwf.WorkID + "&FK_Flow=" + gwf.FK_Flow + "');\" ><img src='/WF/Img/Btn/delete.gif' border=0 />撤消</a>"); this.AddTD("<a href=\"javascript:WinOpen('./../WF/WFRpt.aspx?WorkID=" + gwf.WorkID + "&FK_Flow=" + gwf.FK_Flow + "&FID=0')\" ><img src='/WF/Img/Btn/rpt.gif' border=0 />报告</a>"); this.AddTREnd(); } this.AddTRSum(); this.AddTD("colspan=" + colspan, " "); this.AddTREnd(); this.AddTableEnd(); }
/// <summary> /// 获取挂起数据,传入流程编号与项目编号 /// </summary> /// <returns></returns> private string GetHunupFlowData() { try { string FK_Flow = getUTF8ToString("FK_Flow"); string ProjNo = getUTF8ToString("ProjNo"); int state = (int)WFState.HungUp; string sql = "SELECT a.WorkID FROM WF_GenerWorkFlow A, WF_GenerWorkerlist B WHERE A.FK_Flow='" + FK_Flow + "' AND A.WFState=" + state + " AND A.WorkID=B.WorkID AND B.FK_Emp='" + WebUser.No + "' AND A.WorkID in (select OID from V_FlowData where ProjNo ='" + ProjNo + "') AND B.IsEnable=1 "; GenerWorkFlows gwfs = new GenerWorkFlows(); gwfs.RetrieveInSQL(GenerWorkFlowAttr.WorkID, "(" + sql + ")"); DataTable dt = gwfs.ToDataTableField(); return(GetEasyUIJson(dt)); } catch { return("[{}]"); } }
/// <summary> /// 获取在途数据,传入流程编号和项目编号 /// </summary> /// <returns></returns> private string GetRuningFlowData() { try { string FK_Flow = getUTF8ToString("FK_Flow"); string ProjNo = getUTF8ToString("ProjNo"); string sql = "SELECT a.WorkID FROM WF_GenerWorkFlow A, WF_GenerWorkerlist B WHERE A.FK_Flow='" + FK_Flow + "' AND A.WorkID=B.WorkID AND B.FK_Emp='" + WebUser.No + "' AND A.WorkID in (select OID from V_FlowData where ProjNo ='" + ProjNo + "') AND B.IsEnable=1 AND (B.IsPass=1 or B.IsPass < 0 ) "; GenerWorkFlows gwfs = new GenerWorkFlows(); gwfs.RetrieveInSQL(GenerWorkFlowAttr.WorkID, "(" + sql + ")"); DataTable dt = gwfs.ToDataTableField(); //按照接受日期排序 dt.DefaultView.Sort = "RDT DESC"; return(GetEasyUIJson(dt.DefaultView.ToTable())); } catch { return("[{}]"); } }