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(); }