public static bool Update(SeatMaDll.SeatingChart sc)
{
SeatingchartDbo dbo = new SeatingchartDbo();
SeatingchartPo scPo = new SeatingchartPo();
scPo.SEATINGCHARTID = sc.SeatingChartId;
scPo.SEATINGCHARTNAME = sc.SeatingChartName;
scPo.LEVEL = sc.Level;
scPo.SEATS = sc.Seats;
scPo.COLUMNS = sc.Columns;
scPo.ROWSPACE = sc.RowSpace;
scPo.COLUMNSPACE = sc.ColumnSpace;
scPo.ROTATION = sc.Rotation;
scPo.HALLID = sc.HallId;
scPo.THEATERID = sc.TheaterId;
BlockPo blPo = new BlockPo();
blPo.BLOCKID = scPo.SEATINGCHARTID + "0";
blPo.BLOCKNAME = "默认";
blPo.SEATINGCHARTID = scPo.SEATINGCHARTID;
DataTable dt = dbo.RetrieveALLItemsBySeatingchartId(sc.SeatingChartId);
bool bReturn = false;
if (dt == null || dt.Rows.Count <= 0)
{
bReturn = dbo.InsertWithBlock(scPo, blPo);
}
dt.Dispose();
return(bReturn);
}
public bool Insert(MySqlConnection conn, MySqlTransaction trans, BlockPo obj)
{
string text = string.Concat(new string[]
{
"INSERT INTO ",
this.TABLE_NAME,
" (",
this.SQL_INSERT_COLUMNS,
") VALUES (",
this.SQL_INSERT_VALUES,
")"
});
MySqlCommand mySqlCommand = new MySqlCommand(text, conn, trans);
this.SetKeyParams(mySqlCommand, obj);
this.SetAttParams(mySqlCommand, obj);
bool result;
try
{
result = (mySqlCommand.ExecuteNonQuery() > 0);
}
catch (MySqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception ex2)
{
throw new Exception(ex2.Message);
}
return(result);
}
public bool Delete(BlockPo obj)
{
string text = " DELETE FROM " + this.TABLE_NAME + this.SQL_WHERE_KEYS;
MySqlConnection connection = DBOHelper.GetConnection();
DBOHelper.OpenConnection(connection);
MySqlCommand mySqlCommand = new MySqlCommand(text, connection);
this.SetKeyParams(mySqlCommand, obj);
bool result;
try
{
result = (mySqlCommand.ExecuteNonQuery() > 0);
}
catch (MySqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception ex2)
{
throw new Exception(ex2.Message);
}
finally
{
DBOHelper.CloseConnection(connection);
}
return(result);
}
public bool Update(MySqlConnection conn, MySqlTransaction trans, BlockPo obj)
{
string text = string.Concat(new string[]
{
"UPDATE ",
this.TABLE_NAME,
" SET ",
this.SQL_UPDATE_FIELD,
this.SQL_WHERE_KEYS
});
MySqlCommand mySqlCommand = new MySqlCommand(text, conn, trans);
this.SetKeyParams(mySqlCommand, obj);
this.SetAttParams(mySqlCommand, obj);
bool result;
try
{
result = (mySqlCommand.ExecuteNonQuery() > 0);
}
catch (MySqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception ex2)
{
throw new Exception(ex2.Message);
}
return(result);
}
private void SetAttParams(MySqlCommand cmd, BlockPo obj)
{
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.BLOCKNAME, 253).Value = obj.BLOCKNAME;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.BGCOLOUR, 3).Value = obj.BGCOLOUR;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.SEATS, 503).Value = obj.SEATS;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.HASBLOCKPRICE, 3).Value = obj.HASBLOCKPRICE;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.SEATINGCHARTID, 253).Value = obj.SEATINGCHARTID;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.CREATED, 12).Value = obj.CREATED;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.UPDATED, 12).Value = obj.UPDATED;
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.ACTIVEFLAG, 3).Value = obj.ACTIVEFLAG;
}
public static bool DeleteObj(Block bk, string szBlockId_Default)
{
BlockDbo dbo = new BlockDbo();
BlockPo po = new BlockPo();
po.BLOCKID = bk.BlockId;
po.BLOCKNAME = bk.BlockName;
po.BGCOLOUR = bk.Bgcolour;
po.HASBLOCKPRICE = bk.HasBlockPrice;
po.SEATINGCHARTID = bk.SeatingChartId;
po.SEATS = bk.Seats;
po.CREATED = DateTime.Now;
po.UPDATED = DateTime.Now;
po.ACTIVEFLAG = 1;
return(dbo.DeleteAll(po, szBlockId_Default));
}
public static bool CreateObj(Block bk)
{
BlockDbo dbo = new BlockDbo();
BlockPo po = new BlockPo();
po.BLOCKID = bk.BlockId.Trim().Length <= 0 ? dbo.BuildId(bk.SeatingChartId) : bk.BlockId;
po.BLOCKNAME = bk.BlockName;
po.BGCOLOUR = bk.Bgcolour;
po.HASBLOCKPRICE = bk.HasBlockPrice;
po.SEATINGCHARTID = bk.SeatingChartId;
po.SEATS = bk.Seats;
po.CREATED = DateTime.Now;
po.UPDATED = DateTime.Now;
po.ACTIVEFLAG = 1;
return(dbo.Insert(po));
}
public bool DeleteAll(BlockPo obj, string szBlockIdNew)
{
MySqlConnection connection = DBOHelper.GetConnection();
DBOHelper.OpenConnection(connection);
MySqlTransaction mySqlTransaction = connection.BeginTransaction();
bool result;
try
{
SeatDbo seatDbo = new SeatDbo();
BlockPriceDbo blockPriceDbo = new BlockPriceDbo();
bool flag = true;
seatDbo.UpdateBlockWithNew(connection, mySqlTransaction, obj.BLOCKID, szBlockIdNew);
blockPriceDbo.DeleteAllByBlockId(connection, mySqlTransaction, obj.BLOCKID);
if (flag)
{
flag = this.Delete(connection, mySqlTransaction, obj);
}
if (flag)
{
mySqlTransaction.Commit();
}
else
{
mySqlTransaction.Rollback();
}
result = flag;
}
catch (MySqlException ex)
{
mySqlTransaction.Rollback();
throw ex;
}
catch (Exception ex2)
{
mySqlTransaction.Rollback();
throw ex2;
}
finally
{
DBOHelper.CloseConnection(connection);
}
return(result);
}
public bool InsertWithBlock(SeatingchartPo scPo, BlockPo blPo)
{
MySqlConnection connection = DBOHelper.GetConnection();
DBOHelper.OpenConnection(connection);
MySqlTransaction mySqlTransaction = connection.BeginTransaction();
bool result;
try
{
bool flag = this.Insert(connection, mySqlTransaction, scPo);
if (flag)
{
flag = new BlockDbo().Insert(connection, mySqlTransaction, blPo);
}
if (flag)
{
DBOHelper.CommitTransaction(mySqlTransaction);
}
else
{
DBOHelper.RollBackTransction(mySqlTransaction);
}
result = flag;
}
catch (MySqlException ex)
{
DBOHelper.RollBackTransction(mySqlTransaction);
throw ex;
}
catch (Exception ex2)
{
DBOHelper.RollBackTransction(mySqlTransaction);
throw ex2;
}
finally
{
DBOHelper.CloseConnection(connection);
}
return(result);
}
public bool Insert(BlockPo obj)
{
MySqlConnection connection = DBOHelper.GetConnection();
DBOHelper.OpenConnection(connection);
string text = string.Concat(new string[]
{
"INSERT INTO ",
this.TABLE_NAME,
" (",
this.SQL_INSERT_COLUMNS,
") VALUES (",
this.SQL_INSERT_VALUES,
")"
});
MySqlCommand mySqlCommand = new MySqlCommand(text, connection);
this.SetKeyParams(mySqlCommand, obj);
this.SetAttParams(mySqlCommand, obj);
bool result;
try
{
result = (mySqlCommand.ExecuteNonQuery() > 0);
}
catch (MySqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception ex2)
{
throw new Exception(ex2.Message);
}
finally
{
DBOHelper.CloseConnection(connection);
}
return(result);
}
public bool Delete(MySqlConnection conn, MySqlTransaction trans, BlockPo obj)
{
string text = " DELETE FROM " + this.TABLE_NAME + this.SQL_WHERE_KEYS;
MySqlCommand mySqlCommand = new MySqlCommand(text, conn, trans);
this.SetKeyParams(mySqlCommand, obj);
bool result;
try
{
result = (mySqlCommand.ExecuteNonQuery() > 0);
}
catch (MySqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception ex2)
{
throw new Exception(ex2.Message);
}
return(result);
}
public bool Update(BlockPo obj)
{
MySqlConnection connection = DBOHelper.GetConnection();
DBOHelper.OpenConnection(connection);
string text = string.Concat(new string[]
{
"UPDATE ",
this.TABLE_NAME,
" SET ",
this.SQL_UPDATE_FIELD,
this.SQL_WHERE_KEYS
});
MySqlCommand mySqlCommand = new MySqlCommand(text, connection);
this.SetKeyParams(mySqlCommand, obj);
this.SetAttParams(mySqlCommand, obj);
bool result;
try
{
result = (mySqlCommand.ExecuteNonQuery() > 0);
}
catch (MySqlException ex)
{
throw new Exception(ex.Message);
}
catch (Exception ex2)
{
throw new Exception(ex2.Message);
}
finally
{
DBOHelper.CloseConnection(connection);
}
return(result);
}
private void SetKeyParams(MySqlCommand cmd, BlockPo obj)
{
cmd.Parameters.AddWithValue(BlockDbo.CmdParam.BLOCKID, 253).Value = obj.BLOCKID;
}
