private static SeatPo ChangeObj(DataRow dr, int nUser, ref string szStatusFlag) { SeatPo obj = new SeatPo(); obj.SEATID = dr["SeatId"] == DBNull.Value ? "" : dr["SeatId"].ToString(); obj.ROWNUMBER = dr["RowNumber"] == DBNull.Value ? "" : dr["RowNumber"].ToString(); obj.COLUMNNUMBER = dr["ColumnNumber"] == DBNull.Value ? "" : dr["ColumnNumber"].ToString(); obj.SEATNUMBER = dr["SeatNumber"] == DBNull.Value ? "" : dr["SeatNumber"].ToString(); obj.XAXIS = dr["Xaxis"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Xaxis"]); obj.YAXIS = dr["Yaxis"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Yaxis"]); obj.HEIGHT = dr["Height"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Height"]); obj.WIDTH = dr["Width"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Width"]); obj.PROPERTY = dr["Property"] == DBNull.Value ? "" : dr["Property"].ToString(); obj.SEATINGCHARTID = dr["SeatingChartId"] == DBNull.Value ? "" : dr["SeatingChartId"].ToString(); obj.BLOCKID = dr["BlockId"] == DBNull.Value ? "" : dr["BlockId"].ToString(); obj.SEATTYPE = dr["SeatType"] == DBNull.Value ? "" : dr["SeatType"].ToString(); obj.SEATGROUP = dr["SeatGroup"] == DBNull.Value ? "" : dr["SeatGroup"].ToString(); obj.CREATED = dr["Created"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["Created"]); obj.UPDATED = dr["Updated"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["Updated"]); obj.ACTIVEFLAG = dr["ActiveFlag"] == DBNull.Value ? 1 : Convert.ToInt32(dr["ActiveFlag"]); int nLockedBy = dr["LockedBy"] == DBNull.Value ? 0 : Convert.ToInt32(dr["LockedBy"]); szStatusFlag = dr["TicketingState"] == DBNull.Value ? "0" : dr["TicketingState"].ToString(); if (szStatusFlag == "1") { if (nLockedBy == nUser) { szStatusFlag = "5"; } } return(obj); }
public bool Delete(SeatPo 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 static List <SeatMaDll.Seat> RetrieveStatusObjs(string szShowPlanId, string szHallId, int nLevel, int nUser) { List <SeatMaDll.Seat> listAll = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listNoBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listHaveBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.SeatingChart> scList = SeatingChartAction.RetrieveObjList(szHallId, nLevel); if (scList == null || scList.Count <= 0) { return(listAll); } SeatstatusDbo dbo = new SeatstatusDbo(); //DataTable dt = dbo.RetrieveItemStatus_Init(szShowPlanId, szHallId, nLevel); DataTable dt = dbo.RetrieveItemStatus(szShowPlanId, scList[0].SeatingChartId); if (dt == null || dt.Rows.Count <= 0) { return(listAll); } foreach (DataRow dr in dt.Rows) { string szStatusFlag = "0"; SeatPo po = ChangeObj(dr, nUser, ref szStatusFlag); SeatMaDll.Seat st = SeatAction.ChangeObjFromData(po); //st._seatStatusFlag = dr["TicketingState"] == DBNull.Value ? "0" : dr["TicketingState"].ToString(); st._seatStatusFlag = szStatusFlag; if (st._seatSeatGroup.Trim().Length <= 0) { listAll.Add(st); } else { if (st._brotherList.Count <= 0) { listNoBrother.Add(st); } else { st._brotherList[0]._seatStatusFlag = szStatusFlag; listHaveBrother.Add(st); } } //if (!SeatAction.MergeObj(list, st)) list.Add(st); } SeatAction.MergeObjNew(listNoBrother, listHaveBrother); foreach (SeatMaDll.Seat st in listHaveBrother) { listAll.Add(st); } //if (listHaveBrother.Count > 0) // listAll.AddRange(listHaveBrother[0], listHaveBrother[listHaveBrother.Count-1]); //listAll = listAll.AddRange(listNoBrother); //.CopyTo(listNoBrother); return(listAll); }
public bool Update(MySqlConnection conn, MySqlTransaction trans, SeatPo 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); }
public bool Insert(MySqlConnection conn, MySqlTransaction trans, SeatPo 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 static List <SeatPo> SplitDBObj(SeatMaDll.Seat st) { List <SeatPo> list = new List <SeatPo>(); if (st._brotherList.Count <= 0) { SeatPo po = new SeatPo(); po.SEATID = st._seatId; po.ROWNUMBER = st._seatRowNumberDisplay;//st._seatRowNumber; po.COLUMNNUMBER = st._seatColumn; po.SEATNUMBER = st._seatNumber; po.XAXIS = st._seatPosX; po.YAXIS = st._seatPosY; po.WIDTH = st._seatWidth; po.HEIGHT = st._seatHeight; po.PROPERTY = st._seatProperty; po.SEATINGCHARTID = st._seatSeatingChartId; po.BLOCKID = st._seatBlockId; po.SEATTYPE = st._seatFlag; po.SEATGROUP = st._seatSeatGroup; po.CREATED = DateTime.Now; //st._seatStatusFlag; po.UPDATED = DateTime.Now; //st._seatStatusFlag; po.ACTIVEFLAG = 1; list.Add(po); } else { string szSeatGroup = st._brotherList[0]._seatId; for (int i = 0; i < st._brotherList.Count; i++) { SeatPo po = new SeatPo(); po.SEATID = st._brotherList[i]._seatId; po.ROWNUMBER = st._brotherList[i]._seatRowNumberDisplay;//st._brotherList[i]._seatRowNumber; po.COLUMNNUMBER = st._brotherList[i]._seatColumn; po.SEATNUMBER = st._brotherList[i]._seatNumber; po.XAXIS = st._brotherList[i]._seatPosX; po.YAXIS = st._brotherList[i]._seatPosY; po.WIDTH = st._brotherList[i]._seatWidth; po.HEIGHT = st._brotherList[i]._seatHeight; po.PROPERTY = st._brotherList[i]._seatProperty; po.SEATINGCHARTID = st._brotherList[i]._seatSeatingChartId; po.BLOCKID = st._brotherList[i]._seatBlockId; po.SEATTYPE = st._brotherList[i]._seatFlag; po.SEATGROUP = szSeatGroup; //po.SEATGROUP = st._brotherList[i]._seatFlag == "0" ? szSeatGroup : ""; po.CREATED = DateTime.Now; //st._seatStatusFlag; po.UPDATED = DateTime.Now; //st._seatStatusFlag; po.ACTIVEFLAG = 1; list.Add(po); } } return(list); }
public static List <SeatMaDll.Seat> RetrieveItemsWithBlock(string SeatingChartId) { List <SeatMaDll.Seat> listAll = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listNoBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listHaveBrother = new List <SeatMaDll.Seat>(); SeatDbo dbo = new SeatDbo(); DataTable dt = dbo.RetrieveALLItemsWithBlock(SeatingChartId); if (dt == null || dt.Rows.Count <= 0) { return(listAll); } foreach (DataRow dr in dt.Rows) { int nBgColour = dr["BgColour"] == DBNull.Value ? 0 : Convert.ToInt32(dr["BgColour"]); SeatPo po = ChangeObj(dr); SeatMaDll.Seat st = ChangeObjFromData(po); st._BackColor = nBgColour; st._IsUsedBackColor = true; if (st._seatSeatGroup.Trim().Length <= 0) { listAll.Add(st); } else { if (st._brotherList.Count <= 0) { listNoBrother.Add(st); } else { st._brotherList[0]._BackColor = nBgColour; st._brotherList[0]._IsUsedBackColor = true; listHaveBrother.Add(st); } } } SeatAction.MergeObjNew(listNoBrother, listHaveBrother); foreach (SeatMaDll.Seat st in listHaveBrother) { listAll.Add(st); } return(listAll); }
public static List <SeatMaDll.Seat> RetrieveItems(string SeatingChartId) { List <SeatMaDll.Seat> listAll = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listNoBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listHaveBrother = new List <SeatMaDll.Seat>(); SeatDbo dbo = new SeatDbo(); DataTable dt = dbo.RetrieveALLItems(SeatingChartId); if (dt == null || dt.Rows.Count <= 0) { return(listAll); } foreach (DataRow dr in dt.Rows) { SeatPo po = ChangeObj(dr); SeatMaDll.Seat st = ChangeObjFromData(po); if (st._seatSeatGroup.Trim().Length <= 0) { listAll.Add(st); } else { if (st._brotherList.Count <= 0) { listNoBrother.Add(st); } else { listHaveBrother.Add(st); } } } SeatAction.MergeObjNew(listNoBrother, listHaveBrother); foreach (SeatMaDll.Seat st in listHaveBrother) { listAll.Add(st); } //if (listHaveBrother.Count > 0) // listAll.AddRange(listHaveBrother[0], listHaveBrother[listHaveBrother.Count-1]); //listAll = listAll.AddRange(listNoBrother); //.CopyTo(listNoBrother); return(listAll); }
public static SeatMaDll.Seat ChangeObjFromDataWithBlock(SeatPo po) { SeatMaDll.Seat st = new SeatMaDll.Seat(); st._seatFlag = po.SEATTYPE; st._seatStatusFlag = "0"; //po.SEATSTATUSID; st._seatRowNumber = po.ROWNUMBER; st._seatRowNumberDisplay = po.ROWNUMBER; st._seatColumn = po.COLUMNNUMBER; st._seatNumber = po.SEATNUMBER; st._seatId = po.SEATID; st._seatColumnCount = 1; st._seatPosX = po.XAXIS; st._seatPosY = po.YAXIS; st._seatWidth = po.WIDTH; st._seatHeight = po.HEIGHT; st._seatProperty = po.PROPERTY; st._seatSeatingChartId = po.SEATINGCHARTID; st._seatBlockId = po.BLOCKID; st._seatSeatGroup = po.SEATGROUP; st._IsUsedBackColor = true; if (po.SEATGROUP.Trim().Length > 0 && po.SEATGROUP == po.SEATID) { SeatMaDll.Seat stN = new SeatMaDll.Seat(); stN._seatFlag = po.SEATTYPE; stN._seatStatusFlag = "0"; //po.SEATSTATUSID; stN._seatRowNumber = po.ROWNUMBER; stN._seatRowNumberDisplay = po.ROWNUMBER; stN._seatColumn = po.COLUMNNUMBER; stN._seatNumber = po.SEATNUMBER; stN._seatId = po.SEATID; stN._seatColumnCount = 1; stN._seatPosX = po.XAXIS; stN._seatPosY = po.YAXIS; stN._seatWidth = po.WIDTH; stN._seatHeight = po.HEIGHT; stN._seatProperty = po.PROPERTY; stN._seatSeatingChartId = po.SEATINGCHARTID; stN._seatBlockId = po.BLOCKID; stN._seatSeatGroup = po.SEATGROUP; stN._IsUsedBackColor = true; st._brotherList.Add(stN); } return(st); }
private void SetAttParams(MySqlCommand cmd, SeatPo obj) { cmd.Parameters.AddWithValue(SeatDbo.CmdParam.ROWNUMBER, 15).Value = obj.ROWNUMBER; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.COLUMNNUMBER, 15).Value = obj.COLUMNNUMBER; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATNUMBER, 15).Value = obj.SEATNUMBER; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.XAXIS, 3).Value = obj.XAXIS; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.YAXIS, 3).Value = obj.YAXIS; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.HEIGHT, 3).Value = obj.HEIGHT; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.WIDTH, 3).Value = obj.WIDTH; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.PROPERTY, 253).Value = obj.PROPERTY; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATGROUP, 253).Value = obj.SEATGROUP; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.CAPACITY, 3).Value = obj.CAPACITY; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATINGCHARTID, 253).Value = obj.SEATINGCHARTID; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.BLOCKID, 253).Value = obj.BLOCKID; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATTYPE, 253).Value = obj.SEATTYPE; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.CREATED, 12).Value = obj.CREATED; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.UPDATED, 12).Value = obj.UPDATED; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.ACTIVEFLAG, 3).Value = obj.ACTIVEFLAG; }
public bool Insert(SeatPo 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, SeatPo 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 UpdateType(SeatPo obj) { MySqlConnection connection = DBOHelper.GetConnection(); DBOHelper.OpenConnection(connection); string text = string.Concat(new string[] { "UPDATE ", this.TABLE_NAME, " SET ", this.SQL_UPDATETYPE_FIELD, this.SQL_WHERE_KEYS }); MySqlCommand mySqlCommand = new MySqlCommand(text, connection); this.SetKeyParams(mySqlCommand, obj); this.SetAttParams_UpdateType(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 static List <SeatMaDll.Seat> RetrieveObjWithSeatingchartAndBlock(string szShowPlanId, string szHallId, int nLevel, int nUser, ref SeatMaDll.SeatingChart seatingchart) { List <SeatMaDll.Seat> listAll = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listNoBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listHaveBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.SeatingChart> scList = SeatingChartAction.RetrieveObjList(szHallId, nLevel); if (scList == null || scList.Count <= 0) { return(listAll); } SeatstatusDbo dbo = new SeatstatusDbo(); //DataTable dt = dbo.RetrieveItemStatus_Init(szShowPlanId, szHallId, nLevel); DataTable dt = dbo.RetrieveItemStatus_InitWithBlock(szShowPlanId, scList[0].SeatingChartId); seatingchart = scList[0]; if (dt == null || dt.Rows.Count <= 0) { return(listAll); } foreach (DataRow dr in dt.Rows) { int nBgColour = dr["BgColour"] == DBNull.Value ? 0 : Convert.ToInt32(dr["BgColour"]); string szStatusFlag = "0"; SeatPo po = ChangeObj(dr, nUser, ref szStatusFlag); SeatMaDll.Seat st = SeatAction.ChangeObjFromData(po); st._BackColor = nBgColour; st._IsUsedBackColor = true; //st._seatStatusFlag = dr["TicketingState"] == DBNull.Value ? "0" : dr["TicketingState"].ToString(); st._seatStatusFlag = szStatusFlag; if (st._seatSeatGroup.Trim().Length <= 0) { listAll.Add(st); } else { if (st._brotherList.Count <= 0) { listNoBrother.Add(st); } else { st._brotherList[0]._BackColor = nBgColour; st._brotherList[0]._IsUsedBackColor = true; st._brotherList[0]._seatStatusFlag = szStatusFlag; listHaveBrother.Add(st); } } } SeatAction.MergeObjNew(listNoBrother, listHaveBrother); foreach (SeatMaDll.Seat st in listHaveBrother) { listAll.Add(st); } return(listAll); }
private void SetAttParams_UpdateType(MySqlCommand cmd, SeatPo obj) { cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATGROUP, 253).Value = obj.SEATGROUP; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATTYPE, 253).Value = obj.SEATTYPE; cmd.Parameters.AddWithValue(SeatDbo.CmdParam.UPDATED, 12).Value = obj.UPDATED; }
public static List <SeatMaDll.Seat> RetrieveObjWithSeatingchartAndBlock(string szShowPlanId, SeatMaDll.SeatingChart seatingChartTemp, int nUser, int nLeftPad, int nTopPad, ref SeatMaDll.SeatingChart seatingchart) { List <SeatMaDll.Seat> listAll = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listNoBrother = new List <SeatMaDll.Seat>(); List <SeatMaDll.Seat> listHaveBrother = new List <SeatMaDll.Seat>(); if (seatingChartTemp == null) { return(listAll); } SeatstatusDbo dbo = new SeatstatusDbo(); DataTable dt = dbo.RetrieveItemStatus_InitWithBlock(szShowPlanId, seatingChartTemp.SeatingChartId); seatingchart = seatingChartTemp; if (dt == null || dt.Rows.Count <= 0) { return(listAll); } //var sw = new Stopwatch(); //sw.Restart(); foreach (DataRow dr in dt.Rows) { int nBgColour = dr["BgColour"] == DBNull.Value ? 0 : Convert.ToInt32(dr["BgColour"]); string szStatusFlag = "0"; SeatPo po = ChangeObj(dr, nUser, ref szStatusFlag); SeatMaDll.Seat st = SeatAction.ChangeObjFromDataWithPad(po, nLeftPad, nTopPad); st._BackColor = nBgColour; st._IsUsedBackColor = true; //st._seatStatusFlag = dr["TicketingState"] == DBNull.Value ? "0" : dr["TicketingState"].ToString(); st._seatStatusFlag = szStatusFlag; if (st._seatSeatGroup.Trim().Length <= 0) { listAll.Add(st); } else { if (st._brotherList.Count <= 0) { listNoBrother.Add(st); } else { st._brotherList[0]._BackColor = nBgColour; st._brotherList[0]._IsUsedBackColor = true; st._brotherList[0]._seatStatusFlag = szStatusFlag; listHaveBrother.Add(st); } } } //sw.Stop(); //TimeSpan time = sw.Elapsed; SeatAction.MergeObjNew(listNoBrother, listHaveBrother); dt.Dispose(); foreach (SeatMaDll.Seat st in listHaveBrother) { listAll.Add(st); } return(listAll); }
private void SetKeyParams(MySqlCommand cmd, SeatPo obj) { cmd.Parameters.AddWithValue(SeatDbo.CmdParam.SEATID, 253).Value = obj.SEATID; }
public static List <SeatPo> SplitDBObj_ForUpdate(SeatMaDll.Seat st) { List <SeatPo> list = new List <SeatPo>(); if (st._brotherList.Count <= 0) { SeatPo po = new SeatPo(); po.SEATID = st._seatId; po.ROWNUMBER = st._seatRowNumber; po.COLUMNNUMBER = st._seatColumn; po.SEATNUMBER = st._seatNumber; po.XAXIS = st._seatPosX; po.YAXIS = st._seatPosY; po.WIDTH = st._seatWidth; po.HEIGHT = st._seatHeight; po.PROPERTY = st._seatProperty; po.SEATINGCHARTID = st._seatSeatingChartId; po.BLOCKID = st._seatBlockId; po.SEATTYPE = st._seatFlag; po.SEATGROUP = st._seatSeatGroup; po.CREATED = DateTime.Now; //st._seatStatusFlag; po.UPDATED = DateTime.Now; //st._seatStatusFlag; po.ACTIVEFLAG = 1; list.Add(po); } else { string szSeatGroup = st._brotherList[0]._seatId; int nGroupCount = 0; ReFindGroupId(st._brotherList, ref szSeatGroup, ref nGroupCount); for (int i = 0; i < st._brotherList.Count; i++) { SeatPo po = new SeatPo(); po.SEATID = st._brotherList[i]._seatId; po.ROWNUMBER = st._brotherList[i]._seatRowNumber; po.COLUMNNUMBER = st._brotherList[i]._seatColumn; po.SEATNUMBER = st._brotherList[i]._seatNumber; po.XAXIS = st._brotherList[i]._seatPosX; po.YAXIS = st._brotherList[i]._seatPosY; po.WIDTH = st._brotherList[i]._seatWidth; po.HEIGHT = st._brotherList[i]._seatHeight; po.PROPERTY = st._brotherList[i]._seatProperty; po.SEATINGCHARTID = st._brotherList[i]._seatSeatingChartId; po.BLOCKID = st._brotherList[i]._seatBlockId; if (st._brotherList[i]._seatFlag != "0" && st._brotherList[i]._seatFlag != "1" && st._brotherList[i]._seatFlag != "2") { po.SEATGROUP = ""; po.SEATTYPE = st._brotherList[i]._seatFlag; } else { if (nGroupCount <= 1) { po.SEATGROUP = ""; po.SEATTYPE = "0"; } else { po.SEATGROUP = szSeatGroup; po.SEATTYPE = st._brotherList[i]._seatFlag; } } po.CREATED = DateTime.Now; //st._seatStatusFlag; po.UPDATED = DateTime.Now; //st._seatStatusFlag; po.ACTIVEFLAG = 1; list.Add(po); } } return(list); }