//public void ExcelOut(GridView gv)
//{
// if (gv.Rows.Count > 0)
// {
// grdvw_List.Caption = "<FONT style='WIDTH: 102.16%;font-size:22pt; LINE-HEIGHT: 150%; FONT-FAMILY: SimSun_GB2312; HEIGHT: 35px'><b>样 品 出 入 库 登 记 表</b></font>";
// Response.Clear();
// Response.ClearContent();
// Response.AddHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.ToString("_yyyyMMdd_HHmmss") + ".doc");
// Response.ContentEncoding = System.Text.Encoding.UTF8;
// Response.ContentType = "application/ms-word";
// StringWriter sw = new StringWriter();
// HtmlTextWriter htw = new HtmlTextWriter(sw);
// gv.RenderControl(htw);
// Response.Write("TXHJ/ZJ40" + "\n\r" + sw.ToString());
// Response.Flush();
// Response.End();
// grdvw_List.Caption = "";
// }
// else
// {
// Response.Write("没有数据");
// }
//}
//public override void VerifyRenderingInServerForm(Control control)
//{
// // base.VerifyRenderingInServerForm(control);
//}
protected void btn_print_Click(object sender, EventArgs e)
{
OutReport report = new OutReport();
try
{
string DocPath = Server.MapPath("../");
string TemplateFile = "";
TemplateFile = DocPath + "Sample\\template\\SampleInAndOut.doc";
report.CreateNewDocument(TemplateFile);
int row = 4;
string[] heads = new string[6];
int i = 0;
foreach (GridViewRow gvr in grdvw_List.Rows)
{
report.AddRow(1, 1);
string[] values = new string[6];
i = 0;
foreach (TableCell tc in gvr.Cells)
{
if (tc.Text != " ")
{
values.SetValue(tc.Text, i++);
}
else
{
values.SetValue("", i++);
}
}
// values.SetValue("", i++);
report.InsertCell(1, row++, 6, values); //给模板中第一个表格的第二行的6列分别插入数据
}
// report.AddRow(1,1);
Microsoft.Office.Interop.Word.Table table = report.Document.Content.Tables[1];
report.MergeCell(table, row, 1, row, 6);
// table.
report.InsertCell(1, row, 1, "备注:");
table.Cell(row, 1).Range.Font.Size = Convert.ToSingle(10.5);
table.Cell(row, 1).Range.Cells.VerticalAlignment = WdCellVerticalAlignment.wdCellAlignVerticalTop;
table.Cell(row, 1).Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphLeft;
// table.AutoFormat
Random rd = new Random();
int oid = rd.Next(10000);
//生成的具有模板样式的新文件
string FileName = DocPath + "Sample\\temp\\" + oid.ToString() + ".doc";
report.SaveDocument(FileName);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "window.open('temp/" + oid.ToString() + ".doc','theNewWindow',' left=0,top=0,width='+ (screen.availWidth - 10) +',height='+ (screen.availHeight-50) +',scrollbars,resizable=yes,toolbar=no')", true);
}
catch (Exception exp)
{ ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('" + exp.Message.ToString() + "');", true); }
}
//public void ExcelOut(GridView gv)
//{
// if (gv.Rows.Count > 0)
// {
// grdvw_List.Caption = "<FONT style='WIDTH: 102.16%;font-size:22pt; LINE-HEIGHT: 150%; FONT-FAMILY: SimSun_GB2312; HEIGHT: 35px'><b>样 品 登 记 表</b></font>";
// Response.Clear();
// Response.ClearContent();
// Response.AddHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.ToString("_yyyyMMdd_HHmmss") + ".doc");
// Response.ContentEncoding = System.Text.Encoding.UTF8;
// Response.ContentType = "application/ms-word";
// StringWriter sw = new StringWriter();
// HtmlTextWriter htw = new HtmlTextWriter(sw);
// gv.RenderControl(htw);
// Response.Write("TXHJ / ZJ39" + "\n\r" + sw.ToString());
// Response.Flush();
// Response.End();
// grdvw_List.Caption = "";
// }
// else
// {
// Response.Write("没有数据");
// }
//}
//public override void VerifyRenderingInServerForm(Control control)
//{
// // base.VerifyRenderingInServerForm(control);
//}
protected void btn_print_Click(object sender, EventArgs e)
{
OutReport report = new OutReport();
try
{
string DocPath = Server.MapPath("../");
string TemplateFile = "";
TemplateFile = DocPath + "Sample\\template\\SampleInOut.doc";
report.CreateNewDocument(TemplateFile);
int row = 2;
string[] heads = new string[12];
int i = 0;
foreach (GridViewRow gvr in grdvw_List.Rows)
{
report.AddRow(1, 1);
string[] values = new string[12];
i = 0;
int j = 0;
foreach (TableCell tc in gvr.Cells)
{
if (j > 0)
{
if (tc.Text != " ")
{
values.SetValue(tc.Text, i++);
}
else
{
values.SetValue("", i++);
}
}
j++;
}
// values.SetValue("", i++);
report.InsertCell(1, row++, 12, values); //给模板中第一个表格的第二行的5列分别插入数据
}
Random rd = new Random();
int oid = rd.Next(10000);
//生成的具有模板样式的新文件
string FileName = DocPath + "Sample\\temp\\" + oid.ToString() + ".doc";
report.SaveDocument(FileName);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "window.open('temp/" + oid.ToString() + ".doc','theNewWindow',' left=0,top=0,width='+ (screen.availWidth - 10) +',height='+ (screen.availHeight-50) +',scrollbars,resizable=yes,toolbar=no')", true);
}
catch
{ report.killWinWordProcess(); }
}