private void btExcel_Click(object sender, EventArgs e) { clsControlChargeWorkReport cls = new clsControlChargeWorkReport(); cls.m_mthOutExcel(((clsCheckOuthistoryDay)this.objController).dtStatistics); }
private void btExcel_Click(object sender, EventArgs e) { clsControlChargeWorkReport cls = new clsControlChargeWorkReport(); DataRow dr = ((clsCtl_GroupWorkLoadReport)this.objController).Mydt.Rows[0]; ((clsCtl_GroupWorkLoadReport)this.objController).Mydt.Rows[0].Delete(); ((clsCtl_GroupWorkLoadReport)this.objController).Mydt.AcceptChanges(); DataTable dtTempMydt = ((clsCtl_GroupWorkLoadReport)this.objController).Mydt; DataTable dtTemp2 = new DataTable(); for (int i = 0; i < dtTempMydt.Columns.Count; i++) { if (dtTempMydt.Columns[i].ColumnName.IndexOf("名称") >= 0) { dtTemp2.Columns.Add(dtTempMydt.Columns[i].ColumnName, System.Type.GetType("System.String")); } else { dtTemp2.Columns.Add(dtTempMydt.Columns[i].ColumnName, System.Type.GetType("System.Decimal")); } //dtTemp2.Columns.Add(dtTempMydt.Columns[i].ColumnName, System.Type.GetType("System.String")); } DataRow drnew = null; for (int i = 0; i < dtTempMydt.Rows.Count; i++) { drnew = dtTemp2.NewRow(); for (int i2 = 0; i2 < dtTempMydt.Columns.Count; i2++) { if (dtTempMydt.Rows[i][i2].ToString().Trim() == "") { //if (dtTempMydt.Columns[i2].DataType.FullName.ToString() == "System.Decimal") //{ // drnew[i2] = 0; //} //else //{ // drnew[i2] = "0"; //} drnew[i2] = "0"; } else { //if (dtTempMydt.Rows[i][i2].ToString().IndexOf("合计") < 0) //{ // if (dtTemp2.Columns[i2].DataType.FullName.ToString() == "System.Decimal") // { // drnew[i2] = Convert.ToDecimal(dtTempMydt.Rows[i][i2]); // } // else // { // drnew[i2] = dtTempMydt.Rows[i][i2].ToString(); // } //} drnew[i2] = dtTempMydt.Rows[i][i2]; } } dtTemp2.Rows.Add(drnew); } cls.m_mthOutExcel(dtTemp2); ((clsCtl_GroupWorkLoadReport)this.objController).Mydt.Rows.InsertAt(dr, 0); ((clsCtl_GroupWorkLoadReport)this.objController).Mydt.AcceptChanges(); }