public decimal SaveRecord() { string sql = string.Empty; int len = 0; if (this.id < 0) { this.id = DBControl.GetSystemID(1)[0]; // 新增 len = this.fields.Count; sql = sql + "insert into " + this.tableName + "(id,"; for (int i = 0; i < len; i++) { if (i != len - 1) { sql = sql + this.fields[i].FieldName + ","; } else { sql = sql + this.fields[i].FieldName + ") values (" + this.id + ","; } } for (int i = 0; i < len; i++) { if (i != len - 1) { sql = sql + "'" + this.fields[i]._GetControlValue() + "',"; } else { sql = sql + "'" + this.fields[i]._GetControlValue() + "')"; } } } else { // 修改 len = this.fields.Count; sql = sql + "update " + this.tableName + " set "; for (int i = 0; i < len; i++) { if (i != len - 1) { sql = sql + this.fields[i].FieldName + "='" + this.fields[i]._GetControlValue() + "',"; } else { sql = sql + this.fields[i].FieldName + "='" + this.fields[i]._GetControlValue() + "'"; } } sql = sql + " where id = " + this.id; } DBControl.ExcuteSql(sql); return(this.id); }
//添加 public void DeletRecord() { string sql = string.Empty; int len = 0; // 新增 len = this.fields.Count; sql = sql + "delete from " + this.tableName + " where id=" + this.id; DBControl.ExcuteSql(sql); SetId(-1); }
public void ExcuteSql(string sql) { DBControl.ExcuteSql(sql); }