#region 论文专著及教材
WritingAndDissertation wad = new WritingAndDissertation();//论文
DataSet dat = wad.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "WDID"); ScienceProduction spd = new ScienceProduction();//专著
DataSet dst = spd.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "ProductionID"); TeachingBook tb = new TeachingBook();//教材
DataSet det = tb.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "ID");
int count = dat.Tables[0].Rows.Count + dst.Tables[0].Rows.Count + det.Tables[0].Rows.Count;
wh.GoToBookMark("论文专著");//获取论文的书签
if (count <= 5)
{
//论文
if (dat != null && dat.Tables.Count > 0 && dat.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in dat.Tables[0].Rows)
{
i++;
wh.InsertText(i.ToString());//插入数据
wh.MoveNextCell();//移动到下一单元格
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["WDTitle"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Publisher"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow();//移动到下一行 } }
//著作 if (dst != null && dst.Tables.Count > 0 && dst.Tables[0].Rows.Count > 0)
{
int i = dat.Tables[0].Rows.Count;
foreach (DataRow dr in dst.Tables[0].Rows)
{ i++;
wh.InsertText(i.ToString());
wh.MoveNextCell();
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["ProductionName"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Organization"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow(); }
}
//教材 if (det != null && det.Tables.Count > 0 && det.Tables[0].Rows.Count > 0)
{
int i = dat.Tables[0].Rows.Count + dst.Tables[0].Rows.Count;
foreach (DataRow dr in det.Tables[0].Rows)
{
i++;
wh.InsertText(i.ToString());
wh.MoveNextCell();
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Name"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Organization"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow();
}
}
}
#endregion
这段代码是王Word文档书签里插入数据,Word文档里有一个表格
比如说
序号 论文专著教材 完成人顺序
论文,专著,教材分别属于三个表
现在的问题是,这三个表的数据总条数不确定啊,我只想去前五条,怎么弄啊,帮帮忙,各位大侠!最好写几句代码
WritingAndDissertation wad = new WritingAndDissertation();//论文
DataSet dat = wad.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "WDID"); ScienceProduction spd = new ScienceProduction();//专著
DataSet dst = spd.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "ProductionID"); TeachingBook tb = new TeachingBook();//教材
DataSet det = tb.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "ID");
int count = dat.Tables[0].Rows.Count + dst.Tables[0].Rows.Count + det.Tables[0].Rows.Count;
wh.GoToBookMark("论文专著");//获取论文的书签
if (count <= 5)
{
//论文
if (dat != null && dat.Tables.Count > 0 && dat.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in dat.Tables[0].Rows)
{
i++;
wh.InsertText(i.ToString());//插入数据
wh.MoveNextCell();//移动到下一单元格
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["WDTitle"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Publisher"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow();//移动到下一行 } }
//著作 if (dst != null && dst.Tables.Count > 0 && dst.Tables[0].Rows.Count > 0)
{
int i = dat.Tables[0].Rows.Count;
foreach (DataRow dr in dst.Tables[0].Rows)
{ i++;
wh.InsertText(i.ToString());
wh.MoveNextCell();
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["ProductionName"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Organization"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow(); }
}
//教材 if (det != null && det.Tables.Count > 0 && det.Tables[0].Rows.Count > 0)
{
int i = dat.Tables[0].Rows.Count + dst.Tables[0].Rows.Count;
foreach (DataRow dr in det.Tables[0].Rows)
{
i++;
wh.InsertText(i.ToString());
wh.MoveNextCell();
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Name"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Organization"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow();
}
}
}
#endregion
这段代码是王Word文档书签里插入数据,Word文档里有一个表格
比如说
序号 论文专著教材 完成人顺序
论文,专著,教材分别属于三个表
现在的问题是,这三个表的数据总条数不确定啊,我只想去前五条,怎么弄啊,帮帮忙,各位大侠!最好写几句代码
解决方案 »
- C#调用C语言编写的dll,如何释放内存?
- List<T>如何返回记录的值
- 一维数组中怎么接收输入的数据,并将这些数据排列?
- combox中如何查找确定ValueMember的值
- 急急急急急急急
- 自定的在.Net Compact Framework中进行截屏的函数,运行一段时间后,程序死了.
- 在datagridview已经绑定的数据里动态添加数据到数据库
- 关于动态生成TabPage并添加至TabControl的问题....
- 100分求《C# Web 服务高级编程》中文电子版!!!
- web出错
- Visual Studio 2005 Express Edition 中的Express是什么意思
- 请,大侠帮忙【Repeater 读取数据的问题】
{
int i = 0;
foreach (DataRow dr in dat.Tables[0].Rows)
{
i++;
wh.InsertText(i.ToString());//插入数据
wh.MoveNextCell();//移动到下一单元格
wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["WDTitle"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["Publisher"].ToString());
wh.MoveNextCell();
wh.InsertText(dr["AuthorOrder"].ToString());
wh.MoveNextRow();//移动到下一行
if (i > 5) break;
} }