DataGridView的带图片滚动浏览
来源:互联网 发布:蛋糕网络营销策划方案 编辑:程序博客网 时间:2024/04/29 00:25
给一个司机班做的班次浏览
界面图片没加上~~~~~总报脚本错误:附个链接吧
http://p.blog.csdn.net/images/p_blog_csdn_net/cling_clang/376310/o_1.JPG
界面图片没加上~~~~~总报脚本错误:附个链接吧
http://p.blog.csdn.net/images/p_blog_csdn_net/cling_clang/376310/o_1.JPG
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using Ini;
using System.Resources;
using System.Threading;
namespace cshow
{
public partial class Form1 : Form
{
private Point mouseOffset; //记录鼠标指针的坐标
private bool isMouseDown = false; //记录鼠标按键是否按下
ArrayList obj;
int screenrows, picscal;
static string runPath=@AppDomain.CurrentDomain.BaseDirectory;
System.Resources.ResourceManager rm = null;
public Form1()
{
InitializeComponent();
rm = new System.Resources.ResourceManager("cshow.Form1", System.Reflection.Assembly.GetExecutingAssembly());
}
private void Form1_Load(object sender, EventArgs e)
{
/* DBAccess.DBAccess dba = new DBAccess.DBAccess();
OleDbDataReader reader2 = dba.GetReader("select workdate as 日期,isout as 接送,manname as 客人姓名,mannum as 人数,code as 航班,worktime as 时间,outtime as 出发时间,tozone as 到着地,dyer as 对应者,drivers as 司机,automotive as 车辆,other as 其他 from today where workdate=#" + System.DateTime.Now.ToString("yyyy-MM-dd") + "# order by id");
if (!reader2.HasRows)
{
dba.CloseDB();
return;
}
dba.CloseDB();
*/
System.Windows.Forms.Screen screen=Screen.PrimaryScreen;
System.Drawing.Rectangle rct=screen.Bounds;
this.Height=rct.Height;//高度
this.Width=rct.Width;//宽度
IniFile ini = new IniFile(runPath + "config.ini");
obj = new ArrayList();
dg1.Width = this.Width;
dg1.Height = this.Height;
btnPanel.Left = this.Width - btnPanel.Width - 10;
if (ini.IniReadValue("other", "twoScreen") == "1")
{
this.Left = rct.Width + 1;
}
screenrows = Int16.Parse(ini.IniReadValue("other", "screenrows"));
picscal = Int16.Parse(ini.IniReadValue("pic", "scal"));
todayDate.Text = rm.GetString("todayTitle") + " " + System.DateTime.Now.ToString("d");
show(SetObj());
int x=Int32.Parse(ini.IniReadValue("time","scrolltime"));
int y = Int32.Parse(ini.IniReadValue("time", "AtoBformtime"));
if (x > 0)
{
timerScroll1.Interval = x * 60000;
timerScroll1.Enabled = true;
}
if (y > 0)
{
timerA.Interval = y * 60000;
timerA.Enabled = true;
}
}
private ArrayList SetObj()
{
int i;
obj.Clear();
ArrayList[] al=new ArrayList[50];
for(i=0; i < 20; i++)
{
al[i] = new ArrayList();
}
DBAccess.DBAccess dba = new DBAccess.DBAccess();
OleDbDataReader reader = dba.GetReader("select workdate,isout,manname,mannum,code,worktime,outtime,tozone,dyer,drivers,automotive,other from today where workdate=#"+System.DateTime.Now.ToString("yyyy-MM-dd")+"# order by id");
i = 0;
while (reader.Read())
{
al[i].Add(reader[0].ToString().Trim());
al[i].Add(reader[1].ToString().Trim());
al[i].Add(reader[2].ToString().Trim());
al[i].Add(reader[3].ToString().Trim());
al[i].Add(reader[4].ToString().Trim());
al[i].Add(reader[5].ToString().Trim());
al[i].Add(reader[6].ToString().Trim());
al[i].Add(reader[7].ToString().Trim());
al[i].Add(reader[8].ToString().Trim());
al[i].Add(GetPic(@reader[9].ToString().Trim(), 0));
al[i].Add(GetPic(@reader[10].ToString().Trim(), 1));
al[i].Add(reader[11].ToString().Trim());
al[i].Add(reader[9].ToString().Trim());
al[i].Add(reader[10].ToString().Trim());
obj.Add(al[i]);
i++;
}
for (int j = obj.Count; j < screenrows; j++)
{
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(new Bitmap(1,1));
al[j].Add(new Bitmap(1,1));
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
obj.Add(al[j]);
}
dba.CloseDB();
return obj;
}
private void show(ArrayList obj)
{
int i = 0;
string sjname = "", qcname = "";
//string picpath = "Image/";
//string sjimage = "", qcimage = "";
Bitmap sjimage = null;
Bitmap qcimage = null;
DataTable firstdt = new DataTable("first");
firstdt.Columns.Add(new DataColumn("1", typeof(object)));
firstdt.Columns.Add(new DataColumn("2", typeof(object)));
firstdt.Columns.Add(new DataColumn("3", typeof(object)));
firstdt.Columns.Add(new DataColumn("4", typeof(object)));
DataTable dt = new DataTable("today");
dt.Columns.Add(new DataColumn(rm.GetString("workdateStr"), typeof(DateTime)));
dt.Columns.Add(new DataColumn(rm.GetString("isOutStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("mannameStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("mannumStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("codeStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("worktimeStr"), typeof(DateTime)));
dt.Columns.Add(new DataColumn(rm.GetString("outtimeStr"), typeof(DateTime)));
dt.Columns.Add(new DataColumn(rm.GetString("tozoneStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("dyerStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("driversStr"), typeof(Bitmap)));
dt.Columns.Add(new DataColumn(rm.GetString("autoStr"), typeof(Bitmap)));
dt.Columns.Add(new DataColumn(rm.GetString("otherStr"), typeof(string)));
while (i<=obj.Count-1)
{
ArrayList reader = (ArrayList)obj[i];
DataRow dr;
dr = dt.NewRow();
if (i == 0)
{
sjname = @reader[12].ToString().Trim();
qcname = @reader[13].ToString().Trim();
//sjimage = picpath + "man/" + sjname + ".jpg";
//qcimage = picpath + "auto/" + qcname + ".jpg";
sjimage = (Bitmap)reader[9];
qcimage = (Bitmap)reader[10];
DataRow firstdr;
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("workdateStr");
firstdr[1] = reader[0] == DBNull.Value ? "" : DateTime.Parse(reader[0].ToString().Trim()).ToString("MM月dd日");
firstdr[2] = rm.GetString("outtimeStr");
firstdr[3] = reader[6] == DBNull.Value ? "" : DateTime.Parse(reader[6].ToString().Trim()).ToString("hh点mm分");
firstdt.Rows.Add(firstdr);
//firstdr[7] = new Bitmap(sjimage, true);
//firstdr[8] = new Bitmap(qcimage, true);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("mannameStr");
firstdr[1] = reader[2].ToString().Trim();
firstdr[2] = rm.GetString("mannumStr");
firstdr[3] = reader[3].ToString().Trim();
firstdt.Rows.Add(firstdr);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("codeStr");
firstdr[1] = reader[4].ToString().Trim();
firstdr[2] = rm.GetString("worktimeStr");
firstdr[3] = reader[5] == DBNull.Value ? "" : DateTime.Parse(reader[5].ToString().Trim()).ToString("hh点mm分");
firstdt.Rows.Add(firstdr);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("isOutStr");
firstdr[1] = reader[1].ToString().Trim();
firstdr[2] = rm.GetString("dyerStr");
firstdr[3] = reader[8].ToString().Trim();
firstdt.Rows.Add(firstdr);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("tozoneStr");
firstdr[1] = reader[7].ToString().Trim();
firstdr[2] = rm.GetString("otherStr");
firstdr[3] = reader[11].ToString().Trim();
firstdt.Rows.Add(firstdr);
i++;
continue;
}
dr[0] = reader[0];
dr[1] = reader[1].ToString().Trim();
dr[2] = reader[2].ToString().Trim();
dr[3] = reader[3].ToString().Trim();
dr[4] = reader[4].ToString().Trim();
dr[5] = reader[5];
dr[6] = reader[6];
dr[7] = reader[7].ToString().Trim();
dr[8] = reader[8].ToString().Trim();
dr[9] = GetSmallPic((Bitmap)reader[9]);
dr[10] = GetSmallPic((Bitmap)reader[10]);
dr[11] = reader[11].ToString().Trim();
dt.Rows.Add(dr);
i++;
}
this.firstdg.DataSource = firstdt.DefaultView;
picsj.Image = (Image)sjimage;
picauto.Image = (Image)qcimage;
// if(sjname.Trim()!="")
//LoadToPic(picsj, sjimage);
// if(qcname.Trim()!="")
//LoadToPic(picauto, qcimage);
gg1.Text = rm.GetString("driversStr") + ":" + sjname;
gg2.Text = rm.GetString("autoStr") + ":" + qcname;
this.dg1.DataSource = dt.DefaultView;
}
private void LoadToPic(PictureBox pic1,Bitmap bmp)
{
//新建第二个bitmap类型的bmp2变量,我这里是根据我的程序需要设置的。
Bitmap bmp2 = new Bitmap(bmp.Width,bmp.Height);
//将第一个bmp拷贝到bmp2中
Graphics draw = Graphics.FromImage(bmp2);
draw.DrawImage(bmp, 0, 0);
pic1.Image = (Image)bmp2;//读取bmp2到picturebox
//string FILE =fn;
draw.Dispose();
//bmp1.Dispose();//释放bmp文件资源
}
private Bitmap GetSmallPic(Bitmap bmp)
{
int iScale = 0;
Bitmap tmp = null;
if (bmp!=null)
{
//System.Drawing.Image image = System.Drawing.Image.FromHbitmap(bmp.GetHbitmap());
int iScaleWidth = bmp.Width / 80;
int iScaleHeight = bmp.Height / 78;
if (iScaleHeight <= iScaleWidth)
iScale = iScaleWidth;
else
iScale = iScaleHeight;
if (iScaleHeight <= 0 || iScaleWidth <= 0)
iScale = 1;
//取得图片大小
//System.Drawing.Size size = new Size(image.Width / iScale, image.Height / iScale);
System.Drawing.Size size = new Size(bmp.Width / iScale, bmp.Height / iScale);
//新建一个bmp图片
System.Drawing.Image bitmap = new System.Drawing.Bitmap(size.Width, size.Height);
//新建一个画板
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap);
//设置高质量插值法
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
//设置高质量,低速度呈现平滑程度
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
//清空一下画布
g.Clear(Color.Blue);
//在指定位置画图
g.DrawImage(bmp, new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height),
new System.Drawing.Rectangle(0, 0, bmp.Width, bmp.Height),
System.Drawing.GraphicsUnit.Pixel);
tmp = (Bitmap)bitmap;
}
else
{
tmp = new Bitmap(1,1);
}
return tmp;
}
private Bitmap GetPic(string piccode, int f)
{
Bitmap tmp = null;
if (piccode.Trim() != "")
{
try
{
string subpath = f == 0 ? "man/" : "auto/";
string originalFilename = runPath + "Image/" + subpath + piccode + ".jpg";
//生成的高质量图片名称
//string strGoodFile = @AppDomain.CurrentDomain.BaseDirectory + "SmallImage/" + subpath + "small-" + piccode + ".jpg";
//缩小的倍数
/*if (piccode.Trim() == "")
{
originalFilename = @AppDomain.CurrentDomain.BaseDirectory+"Image/NULL.jpg";
}*/
//从文件取得图片对象
System.Drawing.Image image = System.Drawing.Image.FromFile(originalFilename);
//取得图片大小
System.Drawing.Size size = new Size(image.Width, image.Height);
//新建一个bmp图片
System.Drawing.Image bitmap = new System.Drawing.Bitmap(size.Width, size.Height);
//新建一个画板
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap);
//设置高质量插值法
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
//设置高质量,低速度呈现平滑程度
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
//清空一下画布
g.Clear(Color.Blue);
//在指定位置画图
g.DrawImage(image, new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height),
new System.Drawing.Rectangle(0, 0, image.Width, image.Height),
System.Drawing.GraphicsUnit.Pixel);
tmp = (Bitmap)bitmap;
}
catch
{
return new Bitmap(1,1);
}
}
else
{
tmp = new Bitmap(1, 1);
}
return tmp;
}
private void CreatSmallPic(string piccode,int f)
{
string subpath = f == 0 ? "man/" : "auto/";
string originalFilename = @AppDomain.CurrentDomain.BaseDirectory + "Image/" + subpath + piccode + ".jpg";
//生成的高质量图片名称
string strGoodFile = @AppDomain.CurrentDomain.BaseDirectory + "SmallImage/" + subpath + "small-" + piccode + ".jpg";
//缩小的倍数
int iScale = 5;
//从文件取得图片对象
System.Drawing.Image image = System.Drawing.Image.FromFile(originalFilename);
//取得图片大小
System.Drawing.Size size = new Size(image.Width / iScale, image.Height / iScale);
//新建一个bmp图片
System.Drawing.Image bitmap = new System.Drawing.Bitmap(size.Width, size.Height);
//新建一个画板
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap);
//设置高质量插值法
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
//设置高质量,低速度呈现平滑程度
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
//清空一下画布
g.Clear(Color.Blue);
//在指定位置画图
g.DrawImage(image, new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height),
new System.Drawing.Rectangle(0, 0, image.Width, image.Height),
System.Drawing.GraphicsUnit.Pixel);
//保存高清晰度的缩略图
bitmap.Save(strGoodFile, System.Drawing.Imaging.ImageFormat.Jpeg);
//取得原图像的普通缩略图
/*System.Drawing.Image img = image.GetThumbnailImage(image.Width / iScale, image.Height / iScale, null, IntPtr.Zero);
//保存普通缩略图
img.Save(strBadFile, System.Drawing.Imaging.ImageFormat.Jpeg);*/
g.Dispose();
}
private void dg1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
SetGrid();
if (e.ColumnIndex == 0)
e.CellStyle.Format = "MM-dd";
if (e.ColumnIndex == 5 || e.ColumnIndex == 6)
e.CellStyle.Format = "t";
e.CellStyle.SelectionBackColor = e.CellStyle.BackColor;
e.CellStyle.SelectionForeColor = e.CellStyle.ForeColor;
e.CellStyle.Font = new Font("宋体", 14, FontStyle.Bold, GraphicsUnit.Pixel);
e.CellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
}
private void btnExit_Click(object sender, EventArgs e)
{
Close();
}
private void scrollShow()
{
int i;
object tmp;
object ot=obj[0];
if ((((ArrayList)obj[0])[0] == DBNull.Value && ((ArrayList)obj[0])[0] == DBNull.Value) || (((ArrayList)obj[1])[0] == DBNull.Value && ((ArrayList)obj[1])[0] == DBNull.Value))
{
return;
}
obj.RemoveAt(0);
for (i = 1; i < obj.Count; i++)
{
tmp=obj[i];
if (((ArrayList)tmp)[0] == DBNull.Value && ((ArrayList)tmp)[1] == DBNull.Value)
{
break;
}
}
obj.Insert(i,ot);
show(obj);
}
private void firstdg_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
e.CellStyle.Font = new Font("宋体", 20, FontStyle.Bold, GraphicsUnit.Pixel);
if (e.ColumnIndex%2 == 0)
{
e.CellStyle.BackColor = Color.LightBlue;
e.CellStyle.ForeColor = Color.Black;
e.CellStyle.Font = new Font("隶书", 24, FontStyle.Bold, GraphicsUnit.Pixel);
}
e.CellStyle.SelectionBackColor = e.CellStyle.BackColor;
e.CellStyle.SelectionForeColor = e.CellStyle.ForeColor;
e.CellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
}
private void btnClose_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Close();
}
private void btnScroll_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
scrollShow();
}
private void btnChange_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
changeForm();
}
private void Form1_FormClosed(object sender, FormClosedEventArgs e)
{
//Application.Exit();
}
private void timerA_Tick(object sender, EventArgs e)
{
changeForm();
}
private void timerScroll_Tick(object sender, EventArgs e)
{
scrollShow();
}
private void changeForm()
{
try
{
DBAccess.DBAccess dba = new DBAccess.DBAccess();
OleDbDataReader reader = dba.GetReader("select workdate as 日期,isout as 接送,manname as 客人姓名,mannum as 人数,code as 航班,worktime as 时间,outtime as 出发时间,tozone as 到着地,dyer as 对应者,drivers as 司机,automotive as 车辆,other as 其他 from today where workdate=#" + System.DateTime.Now.Date.AddDays(1).ToString("yyyy-MM-dd") + "# order by id");
bool haveRows = reader.HasRows;
dba.CloseDB();
if (haveRows)
{
timerScroll1.Enabled = false;
timerA.Enabled = false;
Form2 f2 = new Form2();
f2.frmmain = this;
f2.Show();
}
}
catch(Exception ec)
{ MessageBox.Show(ec.Message); }
}
private void SetGrid()
{
for (int i = 1; i < dg1.ColumnCount; i++)
{
dg1.Columns[i].ReadOnly = true;
dg1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; //不自动排序
//dg1.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //列标题字体居中
}
dg1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dg1.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
for (int i = 0; i < dg1.Rows.Count; i++)
dg1.Rows[i].Height = 78;
dg1.Columns[0].Width=64;
dg1.Columns[1].Width = 64;
dg1.Columns[2].Width = 164;
dg1.Columns[3].Width = 64;
dg1.Columns[4].Width = 64;
dg1.Columns[5].Width = 100;
dg1.Columns[6].Width = 100;
dg1.Columns[7].Width = 80;
dg1.Columns[8].Width = 80;
dg1.Columns[9].Width = 80;
dg1.Columns[10].Width = 80;
dg1.Columns[11].Width = 82;
}
private void Form1_MouseDown(object sender, MouseEventArgs e)
{
int xOffset;
int yOffset;
if (e.Button == MouseButtons.Left)
{
xOffset = -e.X - SystemInformation.FrameBorderSize.Width;
yOffset = -e.Y - SystemInformation.CaptionHeight -
SystemInformation.FrameBorderSize.Height;
mouseOffset = new Point(xOffset, yOffset);
isMouseDown = true;
}
}
private void Form1_MouseMove(object sender, MouseEventArgs e)
{
if (isMouseDown)
{
Point mousePos = Control.MousePosition;
mousePos.Offset(mouseOffset.X, mouseOffset.Y);
Location = mousePos;
}
}
private void Form1_MouseUp(object sender, MouseEventArgs e)
{
// 修改鼠标状态isMouseDown的值
// 确保只有鼠标左键按下并移动时,才移动窗体
if (e.Button == MouseButtons.Left)
{
isMouseDown = false;
}
}
}
}
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using Ini;
using System.Resources;
using System.Threading;
namespace cshow
{
public partial class Form1 : Form
{
private Point mouseOffset; //记录鼠标指针的坐标
private bool isMouseDown = false; //记录鼠标按键是否按下
ArrayList obj;
int screenrows, picscal;
static string runPath=@AppDomain.CurrentDomain.BaseDirectory;
System.Resources.ResourceManager rm = null;
public Form1()
{
InitializeComponent();
rm = new System.Resources.ResourceManager("cshow.Form1", System.Reflection.Assembly.GetExecutingAssembly());
}
private void Form1_Load(object sender, EventArgs e)
{
/* DBAccess.DBAccess dba = new DBAccess.DBAccess();
OleDbDataReader reader2 = dba.GetReader("select workdate as 日期,isout as 接送,manname as 客人姓名,mannum as 人数,code as 航班,worktime as 时间,outtime as 出发时间,tozone as 到着地,dyer as 对应者,drivers as 司机,automotive as 车辆,other as 其他 from today where workdate=#" + System.DateTime.Now.ToString("yyyy-MM-dd") + "# order by id");
if (!reader2.HasRows)
{
dba.CloseDB();
return;
}
dba.CloseDB();
*/
System.Windows.Forms.Screen screen=Screen.PrimaryScreen;
System.Drawing.Rectangle rct=screen.Bounds;
this.Height=rct.Height;//高度
this.Width=rct.Width;//宽度
IniFile ini = new IniFile(runPath + "config.ini");
obj = new ArrayList();
dg1.Width = this.Width;
dg1.Height = this.Height;
btnPanel.Left = this.Width - btnPanel.Width - 10;
if (ini.IniReadValue("other", "twoScreen") == "1")
{
this.Left = rct.Width + 1;
}
screenrows = Int16.Parse(ini.IniReadValue("other", "screenrows"));
picscal = Int16.Parse(ini.IniReadValue("pic", "scal"));
todayDate.Text = rm.GetString("todayTitle") + " " + System.DateTime.Now.ToString("d");
show(SetObj());
int x=Int32.Parse(ini.IniReadValue("time","scrolltime"));
int y = Int32.Parse(ini.IniReadValue("time", "AtoBformtime"));
if (x > 0)
{
timerScroll1.Interval = x * 60000;
timerScroll1.Enabled = true;
}
if (y > 0)
{
timerA.Interval = y * 60000;
timerA.Enabled = true;
}
}
private ArrayList SetObj()
{
int i;
obj.Clear();
ArrayList[] al=new ArrayList[50];
for(i=0; i < 20; i++)
{
al[i] = new ArrayList();
}
DBAccess.DBAccess dba = new DBAccess.DBAccess();
OleDbDataReader reader = dba.GetReader("select workdate,isout,manname,mannum,code,worktime,outtime,tozone,dyer,drivers,automotive,other from today where workdate=#"+System.DateTime.Now.ToString("yyyy-MM-dd")+"# order by id");
i = 0;
while (reader.Read())
{
al[i].Add(reader[0].ToString().Trim());
al[i].Add(reader[1].ToString().Trim());
al[i].Add(reader[2].ToString().Trim());
al[i].Add(reader[3].ToString().Trim());
al[i].Add(reader[4].ToString().Trim());
al[i].Add(reader[5].ToString().Trim());
al[i].Add(reader[6].ToString().Trim());
al[i].Add(reader[7].ToString().Trim());
al[i].Add(reader[8].ToString().Trim());
al[i].Add(GetPic(@reader[9].ToString().Trim(), 0));
al[i].Add(GetPic(@reader[10].ToString().Trim(), 1));
al[i].Add(reader[11].ToString().Trim());
al[i].Add(reader[9].ToString().Trim());
al[i].Add(reader[10].ToString().Trim());
obj.Add(al[i]);
i++;
}
for (int j = obj.Count; j < screenrows; j++)
{
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(new Bitmap(1,1));
al[j].Add(new Bitmap(1,1));
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
al[j].Add(DBNull.Value);
obj.Add(al[j]);
}
dba.CloseDB();
return obj;
}
private void show(ArrayList obj)
{
int i = 0;
string sjname = "", qcname = "";
//string picpath = "Image/";
//string sjimage = "", qcimage = "";
Bitmap sjimage = null;
Bitmap qcimage = null;
DataTable firstdt = new DataTable("first");
firstdt.Columns.Add(new DataColumn("1", typeof(object)));
firstdt.Columns.Add(new DataColumn("2", typeof(object)));
firstdt.Columns.Add(new DataColumn("3", typeof(object)));
firstdt.Columns.Add(new DataColumn("4", typeof(object)));
DataTable dt = new DataTable("today");
dt.Columns.Add(new DataColumn(rm.GetString("workdateStr"), typeof(DateTime)));
dt.Columns.Add(new DataColumn(rm.GetString("isOutStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("mannameStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("mannumStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("codeStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("worktimeStr"), typeof(DateTime)));
dt.Columns.Add(new DataColumn(rm.GetString("outtimeStr"), typeof(DateTime)));
dt.Columns.Add(new DataColumn(rm.GetString("tozoneStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("dyerStr"), typeof(string)));
dt.Columns.Add(new DataColumn(rm.GetString("driversStr"), typeof(Bitmap)));
dt.Columns.Add(new DataColumn(rm.GetString("autoStr"), typeof(Bitmap)));
dt.Columns.Add(new DataColumn(rm.GetString("otherStr"), typeof(string)));
while (i<=obj.Count-1)
{
ArrayList reader = (ArrayList)obj[i];
DataRow dr;
dr = dt.NewRow();
if (i == 0)
{
sjname = @reader[12].ToString().Trim();
qcname = @reader[13].ToString().Trim();
//sjimage = picpath + "man/" + sjname + ".jpg";
//qcimage = picpath + "auto/" + qcname + ".jpg";
sjimage = (Bitmap)reader[9];
qcimage = (Bitmap)reader[10];
DataRow firstdr;
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("workdateStr");
firstdr[1] = reader[0] == DBNull.Value ? "" : DateTime.Parse(reader[0].ToString().Trim()).ToString("MM月dd日");
firstdr[2] = rm.GetString("outtimeStr");
firstdr[3] = reader[6] == DBNull.Value ? "" : DateTime.Parse(reader[6].ToString().Trim()).ToString("hh点mm分");
firstdt.Rows.Add(firstdr);
//firstdr[7] = new Bitmap(sjimage, true);
//firstdr[8] = new Bitmap(qcimage, true);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("mannameStr");
firstdr[1] = reader[2].ToString().Trim();
firstdr[2] = rm.GetString("mannumStr");
firstdr[3] = reader[3].ToString().Trim();
firstdt.Rows.Add(firstdr);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("codeStr");
firstdr[1] = reader[4].ToString().Trim();
firstdr[2] = rm.GetString("worktimeStr");
firstdr[3] = reader[5] == DBNull.Value ? "" : DateTime.Parse(reader[5].ToString().Trim()).ToString("hh点mm分");
firstdt.Rows.Add(firstdr);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("isOutStr");
firstdr[1] = reader[1].ToString().Trim();
firstdr[2] = rm.GetString("dyerStr");
firstdr[3] = reader[8].ToString().Trim();
firstdt.Rows.Add(firstdr);
firstdr = firstdt.NewRow();
firstdr[0] = rm.GetString("tozoneStr");
firstdr[1] = reader[7].ToString().Trim();
firstdr[2] = rm.GetString("otherStr");
firstdr[3] = reader[11].ToString().Trim();
firstdt.Rows.Add(firstdr);
i++;
continue;
}
dr[0] = reader[0];
dr[1] = reader[1].ToString().Trim();
dr[2] = reader[2].ToString().Trim();
dr[3] = reader[3].ToString().Trim();
dr[4] = reader[4].ToString().Trim();
dr[5] = reader[5];
dr[6] = reader[6];
dr[7] = reader[7].ToString().Trim();
dr[8] = reader[8].ToString().Trim();
dr[9] = GetSmallPic((Bitmap)reader[9]);
dr[10] = GetSmallPic((Bitmap)reader[10]);
dr[11] = reader[11].ToString().Trim();
dt.Rows.Add(dr);
i++;
}
this.firstdg.DataSource = firstdt.DefaultView;
picsj.Image = (Image)sjimage;
picauto.Image = (Image)qcimage;
// if(sjname.Trim()!="")
//LoadToPic(picsj, sjimage);
// if(qcname.Trim()!="")
//LoadToPic(picauto, qcimage);
gg1.Text = rm.GetString("driversStr") + ":" + sjname;
gg2.Text = rm.GetString("autoStr") + ":" + qcname;
this.dg1.DataSource = dt.DefaultView;
}
private void LoadToPic(PictureBox pic1,Bitmap bmp)
{
//新建第二个bitmap类型的bmp2变量,我这里是根据我的程序需要设置的。
Bitmap bmp2 = new Bitmap(bmp.Width,bmp.Height);
//将第一个bmp拷贝到bmp2中
Graphics draw = Graphics.FromImage(bmp2);
draw.DrawImage(bmp, 0, 0);
pic1.Image = (Image)bmp2;//读取bmp2到picturebox
//string FILE =fn;
draw.Dispose();
//bmp1.Dispose();//释放bmp文件资源
}
private Bitmap GetSmallPic(Bitmap bmp)
{
int iScale = 0;
Bitmap tmp = null;
if (bmp!=null)
{
//System.Drawing.Image image = System.Drawing.Image.FromHbitmap(bmp.GetHbitmap());
int iScaleWidth = bmp.Width / 80;
int iScaleHeight = bmp.Height / 78;
if (iScaleHeight <= iScaleWidth)
iScale = iScaleWidth;
else
iScale = iScaleHeight;
if (iScaleHeight <= 0 || iScaleWidth <= 0)
iScale = 1;
//取得图片大小
//System.Drawing.Size size = new Size(image.Width / iScale, image.Height / iScale);
System.Drawing.Size size = new Size(bmp.Width / iScale, bmp.Height / iScale);
//新建一个bmp图片
System.Drawing.Image bitmap = new System.Drawing.Bitmap(size.Width, size.Height);
//新建一个画板
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap);
//设置高质量插值法
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
//设置高质量,低速度呈现平滑程度
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
//清空一下画布
g.Clear(Color.Blue);
//在指定位置画图
g.DrawImage(bmp, new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height),
new System.Drawing.Rectangle(0, 0, bmp.Width, bmp.Height),
System.Drawing.GraphicsUnit.Pixel);
tmp = (Bitmap)bitmap;
}
else
{
tmp = new Bitmap(1,1);
}
return tmp;
}
private Bitmap GetPic(string piccode, int f)
{
Bitmap tmp = null;
if (piccode.Trim() != "")
{
try
{
string subpath = f == 0 ? "man/" : "auto/";
string originalFilename = runPath + "Image/" + subpath + piccode + ".jpg";
//生成的高质量图片名称
//string strGoodFile = @AppDomain.CurrentDomain.BaseDirectory + "SmallImage/" + subpath + "small-" + piccode + ".jpg";
//缩小的倍数
/*if (piccode.Trim() == "")
{
originalFilename = @AppDomain.CurrentDomain.BaseDirectory+"Image/NULL.jpg";
}*/
//从文件取得图片对象
System.Drawing.Image image = System.Drawing.Image.FromFile(originalFilename);
//取得图片大小
System.Drawing.Size size = new Size(image.Width, image.Height);
//新建一个bmp图片
System.Drawing.Image bitmap = new System.Drawing.Bitmap(size.Width, size.Height);
//新建一个画板
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap);
//设置高质量插值法
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
//设置高质量,低速度呈现平滑程度
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
//清空一下画布
g.Clear(Color.Blue);
//在指定位置画图
g.DrawImage(image, new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height),
new System.Drawing.Rectangle(0, 0, image.Width, image.Height),
System.Drawing.GraphicsUnit.Pixel);
tmp = (Bitmap)bitmap;
}
catch
{
return new Bitmap(1,1);
}
}
else
{
tmp = new Bitmap(1, 1);
}
return tmp;
}
private void CreatSmallPic(string piccode,int f)
{
string subpath = f == 0 ? "man/" : "auto/";
string originalFilename = @AppDomain.CurrentDomain.BaseDirectory + "Image/" + subpath + piccode + ".jpg";
//生成的高质量图片名称
string strGoodFile = @AppDomain.CurrentDomain.BaseDirectory + "SmallImage/" + subpath + "small-" + piccode + ".jpg";
//缩小的倍数
int iScale = 5;
//从文件取得图片对象
System.Drawing.Image image = System.Drawing.Image.FromFile(originalFilename);
//取得图片大小
System.Drawing.Size size = new Size(image.Width / iScale, image.Height / iScale);
//新建一个bmp图片
System.Drawing.Image bitmap = new System.Drawing.Bitmap(size.Width, size.Height);
//新建一个画板
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap);
//设置高质量插值法
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
//设置高质量,低速度呈现平滑程度
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
//清空一下画布
g.Clear(Color.Blue);
//在指定位置画图
g.DrawImage(image, new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height),
new System.Drawing.Rectangle(0, 0, image.Width, image.Height),
System.Drawing.GraphicsUnit.Pixel);
//保存高清晰度的缩略图
bitmap.Save(strGoodFile, System.Drawing.Imaging.ImageFormat.Jpeg);
//取得原图像的普通缩略图
/*System.Drawing.Image img = image.GetThumbnailImage(image.Width / iScale, image.Height / iScale, null, IntPtr.Zero);
//保存普通缩略图
img.Save(strBadFile, System.Drawing.Imaging.ImageFormat.Jpeg);*/
g.Dispose();
}
private void dg1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
SetGrid();
if (e.ColumnIndex == 0)
e.CellStyle.Format = "MM-dd";
if (e.ColumnIndex == 5 || e.ColumnIndex == 6)
e.CellStyle.Format = "t";
e.CellStyle.SelectionBackColor = e.CellStyle.BackColor;
e.CellStyle.SelectionForeColor = e.CellStyle.ForeColor;
e.CellStyle.Font = new Font("宋体", 14, FontStyle.Bold, GraphicsUnit.Pixel);
e.CellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
}
private void btnExit_Click(object sender, EventArgs e)
{
Close();
}
private void scrollShow()
{
int i;
object tmp;
object ot=obj[0];
if ((((ArrayList)obj[0])[0] == DBNull.Value && ((ArrayList)obj[0])[0] == DBNull.Value) || (((ArrayList)obj[1])[0] == DBNull.Value && ((ArrayList)obj[1])[0] == DBNull.Value))
{
return;
}
obj.RemoveAt(0);
for (i = 1; i < obj.Count; i++)
{
tmp=obj[i];
if (((ArrayList)tmp)[0] == DBNull.Value && ((ArrayList)tmp)[1] == DBNull.Value)
{
break;
}
}
obj.Insert(i,ot);
show(obj);
}
private void firstdg_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
e.CellStyle.Font = new Font("宋体", 20, FontStyle.Bold, GraphicsUnit.Pixel);
if (e.ColumnIndex%2 == 0)
{
e.CellStyle.BackColor = Color.LightBlue;
e.CellStyle.ForeColor = Color.Black;
e.CellStyle.Font = new Font("隶书", 24, FontStyle.Bold, GraphicsUnit.Pixel);
}
e.CellStyle.SelectionBackColor = e.CellStyle.BackColor;
e.CellStyle.SelectionForeColor = e.CellStyle.ForeColor;
e.CellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
}
private void btnClose_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Close();
}
private void btnScroll_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
scrollShow();
}
private void btnChange_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
changeForm();
}
private void Form1_FormClosed(object sender, FormClosedEventArgs e)
{
//Application.Exit();
}
private void timerA_Tick(object sender, EventArgs e)
{
changeForm();
}
private void timerScroll_Tick(object sender, EventArgs e)
{
scrollShow();
}
private void changeForm()
{
try
{
DBAccess.DBAccess dba = new DBAccess.DBAccess();
OleDbDataReader reader = dba.GetReader("select workdate as 日期,isout as 接送,manname as 客人姓名,mannum as 人数,code as 航班,worktime as 时间,outtime as 出发时间,tozone as 到着地,dyer as 对应者,drivers as 司机,automotive as 车辆,other as 其他 from today where workdate=#" + System.DateTime.Now.Date.AddDays(1).ToString("yyyy-MM-dd") + "# order by id");
bool haveRows = reader.HasRows;
dba.CloseDB();
if (haveRows)
{
timerScroll1.Enabled = false;
timerA.Enabled = false;
Form2 f2 = new Form2();
f2.frmmain = this;
f2.Show();
}
}
catch(Exception ec)
{ MessageBox.Show(ec.Message); }
}
private void SetGrid()
{
for (int i = 1; i < dg1.ColumnCount; i++)
{
dg1.Columns[i].ReadOnly = true;
dg1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; //不自动排序
//dg1.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //列标题字体居中
}
dg1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dg1.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
for (int i = 0; i < dg1.Rows.Count; i++)
dg1.Rows[i].Height = 78;
dg1.Columns[0].Width=64;
dg1.Columns[1].Width = 64;
dg1.Columns[2].Width = 164;
dg1.Columns[3].Width = 64;
dg1.Columns[4].Width = 64;
dg1.Columns[5].Width = 100;
dg1.Columns[6].Width = 100;
dg1.Columns[7].Width = 80;
dg1.Columns[8].Width = 80;
dg1.Columns[9].Width = 80;
dg1.Columns[10].Width = 80;
dg1.Columns[11].Width = 82;
}
private void Form1_MouseDown(object sender, MouseEventArgs e)
{
int xOffset;
int yOffset;
if (e.Button == MouseButtons.Left)
{
xOffset = -e.X - SystemInformation.FrameBorderSize.Width;
yOffset = -e.Y - SystemInformation.CaptionHeight -
SystemInformation.FrameBorderSize.Height;
mouseOffset = new Point(xOffset, yOffset);
isMouseDown = true;
}
}
private void Form1_MouseMove(object sender, MouseEventArgs e)
{
if (isMouseDown)
{
Point mousePos = Control.MousePosition;
mousePos.Offset(mouseOffset.X, mouseOffset.Y);
Location = mousePos;
}
}
private void Form1_MouseUp(object sender, MouseEventArgs e)
{
// 修改鼠标状态isMouseDown的值
// 确保只有鼠标左键按下并移动时,才移动窗体
if (e.Button == MouseButtons.Left)
{
isMouseDown = false;
}
}
}
}
- DataGridView的带图片滚动浏览
- Javascript的图片滚动浏览效果代码
- 浏览图片带缩略图
- 实现图片滚动浏览代码滚动源代码
- mac下生成一个带滚动条浏览文本信息的窗口的方法
- JS浏览图片,左右滚动效果
- Java代码使图片自行滚动浏览
- vs2015 滚动条实现,浏览Bitmap图片
- DataGridView滚动慢的解决方法
- ios--解决方案--图片浏览(带缩放+平移)
- 带按钮可左右滚动的图片展示特效
- 带按钮可左右滚动的图片展示特效
- 带左右箭头切换的自动滚动图片JS特效
- java 带图片和滚动条的TextArea
- opencv1:带滚动条的图片二值化处理
- javascript的图片浏览
- 图片浏览的ScrollView
- 图片的浏览,删除
- 04.03
- 发了5天的实习工资,哈哈……
- EasyMock 使用方法与原理剖析
- 让进度条平滑显示
- JSP连接数据库方法大全
- DataGridView的带图片滚动浏览
- 黑客常用命令和快捷键大全
- 蜗牛计划
- c时间函数
- 中国手机电视国家标准终于确定:T-MMB !, 但CMMB能答应吗?
- 程序员必知必会
- 未来我能“值”多少钱?
- 职场新人如何进行职业规划
- fckeditor2.5.1+aspnetpager实现内容分页