public static int DeleteWorkFlow(string workflowId)
{
if (workflowId.Trim().Length == 0 || workflowId == null)
throw new Exception("DeleteWorkFlow方法错误，workflowId 不能为空！");
try
{
WF_WorkFlow wf = new WF_WorkFlow();
wf.WorkFlowId = workflowId;
return MainHelper.PlatformSqlMap.DeleteByKey<WF_WorkFlow>(wf);
}
catch (Exception ex)
{
throw ex;
}
}
private void frmExcelEditSQLSet_Load(object sender, EventArgs e) {
cbxSWorkFolwDataTable.Items.Clear();
cbxTWorkFolwDataTable.Items.Clear();
comboBox1.Items.Clear();
ListItem l = new ListItem("###", "请选择");
cbxSWorkFolwDataTable.Items.Add(l);
cbxTWorkFolwDataTable.Items.Add(l);
IList li = MainHelper.PlatformSqlMap.GetList("SelectWF_WorkFlowList", " where 1=1 order by FlowCaption ");
DataTable dt = ConvertHelper.ToDataTable(li);
WinFormFun.LoadComboBox(cbxTWorkFolwDataTable, dt, "WorkFlowId", "FlowCaption");
WF_WorkFlow wf = new WF_WorkFlow();
wf.FlowCaption = "无";
wf.WorkFlowId = "无";
li.Insert(0, wf);
dt = ConvertHelper.ToDataTable(li);
WinFormFun.LoadComboBox(cbxSWorkFolwDataTable, dt, "WorkFlowId", "FlowCaption");
WinFormFun.LoadComboBox(cbxTWorkFolwDataTable, dt, "WorkFlowId", "FlowCaption");
l = new ListItem("下拉并选中", "下拉并选中");
comboBox1.Items.Add(l);
l = new ListItem("下拉不选中", "下拉不选中");
comboBox1.Items.Add(l);
l = new ListItem("赋值", "赋值");
comboBox1.Items.Add(l);
setComoboxFocusIndex(cbxSWorkFolwDataTable, rowData.slcid);
setComoboxFocusIndex(cbxTWorkFolwDataTable, rowData.tlcid);
if (strtype == "edit") {
setComoboxFocusIndex(cbxSWorkFolwDataTable, rowData.slcid);
setComoboxFocusIndex(cbxSWorkTastDataTable, rowData.slcjdid);
setComoboxFocusIndex(cbxSWorkTastzdDataTable, rowData.slcjdzdid);
tetSWorkSQL.Text = rowData.sSQL;
setComoboxFocusIndex(comboBox1, rowData.cdfs);
setComoboxFocusIndex(cbxTWorkFolwDataTable, rowData.tlcid);
setComoboxFocusIndex(cbxTWorkTastDataTable, rowData.tlcjdid);
setComoboxFocusIndex(cbxTWorkTastzdDataTable, rowData.tlcjdzdid);
tetTWorkSQL.Text = rowData.tSQL;
}
}
//private void setParameter()
//{
// sqlDataItem.ParameterList.Clear();
// sqlDataItem.AppendParameter("@WorkFlowId", WorkFlowId);
// sqlDataItem.AppendParameter("@WFClassId", WorkFlowClassId);
// sqlDataItem.AppendParameter("@FlowCaption", WorkFlowCaption);
// sqlDataItem.AppendParameter("@Description", Description);
// sqlDataItem.AppendParameter("@Status", Status);
// sqlDataItem.AppendParameter("@MgrUrl", MgrUrl);
//}
//private void setInsertSql()
//{
// string tmpValueList="";
// string tmpFieldName="";
// sqlString="insert into "+tableName+"(";
// int tmpInt=this.fieldList.Length;
// for(int i=0;i<tmpInt-1;i++)
// {
// tmpFieldName=fieldList[i].ToString();
// sqlString=sqlString+tmpFieldName+",";
// tmpValueList=tmpValueList+"@"+tmpFieldName+",";
// }
// tmpFieldName=this.fieldList[tmpInt-1].ToString();
// sqlString=sqlString+tmpFieldName;
// tmpValueList=tmpValueList+"@"+tmpFieldName;
// this.sqlString=sqlString+")values("+tmpValueList+")";
// sqlDataItem.CommandText = sqlString;
//}
//private void setUpdateSql()
//{
// string tmpFieldName="";
// int tmpInt=this.fieldList.Length;
// sqlString="update "+tableName+" set ";
// for(int i=0;i<tmpInt-1;i++)
// {
// tmpFieldName=this.fieldList[i].ToString();
// sqlString=sqlString+tmpFieldName+"=@"+tmpFieldName+",";
// }
// tmpFieldName=fieldList[tmpInt-1].ToString();
// sqlString=sqlString+tmpFieldName+"=@"+tmpFieldName;
// sqlString=sqlString+" where "+keyField+"=@"+keyField;
// sqlDataItem.CommandText = sqlString;
//}
/// <summary>
/// 新建 一个流程模板
/// </summary>
public void InsertWorkFlow()
{
if (WorkFlowId.Trim().Length==0||WorkFlowId==null)
throw new Exception("InsertWorkFlow方法错误，WorkFlowId 不能为空！");
try
{
//setInsertSql();//设定insert语句
//setParameter();//设定参数
//ClientDBAgent agent = new ClientDBAgent();
//agent.ExecuteNonQuery(sqlDataItem);
WF_WorkFlow wf = new WF_WorkFlow();
wf.WorkFlowId= WorkFlowId;
wf.WFClassId= WorkFlowClassId;
wf.FlowCaption= WorkFlowCaption;
wf.Description= Description;
wf.Status= Status;
wf.MgrUrl= MgrUrl;
MainHelper.PlatformSqlMap.Create<WF_WorkFlow>(wf);
}
catch (Exception ex)
{
throw ex;
}
}
void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) {
if (FocusedNodeChanged != null)
{
//DataRow dr = treeList1.GetDataRecordByNode(e.Node) as DataRow;
WF_WorkFlow wf = new WF_WorkFlow();
if (e.Node["Kind"].ToString() == "流程")
{
wf.FlowCaption = e.Node["FlowCaption"].ToString();
wf.WFClassId = e.Node["WFClassId"].ToString();
wf.WorkFlowId = e.Node["WorkFlowId"].ToString();
FocusedNodeChanged(treeList1, wf);
}
else
{
FocusedNodeChanged(treeList1, null);
}
}
}
void treeViewOperator_AfterAdd(WF_WorkFlow newobj) {
if (AfterAdd != null)
AfterAdd(treeList1, newobj);
}
void treeViewOperator_AfterDelete(WF_WorkFlow newobj) {
if (AfterDelete != null)
AfterDelete(treeList1, newobj);
}
void treeViewOperator_CreatingObject(WF_WorkFlow newobj) {
//newobj.OrgType = "0";
}