读书人

infopath 数据在代码里插入重复节,该怎

发布时间: 2012-02-06 15:52:44 作者: rapoo

infopath 数据在代码里插入重复节
现在用这个方法,把重复节的内容插入sql

C# code
XPathNavigator domNav = MainDataSource.CreateNavigator();                        XPathNodeIterator rows = domNav.Select("/my:myFields/my:qj_detail", NamespaceManager);                        string inQjDetailSql = string.Empty;                       //保存请假详细信息                        while (rows.MoveNext())                        {                            string beginDate = rows.Current.SelectSingleNode("my:beginDate", NamespaceManager).Value.ToString();                            string endDate = rows.Current.SelectSingleNode("my:endDate", NamespaceManager).Value.ToString();                            string reson = rows.Current.SelectSingleNode("my:reson", NamespaceManager).Value.ToString();                            string note = rows.Current.SelectSingleNode("my:note", NamespaceManager).Value.ToString();                            inQjDetailSql += "INSERT INTO qingjia_detail (qj_id,Begin_Date,End_Date,Style,Note)";                            inQjDetailSql += " VALUES ('" + qj_id + "','" + beginDate + "','" + endDate + "','" + reson + "','" + note + "');";                        }

那么,怎么把数据反过来,在代码里插入重复节?

[解决办法]
创建一个xml数据源,用重复数据填充这个xml数据源。然后用重复控件list boxes, drop-down list boxes, combo boxes, repeating sections, 或repeating tables与这个xml数据源绑定:

[解决办法]
XPathNavigator domNav = this.MainDataSource.CreateNavigator();

for (int i = 0; i < filelist.Length - 2; i++)
{
XPathNavigator FileList = domNav.SelectSingleNode("/my:Task0/my:group1", NamespaceManager);
XPathNavigator FileNode = domNav.SelectSingleNode("/my:Task0/my:group1/my:group2", NamespaceManager);
FileList.AppendChild(FileNode);
}

读书人网 >行业软件

热点推荐