internal string GetSelectSql(string tableName) { StringBuilder sb = new StringBuilder(); sb.Append(" WHERE "); // foreach( PropertyInfo p in PropertyList ) // { // string str = GetProperty(p); // if( str != null && str.Length > 0 ) // sb.Append( p.Name + "=" + GetProperty(p) + "," ); // } PropertyInfo key = MainKey; if (key == null) { return(""); } string fname = DObjectHelper.GetFieldName(key); sb.Append(fname + "=" + GetProperty(key)); string sql = sb.ToString(); sql = sql.TrimEnd(',').Replace(",", " AND "); sql = GetSelectAllSql(tableName) + sql; return(sql); }
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); }
private DObjectManager(string tableName, Type objectType) { _tableName = tableName; _objectType = objectType; if (_tableName == null || _tableName.Length < 1 || _objectType == null || !DObjectHelper.IsDObject(_objectType)) { throw new ArgumentNullException("DObjectManager构造函数的参数不能为空,而且传入的objectType参数必须是DObject类型或DObject的派生类型。"); } }
internal string GetMaxAutoIDSql(string tableName) { PropertyInfo key = MainKey; if (key == null || !DObjectHelper.IsAutoIncrementing(key)) { return(""); } string kname = DObjectHelper.GetFieldName(key); string sql = "SELECT MAX(" + kname + ") FROM " + tableName; return(sql); }
internal string GetDeleteSql(string tableName) { PropertyInfo key = MainKey; if (key == null) { return(""); } string val = GetProperty(key); string fname = DObjectHelper.GetFieldName(key); string sql = "DELETE FROM " + tableName + " WHERE " + fname + "=" + val; return(sql); }
internal bool LoadData(DbDataRecord dbData) { if (dbData == null) { return(false); } PropertyInfo[] plist = PropertyList; if (plist == null) { return(false); } foreach (PropertyInfo p in plist) { string fname = DObjectHelper.GetFieldName(p); SetProperty(p, dbData[fname]); } return(true); }
internal string GetSelectAllSql(string tableName) { PropertyInfo[] plist = PropertyList; if (plist == null) { return(""); } StringBuilder sb = new StringBuilder(); sb.Append("SELECT "); foreach (PropertyInfo p in plist) { string fname = DObjectHelper.GetFieldName(p); sb.Append(fname + ","); } string str = sb.ToString().TrimEnd(','); str = str + " FROM " + tableName; return(str); }
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); }
internal string GetCreateTableSql(string tableName) { PropertyInfo[] plist = PropertyList; if (plist == null) { return(""); } StringBuilder sb = new StringBuilder(); sb.Append("CREATE TABLE "); sb.Append(tableName + " ("); foreach (PropertyInfo p in plist) { string finfo = DObjectHelper.GetFileInfor(p); sb.Append(finfo + ","); } string str = sb.ToString().TrimEnd(','); str = str + ")"; return(str); }