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