public bool createAndInsertToDB()
{
Console.WriteLine("createAndInsertToDB");
//insert into yw_account(guid) values('8902');
string cmdstring = "insert into " + tableName + " (";
string values = "values(";
Type tp = GetType();
List <string> columns = DBSerializer.getDBColoumns(tp);
List <string> defines = DBSerializer.getDBDefines(tp);
for (int i = 0; i < columns.Count; ++i)
{
cmdstring += columns[i] + ",";
FieldInfo field = tp.GetField(columns[i]);
values += "'" + DBSerializer.serializeField(field.FieldType, field.GetValue(this)) + "',";
}
cmdstring = cmdstring.Remove(cmdstring.Length - 1);
values = values.Remove(values.Length - 1);
cmdstring = cmdstring + ") " + values + ");";
Console.WriteLine("createAndInsertToDB:" + cmdstring);
return(DataInitializer.DB_insert(tableName, cmdstring));;
}
private string getCreateString(Type tp)
{
string cmdString = "(";
List <string> columns = DBSerializer.getDBColoumns(tp);
List <string> defines = DBSerializer.getDBDefines(tp);
for (int i = 0; i < columns.Count; ++i)
{
cmdString += columns[i];
cmdString += " " + defines[i] + ",";
}
cmdString = cmdString.Remove(cmdString.Length - 1, 1);
cmdString += ");";
Console.WriteLine("CmdString: " + cmdString);
return(cmdString);
}