/// <summary>
/// 删除一条记录
/// </summary>
public void DeleteBaseDataRecord()
{
BaseDataRecord objRecord = CreateRecordInstance();
if (objRecord != null)
{
string tableName = formView.SelectedTable.BASE_TABLE_DB_NAME.ToString().Trim();
BaseDataController.DeleteBaseDataRecord(objRecord, formView.SelectedTable);
}
}
/// <summary>
///
/// </summary>
private BaseDataRecord CreateRecordInstance()
{
if (formView.SelectedTable == null)
{
throw new Exception("没有选择数据表");
}
string TableName = formView.SelectedTable.BASE_TABLE_DB_NAME.ToString().Trim();
DataTable tb = BaseDataReader.GetBaseTableData(TableName, "1 > 2");
BaseDataRecord dataRecord = new BaseDataRecord();//定义一条新记录
foreach (Control ctrl in this.propertyPanel.Controls)
{
if (ctrl is Label)
{
continue;
}
if (ctrl.Tag == null)
{
continue;
}
FieldConfig config = (FieldConfig)ctrl.Tag;
for (int i = 0; i < tb.Columns.Count; i++)
{
string fieldName = tb.Columns[i].ColumnName;
if (fieldName.ToUpper() == config.FIELD_DB_NAME.ToUpper())
{
object objValue = null;
if (config.UIC_TYPE == ControlType.CheckBox)
{
objValue = ((CheckBox)ctrl).Checked ? 1 : 0;
}
if (config.UIC_TYPE == ControlType.ComboBox)
{
objValue = ((ComboBox)ctrl).SelectedValue;
}
if (config.UIC_TYPE == ControlType.TextBox)
{
objValue = ((TextBox)ctrl).Text;
}
//如果是自增长的主键，跳过
if (config.IS_PRIMARY_KEY && config.AUTO_INCREASE && objValue.ToString().Trim() == "")
{
continue;
}
if ((config.IS_PRIMARY_KEY || !config.ALLOW_EMPTY))
{
if (objValue == null || objValue.ToString() == "")
{
throw new Exception(config.FIELD_CN_NAME + "不能为空！");
}
}
objValue = Convert.ChangeType(objValue, tb.Columns[i].DataType);
BaseDataRecordField field_value = new BaseDataRecordField();
field_value.FieldConfig = config;
field_value.DataValue = objValue;
dataRecord.RecordFields.Add(field_value);
}
}
}
return(dataRecord);
}
