public static string BuildSeatingchartId(string szHallId, int nLevel)
{
SeatingchartDbo dbo = new SeatingchartDbo();
string szSeatingchartId = dbo.BuildId(szHallId, nLevel);
return(szSeatingchartId);
}
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 static SeatMaDll.SeatingChart GetSeatingChart(string szSeatingChartName)
{
SeatingchartDbo dbo = new SeatingchartDbo();
DataTable dt = dbo.GetSeatingChart(szSeatingChartName);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
SeatMaDll.SeatingChart obj = ChangeObj(dt.Rows[0]);
return(obj);
}
public static List <SimHallLevel> RetrieveLevelItems(string szTheaterId, string szHallId)
{
List <SimHallLevel> list = new List <SimHallLevel>();
DataTable dt = new SeatingchartDbo().RetrieveLevelItems(szTheaterId, szHallId);
if (dt == null || dt.Rows.Count <= 0)
{
return(list);
}
foreach (DataRow dr in dt.Rows)
{
SimHallLevel obj = ChangeObj(dr, szTheaterId);
list.Add(obj);
}
return(list);
}
public static SeatMaDll.SeatingChart RetrieveObj(string szHallId, int nLevel)
{
SeatingchartDbo dbo = new SeatingchartDbo();
DataTable dt = dbo.RetrieveALLItems(szHallId, nLevel);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
SeatMaDll.SeatingChart obj = ChangeObj(dt.Rows[0]);
if (obj != null)
{
obj._listSiteItem = SeatAction.RetrieveItems(obj.SeatingChartId);
}
return(obj);
}
public static byte[] GetThumbnailBytes(string szSeatingchartId)
{
SeatingchartDbo dbo = new SeatingchartDbo();
return(dbo.GetThumbnailValue(szSeatingchartId));
//byte[] binaryDataResult = null;
//MemoryStream memStream = new MemoryStream();
//IFormatter brFormatter = new BinaryFormatter();
//brFormatter.Serialize(memStream, obj);
//binaryDataResult = memStream.ToArray();
//memStream.Close();
//memStream.Dispose();
//return binaryDataResult;
//return Compress(binaryDataResult);
}
public static List <SeatMaDll.SeatingChart> RetrieveObjListWithBlock(string szHallId, int nLevel)
{
List <SeatMaDll.SeatingChart> list = new List <SeatMaDll.SeatingChart>();
SeatingchartDbo dbo = new SeatingchartDbo();
DataTable dt = dbo.RetrieveALLItems(szHallId, nLevel);
if (dt == null || dt.Rows.Count <= 0)
{
return(list);
}
foreach (DataRow dr in dt.Rows)
{
SeatMaDll.SeatingChart obj = ChangeObj(dr);
obj._listSiteItem = SeatAction.RetrieveItemsWithBlock(obj.SeatingChartId);
list.Add(obj);
}
return(list);
}
public static bool ResetData(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.ROWS = sc.Rows;
scPo.COLUMNS = sc.Columns;
scPo.ROWSPACE = sc.RowSpace;
scPo.COLUMNSPACE = sc.ColumnSpace;
scPo.ROTATION = sc.Rotation;
scPo.HALLID = sc.HallId;
scPo.THEATERID = sc.TheaterId;
scPo.BGCOLOUR = sc.BgColour;
scPo.SHAPE = sc.Shape;
bool bReturn = dbo.Update(scPo);
return(bReturn);
}
public static bool UpdateThumbnail(string szSeatingchartId, byte[] byteThumbnail)
{
SeatingchartDbo dbo = new SeatingchartDbo();
return(dbo.UpdateThumbnail(szSeatingchartId, byteThumbnail));
}
public static bool UpdateActiveFlag(string szSeatingchartId, int nActiveFlag)
{
SeatingchartDbo dbo = new SeatingchartDbo();
return(dbo.UpdateActiveFlag(szSeatingchartId, nActiveFlag));
}
public static bool SeatingChartExistWillUsed(string szSeatingChartName, DateTime dtStartTime)
{
SeatingchartDbo dbo = new SeatingchartDbo();
return(dbo.CheckExistByNameWillUsed(szSeatingChartName, dtStartTime));
}
public static bool SeatingChartExistHaveUsed(string szSeatingChartId)
{
SeatingchartDbo dbo = new SeatingchartDbo();
return(dbo.CheckExistByIdHaveUsed(szSeatingChartId));
}
public static bool SeatingChartExist(string szSeatingChartName)
{
SeatingchartDbo dbo = new SeatingchartDbo();
return(dbo.CheckExistByName(szSeatingChartName));
}
