private void TimeLine_Load(object sender, EventArgs e)
{
int index = 0;
DataGridViewImageColumn status = new DataGridViewImageColumn();
status.Name = "image";
status.HeaderText = "图片";
status.Width = 150;
dataGridView1.Columns.Insert(2, status);
int a = 0;
ImageOP imageOP = new ImageOP();
MessageDAO messageDAO = new MessageDAO(new Database(Program.constr));
List <MixMsg> arrayList = messageDAO.GetData();
int i = 0;
while (i < arrayList.Count && a < 5)
{
index = this.dataGridView1.Rows.Add();
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[index].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[index].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[index].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[index].Cells[3].Value = mx.Time;
i++;
a++;
}
row = a;
lastn = a;
dataGridView1.AllowUserToAddRows = false;
}
private void TimeLine_Load(object sender, EventArgs e)
{
int index = 0;
DataGridViewImageColumn status = new DataGridViewImageColumn();
status.Name = "image";
status.HeaderText = "图片";
status.Width = 150;
dataGridView1.Columns.Insert(2, status);
int a = 0;
ImageOP imageOP = new ImageOP();
Database database = new Database(Program.constr);
MessageDAO messageDAO = new MessageDAO(database);
string command = "select account,information,image,time from infos natural join users order by time desc";
IDataReader reader = database.GetReader(command);
List <MixMsg> arrayList = messageDAO.GetData(reader);
int i = 0;
while (i < arrayList.Count && a < 5)
{
index = this.dataGridView1.Rows.Add();
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[index].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[index].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[index].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[index].Cells[3].Value = mx.Time;
i++;
a++;
}
row = a;
lastn = a;
dataGridView1.AllowUserToAddRows = false;
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
ImageOP imageOP = new ImageOP();
MessageDAO messageDAO = new MessageDAO(new Database(Program.constr));
List <MixMsg> arrayList = messageDAO.GetData();
int n = arrayList.Count();
if (n == row)
{
return;
}
else if (n == lastn)
{
return;
}
else if (n > lastn && n <= 5)
{
for (int a = lastn; a < n; a++)
{
this.dataGridView1.Rows.Add();
}
int i = 0;
while (i < arrayList.Count)
{
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[i].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[i].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[i].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[i].Cells[3].Value = mx.Time;
i++;
}
lastn = n;
}
else if (n > 5 && lastn < 5)
{
for (int a = lastn; a < 5; a++)
{
this.dataGridView1.Rows.Add();
}
int i = 0;
while (i < arrayList.Count && i < 5)
{
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[i].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[i].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[i].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[i].Cells[3].Value = mx.Time;
i++;
}
lastn = n;
}
else
{
int i = 0;
int a = 0;
while (i < arrayList.Count && a < 5)
{
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[i].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[i].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[i].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[i].Cells[3].Value = mx.Time;
i++;
a++;
}
}
dataGridView1.AllowUserToAddRows = false;
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
ImageOP imageOP = new ImageOP();
Database database = new Database(Program.constr);
MessageDAO messageDAO = new MessageDAO(database);
string command = "select account,information,image,time from infos natural join users order by time desc";
IDataReader reader = database.GetReader(command);
List <MixMsg> arrayList = messageDAO.GetData(reader);
int n = arrayList.Count();
if (n == row)
{
return;
}
else if (n == lastn)
{
return;
}
else if (n > lastn && n <= 5)
{
for (int a = lastn; a < n; a++)
{
this.dataGridView1.Rows.Add();
}
int i = 0;
while (i < arrayList.Count)
{
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[i].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[i].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[i].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[i].Cells[3].Value = mx.Time;
i++;
}
lastn = n;
}
else if (n > 5 && lastn < 5)
{
for (int a = lastn; a < 5; a++)
{
this.dataGridView1.Rows.Add();
}
int i = 0;
while (i < arrayList.Count && i < 5)
{
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[i].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[i].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[i].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[i].Cells[3].Value = mx.Time;
i++;
}
lastn = n;
}
else
{
int i = 0;
int a = 0;
while (i < arrayList.Count && a < 5)
{
MixMsg mx = arrayList[i];
this.dataGridView1.Rows[i].Cells[0].Value = mx.Account;
this.dataGridView1.Rows[i].Cells[1].Value = mx.Information;
this.dataGridView1.Rows[i].Cells[2].Value = imageOP.GetImageByPath(mx.Image);
this.dataGridView1.Rows[i].Cells[3].Value = mx.Time;
i++;
a++;
}
}
dataGridView1.AllowUserToAddRows = false;
}