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); }