示例#1
0
        private void copyItemRClkBtn_Click(object sender, EventArgs e)
        {
            DataTable FindNewID = DBConnect.AQuery("SELECT max(typeID) from invTypes");
            int newid = 0;
            foreach (DataRow record in FindNewID.Rows)
            {
                newid = Convert.ToInt16(record[0].ToString()) + 1;
            }

            foreach (ListViewItem SelectedItem in ItemList.SelectedItems)
            {
                int typeID = Convert.ToInt16(SelectedItem.SubItems[0].Text);
                DBConnect.SQuery("INSERT INTO invTypes(typeID, groupID, typeName, description, graphicID, radius, mass, volume, capacity, portionSize, raceID, basePrice, published, marketGroupID, chanceOfDuplicating) SELECT '" + newid + "', groupID, concat('Copy of ', typeName), description, graphicID, radius, mass, volume, capacity, portionSize, raceID, basePrice, published, marketGroupID, chanceOfDuplicating from invTypes WHERE typeID = '" + typeID + "'");
                DBConnect.SQuery("INSERT INTO dgmTypeAttributes SELECT '" + newid + "', attributeID, valueInt, valueFloat from dgmTypeAttributes WHERE typeID = '" + typeID + "'");
                DBConnect.SQuery("INSERT INTO invShipTypes SELECT '" + newid + "', weapontypeID, miningtypeID, skilltypeID from invShipTypes WHERE shiptypeID = '" + typeID + "'");
                DBConnect.SQuery("INSERT INTO dgmTypeEffects SELECT '" + newid + "', effectID, isDefault from dgmTypeEffects WHERE typeID = '" + typeID + "'");
            }
            CategoryDropdown_SelectedIndexChanged(null, null);

            itemAddEdit add = new itemAddEdit();
            add.Show();
            add.extractItemInfo(newid);
        }
示例#2
0
 private void button7_Click(object sender, EventArgs e)
 {
     if (SelectedOretypeID.Text != "")
     {
         itemAddEdit add = new itemAddEdit();
         add.Show();
         add.extractItemInfo(Convert.ToInt16(SelectedOretypeID.Text));
     }
 }
示例#3
0
 private void editItemBtn_Click(object sender, EventArgs e)
 {
     itemAddEdit add = new itemAddEdit();
     add.Show();
     add.extractItemInfo(int.Parse(ItemList.SelectedItems[0].SubItems[0].Text));
 }
示例#4
0
 private void ItemList_DblClick(object sender, EventArgs e)
 {
     foreach (ListViewItem SelectedItem in ItemList.SelectedItems)
     {
         itemAddEdit add = new itemAddEdit();
         add.Show();
         add.extractItemInfo(int.Parse(ItemList.SelectedItems[0].SubItems[0].Text));
     }
 }
示例#5
0
 private void button4_Click(object sender, EventArgs e)
 {
     itemAddEdit add = new itemAddEdit();
     add.Show();
     add.extractItemInfo(int.Parse(itemID.Text));
 }