/// ****************************************************************************
/// <summary>
/// 数据加载
/// </summary>
/// ****************************************************************************
private void LoadData()
{
try
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
sb.AddStrategy(new Strategy(DAL.QueryStrategy.WorkFlowActStrategyName.ActCode, this.ActCode));
string sql = sb.BuildMainQueryString();
QueryAgent QA = new QueryAgent();
EntityData entity = QA.FillEntityData("WorkFlowAct", sql);
this.ViewState["_CaseCode"] = entity.CurrentRow["CaseCode"].ToString();
QA.Dispose();
entity.Dispose();
WorkCase workCase = Rms.WorkFlow.WorkCaseManager.GetWorkCase(this.ViewState["_CaseCode"].ToString());
this.ViewState["_ApplicationCode"] = workCase.ApplicationCode;
Act currentAct = workCase.GetAct(this.ActCode);
Procedure procedure = DefinitionManager.GetProcedureDifinition(workCase.ProcedureCode, true);
this.ViewState["_ProcedureCode"] = procedure.ProcedureCode;
Task currentTask = procedure.GetTask(currentAct.ToTaskCode);
this.contentspan.InnerHtml = WriteOpinion(workCase, currentTask, currentAct);
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
private string BuildWorkFlowSqlString(string usercode, string type)
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
switch (type)
{
case "Begin":
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBegin, "Begin"));
break;
case "DealWith":
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Status, "'DealWith'"));
break;
case "BeginAndDealWith":
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBeginAndDealWith, "Begin"));
break;
default:
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBegin, "Begin"));
break;
}
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBegin, "Begin"));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.InActUser, usercode));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ActMeetOrder, ""));
string sql = sb.BuildMainQueryString();
//排序
sql = sql + " order by fromdate ";
return(sql);
}
private void BuildSqlString()
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBegin, "Begin"));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.InActUser, user.UserCode));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ActMeetOrder, ""));
if (this.sltProcedure.Value != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ProcedureCodeIn, BLL.WorkFlowRule.GetProcedureCodeListByName(this.sltProcedure.Value)));
}
if (this.txtCaseCode.Value != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.FlowNumber, this.txtCaseCode.Value));
}
if (this.txtTaskName.Value != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.CurrentTaskName, this.txtTaskName.Value));
}
if (this.txtTitle.Value != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Title, this.txtTitle.Value));
}
if (this.DropDownProject.SelectedValue != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ProjectCode, this.DropDownProject.SelectedValue));
}
if (this.ucPerson.Value != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.FromUserCode, this.ucPerson.Value));
}
if (this.DateStart.Value != "" || this.DateEnd.Value != "")
{
string sDate = this.DateStart.Value;
string eDate = this.DateEnd.Value;
if (this.DateStart.Value == "")
{
sDate = DateTime.MinValue.ToShortDateString();
}
if (this.DateEnd.Value == "")
{
eDate = DateTime.MaxValue.ToShortDateString();
}
ArrayList arrlist = new ArrayList();
arrlist.Add(sDate);
arrlist.Add(eDate);
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.FromDate, arrlist));
}
string sql = sb.BuildMainQueryString();
//排序
string sortsql = BLL.GridSort.GetSortSQL(ViewState, "FromDate desc");
if (sortsql != "")
{
sql = sql + " order by " + sortsql;
}
this.ViewState.Add("SqlString", sql);
}
/// ****************************************************************************
/// <summary>
/// 生成查看流程信息 sql 语句
/// </summary>
/// ****************************************************************************
private void BuildSqlString()
{
//////根据动作代码查找流程代码//////
string sql = "";
if (CaseCode == "")
{
if (this.ActCode != "")
{
RmsPM.DAL.QueryStrategy.WorkFlowActStrategyBuilder sb = new RmsPM.DAL.QueryStrategy.WorkFlowActStrategyBuilder();
sb.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.WorkFlowActStrategyName.ActCode, this.ActCode));
sql = sb.BuildMainQueryString();
QueryAgent QA = new QueryAgent();
EntityData entity = QA.FillEntityData("WorkFlowAct", sql);
this.ViewState["_CaseCode"] = entity.CurrentRow["CaseCode"].ToString();
QA.Dispose();
entity.Dispose();
}
/*else if (this.ApplicationCode != "")
* {
* RmsPM.DAL.QueryStrategy.WorkFlowCaseStrategyBuilder sb = new RmsPM.DAL.QueryStrategy.WorkFlowCaseStrategyBuilder();
* sb.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.WorkFlowCaseStrategyName.ApplicationCode, this.ApplicationCode));
* sb.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.WorkFlowCaseStrategyName.ProcedureCode, RmsPM.BLL.WorkFlowRule.GetProcedureCodeByName(this.FlowName)));
*
* sql = sb.BuildMainQueryString();
*
* QueryAgent QA = new QueryAgent();
* EntityData entity = QA.FillEntityData("WorkFlowCase", sql);
* this.ViewState["_CaseCode"] = entity.CurrentRow["CaseCode"].ToString();
* QA.Dispose();
* entity.Dispose();
* }*/
}
WorkFlowActStrategyBuilder sb1 = new WorkFlowActStrategyBuilder();
sb1.AddStrategy(new Strategy(WorkFlowActStrategyName.CaseCode, this.ViewState["_CaseCode"].ToString()));
sb1.AddOrder("FromDate", true);
sql = sb1.BuildMainQueryString();
this.ViewState.Add("SqlString", sql);
}
/// ****************************************************************************
/// <summary>
/// 查询规则
/// </summary>
/// ****************************************************************************
private void BuildSqlString()
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
switch (this.Status)
{
case "":
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Status, "'DealWith','Begin'"));
break;
case "All":
break;
default:
char[] delimiter = ",".ToCharArray();
string ud_sRule = "";
foreach (string tmp in this.Status.Split(delimiter))
{
if (ud_sRule != "")
{
ud_sRule += ",'" + tmp + "'";
}
else
{
ud_sRule = "'" + tmp + "'";
}
}
if (ud_sRule != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Status, ud_sRule));
}
else
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Status, "'DealWith','Begin'"));
}
break;
}
switch (this.CaseStatus)
{
case "":
break;
case "All":
break;
default:
char[] delimiter = ",".ToCharArray();
string ud_sRule = "";
foreach (string tmp in this.CaseStatus.Split(delimiter))
{
if (ud_sRule != "")
{
ud_sRule += ",'" + tmp + "'";
}
else
{
ud_sRule = "'" + tmp + "'";
}
}
if (ud_sRule != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.CaseStatus, ud_sRule));
}
break;
}
if (this._ProcedureName != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ProcedureCodeIn, BLL.WorkFlowRule.GetProcedureCodeListByName(this._ProcedureName)));
}
if (this._ActUser != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.IsCaseActUser, this._ActUser));
}
if (this._SendActUser != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.SendActUser, this._SendActUser));
}
if (this._IsNotActUser != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.IsNotActUser, this._IsNotActUser));
ArrayList arA = new ArrayList();
arA.Add("090201");
arA.Add(((User)Session["User"]).UserCode);
arA.Add(((User)Session["User"]).BuildStationCodes());
arA.Add("");
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.AccessRange, arA));
}
if (this._IsNotActUser == "" && this._ActUser == "")
{
ArrayList arA = new ArrayList();
arA.Add("090201");
arA.Add(((User)Session["User"]).UserCode);
arA.Add(((User)Session["User"]).BuildStationCodes());
arA.Add(((User)Session["User"]).UserCode);
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.AccessRange, arA));
}
if (this._CaseCode != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.FlowNumber, this._CaseCode));
}
if (this._TaskName != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.CurrentTaskName, this._TaskName));
}
if (this._Title != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Title, this._Title));
}
if (this._ProjectCode != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ProjectCode, this._ProjectCode));
}
if (this._ucPerson != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.FromUserCode, this._ucPerson));
}
if (this._DateStart != "" || this._DateEnd != "")
{
if (this._DateStart == "")
{
this._DateStart = DateTime.MinValue.ToString();
}
if (this._DateEnd == "")
{
this._DateEnd = DateTime.MaxValue.ToString();
}
ArrayList arrlist = new ArrayList();
arrlist.Add(this._DateStart);
arrlist.Add(this._DateEnd);
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.FromDate, arrlist));
}
if (this._ucToPerson != "")
{
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ActUserCode, this._ucToPerson));
}
if (this._CalendarStart != "" || this._CalendarEnd != "")
{
if (this._CalendarStart == "")
{
this._CalendarStart = DateTime.MinValue.ToString();
}
if (this._CalendarEnd == "")
{
this._CalendarEnd = DateTime.MaxValue.ToShortDateString();
}
ArrayList arrlist = new ArrayList();
arrlist.Add(this._CalendarStart);
arrlist.Add(this._CalendarEnd);
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.SignDate, arrlist));
}
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.CopyState, "0"));
string sql = sb.BuildMainQueryString();
this.ViewState["SelectString"] = sql;
//排序
string sortsql = BLL.GridSort.GetSortSQL(ViewState, "FromDate desc");
if (sortsql != "")
{
sql = sql + " order by " + sortsql;
}
this.ViewState.Add("SqlString", sql);
this.ViewState["sorttype"] = " desc";
this.ViewState["sortfield"] = "FromDate";
}
private static string GetUserEmailContent(string UserCode, string url, string contentflag)
{
string text4;
try
{
string text5;
string text = "";
WorkFlowActStrategyBuilder builder = new WorkFlowActStrategyBuilder();
if (contentflag == "1")
{
builder.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBeginAndDealWith));
}
else
{
builder.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBegin, "Begin"));
}
builder.AddStrategy(new Strategy(WorkFlowActStrategyName.InActUser, UserCode));
builder.AddStrategy(new Strategy(WorkFlowActStrategyName.ActMeetOrder, ""));
string queryString = builder.BuildMainQueryString();
string text3 = "FromDate desc";
if (text3 != "")
{
queryString = queryString + " order by " + text3;
}
text = SystemRule.GetUserName(UserCode) + ",您好！<br/> 以下为您的待处理事宜：<br/>";
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("WorkFlowAct", queryString);
if (data.CurrentTable.Rows.Count != 0)
{
text = text + "<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" width=\"100%\" style=\"font-size: 13px;color:Black;background-color:LightGoldenrodYellow;border-color:Tan;border-width:1px;border-style:solid;border-collapse:collapse;\"><tr style=\"background-color:Tan;font-weight:bold;font-size: 13px;height:23pt;\"><td align=\"center\">流水号</td><td align=\"center\">项目</td><td nowrap=\"nowrap\" align=\"center\">流程名称</td><td align=\"center\" nowrap=\"nowrap\">任 务</td><td align=\"center\">主题</td><td align=\"center\" nowrap=\"nowrap\">发件人</a></td><td align=\"center\" nowrap=\"nowrap\">发件日期</a></td><td align=\"center\" nowrap=\"nowrap\">手送资料</a></td></tr>";
foreach (DataRow row in data.CurrentTable.Select())
{
text5 = text;
text = text5 + "<tr style=\"font-size: 13px;height:23pt;\"><td>" + WorkFlowRule.GetWorkFlowNumber(row["CaseCode"].ToString()) + "</td><td><span>" + WorkFlowRule.GetWorkFlowCaseProjectName(row["CaseCode"].ToString()) + "</span></td><td>" + row["ProcedureName"].ToString() + "</td><td nowrap=\"nowrap\">" + row["ToTaskName"].ToString() + "</td><td>" + WorkFlowRule.GetWorkFlowCaseTitle(row["CaseCode"].ToString()) + "</td><td nowrap=\"nowrap\">" + SystemRule.GetUserName(row["FromUserCode"].ToString()) + "</td><td nowrap=\"nowrap\">" + WorkFlowRule.GetFormatExcedableDate((DateTime)row["FromDate"]) + "</td><td>" + WorkFlowRule.GetWorkFlowHandmade(row["CaseCode"].ToString()) + "</td></tr>";
}
}
else
{
text = "";
}
data.Clear();
object obj2 = ("Select B.Title,B.BiddingRemark1,BE.EmitDate,BE.EndDate,BE.PrejudicationDate,BE.State" + " From BiddingEmit BE") + " Inner Join Bidding B on BE.BiddingCode=B.BiddingCode" + " Inner Join BiddingOpen BO On BE.BiddingEmitCode=BO.BiddingEmitCode";
queryString = string.Concat(new object[] { obj2, " Where BO.OpenerCode='", UserCode, "' And BE.state=0 And BE.PrejudicationDate Between DateAdd(day,1,'", DateTime.Today, "') And 'DateAdd(day,2,'", DateTime.Today, "')" });
data = agent.FillEntityData("BiddingOpen", queryString);
if (data.CurrentTable.Rows.Count != 0)
{
text = text + "<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" width=\"100%\" style=\"font-size: 13px;color:Black;background-color:LightGoldenrodYellow;border-color:Tan;border-width:1px;border-style:solid;border-collapse:collapse;\"><tr style=\"background-color:Tan;font-weight:bold;font-size: 13px;height:23pt;\"><td align=\"center\">拟定标段 </td><td align=\"center\">承办部门</td><td nowrap=\"nowrap\" align=\"center\">发标日期</td><td align=\"center\" nowrap=\"nowrap\">截标日期</td><td align=\"center\">定标日期</td><td align=\"center\" nowrap=\"nowrap\">当前状态</a></td></tr>";
foreach (DataRow row in data.CurrentTable.Select())
{
text5 = text;
text = text5 + "<tr style=\"font-size: 13px;height:23pt;\"><td>" + row["Title"].ToString() + "</td><td><span>" + row["BiddingRemark1"].ToString() + "</span></td><td>" + row["EmitDate"].ToString() + "</td><td nowrap=\"nowrap\">" + row["EndDate"].ToString() + "</td><td>" + row["PrejudicationDate"].ToString() + "</td><td nowrap=\"nowrap\">" + row["State"].ToString() + "</td></tr>";
}
}
else
{
text = "";
}
agent.Dispose();
data.Dispose();
if (text != "")
{
text5 = text;
text = text5 + "</table> <br/> 请您登录“<a href=\"" + url + "\" target=\"_blank\">" + url + "</a>”进行处理，谢谢。";
}
text4 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text4);
}
//private int PayLoad(DataTable dtRemind,string ProjectCode)
//{
// //付款超期提醒条件
// PaymentStrategyBuilder sb = new PaymentStrategyBuilder("V_Payment");
// //某个项目
// sb.AddStrategy( new Strategy( PaymentStrategyName.ProjectCode,ProjectCode));
// //当天之前
// ArrayList ar = new ArrayList();
// ar.Add("1900-1-1");
// ar.Add(DateTime.Now.ToShortDateString());
// sb.AddStrategy( new Strategy( PaymentStrategyName.PayDate,ar ));
// //未付清的
// sb.AddStrategy(new Strategy(DAL.QueryStrategy.PaymentStrategyName.NotPayout));
// //状态是已审核的
// string status = "1";
// sb.AddStrategy(new Strategy(PaymentStrategyName.Status, status));
// //当前用户
// //sb.AddStrategy( new Strategy( PaymentStrategyName.ApplyPerson,user.UserCode));
// //权限
// ArrayList arA = new ArrayList();
// arA.Add(user.UserCode);
// arA.Add(user.BuildStationCodes());
// sb.AddStrategy( new Strategy( DAL.QueryStrategy.PaymentStrategyName.AccessRange,arA));
// string sql = sb.BuildMainQueryString();
// QueryAgent qa = new QueryAgent();
// EntityData entity = qa.FillEntityData( "Payment",sql );
// qa.Dispose();
// if(entity.Tables[0].Rows.Count != 0 )
// {
// DataRow drRemind = dtRemind.NewRow();
// drRemind["Type"] = " [付款到期]";
// //传递参数：ProjectCode/ACT=1应付款/PayLoad=1付款到期
// drRemind["Url"] = "Finance/PaymentList.aspx?Act=1&Pay_Load=1&ProjectCode="+ProjectCode;
// drRemind["Title"] = entity.Tables[0].Rows.Count.ToString()+"个";
// dtRemind.Rows.Add(drRemind);
// }
// return entity.Tables[0].Rows.Count;
//}
//private int BiddingLoad(DataTable dtRemind,string ProjectCode)
//{
// BLL.Bidding bidding = new BLL.Bidding();
// ArrayList ar = new ArrayList();
// ar.Add("1900-1-1");
// ar.Add(DateTime.Now.ToShortDateString());
// bidding.ArrangedDateEx = ar;
// bidding.State = "0";
// bidding.ProjectCode = ProjectCode;
// if(bidding.GetBiddings().Rows.Count != 0)
// {
// DataRow drRemind = dtRemind.NewRow();
// drRemind["Type"] = " [招投标到期]";
// drRemind["Url"] = "BiddingManage/BiddingQuery.aspx?State=0&ProjectCode="+ProjectCode;
// drRemind["Title"] = bidding.GetBiddings().Rows.Count.ToString()+"个";
// dtRemind.Rows.Add(drRemind);
// }
// return bidding.GetBiddings().Rows.Count;
//}
//private int ContractLoad(DataTable dtRemind,string ProjectCode)
//{
// BLL.Bidding bidding = new BLL.Bidding();
// ArrayList ar = new ArrayList();
// ar.Add("1900-1-1");
// ar.Add(DateTime.Now.ToShortDateString());
// bidding.ConfirmDateEx = ar;
// bidding.State = "4";
// bidding.ProjectCode = ProjectCode;
// if(bidding.GetBiddings().Rows.Count != 0)
// {
// DataRow drRemind = dtRemind.NewRow();
// drRemind["Type"] = " [合同签约到期]";
// drRemind["Url"] = "BiddingManage/BiddingQuery.aspx?State=4&ProjectCode="+ProjectCode;
// drRemind["Title"] = bidding.GetBiddings().Rows.Count.ToString()+"个";
// dtRemind.Rows.Add(drRemind);
// }
// return bidding.GetBiddings().Rows.Count;
//}
private int WorkFlowLoadRemind(DataTable dtRemind, string Status)
{
// ***********************流程待审核*****************************
EntityData entity = DAL.EntityDAO.WorkFlowDAO.GetAllWorkFlowProcedure();
int iCount = entity.CurrentTable.Rows.Count;
int LoadCount = 0;
List <string> ProcedureNameList = new List <string>();
for (int i = 0; i < iCount; i++)
{
entity.SetCurrentRow(i);
string ProcedureName = entity.GetString("ProcedureName");
if (!ProcedureNameList.Contains(ProcedureName))
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.Status, Status));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.InActUser, user.UserCode));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ProcedureCodeIn, BLL.WorkFlowRule.GetProcedureCodeListByName(ProcedureName))); // 各种流程
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity1 = qa.FillEntityData("WorkFlowAct", sql);
qa.Dispose();
int tempcount = 0;
for (int m = 0; m < entity1.CurrentTable.Rows.Count; m++)
{
if (RmsPM.BLL.WorkFlowRule.GetCheckExecdableDate((DateTime)entity1.CurrentTable.Rows[m]["FromDate"], DateTime.Parse("1900-1-1")))
{
tempcount++;
}
}
if (tempcount > 0)
{
string FlowStatusName = "";
if (Status == "'Begin'")
{
FlowStatusName = "待办";
}
else if (Status == "'DealWith'")
{
FlowStatusName = "在办";
}
DataRow drRemind = dtRemind.NewRow();
drRemind["Type"] = " " + entity.GetString("Description") + "<font color=\"red\">(" + FlowStatusName + "超期)</font>";
drRemind["Title"] = tempcount.ToString() + "个";
if (Status == "'Begin'")
{
drRemind["Url"] = "WorkFlowContral/WorkFlowReceiveBox.aspx?ProcedureName=" + Server.UrlEncode(ProcedureName);
}
else if (Status == "'DealWith'")
{
drRemind["Url"] = "WorkFlowContral/workflowinbox.aspx?ProcedureName=" + Server.UrlEncode(ProcedureName);
}
drRemind["RemindTime"] = System.DBNull.Value;
dtRemind.Rows.Add(drRemind);
LoadCount++;
}
entity1.Dispose();
ProcedureNameList.Add(ProcedureName);
}
}
entity.Dispose();
return(LoadCount);
}
private void LoadDoNow()
{
//EntityData entity = DAL.EntityDAO.WorkFlowDAO.GetAllWorkFlowProcedure();
DataRow drAudit;
///////////////////////////////////////////////////////////////////////////////////
// 取得流程待审核，即在办箱单据 unm add 2005.4.4
// ***********************流程待审核*****************************
DataTable dtAuditclm = new DataTable();
dtAuditclm.Columns.Add("Type", System.Type.GetType("System.String"));
dtAuditclm.Columns.Add("Title", System.Type.GetType("System.String"));
dtAuditclm.Columns.Add("Url", System.Type.GetType("System.String"));
dtAuditclm.Columns.Add("AuditTime", System.Type.GetType("System.String"));
dtAuditclm.Columns.Add("ProjectCode", System.Type.GetType("System.String"));
EntityData entityclm = DAL.EntityDAO.WorkFlowDAO.GetAllWorkFlowProcedure();
int iCountclm = entityclm.CurrentTable.Rows.Count;
List <string> ProcedureNameList = new List <string>();
for (int i = 0; i < iCountclm; i++)
{
entityclm.SetCurrentRow(i);
// 取得每个类别的个数
string ProcedureName = entityclm.GetString("ProcedureName");
string ProcedureCodeclm = entityclm.GetString("ProcedureCode");
if (!ProcedureNameList.Contains(ProcedureName))
{
WorkFlowActStrategyBuilder sbclm = new WorkFlowActStrategyBuilder();
sbclm.AddStrategy(new Strategy(WorkFlowActStrategyName.Status, "'DealWith'")); // 收件箱
sbclm.AddStrategy(new Strategy(WorkFlowActStrategyName.InActUser, user.UserCode));
sbclm.AddStrategy(new Strategy(WorkFlowActStrategyName.ProcedureCodeIn, BLL.WorkFlowRule.GetProcedureCodeListByName(ProcedureName))); // 各种流程
//还有待问问包哥
//sbclm.AddStrategy(new Strategy(WorkFlowActStrategyName.ProcedureCode, ProcedureCodeclm)); // 各种流程
string sqlclm = sbclm.BuildMainQueryString();
QueryAgent qaclm = new QueryAgent();
EntityData entity1clm = qaclm.FillEntityData("WorkFlowAct", sqlclm);
qaclm.Dispose();
if (entity1clm.CurrentTable.Rows.Count > 0)
{
drAudit = dtAuditclm.NewRow();
drAudit["Type"] = entityclm.GetString("Description");
drAudit["Title"] = entity1clm.CurrentTable.Rows.Count;
drAudit["Url"] = "WorkFlowContral/WorkFlowInBox.aspx?ProcedureName=" + Server.UrlEncode(ProcedureName); //暂时去掉?ProcedureCode=" + entityclm.GetString("ProcedureCode");
drAudit["AuditTime"] = System.DBNull.Value;
dtAuditclm.Rows.Add(drAudit);
}
entity1clm.Dispose();
ProcedureNameList.Add(ProcedureName);
}
}
entityclm.Dispose();
// ***********************流程待审核*****************************
DataView dvclm = new DataView(dtAuditclm);
dvclm.Sort = " AuditTime desc ";
// 取得全部审核的前n条
DataTable dtTmpclm = new DataTable();
dtTmpclm = dtAuditclm.Clone();
int jclm = 0;
foreach (DataRowView drv in dvclm)
{
drAudit = dtTmpclm.NewRow();
drAudit.ItemArray = drv.Row.ItemArray;
dtTmpclm.Rows.Add(drAudit);
jclm++;
if (jclm >= this.intListAuditNum)
{
break;
}
}
this.Repeater1.DataSource = dtTmpclm;
this.Repeater1.DataBind();
}
private void LoadAudit()
{
DataTable dtAudit = new DataTable();
dtAudit.Columns.Add("Type", System.Type.GetType("System.String"));
dtAudit.Columns.Add("Title", System.Type.GetType("System.String"));
dtAudit.Columns.Add("Url", System.Type.GetType("System.String"));
dtAudit.Columns.Add("AuditTime", System.Type.GetType("System.String"));
dtAudit.Columns.Add("ProjectCode", System.Type.GetType("System.String"));
DataRow drAudit;
// 是否有合同审核权限
bool isContractRight = user.HasOperationRight("050105") && user.HasOperationRight("0802");
if (isContractRight)
{
// 合同前n条数据
int intContractNum = 6;
DataTable dtContract = this.GetContact(intContractNum);
//DataGrid1.DataSource = dtContract;
//DataGrid1.DataBind();
// for(int i=0;i<dtContract.Rows.Count;i++)
// {
// drAudit = dtAudit.NewRow();
// drAudit["Type"] = "合同审核";
// drAudit["Title"] = dtContract.Rows[i]["ContractName"].ToString();
// drAudit["Url"] = "Contract/ContractInfo.aspx?ProjectCode="+projectCode+"&ContractCode="+dtContract.Rows[i]["ContractCode"].ToString();
// drAudit["AuditTime"] = dtContract.Rows[i]["CreateDate"].ToString();
// dtAudit.Rows.Add(drAudit);
// }
if (dtContract.Rows.Count > 0)
{
//Response.Write(dtContract.Rows.Count);
drAudit = dtAudit.NewRow();
drAudit["Type"] = "合同审核";
drAudit["Title"] = dtContract.Rows.Count;
drAudit["Url"] = "Contract/Contract.aspx?Status=1";//&ProjectCode="+dtContract.Rows[0]["ProjectCode"].ToString();
drAudit["AuditTime"] = dtContract.Rows[0]["CreateDate"].ToString();
dtAudit.Rows.Add(drAudit);
}
}
// 是否有情款审核权限
bool isPaymentRight = user.HasOperationRight("060105") && user.HasOperationRight("0802");
if (isPaymentRight)
{
// 请款前n条数据
int intPaymentNum = 6;
DataTable dtPayment = this.GetPayment(intPaymentNum);
// for(int i=0;i<dtPayment.Rows.Count;i++)
// {
// drAudit = dtAudit.NewRow();
// drAudit["Type"] = "请款审核";
// drAudit["Title"] = dtPayment.Rows[i]["PaymentCode"].ToString();
// drAudit["Url"] = "Finance/PaymentInfo.aspx?PaymentCode="+dtPayment.Rows[i]["PaymentCode"].ToString();
// drAudit["AuditTime"] = dtPayment.Rows[i]["ApplyDate"].ToString();
// dtAudit.Rows.Add(drAudit);
// }
if (dtPayment.Rows.Count > 0)
{
drAudit = dtAudit.NewRow();
drAudit["Type"] = "请款审核";
drAudit["Title"] = dtPayment.Rows.Count;
drAudit["Url"] = "Finance/PaymentList.aspx?Status=0";//&ProjectCode="+dtPayment.Rows[0]["ProjectCode"].ToString();
drAudit["AuditTime"] = dtPayment.Rows[0]["ApplyDate"].ToString();
dtAudit.Rows.Add(drAudit);
}
}
bool isDynamicCostRight = user.HasOperationRight("040403");
if (isDynamicCostRight)
{
// 费用前n条数据 ,在动态费用－》动态调整中的待审核
int intDynamicCostNum = 6;
DataTable dtDynamicCost = this.GetDynamicCost(intDynamicCostNum);
// for(int i=0;i<dtDynamicCost.Rows.Count;i++)
// {
// drAudit = dtAudit.NewRow();
// drAudit["Type"] = "费用审核";
// drAudit["Title"] = dtDynamicCost.Rows[i]["BudgetName"].ToString();
// drAudit["Url"] = "Cost/DynamicApplyInfo.aspx?ProjectCode="+projectCode+"&BudgetCode="+dtDynamicCost.Rows[i]["BudgetCode"].ToString();
// drAudit["AuditTime"] = dtDynamicCost.Rows[i]["MakeDate"].ToString();
// dtAudit.Rows.Add(drAudit);
// }
if (dtDynamicCost.Rows.Count > 0)
{
drAudit = dtAudit.NewRow();
drAudit["Type"] = "动态费用审核";
drAudit["Title"] = dtDynamicCost.Rows.Count;
drAudit["Url"] = "Cost/DynamicCostApplyList.aspx?ProjectCode=" + dtDynamicCost.Rows[0]["ProjectCode"].ToString();
drAudit["AuditTime"] = dtDynamicCost.Rows[0]["MakeDate"].ToString();
dtAudit.Rows.Add(drAudit);
}
}
// 取得流程待审核，即在办箱单据 unm add 2005.4.4
// ***********************流程待审核*****************************
EntityData entity = DAL.EntityDAO.WorkFlowDAO.GetAllWorkFlowProcedure();
int iCount = entity.CurrentTable.Rows.Count;
List <string> ProcedureNameList = new List <string>();
for (int i = 0; i < iCount; i++)
{
entity.SetCurrentRow(i);
// 取得每个类别的个数
string ProcedureName = entity.GetString("ProcedureName");
if (!ProcedureNameList.Contains(ProcedureName))
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.StatusBegin, "Begin")); // 收件箱
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.InActUser, user.UserCode));
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ProcedureCodeIn, BLL.WorkFlowRule.GetProcedureCodeListByName(ProcedureName))); // 各种流程
sb.AddStrategy(new Strategy(WorkFlowActStrategyName.ActMeetOrder, ""));
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity1 = qa.FillEntityData("WorkFlowAct", sql);
qa.Dispose();
if (entity1.CurrentTable.Rows.Count > 0)
{
drAudit = dtAudit.NewRow();
drAudit["Type"] = entity.GetString("Description");
drAudit["Title"] = entity1.CurrentTable.Rows.Count;
drAudit["Url"] = "WorkFlowContral/WorkFlowReceiveBox.aspx?ProcedureName=" + Server.UrlEncode(ProcedureName); //暂时屏蔽?ProcedureCode=" + entity.GetString("ProcedureCode");
drAudit["AuditTime"] = System.DBNull.Value;
dtAudit.Rows.Add(drAudit);
}
entity1.Dispose();
ProcedureNameList.Add(ProcedureName);
}
}
entity.Dispose();
// ***********************流程待审核*****************************
DataView dv = new DataView(dtAudit);
dv.Sort = " AuditTime desc ";
// 取得全部审核的前n条
DataTable dtTmp = new DataTable();
dtTmp = dtAudit.Clone();
//int j=0;
//foreach(DataRowView drv in dv)
//{
//drAudit = dtTmp.NewRow();
///drAudit.ItemArray = drv.Row.ItemArray;
//dtTmp.Rows.Add(drAudit);
//j++;
//if(j>=this.intListAuditNum) break;
//}
this.rpAudit.DataSource = dtAudit;
this.rpAudit.DataBind();
///////////////////////////////////////////////////////////////////////////////////
// ***********************流程待审核*****************************
/*DataView dvclm = new DataView(dtAuditclm);
* dvclm.Sort = " AuditTime desc ";
* // 取得全部审核的前n条
* DataTable dtTmpclm = new DataTable();
* dtTmpclm = dtAuditclm.Clone();
* int jclm=0;
* foreach(DataRowView drv in dvclm)
* {
* drAudit = dtTmpclm.NewRow();
* drAudit.ItemArray = drv.Row.ItemArray;
* dtTmpclm.Rows.Add(drAudit);
*
* jclm++;
* if(jclm>=this.intListAuditNum) break;
* }
* //this.Repeater1.DataSource = dtTmpclm;
* //this.Repeater1.DataBind();*/
///////////////////////////////////////////////////////////////////////////////////
}
