private static String GetIntoLibSQL()
{
IList intolibs = IntoLibData.GetAllIntoLibRecs();
StringBuilder sbResult = new StringBuilder();
foreach (object o in intolibs)
{
IntoLib il = o as IntoLib;
StringBuilder sb = new StringBuilder();
sb.Append("insert into intolib (User,InputTime,PumpName,PumpType,DrawType,FileName,Version,ProductNo) values ");
sb.Append("('" + il.User + "'");
sb.Append(",'" + il.InputTime.ToString() + "'");
sb.Append(",'" + il.PumpName + "'");
sb.Append(",'" + il.PumpType + "'");
sb.Append(",'" + il.DrawType + "'");
sb.Append(",'" + il.FileName + "'");
sb.Append("," + il.Version);
sb.Append(",'" + il.ProductNo + "'");
sb.Append(");");
string queryText = sb.ToString();
sbResult.Append(Environment.NewLine);
sbResult.Append(queryText);
sbResult.Append(Environment.NewLine);
}
return(sbResult.ToString());;
}
private void button2_Click(object sender, System.EventArgs e)
{
IList list = IntoLibData.GetAllIntoLibRecs();
FillList(list);
LogFindResult();
}