public static void SqlServerTransaction <T>(this T t, OperationType opType, bool containsIdentityColumn = false, T newRec = default(T))
where T : class, new()
{
SqlServerDbMapper <T> mapper = new SqlServerDbMapper <T>();
switch (opType)
{
case OperationType.Select:
mapper.GetObjectInstance(t);
break;
case OperationType.Insert:
mapper.Insert(t, containsIdentityColumn);
break;
case OperationType.Update:
mapper.Update(t, newRec);
break;
case OperationType.Delete:
mapper.Delete(t);
break;
default:
mapper.Insert(t, containsIdentityColumn);
break;
}
}
private void RibbonForm1_Load(object sender, EventArgs e)
{
SqlServerDbMapper <DishMenu> dishMenu = new SqlServerDbMapper <DishMenu>();
//this.gridControl1.DataSource = dishMenu.GetAllObjectInstanceList();
//DevExpress.XtraGrid.Views.Grid.GridView gridView2;
this.gridControl1.DataSource = this.GetDataTable(); //dishMenu.GetAllObjectInstanceList();
//this.gridControl1.DefaultView.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.UltraFlat;
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsView.ShowGroupPanel = false;
}
private void winGridViewPager1_OnDeleteSelected(object sender, EventArgs e)
{
if (MessageBox.Show("您确定删除选定的记录么？") == DialogResult.No)
{
return;
}
int[] rowSelected = this.gridView1.GetSelectedRows();
foreach (int iRow in rowSelected)
{
string id = this.gridView1.GetRowCellDisplayText(iRow, "Id");
SqlServerDbMapper <DishMenu> dishMenuMap = new SqlServerDbMapper <DishMenu>();
dishMenuMap.Delete(new DishMenu {
Id = Convert.ToInt32(id)
});
}
this.gridControl1.DataSource = this.GetDataTable();
}
