مستند مسئله انتخاب اقدام کنندگان در گرید

using System;

using System.Data;

using System.Data.SqlClient;

using Chargoon.Didgah.BPMS.CommonApi;

namespace Chargoon.Didgah.BPMS.Runtime

{

public class ScriptTask : IScriptTask

{

public IExecution Execution { get; set; }

public void Execute()

{

DataTable dt = new DataTable();

int counttable = 0;

SqlConnection conn = new SqlConnection();

conn.ConnectionString = Execution.GetConnectionString(“BPMSC601″);

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandText = @”SELECT TASKOWNER FROM  bpm_KalaNavganShargh_Extra_SampleGrid

WHERE ParentGuid = @BusinessKey AND TASKOWNER is not null”;

cmd.Parameters.AddWithValue(“@BusinessKey”,Execution.GuidValue(“___BusinessKey”));

conn.Open();

dt.Load(cmd.ExecuteReader());

conn.Close();

SqlCommand cmd2 = new SqlCommand();

cmd2.Connection = conn;

cmd2.CommandText = @”SELECT COUNT(*) as counttable FROM bpm_KalaNavganShargh_Extra_SampleGrid

WHERE ParentGuid = @BusinessKey AND TASKOWNER is not null”;

cmd2.Parameters.AddWithValue(“@BusinessKey”,Execution.GuidValue(“___BusinessKey”));

conn.Open();

counttable = Convert.ToInt32(cmd2.ExecuteScalar());

conn.Close();

Execution.SetVariable(“dtVariable”,dt);

Execution.SetVariable(“counttable”,counttable);

Execution.SetVariable(“i”,0);

}

}

}

using System;

using Chargoon.Didgah.BPMS.CommonApi;

namespace Chargoon.Didgah.BPMS.Runtime

{

public class ConditionalFlow : IConditionalFlow

{

public IExecution Execution { get; set; }

public bool Evaluate()

{

return Execution.IntegerValue(“counttable”)>0;

}

}

}

using System;

using Chargoon.Didgah.BPMS.CommonApi;

namespace Chargoon.Didgah.BPMS.Runtime

{

public class ConditionalFlow : IConditionalFlow

{

public IExecution Execution { get; set; }

public bool Evaluate()

{ if(Execution.IntegerValue(“i”)<Execution.IntegerValue(“counttable”))

return true;

else

return false;

}

}

}

using System;

using System.Data;

using Chargoon.Didgah.BPMS.CommonApi;

namespace Chargoon.Didgah.BPMS.Runtime

{

public class ScriptTask : IScriptTask

{

public IExecution Execution { get; set; }

public void Execute()

{ int[] arrray = new int[Execution.DataTableValue(“dtVariable”).Rows.Count];

for (int i = 0; i < Execution.DataTableValue(“dtVariable”).Rows.Count; i++)

{

arrray[i] = Convert.ToInt32(Execution.DataTableValue(“dtVariable”).Rows[i][0]);

}

Execution.SetVariable(“abc”,arrray[Execution.IntegerValue(“i”)]);

}

}

}

using System;

using Chargoon.Didgah.BPMS.CommonApi;

namespace Chargoon.Didgah.BPMS.Runtime

{

public class ScriptTask : IScriptTask

{

public IExecution Execution { get; set; }

public void Execute()

{

int temp = Execution.IntegerValue(“i”);

temp += 1;

Execution.SetVariable(“i”,temp);

}

}

}

using System;

using Chargoon.Didgah.BPMS.CommonApi;

namespace Chargoon.Didgah.BPMS.Runtime

{

public class OwnerSelector : IOwnerSelector

{

public Iexecution Execution { get; set; }

public Owner GetOwner()

{

int UserStaffId = Execution.IntegerValue(“abc”);

return new Owner(UserStaffId);

}

}

}