/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(MColumnStyle model)
{
#region SQL语句
const string sql = @"
UPDATE [T_Column_Style]
SET
[Column_Id] = @ColumnId
,[Style_Name] = @StyleName
,[Column_Name] = @ColumnName
,[Column_Caption] = @ColumnCaption
,[Column_Type] = @ColumnType
,[Column_Index] = @ColumnIndex
,[Column_Width] = @ColumnWidth
,[Column_Visible] = @ColumnVisible
,[Update_Sign] = @UpdateSign
WHERE [Column_Id] = @ColumnId";
#endregion
return(SqlHelper.ExecuteNonQuery(CommandType.Text, sql,
new SQLiteParameter("@ColumnId", SqlHelper.ToNullDBValue(model.ColumnId)),
new SQLiteParameter("@StyleName", SqlHelper.ToNullDBValue(model.StyleName)),
new SQLiteParameter("@ColumnName", SqlHelper.ToNullDBValue(model.ColumnName)),
new SQLiteParameter("@ColumnCaption", SqlHelper.ToNullDBValue(model.ColumnCaption)),
new SQLiteParameter("@ColumnType", SqlHelper.ToNullDBValue(model.ColumnType)),
new SQLiteParameter("@ColumnIndex", SqlHelper.ToNullDBValue(model.ColumnIndex)),
new SQLiteParameter("@ColumnWidth", SqlHelper.ToNullDBValue(model.ColumnWidth)),
new SQLiteParameter("@ColumnVisible", SqlHelper.ToNullDBValue(model.ColumnVisible)),
new SQLiteParameter("@UpdateSign", SqlHelper.ToNullDBValue(model.UpdateSign))
));
}
/// <summary>
/// 创建CheckBox
/// </summary>
/// <param name="columnStyle"></param>
private TXCheckBox CreateCheckBox(MColumnStyle columnStyle)
{
TXCheckBox myCheckBox = new TXCheckBox();
myCheckBox.BackColor = Color.Transparent;
myCheckBox.Text = columnStyle.ColumnCaption;
if (columnStyle.ColumnVisible == 1)
{
myCheckBox.Checked = true;
}
else
{
myCheckBox.Checked = false;
}
myCheckBox.Tag = columnStyle;
return(myCheckBox);
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(MColumnStyle model)
{
#region SQL语句
const string sql = @"
INSERT INTO [T_Column_Style] (
[Column_Id]
,[Style_Name]
,[Column_Name]
,[Column_Caption]
,[Column_Type]
,[Column_Index]
,[Column_Width]
,[Column_Visible]
,[Update_Sign]
)
VALUES (
@ColumnId
,@StyleName
,@ColumnName
,@ColumnCaption
,@ColumnType
,@ColumnIndex
,@ColumnWidth
,@ColumnVisible
,@UpdateSign
);";
#endregion
var res = SqlHelper.ExecuteNonQuery(CommandType.Text, sql,
new SQLiteParameter("@ColumnId", SqlHelper.ToNullDBValue(model.ColumnId)),
new SQLiteParameter("@StyleName", SqlHelper.ToNullDBValue(model.StyleName)),
new SQLiteParameter("@ColumnName", SqlHelper.ToNullDBValue(model.ColumnName)),
new SQLiteParameter("@ColumnCaption", SqlHelper.ToNullDBValue(model.ColumnCaption)),
new SQLiteParameter("@ColumnType", SqlHelper.ToNullDBValue(model.ColumnType)),
new SQLiteParameter("@ColumnIndex", SqlHelper.ToNullDBValue(model.ColumnIndex)),
new SQLiteParameter("@ColumnWidth", SqlHelper.ToNullDBValue(model.ColumnWidth)),
new SQLiteParameter("@ColumnVisible", SqlHelper.ToNullDBValue(model.ColumnVisible)),
new SQLiteParameter("@UpdateSign", SqlHelper.ToNullDBValue(model.UpdateSign))
);
return(Convert.ToInt32(res));
}
//保存
private void txButton1_Click(object sender, EventArgs e)
{
try
{
foreach (Control control in this.Controls)
{
TXCheckBox myCheckBox = control as TXCheckBox;
if (myCheckBox == null)
{
continue;
}
MColumnStyle mColumnStyle = myCheckBox.Tag as MColumnStyle;
if (mColumnStyle == null)
{
continue;
}
int visible = 0;
if (myCheckBox.Checked)
{
visible = 1;
}
else
{
visible = 0;
}
if (visible != mColumnStyle.ColumnVisible)
{
mColumnStyle.ColumnVisible = visible;
m_ColumnStyleBLL.Update(mColumnStyle);
}
}
this.Info("保存成功！");
this.Close();
}
catch (Exception ex)
{
this.Warning(ex.Message);
}
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(MColumnStyle model)
{
return(_dao.Update(model));
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(MColumnStyle model)
{
return(_dao.Insert(model));
}
