/// <summary> /// 增加字段进入数据库 /// </summary> /// <param name="model">连结模型</param> /// <param name="field">字段模型</param> public static void Table_AddField(M_SQL_Connection model, M_SQL_Field field) { string sql = "ALTER TABLE [" + model.tbname + "] ADD [" + field.fieldName + "] "; switch (field.fieldType.ToLower()) { case "int": case "money": case "ntext": case "bit": case "datetime": sql += field.fieldType; break; default: sql += field.fieldType + "(" + field.fieldLen + ") "; break; } if (!string.IsNullOrEmpty(field.defval)) { sql += " DEFAULT ('" + field.defval + "')"; } if (string.IsNullOrEmpty(model.constr)) { model.constr = DBCenter.DB.ConnectionString; } DBHelper.ExecuteSQL(model.constr, sql); }
public static bool Table_IsExist(M_SQL_Connection model) { if (string.IsNullOrEmpty(model.tbname)) { return(true); } try { string sql = "SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'[" + model.tbname + "]') AND OBJECTPROPERTY(ID, 'IsTable') = 1"; return(ExecuteTable(sql).Rows.Count > 0); } catch { return(false); } }
public static void Table_Add(M_SQL_Connection model) { }