internal string GetUpdateSql(string tableName) { PropertyInfo[] plist = DObjectHelper.GetInsertablePropertyList(PropertyList); if (plist == null) { return(""); } PropertyInfo key = MainKey; if (key == null) { return(""); } string val = GetProperty(key); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE "); sb.Append(tableName); sb.Append(" SET "); foreach (PropertyInfo p in plist) { string fname = DObjectHelper.GetFieldName(p); sb.Append(fname + "=" + GetProperty(p) + ","); } string str = sb.ToString(); string kname = DObjectHelper.GetFieldName(key); string ostr = str.TrimEnd(',') + " WHERE " + kname + "=" + val; return(ostr); }
internal string GetInsertSql(string tableName) { PropertyInfo[] plist = DObjectHelper.GetInsertablePropertyList(PropertyList); if (plist == null) { return(""); } StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO "); sb.Append(tableName); sb.Append(" ("); foreach (PropertyInfo p in plist) { string fname = DObjectHelper.GetFieldName(p); sb.Append(fname + ","); } string str = sb.ToString().TrimEnd(','); str = str + ") VALUES ("; sb = new StringBuilder(); sb.Append(str); foreach (PropertyInfo p in plist) { sb.Append(GetProperty(p) + ","); } str = sb.ToString().TrimEnd(','); str = str + ")"; return(str); }