private void mainMenuPrintChk_Click(object sender, EventArgs e)
{
//listBox1.Items.Clear();
/*if (listView1.CheckedItems.Count != 0) {
listchecked();
if (listView1.CheckedItems.Count != 0) labelResult.Text = ": " + listView1.CheckedItems.Count.ToString();
else labelResult.Text = ": ";
} else {labelResult.Text = ": ";}*/
ArrayList alMembers = new ArrayList();
ArrayList alPrintSelect = new ArrayList();
mylib ml = new mylib();
ml.delete("DELETE FROM PrintTable");
bool print = false;
foreach (DataGridViewRow row in dgMembers.Rows) {
if (Convert.ToBoolean(row.Cells[0].Value) == true) {
print = true;
DataGridViewCell cell = row.Cells[1];
alMembers.Add(cell.Value.ToString());
string val = alMembers[(alMembers.Count - 1)].ToString();
//MessageBox.Show(val);
string cmd1 = "SELECT * FROM cards WHERE uid = '" + val + "'";
alPrintSelect = (ArrayList)ml.select(cmd1);
if (alPrintSelect.Count != 0) {
foreach (object[] myTargetArray in alPrintSelect) {
string cid = myTargetArray[0].ToString();
string uid = myTargetArray[1].ToString();
string tip = myTargetArray[2].ToString();
string phid = myTargetArray[3].ToString();
ml.insert("INSERT INTO PrintTable (cid,phid,uid,tip) VALUES ('" + cid + "','" + phid + "','" + uid + "','" + tip + "')");
}
}
}
}
if (print) {
//report1.Load();
//report1.RegisterData();
report1.Show();
}
}
