void gridViewOperation_AfterAdd(PJ_yfsyhcjl obj) { if (isWorkflowCall) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ModleRecordID = obj.ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.CreatTime = DateTime.Now; mrwt.ModleTableName = obj.GetType().ToString(); MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt); } string slqwhere = " where OrgCode='" + obj.OrgCode + "' "; if (isWorkflowCall) { slqwhere = slqwhere + " and id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where RecordID='" + CurrRecord.ID + "'"; slqwhere = slqwhere + " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'" + " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'" + " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "')"; } //slqwhere = slqwhere + " order by xh"; obj.xh = MainHelper.PlatformSqlMap.GetRowCount<PJ_yfsyhcjl>(slqwhere); MainHelper.PlatformSqlMap.Update<PJ_yfsyhcjl>(obj); RefreshData(" where OrgCode='" + ParentID + "' "); }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_yfsyhcjl newobj) { if ( parentID == null) { return; } try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { } }
void gridViewOperation_AfterDelete(PJ_yfsyhcjl obj) { string slqwhere = " where OrgCode='" + obj.OrgCode +"' "; if (isWorkflowCall) { slqwhere = slqwhere + " and id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where RecordID='" + CurrRecord.ID + "'"; slqwhere = slqwhere + " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'" + " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'" + " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "')"; MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>("where ModleRecordID='" + obj.ID + "'" + " and ModleTableName='" + obj.GetType().ToString() + "'" + " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'" + " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "'" ); } slqwhere = slqwhere + " order by xh"; IList<PJ_yfsyhcjl> li = MainHelper.PlatformSqlMap.GetListByWhere<PJ_yfsyhcjl>(slqwhere); int i = 1; List<PJ_yfsyhcjl> list = new List<PJ_yfsyhcjl>(); foreach (PJ_yfsyhcjl ob in li) { ob.xh = i; i++; list.Add(ob); } 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); RefreshData(" where OrgCode='" + obj.OrgCode +"' "); }