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(); }