private void DatabaseConnection()
{
OleDbConnection conn = null;
//OleDbDataReader reader = null;
try
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("rb_workord.mdb"));
conn.Open(); }
catch (Exception e)
{
Response.Write(e.Message);
Response.End();
}
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
Page_Load(sender, e);
} private void SolverExecuation(object sender, System.EventArgs e)
{
string InputXML = "InputData.xml";
string InputXMLSchema = "InputData.xsd";
try
{
//fs = new FileStream(InputXML, FileMode.Create);
//writer = new StreamWriter(fs);
//Today
DatabaseConnection();
DataSet dataSetOrderShopMaInfo = new DataSet();
OleDbDataAdapter adapterToday = new OleDbDataAdapter("SELECT Today, LeadTime FROM nqry_Today", conn);
adapterToday.Fill(dataSetOrderShopMaInfo, "nqry_Today");
//Order Info
OleDbDataAdapter adapterOrder = new OleDbDataAdapter("SELECT SHOP_NO, PART_NO, OP_NO, QTY_MFG, GOOD, OPERATIONCOST, DUE_DATE, DUE_DATE2, JOBSTATUS FROM nqry_WorkOrdr_OnSchedule ORDER BY SHOP_NO, OP_NO DESC", conn);
adapterOrder.Fill(dataSetOrderShopMaInfo, "nqry_WorkOrdr_OnSchedule");
//Shop Hours
OleDbDataAdapter adapterShopHours = new OleDbDataAdapter("SELECT DEPT_NO, DAYSPERWEEK1, START1, STOP1, MM1, MAXSETUP1, DAYSPERWEEK2, START2, STOP2, MAXSETUP2, MM2, DAYSPERWEEK3, START3, STOP3, MM3, MAXSETUP3 FROM nqry_Shop_Hours", conn);
adapterShopHours.Fill(dataSetOrderShopMaInfo, "nqry_Shop_Hours"); //Routine
OleDbDataAdapter adapterRoutine = new OleDbDataAdapter("SELECT PART_NO, OP_NO, MACH_NO, ACT_SETUPOfFirst, ACT_RATEOfFirst, SPLIT, BATCHSIZE FROM nqry_Routing_Machine_OnSchedule ORDER BY PART_NO, OP_NO, MACH_NO", conn);
adapterRoutine.Fill(dataSetOrderShopMaInfo, "nqry_Routing_Machine_OnSchedule"); //Machine-Department
OleDbDataAdapter adapterMacDep = new OleDbDataAdapter("SELECT MACH_NO, DEPT_NO, MIN_UTILIZATION, MAX_UTILIZATION, IGNORED, Labor1, Labor2, Labor3 FROM nqry_Mach_Dept", conn);
adapterMacDep.Fill(dataSetOrderShopMaInfo, "nqry_Mach_Dept"); //BOM
OleDbDataAdapter adapterBOM = new OleDbDataAdapter("SELECT SHOP_NO, PRE FROM tbl_BOM", conn);
adapterBOM.Fill(dataSetOrderShopMaInfo, "tbl_BOM"); dataSetOrderShopMaInfo.WriteXmlSchema(InputXMLSchema);
XmlTextReader xmlReaderDS61 = new XmlTextReader(dataSetOrderShopMaInfo.GetXml(), XmlNodeType.Element, null); XmlTextWriter xmlWriterDS61 = new XmlTextWriter(InputXML,System.Text.Encoding.UTF8); xmlWriterDS61.WriteStartDocument();
string elementName = "";
// Parse and display each node.
while(xmlReaderDS61.Read())
{
switch(xmlReaderDS61.NodeType)
{
case XmlNodeType.Element:
xmlWriterDS61.WriteStartElement(xmlReaderDS61.Name);
elementName = xmlReaderDS61.Name;
break;
case XmlNodeType.Text:
if (elementName.Length >= 8 && elementName.ToLower().Substring(0, 8) == "due_date")
{
xmlWriterDS61.WriteString(Convert.ToInt32(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("d"));
}
else if (elementName.Length >= 5 && elementName.ToLower().Substring(0,5) == "start")
xmlWriterDS61.WriteString(Convert.ToDouble(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("F2"));
else if (elementName.Length >= 4 && elementName.ToLower().Substring(0,4) == "stop")
xmlWriterDS61.WriteString(Convert.ToDouble(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("F2"));
else if (elementName.ToLower() == "today")
xmlWriterDS61.WriteString(Convert.ToInt32(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("d"));
else
xmlWriterDS61.WriteString(xmlReaderDS61.Value);
break;
case XmlNodeType.EndElement:
xmlWriterDS61.WriteEndElement();
break;
} //MessageBox.Show(XmlNodeType.EndElement.ToString());
//if (XmlNodeType.EndElement == xmlReader.NodeType)
//{
// xmlReader.ResetState();
//}
}
xmlWriterDS61.Close(); xmlReaderDS61.Close(); //dataSetOrderShopMaInfo.WriteXml(writer);
dataSetOrderShopMaInfo.Clear();
//odbcDataAdapter9.Fill(dataSet61);
//dataSet61.WriteXml(writer); }
catch(Exception excep)
{
Response.Write(excep.ToString());
}
finally
{
//writer.Flush();
//writer.Close();
//fs.Close();
} }上面一段话编译的时候报错,,不知道为什么!
{
OleDbConnection conn = null;
//OleDbDataReader reader = null;
try
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("rb_workord.mdb"));
conn.Open(); }
catch (Exception e)
{
Response.Write(e.Message);
Response.End();
}
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
Page_Load(sender, e);
} private void SolverExecuation(object sender, System.EventArgs e)
{
string InputXML = "InputData.xml";
string InputXMLSchema = "InputData.xsd";
try
{
//fs = new FileStream(InputXML, FileMode.Create);
//writer = new StreamWriter(fs);
//Today
DatabaseConnection();
DataSet dataSetOrderShopMaInfo = new DataSet();
OleDbDataAdapter adapterToday = new OleDbDataAdapter("SELECT Today, LeadTime FROM nqry_Today", conn);
adapterToday.Fill(dataSetOrderShopMaInfo, "nqry_Today");
//Order Info
OleDbDataAdapter adapterOrder = new OleDbDataAdapter("SELECT SHOP_NO, PART_NO, OP_NO, QTY_MFG, GOOD, OPERATIONCOST, DUE_DATE, DUE_DATE2, JOBSTATUS FROM nqry_WorkOrdr_OnSchedule ORDER BY SHOP_NO, OP_NO DESC", conn);
adapterOrder.Fill(dataSetOrderShopMaInfo, "nqry_WorkOrdr_OnSchedule");
//Shop Hours
OleDbDataAdapter adapterShopHours = new OleDbDataAdapter("SELECT DEPT_NO, DAYSPERWEEK1, START1, STOP1, MM1, MAXSETUP1, DAYSPERWEEK2, START2, STOP2, MAXSETUP2, MM2, DAYSPERWEEK3, START3, STOP3, MM3, MAXSETUP3 FROM nqry_Shop_Hours", conn);
adapterShopHours.Fill(dataSetOrderShopMaInfo, "nqry_Shop_Hours"); //Routine
OleDbDataAdapter adapterRoutine = new OleDbDataAdapter("SELECT PART_NO, OP_NO, MACH_NO, ACT_SETUPOfFirst, ACT_RATEOfFirst, SPLIT, BATCHSIZE FROM nqry_Routing_Machine_OnSchedule ORDER BY PART_NO, OP_NO, MACH_NO", conn);
adapterRoutine.Fill(dataSetOrderShopMaInfo, "nqry_Routing_Machine_OnSchedule"); //Machine-Department
OleDbDataAdapter adapterMacDep = new OleDbDataAdapter("SELECT MACH_NO, DEPT_NO, MIN_UTILIZATION, MAX_UTILIZATION, IGNORED, Labor1, Labor2, Labor3 FROM nqry_Mach_Dept", conn);
adapterMacDep.Fill(dataSetOrderShopMaInfo, "nqry_Mach_Dept"); //BOM
OleDbDataAdapter adapterBOM = new OleDbDataAdapter("SELECT SHOP_NO, PRE FROM tbl_BOM", conn);
adapterBOM.Fill(dataSetOrderShopMaInfo, "tbl_BOM"); dataSetOrderShopMaInfo.WriteXmlSchema(InputXMLSchema);
XmlTextReader xmlReaderDS61 = new XmlTextReader(dataSetOrderShopMaInfo.GetXml(), XmlNodeType.Element, null); XmlTextWriter xmlWriterDS61 = new XmlTextWriter(InputXML,System.Text.Encoding.UTF8); xmlWriterDS61.WriteStartDocument();
string elementName = "";
// Parse and display each node.
while(xmlReaderDS61.Read())
{
switch(xmlReaderDS61.NodeType)
{
case XmlNodeType.Element:
xmlWriterDS61.WriteStartElement(xmlReaderDS61.Name);
elementName = xmlReaderDS61.Name;
break;
case XmlNodeType.Text:
if (elementName.Length >= 8 && elementName.ToLower().Substring(0, 8) == "due_date")
{
xmlWriterDS61.WriteString(Convert.ToInt32(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("d"));
}
else if (elementName.Length >= 5 && elementName.ToLower().Substring(0,5) == "start")
xmlWriterDS61.WriteString(Convert.ToDouble(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("F2"));
else if (elementName.Length >= 4 && elementName.ToLower().Substring(0,4) == "stop")
xmlWriterDS61.WriteString(Convert.ToDouble(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("F2"));
else if (elementName.ToLower() == "today")
xmlWriterDS61.WriteString(Convert.ToInt32(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("d"));
else
xmlWriterDS61.WriteString(xmlReaderDS61.Value);
break;
case XmlNodeType.EndElement:
xmlWriterDS61.WriteEndElement();
break;
} //MessageBox.Show(XmlNodeType.EndElement.ToString());
//if (XmlNodeType.EndElement == xmlReader.NodeType)
//{
// xmlReader.ResetState();
//}
}
xmlWriterDS61.Close(); xmlReaderDS61.Close(); //dataSetOrderShopMaInfo.WriteXml(writer);
dataSetOrderShopMaInfo.Clear();
//odbcDataAdapter9.Fill(dataSet61);
//dataSet61.WriteXml(writer); }
catch(Exception excep)
{
Response.Write(excep.ToString());
}
finally
{
//writer.Flush();
//writer.Close();
//fs.Close();
} }上面一段话编译的时候报错,,不知道为什么!
解决方案 »
- asp.net2.0 发送邮件失败,大家帮忙看下.
- 帮看个页面,这是怎么实现的
- 代码中波浪线现象
- System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable),今天不解决都有死的念头了
- 为什么按钮的click事件执行两次
- GridView 固定前三列
- 100分奖励!看谁能得满分!一个硕士毕业设计,占毕业成绩的40%
- 急急 ~!谁有 FlyTreeView CheckBox 复选框 案例 demo
- 奇怪问题,网站要做一计数器,Global.asax中的Session_Start好象过程不执行。2003 OS,是不是操作系统的总题?
- 请问有没有人研究过ASPNETFORUM?
- 是VS2005 Login控件只能用于SQL Server,还是我代码写错了?
- 有没有办法让<iframe>的横向滚动条消失,但要保留竖向滚动条?
using System.Xml.XPath;
using System.Data.OleDb;
using System.Diagnostics; 试试!