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