public static List <String> getFileName(int orderid, Ftypes type)
{
String sql = "SELECT name from orderfiles where type =" + (int)type + " AND orderid=" + orderid;
List <String> lst = new List <String>();
SQLiteConnection myConn = new SQLiteConnection(sqConnectionString);
SQLiteCommand sqCommand = new SQLiteCommand(sql);
sqCommand.Connection = myConn;
myConn.Open();
try
{
SQLiteDataReader r = sqCommand.ExecuteReader();
while (r.Read())
{
lst.Add(r["name"].ToString());
}
r.Close();
err = false;
return(lst);
}
catch
{
err = true;
}
finally
{
myConn.Close();
}
return(lst);
}
public static void setFileName(int orderid, String name, Ftypes type)
{
msql.query("INSERT INTO orderfiles(orderid, name, type) Values(" + orderid + ", \"" + name + "\", " + (int)type + ")");
}
