/// <summary>
/// 初始化流程类型
/// </summary>
private void LoadProcessTemplate()
{
String[] l_strAryProcessTemplates = TableName.GetAllProcessTemplateName();
ddlProcessTemplate.Items.Add(new System.Web.UI.WebControls.ListItem("", ""));
for (int i = 0; i < l_strAryProcessTemplates.Length; i++)
{
ddlProcessTemplate.Items.Add(new ListItem(SysString.GetPTDisplayName(l_strAryProcessTemplates[i]), l_strAryProcessTemplates[i]));
}
}
/// <summary>
/// 初始化流程类型
/// </summary>
private void LoadProcessTemplate()
{
String[] processType = TableName.GetAllProcessDisplayName();
String[] l_strAryProcessType = TableName.GetAllProcessTemplateName();
ddlProcessTemplate.Items.Add(new ListItem("", ""));
for (int i = 0; i < processType.Length; i++)
{
ddlProcessTemplate.Items.Add(new ListItem(SysString.GetPTDisplayName(processType[i]), l_strAryProcessType[i]));
}
}
/// <summary>
/// 初始化流程类型
/// </summary>
private void LoadProcessTemplate()
{
String[] processType = TableName.GetAllProcessTemplateName();
ddlProcessTemplate.Items.Add(new System.Web.UI.WebControls.ListItem("", ""));
for (int i = 0; i < processType.Length; i++)
{
ddlProcessTemplate.Items.Add(new System.Web.UI.WebControls.ListItem(SysString.GetPTDisplayName(processType[i]), processType[i]));
}
this.ddlStepName.Enabled = false;
this.ddlStepName.Items.Clear();
}
/// <summary>
/// 同步所有流程表单ID
/// </summary>
public static int SetID()
{
try
{
String[] tables = TableName.GetAllProcessTemplateName();
StringBuilder strsqlall = new StringBuilder();
String strsql = "";
String ID = "";
int ret = 0;
foreach (String item in tables)
{
String entityName = TableName.GetEntityName(item);
strsql = "select ID from " + TableName.GetWorkItemsTableName(item) + " where D_StepStatus in ('Assigned','New')";
DataTable dt = SQLHelper.GetDataTable1(strsql);
String tabname = TableName.GetWorkItemsTableName(item);
if (dt != null)
{
int i = 0;
foreach (DataRow dr in dt.Rows)
{
i++;
ID = dr[0].ToString();
if (ID != "")
{
strsqlall.AppendFormat(@" update {0} set FormsData.modify('replace value of(/{1}/ID/text())[1] with {2}') where ID={2}", tabname, entityName, ID);
}
if (i % 100 == 0)
{
ret += SQLHelper.ExecuteNonQuery1(strsqlall.ToString());
strsqlall = new StringBuilder();
}
}
if (strsqlall.Length > 0)
{
ret += SQLHelper.ExecuteNonQuery1(strsqlall.ToString());
}
//FounderSoftware.Framework.Business.Entity.RunNoQuery(strsqlall.ToString());
}
}
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
