private string GetInputQuery(CodeActivityContext context)
{
var cardsInput = new List <string>();
var first = Amount.Get(context);
var after = AfterCursor.Get(context);
if (first <= 0)
{
first = 20;
}
cardsInput.Add("first: " + first);
if (!string.IsNullOrWhiteSpace(after))
{
cardsInput.Add(string.Format("after: {0}", after.ToQueryValue()));
}
var searchFields = new List <string>();
var assignees = AssignedTo.Get(context);
var ignoreIds = IgnoreIDs.Get(context);
var labels = Labels.Get(context);
var title = Title.Get(context);
if (assignees?.Length > 0)
{
searchFields.Add(string.Format("assignee_ids: {0}", assignees.ToQueryValue()));
}
if (ignoreIds?.Length > 0)
{
searchFields.Add(string.Format("ignore_ids: {0}", ignoreIds.ToQueryValue()));
}
if (labels?.Length > 0)
{
searchFields.Add(string.Format("label_ids: {0}", labels.ToQueryValue()));
}
if (!string.IsNullOrWhiteSpace(title))
{
searchFields.Add(string.Format("title: {0}", title.ToQueryValue()));
}
string searchFieldsStr = string.Empty;
if (searchFields.Count > 0)
{
searchFieldsStr = "search { " + string.Join(" ", searchFields) + " }";
cardsInput.Add(searchFieldsStr);
}
return(string.Join(" ", cardsInput));
}
protected override void Execute(CodeActivityContext context)
{
Lead l = Lead.Get(context);
l.AssignedTo = AssignedTo.Get(context);
l.Status = "Assigned";
PersistLead persist = context.GetExtension <PersistLead>();
persist.AddLead(l, "Update");
// Store the request in the OutArgument
Lead.Set(context, l);
}
protected override void Execute(CodeActivityContext context)
{
MeetingApplyForm meetingApplyForm = new MeetingApplyForm();
YunShanOA.DataAccess.Mapping.YunShanOADataContext dc = new YunShanOADataContext();
meetingApplyForm.ApplyUserName = AssignedTo.Get(context).ApplyUserName;
meetingApplyForm.BeginTime = AssignedTo.Get(context).BeginTime;
meetingApplyForm.Comments = AssignedTo.Get(context).Comments;
meetingApplyForm.EndTime = AssignedTo.Get(context).EndTime;
meetingApplyForm.MeetingIntroduction = AssignedTo.Get(context).MeetingIntroduction;
meetingApplyForm.MeetingStatus = 2;
meetingApplyForm.MeetingTopic = AssignedTo.Get(context).MeetingTopic;
meetingApplyForm.MeetingTypeID = AssignedTo.Get(context).MeetingTypeID;
meetingApplyForm.WFID = context.WorkflowInstanceId;
var query = from p in dc.Workflows where p.WFID == meetingApplyForm.WFID select p;
if (0 == query.Count())
{
YunShanOA.DataAccess.Mapping.Workflows wf = new Workflows();
wf.WFID = meetingApplyForm.WFID;
wf.WFTID = Guid.NewGuid();
dc.Workflows.InsertOnSubmit(wf);
}
var query1 = from p in dc.MeetingApplyForm where p.WFID == meetingApplyForm.WFID select p;
if (0 == query1.Count())
{
dc.MeetingApplyForm.InsertOnSubmit(meetingApplyForm); //将数据插入到MeetingApplyForm表
dc.SubmitChanges(); //提交MeeingApplyForm的更改，以便下面根据WFID来查询MeetingApplyFormID
var quer = from p in dc.MeetingApplyForm where p.WFID == meetingApplyForm.WFID select p;
if (0 != quer.Count())
{
Model.MeetingRoom mar = new Model.MeetingRoom();
mar = MeetingRoomNameAndID.Get(context);
int meetingApplyFormID = quer.First().MeetingApplyFormID;
DataAccess.Mapping.MeetingAndRoom m = new MeetingAndRoom();
m.Status = 2;
m.MeetingApplyFormID = meetingApplyFormID;
m.MeetingRoomID = mar.MeetingRoomID;
dc.MeetingAndRoom.InsertOnSubmit(m);
dc.SubmitChanges();
}
}
Apply.Set(context, meetingApplyForm);
}
protected override void Execute(CodeActivityContext context)
{
// Create an Assignment class and populate its properties
Assignment a = new Assignment();
a.WorkflowID = context.WorkflowInstanceId;
a.LeadID = LeadID.Get(context);
a.DateAssigned = DateTime.Now;
a.AssignedTo = AssignedTo.Get(context);
a.Status = "Assigned";
a.DateDue = DateTime.Now + TimeSpan.FromDays(5);
PersistAssignment persist = context.GetExtension <PersistAssignment>();
persist.AddAssignment(context.WorkflowInstanceId, a, "Insert");
// Store the request in the OutArgument
Assignment.Set(context, a);
}
protected override void Execute(NativeActivityContext context)
{
// Get the connection string
DBExtension ext = context.GetExtension <DBExtension>();
if (ext == null)
{
throw new InvalidProgramException("No connection string available");
}
// Query the Lead table
LeadDataDataContext dc = new LeadDataDataContext(ext.ConnectionString);
dc.Refresh(RefreshMode.OverwriteCurrentValues, dc.Leads);
Lead l = dc.Leads.SingleOrDefault <Lead>
(x => x.WorkflowID == context.WorkflowInstanceId);
if (l == null)
{
throw new InvalidProgramException
("The Lead was not found in the database");
}
l.AssignedTo = AssignedTo.Get(context);
l.Status = "Assigned";
// Enlist on the current transaction
RuntimeTransactionHandle rth = new RuntimeTransactionHandle();
rth = context.Properties.Find(rth.ExecutionPropertyName)
as RuntimeTransactionHandle;
if (rth != null)
{
Transaction t = rth.GetCurrentTransaction(context);
dc.Connection.EnlistTransaction(t);
}
dc.SubmitChanges();
// Store the request in the OutArgument
Lead.Set(context, l);
}