//private void setParameter() //{ // sqlDataItem.ParameterList.Clear(); // sqlDataItem.AppendParameter("@OperatorId", this.OperatorId); // sqlDataItem.AppendParameter("@WorkFlowId", this.WorkFlowId); // sqlDataItem.AppendParameter("@WorkTaskId", this.WorkTaskId); // sqlDataItem.AppendParameter("@OperType", this.OperType,typeof(int)); // sqlDataItem.AppendParameter("@OperContent", this.OperContent); // sqlDataItem.AppendParameter("@Relation", this.Relation, typeof(int)); // sqlDataItem.AppendParameter("@Description", this.Description); // sqlDataItem.AppendParameter("@InorExclude", this.InorExclude,typeof(bool)); // sqlDataItem.AppendParameter("@OperDisplay", this.OperDisplay); //} /// <summary> ///// 增加一个处理者的语句 ///// </summary> //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; //} ///// <summary> ///// 修改当前处理者的语句 ///// </summary> //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 + "=@" + this.keyField; // sqlDataItem.CommandText = sqlString; //} /// <summary> ///增加处理者 /// </summary> public void InsertOperator() { if (OperatorId.Trim().Length == 0 || OperatorId == null) throw new Exception("InsertOperator方法错误,OperatorId 不能为空!"); try { //setInsertSql();//设定insert语句 //setParameter();//设定参数 //ClientDBAgent agent = new ClientDBAgent(); //agent.ExecuteNonQuery(sqlDataItem); WF_Operator op = new WF_Operator(); op.OperatorId=this.OperatorId; op.WorkFlowId=this.WorkFlowId; op.WorkTaskId=this.WorkTaskId; op.OperType=this.OperType; op.OperContent=this.OperContent; op.Relation=this.Relation; op.Description=this.Description; op.InorExclude = this.InorExclude; op.OperDisplay = this.OperDisplay; MainHelper.PlatformSqlMap.Create<WF_Operator>(op); } catch (Exception ex) { throw ex; } }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); InitColumns();//初始列 InitData();//初始数据 List<WF_Operator> wflist2 = new List<WF_Operator>(); IList<WF_WorkFlow> list = MainHelper.PlatformSqlMap.GetList<WF_WorkFlow>("SelectWF_WorkFlowList", "where FlowCaption like '%分析%'"); foreach (WF_WorkFlow wf in list) { IList<WF_WorkTask> list2 = MainHelper.PlatformSqlMap.GetList<WF_WorkTask>("SelectWF_WorkTaskList", "where WorkFlowId='" + wf.WorkFlowId + "' and TaskTypeId!='2' order by TaskTypeId"); foreach (WF_WorkTask wt in list2) { WF_Operator wfop = (WF_Operator)MainHelper.PlatformSqlMap.GetObject("SelectWF_OperatorList", "where WorkFlowId='" + wt.WorkFlowId + "' and WorkTaskId='" + wt.WorkTaskId + "' and OperContent='all'"); if (wfop == null) { wfop = new WF_Operator(); wfop.OperatorId = Guid.NewGuid().ToString(); wfop.OperContent = "all"; wfop.Description = "所有人"; wfop.OperDisplay = "所有人"; wfop.WorkFlowId = wt.WorkFlowId; wfop.WorkTaskId = wt.WorkTaskId; wfop.OperType = 5; wfop.InorExclude = true; wflist2.Add(wfop); } } } if (wflist2.Count > 0) { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); SqlQueryObject wfobj3 = new SqlQueryObject(SqlQueryType.Insert, wflist2.ToArray()); list3.Add(wfobj3); MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } if (this.Site != null) return; btGdsList.Edit = DicTypeHelper.GdsDic; btGdsList.EditValueChanged += new EventHandler(btGdsList_EditValueChanged); if (MainHelper.UserOrg != null && MainHelper.UserOrg.OrgType == "1") {//如果是供电所人员,则锁定 btGdsList.EditValue = MainHelper.UserOrg.OrgCode; btGdsList.Edit.ReadOnly = true; } }
public bool Save() { bool flag = true; List<string> list = new List<string>(); List<rRoleModul> list2 = new List<rRoleModul>(); //List<string> wflist1 = new List<string>(); List<WF_Operator> wflist2 = new List<WF_Operator>(); this.getCheckList(this.treeList1.Nodes, list); foreach (string str in list) { rRoleModul function = new rRoleModul(); function.RoleID = this.m_RoleID; function.Modu_ID = str; list2.Add(function); TreeListNode td = treeList1.FindNodeByKeyID(str); if (td["Description"].ToString () == "工作流") { WF_WorkTask wt = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkTask>(str); if (wt!= null) { mRole mrl = MainHelper.PlatformSqlMap.GetOneByKey<mRole>(RoleID); WF_Operator wfop = new WF_Operator(); wfop.OperatorId = Guid.NewGuid().ToString(); wfop.OperContent = RoleID; wfop.Description = mrl.RoleName; wfop.OperDisplay = mrl.RoleName; wfop.WorkFlowId = wt.WorkFlowId; wfop.WorkTaskId = wt.WorkTaskId; wfop.OperType = 5; wfop.InorExclude = true; wflist2.Add(wfop); } //wflist1.Add(" where WorkTaskId='" + str + "' and OperContent='" + RoleID + "'"); } } SqlQueryObject item = new SqlQueryObject(SqlQueryType.Delete, "DeleterRoleModulByWhere", "where RoleID='" + this.m_RoleID + "'"); SqlQueryObject item2 = new SqlQueryObject(SqlQueryType.Delete, "DeleteWF_OperatorInstanceByWhere", "where OperContent='" + this.m_RoleID + "'"); SqlQueryObject wfitem = new SqlQueryObject(SqlQueryType.Delete, "DeleteWF_OperatorByWhere", "where OperContent='" + this.m_RoleID + "'"); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); list3.Add(item); list3.Add(item2); if (list2.Count>0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, list2.ToArray()); list3.Add(obj3); } list3.Add(wfitem); if (wflist2.Count > 0) { SqlQueryObject wfobj3 = new SqlQueryObject(SqlQueryType.Insert, wflist2.ToArray()); list3.Add(wfobj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } catch (Exception exception) { MainHelper.ShowWarningMessageBox(exception.Message); flag = false; } return flag; }