/// <summary>
/// 입력된 BoardType을 적당한 문자열로 바꿔줍니다.
/// </summary>
/// <param name="type">BoardType 열거형</param>
/// <returns>string 문자열</returns>
public string BoardTypeToDesc(BoardType type)
{
try
{
string str = type.ToString().Substring(4, type.ToString().IndexOf('x') - 4);
return(str + " x " + str);
}
catch
{
return("Any Type");
}
}
public XElement Serialize()
{
return(new XElement("Config",
new XElement("PPM",
new XAttribute("Enabled", _ppmGenEnabled)
),
new XElement("LCD",
new XAttribute("Enabled", _lcdEnabled),
new XAttribute("BL", _cldbl),
new XAttribute("Addr", _lcdAddr),
new XAttribute("I8080", _lcd8080)
),
new XElement("Debug",
new XAttribute("Enabled", _debugEnabled)
),
new XElement("Retranslator",
new XAttribute("XBee", _xBeeEnabled),
new XAttribute("NRF", _nrfEnabled)
),
new XElement("ROM",
new XAttribute("Enabled", _romEnabled),
new XAttribute("Addr", _romAddr),
new XAttribute("AStyle", _romAddrStyle)
),
new XAttribute("Path", OutputPath),
new XAttribute("BoardType", BoardType.ToString())
));
}
public Bus429()
{
BoardType = BoardType.A429;
Name = BoardType.ToString();//此处以BoardType来作为Name，标识唯一性。
DriverOperate = new Device429Operator();
Path = "BinHong_" + this.Name;
}
/// <summary>
/// この構造体のデータを文字列の並びにする。
/// </summary>
/// <returns></returns>
public List <string> ToList()
{
var list = new List <string>();
list.Add(PlayerNames[0]);
list.Add(PlayerNames[1]);
list.Add(StartTime.ToString());
list.Add(EndTime.ToString());
/* EnumのToString()あまり使いたくないけど、intにcastすると定義変えたときに困るので…。*/
list.Add(LastMove.MoveToString());
list.Add(LastColor.ToUsi());
list.Add(KifuFileName);
list.Add(GamePly.ToString());
list.Add(BoardType.ToString());
list.Add(TimeSettingString);
list.Add(Comment);
// 後方互換性を維持するために、追加が必要になったときは、
// ここの末尾に追加していく。
// これあとから追加した。(V1.16)
list.Add(Handicapped.ToString());
return(list);
}
public Bus1553()
{
BoardType = BoardType.A1553;
Name = BoardType.ToString();//此处以BoardType来作为Name，标识唯一性。
DriverOperate = new Device1553Operator();
}
public Battlefield()
{
boardPanel = new Panel();
ships = new List <Ship>();
cells = new Cell[FIELD_SIZE, FIELD_SIZE];
rowLabels = new Label[FIELD_SIZE];
columnLabels = new Label[FIELD_SIZE];
int rowLabelSize = CELL_SIZE;
int columnLabelSize = CELL_SIZE;
for (int i = 0; i < FIELD_SIZE; i++)
{
rowLabels[i] = new Label();
rowLabels[i].Text = Convert.ToString(i + 1);
rowLabels[i].Location = new Point(1, (i + 1) * CELL_SIZE);
rowLabels[i].Size = new Size(rowLabelSize, CELL_SIZE);
rowLabels[i].TextAlign = ContentAlignment.MiddleCenter;
boardPanel.Controls.Add(rowLabels[i]);
}
for (int i = 0; i < FIELD_SIZE; i++)
{
char columnLabelChar = (char)('A' + i);
columnLabels[i] = new Label();
columnLabels[i].Text = Convert.ToString(columnLabelChar);
columnLabels[i].Location = new Point((i + 1) * CELL_SIZE, 1);
columnLabels[i].Size = new Size(columnLabelSize, CELL_SIZE);
columnLabels[i].TextAlign = ContentAlignment.MiddleCenter;
boardPanel.Controls.Add(columnLabels[i]);
}
for (int i = 0; i < FIELD_SIZE; i++)
{
for (int j = 0; j < FIELD_SIZE; j++)
{
cells[i, j] = new Cell();
cells[i, j].RowNumber = i;
cells[i, j].ColumnNumber = j;
cells[i, j].Location = new Point(rowLabelSize + i * Battlefield.CELL_SIZE, columnLabelSize + j * Battlefield.CELL_SIZE);
cells[i, j].Battlefield = this;
boardPanel.Controls.Add(cells[i, j]);
}
}
boardTypeLabel = new Label();
boardTypeLabel.Text = BoardType.ToString();
boardTypeLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
boardTypeLabel.Size = new Size(CELL_SIZE * (FIELD_SIZE + 1), 24);
boardTypeLabel.Location = new Point(0, 0);
boardTypeLabel.TextAlign = ContentAlignment.MiddleCenter;
this.Controls.Add(boardTypeLabel);
boardPanel.Size = new Size(CELL_SIZE * (FIELD_SIZE + 1), CELL_SIZE * (FIELD_SIZE + 1));
boardPanel.Location = new Point(0, boardTypeLabel.Size.Height + 1);
this.Controls.Add(boardPanel);
scoreboard = new Scoreboard();
scoreboard.Size = new Size(60, 70);
scoreboard.Location = new Point(boardPanel.Size.Width + 10, boardTypeLabel.Size.Height + 1 + columnLabelSize + 1);
scoreboard.Battlefield = this;
this.Controls.Add(scoreboard);
this.BoardType = GameLibrary.BoardType.User;
}
public override string ToString()
{
return(BoardType.ToString() + BoardNo + ChannelType + ChannelCount);
}
/*
* Updates an entries data in the db
*/
public bool UpdateItem()
{
string myConnectString;
string strSQL = "";
//build SQL
strSQL = "UPDATE tblEntry SET dLastModified ='" + DateTime.Now + "',Location = '" + Location + "',txtTown = '" + Town + "',txtZip = '" + Zip + "',txtDetails = '" + Details + "',txtBrand = '" + Brand + "',fltPrice = '" + Price + "'";
if (PriceChange == 1)
{
strSQL += ",iPriceChange ='" + 1 + "'";
}
//can't do this
if (ImgPath1 != "KEEP")
{
strSQL += ",txtImgPath1 = '" + ImgPath1 + "'";
}
if (ImgPath2 != "KEEP")
{
strSQL += ",txtImgPath2 = '" + ImgPath2 + "'";
}
if (ImgPath3 != "KEEP")
{
strSQL += ",txtImgPath3 = '" + ImgPath3 + "'";
}
if (ImgPath4 != "KEEP")
{
strSQL += ",txtImgPath4 = '" + ImgPath4 + "'";
}
//Build SQL for category specific
switch (Category)
{
case 1: //surf
strSQL += ",txtShaper = '" + Shaper + "'";
//Build SQL for surf board dimensions (Width & Thickness)
strSQL += ",iBoardType = '" + BoardType + "'";
strSQL += ",iHtFt = '" + HtFt + "',iHtIn = '" + HtIn + "'";
strSQL += ",width ='" + Width + "',widthNum ='" + WidthNum + "',widthDeNum ='" + WidthDenum + "'";
strSQL += ",Thick = '" + Thickness + "',ThickNum ='" + ThickNum + "',ThickDenum = '" + ThickDenum + "'";
strSQL += ",iTailType = '" + TailType + "',iFins = '" + Fins + "'";
strSQL += ",iShip = '" + Ship + "' ";
break;
case 2: //snow
strSQL += ",iBoardType = '" + BoardType + "'";
strSQL += ",iHtFt = '" + HtFt + "'";
strSQL += ",iShip = '" + Ship + "' ";
break;
case 3: //other boards
if (BoardType.ToString() != "" && BoardType > (int)0)
{
strSQL += ",iBoardType = '" + BoardType + "'";
strSQL += ",txtOtherBoardType = NULL";
}
else
{
strSQL += ",iBoardType = NULL";
strSQL += ",txtOtherBoardType = '" + OtherBoardType + "'";
}
strSQL += ",txtShaper = '" + Shaper + "'";
strSQL += ", txtGenDimensions = '" + GenDimensions + "'";
strSQL += ",iShip = '" + Ship + "' ";
break;
case 4: //gear
strSQL += ",txtGearItem = '" + GearItem + "'";
strSQL += ",iShip = '" + Ship + "' ";
break;
}
strSQL += "WHERE iD = '" + EntryId + "'";
//ErrorLog.ErrorRoutine(false, "strSQL:Update: " + strSQL);
//get connect string
myConnectString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString;;
SqlConnection myConnection = new SqlConnection(myConnectString);
try
{
myConnection.Open();
SqlCommand objCommand = new SqlCommand(strSQL, myConnection);
objCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
ErrorLog.ErrorRoutine(false, "Error:BoardItems.cs:UpdateItem: " + ex.Message);
ErrorLog.ErrorRoutine(false, "Error:BoardItems.cs:UpdateItem:StrSQL: " + strSQL);
return(false);
}
finally
{
myConnection.Close();
}
}
/// <summary>
/// Public Methods
/// </summary>
public override bool SaveItem()
{
string myConnectString;
string strSQL = "Zippo";
myConnectString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString;;
//Build SQL
switch (Category)
{
case (int)1: //SURF
switch (AdType)
{
case 1: //selling
strSQL = "INSERT INTO tblEntry (Location, txtTown, txtZip, adType, iCategory, iBoardType, txtBrand, iHtFt, iHtIn, iTailType, iFins, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, width, widthNum, widthDenum, Thick, ThickNum, ThickDenum, iRatingVal, iRatingCount, iCondition, activateCode, iShip, txtShaper, iStatus, txtModel)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + Zip + "', '" + AdType + "', '" + Category + "', '" + BoardType + "', '" + Brand + "', '" + HtFt +
"', '" + HtIn + "', '" + TailType + "', '" + Fins + "' , '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"', '" + Width + "','" + WidthNum + "','" + WidthDenum + "','" + Thickness + "','" + ThickNum + "','" + ThickDenum + "','" + (int)0 +
"','" + (int)0 + "','" + ICondition + "','" + ActivateCode + "','" + Ship + "','" + Shaper + "','" + (int)1 + "','" + model + "')";
break;
case 2: //wanted
strSQL = "INSERT INTO tblEntry (Location, txtTown, adType, iCategory, iHtFt, iHtIn, iBoardType, txtDetails, dCreateDate, fltPrice, iUser, iRatingVal, iRatingCount, iShip, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + AdType + "', '" + Category + "', '" + HtFt +
"', '" + HtIn + "', '" + BoardType + "', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + (int)0 + "','" + (int)0 + "','" + Ship + "','" + (int)1 + "')";
break;
case 3: //showcase
strSQL = "INSERT INTO tblEntry (Location, txtTown, adTitle, adType, iCategory, txtBrand, txtWeb, txtGearItem, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, txtGenDimensions, iRatingVal, iRatingCount, activateCode, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "','" + AdTitle + "', '" + AdType + "', '" + Category + "', '" + Brand + "', '" + WebURL +
"', '" + GearItem + "', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"', '" + GenDimensions + "','" + (int)0 + "','" + (int)0 + "','" + ActivateCode + "','" + (int)1 + "')";
break;
case 4: //ShaperHouse
strSQL = "INSERT INTO tblEntry (Location, iBoardType, adType, iCategory, txtBrand, txtModel, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, txtGenDimensions, iRatingVal, iRatingCount, iStatus, activateCode, EntryVideoEmbed)";
strSQL += "VALUES ('" + Location + "', '" + BoardType + "','" + AdType + "', '" + Category + "', '" + Brand + "','" + model + "', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"', '" + GenDimensions + "','" + (int)0 + "','" + (int)0 + "','" + Status + "','" + ActivateCode + "','" + videoLink + "')"; //WHY is iStatus 4?
break;
}
break;
case (int)2: //SNOW
//TODO: for adtypes
strSQL = "INSERT INTO tblEntry (Location, txtTown, adType, iCategory, iBoardType, txtBrand, iHtFt, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, iRatingVal, iRatingCount, activateCode, iShip, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + AdType + "', '" + Category + "', '" + BoardType + "', '" + Brand + "', '" + HtFt +
"', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"','" + (int)0 + "','" + (int)0 + "','" + ActivateCode + "','" + Ship + "','" + (int)1 + "')";
break;
case (int)3: //OTHER boards
//TODO: for adtypes
if (BoardType == (int)0 || BoardType.ToString() == "")
{
strSQL = "INSERT INTO tblEntry (Location, txtTown, adType, iCategory, txtBrand, txtGenDimensions, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, iRatingVal, iRatingCount, txtOtherBoardType, activateCode, iShip, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + AdType + "', '" + Category + "', '" + Brand + "', '" + GenDimensions +
"', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"','" + (int)0 + "','" + (int)0 + "','" + OtherBoardType + "','" + ActivateCode + "','" + Ship + "','" + (int)1 + "')";
}
else
{
strSQL = "INSERT INTO tblEntry (Location, txtTown, adType, iCategory, iBoardType, txtBrand, txtGenDimensions, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, iRatingVal, iRatingCount, activateCode, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + AdType + "', '" + Category + "', '" + BoardType + "', '" + Brand + "', '" + GenDimensions +
"', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"','" + (int)0 + "','" + (int)0 + "','" + ActivateCode + "','" + (int)1 + "')";
}
break;
case (int)4: //Gear
switch (AdType)
{
case 1: //Selling
//TODO: for adtypes
strSQL = "INSERT INTO tblEntry (Location, txtTown, adType, iCategory, txtBrand, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, iRatingVal, iRatingCount, txtGearItem, activateCode, iShip, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + AdType + "', '" + Category + "', '" + Brand + "', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"','" + (int)0 + "','" + (int)0 + "','" + GearItem + "','" + ActivateCode + "','" + Ship + "','" + (int)1 + "')";
break;
case 2: //Wanted
strSQL = "INSERT INTO tblEntry (Location, txtTown, adType, iCategory, iHtFt, iHtIn, iBoardType, txtDetails, dCreateDate, fltPrice, iUser, iRatingVal, iRatingCount, activateCode, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "', '" + AdType + "', '" + Category + "', '" + HtFt +
"', '" + HtIn + "', '" + BoardType + "', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + (int)0 + "','" + (int)0 + "','" + ActivateCode + "','" + (int)1 + "')";
break;
case 3: //Showcase
strSQL = "INSERT INTO tblEntry (Location, txtTown, adTitle, adType, iCategory, txtBrand, txtWeb, txtGearItem, txtDetails, dCreateDate, fltPrice, iUser, txtImgPath1, txtImgPath2, txtImgPath3, txtImgPath4, txtGenDimensions, iRatingVal, iRatingCount, activateCode, iStatus)";
strSQL += "VALUES ('" + Location + "', '" + Town + "','" + AdTitle + "', '" + AdType + "', '" + Category + "', '" + Brand + "', '" + WebURL +
"', '" + GearItem + "', '" + Details + "' , '" + Created + "' , '" + Price + "', '" +
IUser + "', '" + ImgPath1 + "', '" + ImgPath2 + "', '" + ImgPath3 + "', '" + ImgPath4 +
"', '" + GenDimensions + "','" + (int)0 + "','" + (int)0 + "','" + ActivateCode + "','" + (int)1 + "')";
break;
}
break;
}
SqlConnection myConnection = new SqlConnection(myConnectString);
try
{
myConnection.Open();
SqlCommand objCommand = new SqlCommand(strSQL, myConnection);
objCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
ErrorLog.ErrorRoutine(false, "ErrMessage: " + ex.Message);
ErrorLog.ErrorRoutine(false, "strSQL: " + strSQL);
ErrorLog.ErrorRoutine(false, "Error Saving");
return(false);
}
finally
{
myConnection.Close();
}
}
