public DataRowCollection GetTasksForSlave(string strInSlaves, ShowMadeTask showMadeTask, int masterID)
{
string paramShowMade = "0,1";
if (showMadeTask == ShowMadeTask.ShowMade)
{
paramShowMade = "1";
}
if (showMadeTask == ShowMadeTask.ShowNotMade)
{
paramShowMade = "0";
}
List <int> slaves = new List <int>();
string connectionString = cs.ToString();
FbConnection connection = new FbConnection(connectionString);
connection.Open();
string selectSQL;
selectSQL = string.Format(@"select t.*, e.shortname as slavefio, m.shortname as masterfio
from tasks t
left join employees e
on t.executorid = e.id
left join employees m
on t.managerid = m.id
where t.executorid in ({0}) and t.isdelete = 0 and t.commitmake in ({1})
and (t.executorid != t.managerid or t.managerid = {2})
order by t.maketask, t.deadline", strInSlaves, paramShowMade, masterID);
DataSet myDataSet = new DataSet();
FbCommand sel_com = new FbCommand(selectSQL, connection);
FbDataAdapter myDataAdapter = new FbDataAdapter(sel_com);
myDataAdapter.Fill(myDataSet, "FREQ");
connection.Close();
DataRowCollection dra = myDataSet.Tables["FREQ"].Rows;
return(dra);
}
private void allTaskToolStripMenuItem_Click(object sender, EventArgs e)
{
currentShowMadeTask = ShowMadeTask.ShowAll;
ReloadData();
}
private void undoneToolStripMenuItem_Click(object sender, EventArgs e)
{
currentShowMadeTask = ShowMadeTask.ShowNotMade;
ReloadData();
}
private void toolStripButton6_Click(object sender, EventArgs e)
{
currentShowMadeTask = ShowMadeTask.ShowNotMade;
ReloadData();
}
