private void button1_Click(object sender, EventArgs e) { SqlConnection sqlcon = new SqlConnection("Data Source=192.168.1.25;Initial Catalog=AIO75_SH_BEQJ;Persist Security Info=True;User ID=sa;Password=pushiAIO7"); string sql = string.Format("select * from v_YPchQuery where NumAtCrd='{0}' order by crdname,z_buyname,ddh", this.textBox1.Text); try { sqlcon.Open(); SqlDataAdapter dadorb = new SqlDataAdapter(sql, sqlcon); //绑定数据 DataSet dsdorb = new DataSet(); dadorb.Fill(dsdorb, "table"); PCGroup pcGroup = new PCGroup(); double totleArea = 0; foreach (DataRow dr in dsdorb.Tables[0].Rows) { PCData dataEntity = new PCData(); dataEntity.PCH = dr["NumAtCrd"].ToString(); dataEntity.DDH = dr["DDH"].ToString(); dataEntity.GH = dr["SortID"].ToString(); dataEntity.JXS = dr["CrdName"].ToString(); dataEntity.KH = dr["Z_BuyName"].ToString(); dataEntity.COLOR = dr["BarCodes"].ToString(); dataEntity.AREA = double.Parse(dr["MJ"].ToString()); totleArea += dataEntity.AREA; dataEntity.BC = dr["BS"].ToString(); pcGroup.list.Add(dataEntity); } pcGroup.totalAREA = totleArea; BindData(pcGroup); textBox2.Text = totleArea.ToString(); } catch (SystemException ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); //MessageBox.Show("OK"); } }
void WriteReport(string filename) { if (File.Exists(ReportBillTemplate)) { File.Copy(ReportBillTemplate, filename); IWorkbook bookReport = null; if (File.Exists(filename)) { bookReport = Factory.GetWorkbook(filename); } IRange cells = bookReport.Worksheets[0].Cells; int index = 0; int startrow = 7; bool iswhitebk = true; PCGroup pcGroup = dataGridView1.Tag as PCGroup; int groupindex = 0; foreach (PCData nc in pcGroup.list) { string cellB = string.Format("B{0}", startrow + index); string cellC = string.Format("C{0}", startrow + index); string cellE = string.Format("E{0}", startrow + index); string cellF = string.Format("F{0}", startrow + index); string cellH = string.Format("H{0}", startrow + index); string cellI = string.Format("I{0}", startrow + index); string cellJ = string.Format("J{0}", startrow + index); cells[cellB].Formula = nc.DDH; cells[cellC].Formula = nc.GH; cells[cellE].Formula = nc.JXS; cells[cellF].Formula = nc.KH; cells[cellH].Formula = nc.COLOR; cells[cellI].Formula = nc.BC; cells[cellJ].Formula = nc.AREA.ToString(); index++; } cells["B3"].Formula = this.textBox1.Text; cells["F3"].Formula = this.textBox2.Text; bookReport.Save(); bookReport.Close(); } }
public void BindData(PCGroup pcGroup) { this.dataGridView1.Rows.Clear(); foreach (PCData dataEntity in pcGroup.list) { int index = this.dataGridView1.Rows.Add(); this.dataGridView1.Rows[index].Cells[0].Value = index + 1; this.dataGridView1.Rows[index].Cells[1].Value = dataEntity.DDH; this.dataGridView1.Rows[index].Cells[2].Value = dataEntity.GH; this.dataGridView1.Rows[index].Cells[4].Value = dataEntity.JXS; this.dataGridView1.Rows[index].Cells[5].Value = dataEntity.KH; this.dataGridView1.Rows[index].Cells[7].Value = dataEntity.COLOR; this.dataGridView1.Rows[index].Cells[8].Value = dataEntity.BC; this.dataGridView1.Rows[index].Cells[9].Value = dataEntity.AREA;// ToString("0.2f"); this.dataGridView1.Rows[index].Tag = dataEntity; } this.dataGridView1.Tag = pcGroup; }