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));
}
