private void AddMoudle_Click(object sender, EventArgs e)
{
if (treeList1.FocusedNode == null)
return;
//TreeListHitInfo hit = treeList1.CalcHitInfo(treeList1.PointToClient(Control.MousePosition));
//if (hit.Node != null && hit.Column != null)
try
{
LP_Temple obj = MainHelper.PlatformSqlMap.GetOneByKey<LP_Temple>(treeList1.FocusedNode["LPID"]);
WF_TableUsedField um = new WF_TableUsedField();
um.UserControlId = tableid;
um.FieldName =obj.CellName ;
um.FieldId =obj.LPID ;
um.WorkflowId= workflowId;
um.WorktaskId=worktaskId;
DataRow dr = udt.NewRow();
dr["ID"] = um.ID;
dr["UserControlId"] = um.UserControlId;
dr["FieldName"] = um.FieldName;
dr["FieldId"] = um.FieldId;
dr["WorkflowId"] = um.WorkflowId;
dr["WorktaskId"] = um.WorktaskId;
udt.Rows.Add(dr);
treeList1.Nodes.Remove(treeList1.FocusedNode);
//treeList1.FocusedNode = treeList1.FocusedNode.NextVisibleNode;
MainHelper.PlatformSqlMap.Create<WF_TableUsedField>(um);
}
catch( Exception ex)
{
Console.WriteLine(ex.Message );
}
}
private void AddAllMoudle_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; mdt.Rows.Count > 0; )
{
LP_Temple obj = MainHelper.PlatformSqlMap.GetOneByKey<LP_Temple>(mdt.Rows[i]["LPID"]);
WF_TableUsedField um = new WF_TableUsedField();
um.UserControlId = tableid;
um.FieldName = obj.CellName;
um.FieldId = obj.LPID;
um.WorkflowId = workflowId;
um.WorktaskId = worktaskId;
DataRow dr = udt.NewRow();
dr["ID"] = um.ID;
dr["UserControlId"] = um.UserControlId;
dr["FieldName"] = um.FieldName;
dr["FieldId"] = um.FieldId;
dr["WorkflowId"] = um.WorkflowId;
dr["WorktaskId"] = um.WorktaskId;
udt.Rows.Add(dr);
mdt.Rows.Remove(mdt.Rows[i]);
//treeList1.FocusedNode = treeList1.FocusedNode.NextVisibleNode;
MainHelper.PlatformSqlMap.Create<WF_TableUsedField>(um);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
void copyData(LP_Temple lp, IList<LP_Temple> templeList)
{
if (templeList.Count == 0) return;
string flowid = lp.ParentID;
int i = 1;
List<LP_Temple> list = new List<LP_Temple>();
string workflowid = flowid;
IList<WF_WorkTask> wftli = MainHelper.PlatformSqlMap.GetList<WF_WorkTask>("SelectWF_WorkTaskList", "where WorkFlowId='" + workflowid + "' and TaskTypeId!='2' order by TaskTypeId");
foreach (WF_WorkTask wft in wftli)
{
//保存关联模块
WorkFlowTask.DeleteAllModle(wft.WorkTaskId);
mModule mu = MainHelper.PlatformSqlMap.GetOne<mModule>("where ModuName='表单执行平台' and ModuTypes='Ebada.Scgl.Lcgl.frmLP'");
WorkFlowTask.SetTaskUserModle(mu.Modu_ID, wft.WorkFlowId, wft.WorkTaskId);
//保存关联表单
WorkFlowTask.DeleteAllControls(wft.WorkTaskId);
WorkFlowTask.DeleteAllTableField(wft.WorkFlowId, wft.WorkTaskId);
string sqlStr = " where WorkTaskId='" + wft.WorkTaskId + "'";
MainHelper.PlatformSqlMap.DeleteByWhere<WF_WorkTaskControls>(sqlStr);
WorkFlowTask.SetTaskUserCtrls(templeList[0].ParentID, workflowid, wft.WorkTaskId);
}
i = 1;
foreach (LP_Temple obj in templeList)
{
obj.SortID = i;
if (obj.SignImg == null)
{
obj.SignImg = new byte[0];
}
if (obj.ImageAttachment == null)
{
obj.ImageAttachment = new byte[0];
}
if (obj.DocContent == null)
{
obj.DocContent = new byte[0];
}
i++;
if (obj.CellName == "6.3 其他安全措施和注意事项" && obj.Status == "")
{
obj.Status = "填票";
}
if (obj.CellName.IndexOf("终了时间") > -1)
{
obj.WordCount = "dd日 HH:mm";
}
else
if (obj.CellName.IndexOf("同意执行时间") > -1)
{
obj.WordCount = "MM-dd日 HH:mm";
}
else
if (obj.CellName.IndexOf("时间") > -1)
{
obj.WordCount = "yyyy-MM-dd HH:mm";
}
if (obj.SqlSentence == "SelectmOrgList where parentid='0'")
{
obj.SqlSentence = "Select OrgName from mOrg where parentid='0'";
obj.SqlColName = "";
}
if (obj.SqlSentence.IndexOf("SelectmUserList where OrgName ='@1'") > -1)
{
obj.SqlSentence = "Select UserName from mUser where OrgName='{1}'";
obj.SqlColName = "";
}
if (lp.CellName == "电力线路第一种工作票")
{
//if (obj.KindTable == "")
{
obj.KindTable = "工作票";
}
}
if (lp.CellName == "电力线路第二种工作票")
{
//if (obj.KindTable == "")
{
obj.KindTable = "Sheet1";
}
}
if (lp.CellName == "电力线路倒闸操作票")
{
//if (obj.KindTable == "")
{
obj.KindTable = "Sheet1";
}
}
if (lp.CellName == "电力线路事故应急抢修单")
{
if (obj.KindTable == "")
{
obj.KindTable = "Sheet1";
}
}
if (obj.SqlSentence == "SelectmOrgList where parentid=(select OrgID From mOrg where OrgName='@1')")
//if (obj.SqlSentence == "Select OrgName from mOrg where parentid=(select OrgID From mOrg where OrgName={1})")
{
obj.SqlSentence = "Select OrgName from mOrg where parentid=(select OrgID From mOrg where OrgName='{1}')";
obj.SqlColName = "";
}
WF_WorkTask wt = MainHelper.PlatformSqlMap.GetOne<WF_WorkTask>(
"where WorkFlowId='" + workflowid + "' and TaskCaption='" + obj.Status + "'");
if (wt == null)
{
continue;
}
WF_TableUsedField tuf = MainHelper.PlatformSqlMap.GetOne<WF_TableUsedField>("where FieldName='" + obj.CellName +
"' and UserControlId='" + obj.ParentID + "'");
if (tuf == null)
{
WF_TableUsedField um = new WF_TableUsedField();
um.ID = um.CreateID();
um.UserControlId = obj.ParentID;
um.FieldName = obj.CellName;
um.FieldId = obj.LPID;
um.WorkflowId = workflowid;
um.WorktaskId = wt.WorkTaskId;
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
MainHelper.PlatformSqlMap.Create<WF_TableUsedField>(um);
}
list.Add(obj);
}
List<SqlQueryObject> list3 = new List<SqlQueryObject>();
if (list.Count > 0)
{
SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray());
list3.Add(obj3);
}
MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3);
}
