private ControlFieldSet GetTestData() { ControlFieldSet ds = new ControlFieldSet(); string sql = "select * from ControlFieldSet where TableName = '" + this.tableName + "'"; DBControl.FillDataSet(ds, "ControlFieldSet", sql); return(ds); }
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 DataTable SelectRecord() { DataTable DataTb = null; string sql = string.Empty; int len = 0; // 新增 len = this.fields.Count / 2; sql = sql + "select * from " + this.tableName; DataTb = DBControl.GetTable(sql); return(DataTb); }
public List <string> Getlist() { string sql = "select NAME from ComboBoxSet where FieldId = '" + this.ControlID + "'"; DataTable tb = DBControl.GetTable(sql); List <string> list = new List <string>(); int count = tb.Rows.Count; for (int i = 0; i < count; i++) { list.Add(tb.Rows[i]["NAME"].ToString()); } return(list); }
public void Load(decimal id) { this.id = id; string sql = "select * from " + this.tableName + " where id = " + id; DataTable tb = DBControl.GetTable(sql); if (tb.Rows.Count == 0) { return; } int len = this.fields.Count; for (int i = 0; i < len; i++) { this.fields[i].FieldValue = tb.Rows[0][this.fields[i].FieldName].ToString(); } }
public void ExcuteSqlInputParam(string sql, OleDbParameter[] param, int len) { DBControl.ExcuteSqlInputParam(sql, param, len); }
public void ExcuteSql(string sql) { DBControl.ExcuteSql(sql); }
public DataTable SelectTabsBySql(string sql) { return(DBControl.GetTable(sql)); }