public override bool Table_Add(string table, M_SQL_Field field) { string sql = "CREATE TABLE " + table + " ({0})"; string fieldstr = field.fieldName + " "; switch (field.fieldType.ToLower()) { case "int": case "money": case "ntext": case "bit": case "datetime": fieldstr += field.fieldType; break; default: fieldstr += field.fieldType + "(" + field.fieldLen + ") "; break; } if (!string.IsNullOrEmpty(field.defval)) { fieldstr += " DEFAULT ('" + field.defval + "')"; } return(SqlHelper.ExecuteSql(string.Format(sql, fieldstr))); }
public override bool Field_Add(string table, M_SQL_Field field) { DBHelper.Table_AddField(new M_SQL_Connection() { constr = ConnectionString, tbname = table }, field); return(true); }
public override bool Field_Add(string tbname, M_SQL_Field field) { string sql = "ALTER TABLE " + tbname + " ADD (" + field.fieldName + " " + field.fieldType + " (" + field.fieldLen + ") " + field.defval + ")"; ExecuteNonQuery(new SqlModel() { sql = sql }); return(true); }
public override bool Table_Add(string table, M_SQL_Field field) { string sql = "CREATE TABLE " + table + " (" + field.fieldName + " " + field.fieldType + " (" + field.fieldLen + ") " + field.defval + ")"; ExecuteNonQuery(new SqlModel() { sql = sql }); return(true); }
public override bool Field_Add(string table, M_SQL_Field field) { string sql = "ALTER TABLE " + table + " ADD COLUMN " + field.fieldName + " " + field.fieldType + "(" + field.fieldLen + ") DEFAULT NULL"; ExecuteNonQuery(new SqlModel() { sql = sql }); return(true); }
public override bool Table_Add(string table, M_SQL_Field field) { //CREATE TABLE `zoomlacms`.`test` (`ID` INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(`ID`)); string sql = "CREATE TABLE " + table + "(`" + field.fieldName + "` INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(`" + field.fieldName + "`))"; ExecuteNonQuery(new SqlModel() { sql = sql }); return(true); }
public override bool Field_Add(string table, M_SQL_Field field) { //ALTER TABLE `zoomlacms`.`zl_c_article` ADD COLUMN `test` TEXT NULL DEFAULT '12' AFTER `K_pages`; string sql = "ALTER TABLE `" + table + "` ADD COLUMN `" + field.fieldName + "` " + field.fieldType; if (field.fieldLen > 0) { sql += " (" + field.fieldLen + ") "; } sql += " DEFAULT NULL"; ExecuteNonQuery(new SqlModel() { sql = sql }); return(true); }
public override bool Table_Add(string table, M_SQL_Field field) { string sql = "CREATE TABLE " + table + " ({0})"; string fieldstr = field.fieldName + " "; switch (field.fieldType.ToLower()) { case "int": case "money": case "ntext": case "bit": case "datetime": fieldstr += field.fieldType; break; default: fieldstr += field.fieldType + "(" + field.fieldLen + ") "; break; } //主键与默认值不同时存在 //CREATE TABLE dbo." + model.TableName + " ([ID] [int] IDENTITY (1, 1) PRIMARY Key NOT NULL) if (field.ispk) { fieldstr += " IDENTITY (1, 1) PRIMARY Key NOT NULL"; } else if (!string.IsNullOrEmpty(field.defval)) { fieldstr += " DEFAULT ('" + field.defval + "')"; } ExecuteNonQuery(new SqlModel() { sql = string.Format(sql, fieldstr) }); return(true); }
public override bool Field_Add(string table, M_SQL_Field field) { throw new NotImplementedException(); }
public abstract bool Field_Add(string table, M_SQL_Field field);