public Form1()
{
InitializeComponent();
progressBar1.Visible = false;
//初始化考场
string sql = "SELECT (substr(ZKZH,6,1)||'-'||substr(ZKZH,11,3)) as KAOCHANG from [20028]";
dbHepler db = new dbHepler();
DataSet KAOCHANG = db.LoadData(sql);
comboBox1.DisplayMember = "KAOCHANG";
comboBox1.ValueMember = "KAOCHANG";
comboBox1.DataSource = KAOCHANG.Tables[0];
string sql1 = generatesql();
// report.PrintPrepared();
}
private void reportShow()
{
this.Invoke(new setStatusDelegate1(setStatus));
int i = 0, j = 0;
dbHepler db = new dbHepler();
string sql = this.Invoke(new getsql(generatesql)) as string;
MessageBox.Show(sql);
// string sql = "select * from [20028] where XH='128590'";
DataSet Student = db.LoadData(sql);
report.Pages.Clear();
//report.Load("Untitled.frx");
;
//DataBand data = (DataBand)report.FindObject("data1");
for (i = 0; i < Student.Tables[0].Rows.Count / 10; i++)
{
ReportPage page1 = new ReportPage();
report.Pages.Add(page1);
DataBand data = new DataBand();
page1.Bands.Add(data);
for (j = 0; j < 10; j++)
{
TextObject text1 = new TextObject();
if (j % 2 == 0)
{
text1.Bounds = new RectangleF(Units.Centimeters * 4, Units.Centimeters * 3 * j, Units.Centimeters * 5, Units.Centimeters * 0.6f);
}
else
{
text1.Bounds = new RectangleF(Units.Centimeters * 9 + Units.Centimeters * 4, Units.Centimeters * 3 * (j - 1), Units.Centimeters * 5, Units.Centimeters * 0.6f);
}
text1.Text = Student.Tables[0].Rows[10 * i + j]["name"].ToString();
data.Objects.Add(text1);
PictureObject pic = new PictureObject();
if (j % 2 == 0)
{
pic.Bounds = new RectangleF(0, Units.Centimeters * 3 * j, Units.Centimeters * 2, Units.Centimeters * 2);
}
else
{
pic.Bounds = new RectangleF(Units.Centimeters * 9 + Units.Centimeters * 0, Units.Centimeters * 3 * (j - 1), Units.Centimeters * 2, Units.Centimeters * 2);
}
if (File.Exists("./" + "20"+Student.Tables[0].Rows[10 * i + j]["XH"].ToString().Substring(0,2) + "/" + Student.Tables[0].Rows[10 * i + j]["XH"].ToString()+ ".jpg"))
pic.Image = Image.FromFile("./" +"20"+ Student.Tables[0].Rows[10 * i + j]["XH"].ToString().Substring(0,2) + "/" + Student.Tables[0].Rows[10 * i + j]["XH"].ToString() + ".jpg");
data.Objects.Add(pic);
BarcodeObject bar = new BarcodeObject();
if (j % 2 == 0)
{
bar.Bounds = new RectangleF(0, Units.Centimeters * 3 * j + Units.Centimeters * 2.5f, Units.Centimeters * 8, Units.Centimeters * 2);
}
else
{
bar.Bounds = new RectangleF(Units.Centimeters * 9 + Units.Centimeters * 0, Units.Centimeters * 3 * (j - 1) + Units.Centimeters * 2.5f, Units.Centimeters * 8, Units.Centimeters * 2);
}
//pic.Image = Image.FromFile("100001.jpg");
bar.Text = Student.Tables[0].Rows[10 * i + j]["ZKZH"].ToString();
data.Objects.Add(bar);
}
}
if (Student.Tables[0].Rows.Count % 10 != 0)
{
Console.WriteLine((10 * i + j).ToString());
ReportPage page2 = new ReportPage();
report.Pages.Add(page2);
DataBand data2 = new DataBand();
page2.Bands.Add(data2);
for (int k = 10 * (i - 1) + j; k < Student.Tables[0].Rows.Count; k++)
{
TextObject text1 = new TextObject();
if (k % 2 == 0)
{
text1.Bounds = new RectangleF(Units.Centimeters * 4, Units.Centimeters * 3 * (k % 10), Units.Centimeters * 5, Units.Centimeters * 0.6f);
}
else
{
text1.Bounds = new RectangleF(Units.Centimeters * 9 + Units.Centimeters * 4, Units.Centimeters * 3 * (k % 10 - 1), Units.Centimeters * 5, Units.Centimeters * 0.6f);
}
text1.Text = Student.Tables[0].Rows[k]["name"].ToString();
data2.Objects.Add(text1);
PictureObject pic = new PictureObject();
if (k % 2 == 0)
{
pic.Bounds = new RectangleF(0, Units.Centimeters * 3 * k % 10, Units.Centimeters * 2, Units.Centimeters * 2);
}
else
{
pic.Bounds = new RectangleF(Units.Centimeters * 9 + Units.Centimeters * 0, Units.Centimeters * 3 * (k % 10 - 1), Units.Centimeters * 2, Units.Centimeters * 2);
}
if (File.Exists("./" + "20" + Student.Tables[0].Rows[k]["XH"].ToString().Substring(0,2) + "/" + Student.Tables[0].Rows[k]["XH"].ToString() + ".jpg"))
pic.Image = Image.FromFile("./" + "20"+Student.Tables[0].Rows[k]["XH"].ToString().Substring(0,2) + "/" + Student.Tables[0].Rows[k]["XH"].ToString()+ ".jpg");
data2.Objects.Add(pic);
BarcodeObject bar = new BarcodeObject();
if (k % 2 == 0)
{
bar.Bounds = new RectangleF(0, Units.Centimeters * 3 * (k % 10) + Units.Centimeters * 2.5f, Units.Centimeters * 8, Units.Centimeters * 2);
}
else
{
bar.Bounds = new RectangleF(Units.Centimeters * 9 + Units.Centimeters * 0, Units.Centimeters * 3 * (k % 10 - 1) + Units.Centimeters * 2.5f, Units.Centimeters * 8, Units.Centimeters * 2);
}
//pic.Image = Image.FromFile("100001.jpg");
bar.Text = Student.Tables[0].Rows[k]["ZKZH"].ToString();
data2.Objects.Add(bar);
}
}
this.Invoke(new setStatusDelegate1(setStatus2));
this.Invoke(new setStatusDelegate1(reportShow1));
}