public static string getPartsToString(parts part)
{
string partStr = "";
switch (part)
{
case parts.None:
partStr = "None";
break;
case parts.BODY:
partStr = "BODY";
break;
case parts.WEAPON:
partStr = "WEAPON";
break;
case parts.MOUNT:
partStr = "MOUNT";
break;
case parts.WING:
partStr = "WING";
break;
default:
break;
}
return(partStr);
}
private void buttonX1_Click(object sender, EventArgs e)
{
//TestBZFrom tbz = new TestBZFrom();
//tbz.Show();
for (int i = 0; i < gridView1.RowCount; i++)
{
int XH = Convert.ToInt32(gridView1.GetRowCellValue(i, "id"));
string LJH = gridView1.GetRowCellValue(i, "PN").ToString();
string NM = gridView1.GetRowCellValue(i, "name").ToString();
string GDH = gridView1.GetRowCellValue(i, "jobnum").ToString();
string CSBH = gridView1.GetRowCellValue(i, "ARef").ToString();
string CC = gridView1.GetRowCellValue(i, "size").ToString();
string sd = gridView1.GetRowCellValue(i, "sm").ToString();
string TM = gridView1.GetRowCellValue(i, "Barcode").ToString();
Maticsoft.BLL.parts use = new Maticsoft.BLL.parts();
Maticsoft.Model.parts us = new parts()
{
id = XH,
PN = LJH,
//name = NM,
//jobnum = GDH,
//ARef = CSBH,
//size = CC,
//sm = sd,
Barcode = TM,
};
use.Update(us);
}
MessageBox.Show("修改成功");
}
private void addpartbtn_Click(object sender, EventArgs e)
{
//getting selected part
var selectedPart = (Part)partsbox.SelectedItem;
if (amountbox.Value == 0)
{
MessageBox.Show("Please enter a valid amount");
}
else if (selectedPart.BatchNumberHasRequired == true && batchnumberbox.Text.Length == 0)
{
MessageBox.Show("Batch Number is required for this part");
}
else
{
var amount = amountbox.Value;
var batchnumber = batchnumberbox.Text;
parts addPart = new parts();
addPart.partid = selectedPart.ID;
addPart.partname = selectedPart.Name;
addPart.amount = amount;
addPart.batchnumber = batchnumber;
listofparts.Add(addPart);
showParts();
}
}
//Update is called once per frame
void Update()
{
if (wire_attached_count < 12)
{
wire_attached_count++;
}
else if (wire_attached_flag)
{
wire_attached_flag = false;
}
if (mainparts = GetComponentInParent <parts>())
{
parts_voltage = mainparts.output_voltage;
amperage = mainparts.amperage;
flag = true;
}
if (mainbattery = GetComponentInParent <battery>())
{
parts_voltage = mainbattery.output_voltage;
amperage = mainbattery.amperage;
if (mainbattery.battery_exist_flag)
{
flag = true;
}
else
{
voltage = mainbattery.output_voltage;
}
}
}
public async Task <word_param> getEntry(int id)
{
try
{
var word_param = await(from c in db.words_list.AsNoTracking() where c.nom_old == id select c).FirstOrDefaultAsync();
indents indent = await(from c in db.indents.AsNoTracking() where c.type == word_param.type select c).FirstOrDefaultAsync();
List <flexes> flex = await(from c in db.flexes.AsNoTracking() where (c.type == word_param.type && (c.field2 > 0)) orderby c.field2, c.id select c).ToListAsync();
accents_class aclass = await(from c in db.accents_class.AsNoTracking() select c).FirstOrDefaultAsync();
accent[] acnt = await(from c in db.accent.AsNoTracking() where c.accent_type == word_param.accent select c).ToArrayAsync();
//minor_acc macc = await (from c in db.minor_acc.AsNoTracking() where c.nom_old == id select c).FirstOrDefaultAsync();
parts part = await(from c in db.parts.AsNoTracking() where c.id == word_param.part select c).FirstOrDefaultAsync();
word_param.parts = part;
word_param.indents = indent;
word_param.indents.flexes = flex;
word_param.accents_class = aclass;
word_param.accents_class.accents = acnt;
//word_param.minor_acc = macc;
return(word_param);
}
catch (Exception ex)
{
if (Logger != null)
{
Logger.LogError(new EventId(0), ex, ex.Message);
return(null);
}
else
{
throw ex;
}
}
}
void OnCustomize(int characterID, parts part, string newImage)
{
if (newImage == "")
{
return;
}
if (characterID == character.data.id)
{
if (part == parts.LEGS)
{
character.data.legs = newImage;
string leg1_image = "customizer/CLOTHES/bottom/" + newImage + "_leg_a";
string leg2_image = "customizer/CLOTHES/bottom/" + newImage + "_leg_b";
character.avatar.leg1.spriteMesh = Resources.Load(leg1_image, typeof(SpriteMesh)) as SpriteMesh;
character.avatar.leg2.spriteMesh = Resources.Load(leg2_image, typeof(SpriteMesh)) as SpriteMesh;
string body_bottom_image = "customizer/CLOTHES/bottom/" + newImage + "_hips";
character.avatar.body_bottom.spriteMesh = Resources.Load(body_bottom_image, typeof(SpriteMesh)) as SpriteMesh;
return;
}
else if (part == parts.CLOTHES)
{
character.data.clothes = newImage;
string arm_a_image = "customizer/CLOTHES/top/" + newImage + "_arm_a";
string arm_b_image = "customizer/CLOTHES/top/" + newImage + "_arm_b";
character.avatar.arm1.spriteMesh = Resources.Load(arm_a_image, typeof(SpriteMesh)) as SpriteMesh;
character.avatar.arm2.spriteMesh = Resources.Load(arm_b_image, typeof(SpriteMesh)) as SpriteMesh;
string body_up_a_image = "customizer/CLOTHES/top/" + newImage + "_torax_a";
string body_up_b_image = "customizer/CLOTHES/top/" + newImage + "_torax_b";
character.avatar.body_up_a.spriteMesh = Resources.Load(body_up_a_image, typeof(SpriteMesh)) as SpriteMesh;
character.avatar.body_up_b.spriteMesh = Resources.Load(body_up_b_image, typeof(SpriteMesh)) as SpriteMesh;
return;
}
else if (part == parts.HAIRS)
{
character.data.hairs = newImage;
//return;
string hair_a_image = "customizer/HAIR/" + newImage + "_a";
string hair_b_image = "customizer/HAIR/" + newImage + "_b";
character.avatar.hair_up.sprite = Resources.Load(hair_a_image, typeof(Sprite)) as Sprite;
character.avatar.hair_down.sprite = Resources.Load(hair_b_image, typeof(Sprite)) as Sprite;
return;
}
else if (part == parts.COLORS)
{
character.data.colors = newImage;
Color color = Data.Instance.clothesSettings.colors[int.Parse(character.data.colors)];
character.avatar.hair_up.color = color;
character.avatar.hair_down.color = color;
return;
}
string part_url = "customizer/" + part.ToString() + "/" + newImage;
}
}
private void button1_Click(object sender, EventArgs e)
{
KeyValuePair <long, string> selectedPart = ((KeyValuePair <long, string>)partscombobox.SelectedItem);
decimal amount = numericUpDown1.Value;
if (amount == 0)
{
MessageBox.Show("Please give a valid amount");
}
else
{
parts addpart = new parts();
addpart.partid = selectedPart.Key;
addpart.partname = selectedPart.Value;
addpart.amount = amount;
newList.Add(addpart);
loadchangedParts(sender, e);
}
}
private void getExistingparts(object sender, EventArgs e)
{
using (Session2Entities db = new Session2Entities())
{
//getting existing changed parts
var getParts = db.ChangedParts.Where(p => p.EmergencyMaintenanceID == EMID).ToList();
if (getParts != null)
{
newList = new List <parts>();
foreach (var item in getParts)
{
parts p = new parts();
p.partid = item.PartID;
p.amount = item.Amount;
p.partname = item.Part.Name;
newList.Add(p);
currentList.Add(item);
}
loadchangedParts(sender, e);
}
}
}
private void addpartbtn_Click(object sender, EventArgs e)
{
if (BatchNumberRequired == true && batchnumberbox.Text.Length == 0)
{
MessageBox.Show("Batch number is required");
}
else if (amountbox.Value == 0)
{
MessageBox.Show("Please enter a valid amount");
}
else
{
var selectedItem = (KeyValuePair <long, string>)partsBox.SelectedItem;
parts newPart = new parts();
newPart.partname = selectedItem.Value;
newPart.batchnumber = batchnumberbox.Text;
newPart.amount = amountbox.Value;
newPart.partid = selectedItem.Key;
Console.WriteLine("Hello");
listofparts.Add(newPart);
showParts(sender, e);
}
}
private void send_bt_Click(object sender, EventArgs e)
{
Maticsoft.BLL.parts use = new Maticsoft.BLL.parts();
Maticsoft.Model.parts us = new parts()
{
PN = bom_no_tb.Text,
//name = bomname_tb.Text,
//jobnum = gdno_tb.Text,
//ARef = scbh_tb.Text,
//size= cicun_tb.Text,
//sm= sandsm_tb.Text,
Barcode = tm_tb.Text,
};
use.Add(us);
MessageBox.Show("保存成功");
foreach (Control Ctrol in this.Controls)
{
if (Ctrol is TextBox)
{
Ctrol.Text = "";
}
}
this.Close();
}
public film(string name_of_film, int year_of_release, int times_of_film, int count_of_adverts, parts pr = parts.one)
{
strct.name_of_film = name_of_film;
strct.year_of_release = year_of_release;
strct.times_of_film = times_of_film;
strct.count_of_adverts = count_of_adverts;
strct.pr = pr;
}
private void WarehouseManagement_Load(object sender, EventArgs e)
{
using (Session4Entities db = new Session4Entities())
{
var warehouselist = db.Warehouses.ToList();
var partslist = db.Parts.ToList();
sourcewarehousebox.DataSource = new BindingSource(warehouselist, null);
sourcewarehousebox.DisplayMember = "Name";
sourcewarehousebox.ValueMember = "ID";
destinationwarehousebox.DataSource = new BindingSource(warehouselist, null);
destinationwarehousebox.DisplayMember = "Name";
destinationwarehousebox.ValueMember = "ID";
partsbox.DataSource = new BindingSource(partslist, null);
partsbox.DisplayMember = "Name";
partsbox.ValueMember = "ID";
//foreach(var item in partslist)
//{
// partorderitems.Add(item.ID, item.Name);
//}
//partsbox.DataSource = new BindingSource(partorderitems, null);
//partsbox.DisplayMember = "Value";
//partsbox.ValueMember = "Key";
if (edit == true)
{
//get existing warehouse order details
var warehouseorder = db.Orders.Where(order => order.ID == OID).FirstOrDefault();
foreach (var item in sourcewarehousebox.Items)
{
var selecteditem = (Warehouse)item;
if (selecteditem.ID == warehouseorder.SourceWarehouseID)
{
sourcewarehousebox.SelectedItem = item;
}
}
foreach (var item in destinationwarehousebox.Items)
{
var selecteditem = (Warehouse)item;
if (selecteditem.ID == warehouseorder.DestinationWarehouseID)
{
destinationwarehousebox.SelectedItem = item;
}
}
dateTimePicker1.Value = warehouseorder.Date;
//Retrieving all existing orderitems
var existingorderitems = db.OrderItems.Where(orderitem => orderitem.OrderID == OID).ToList();
foreach (var item in existingorderitems)
{
parts expts = new parts();
expts.partid = item.PartID;
expts.partname = item.Part.Name;
expts.amount = item.Amount;
expts.batchnumber = item.BatchNumber;
listofparts.Add(expts);
}
showParts();
}
}
}
private void import_bt_Click(object sender, EventArgs e)
{
//string filepath = "";
//OpenFileDialog opf = new OpenFileDialog();
//if (opf.ShowDialog() == DialogResult.OK)
//{
// filepath = opf.FileName;
//}
DataSet ds = new DataSet();
System.Data.DataTable dt = null;
OpenFileDialog sflg = new OpenFileDialog();
sflg.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx";
if (sflg.ShowDialog() == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
FileStream fs = new FileStream(sflg.FileName, FileMode.Open, FileAccess.Read);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(fs);
int sheetCount = book.NumberOfSheets;
for (int sheetIndex = 0; sheetIndex < sheetCount; sheetIndex++)
{
string st_name = book.GetSheetName(sheetIndex);
NPOI.SS.UserModel.ISheet sheet = book.GetSheetAt(sheetIndex);
if (sheet == null)
{
continue;
}
NPOI.SS.UserModel.IRow row = sheet.GetRow(0);
if (row == null)
{
continue;
}
int firstCellNum = row.FirstCellNum;
int lastCellNum = row.LastCellNum;
if (firstCellNum == lastCellNum)
{
continue;
}
dt = new System.Data.DataTable(sheet.SheetName);
dt.Columns.Add("PN", typeof(string));
//MessageBox.Show(dt.Columns["bushe_xianshu"].DataType.ToString());
//dt.Columns.Add("", typeof(int));
dt.Columns.Add("name", typeof(string));
dt.Columns.Add("jobnum", typeof(string));
dt.Columns.Add("ARef", typeof(string));
dt.Columns.Add("size", typeof(string));
dt.Columns.Add("sm", typeof(string));
dt.Columns.Add("Barcode", typeof(string));
lastCellNum = 7;
for (int i = firstCellNum; i < lastCellNum; i++)
{
dt.Columns.Add(row.GetCell(i).StringCellValue, typeof(string));
}
for (int i = 1; i <= sheet.LastRowNum; i++)
{
DataRow newRow = dt.Rows.Add();
for (int j = firstCellNum; j < lastCellNum; j++)
{
newRow[j] = sheet.GetRow(i).GetCell(j).StringCellValue;
}
}
NPOI.SS.UserModel.IRow row0 = sheet.GetRow(0);
ds.Tables.Add(dt);
main_gc.DataSource = ds.Tables[0];
}
for (int i = 0; i < gridView1.RowCount; i++)
{
string LJH = gridView1.GetRowCellValue(i, "PN").ToString();
string mc = gridView1.GetRowCellValue(i, "name").ToString();
string gdh = gridView1.GetRowCellValue(i, "jobnum").ToString();
string BH = gridView1.GetRowCellValue(i, "ARef").ToString();
string cc = gridView1.GetRowCellValue(i, "size").ToString();
string dsm = gridView1.GetRowCellValue(i, "sm").ToString();
string tm = gridView1.GetRowCellValue(i, "Barcode").ToString();
Maticsoft.BLL.parts use = new Maticsoft.BLL.parts();
Maticsoft.Model.parts us = new parts()
{
PN = LJH,
//name = mc,
//jobnum = gdh,
//ARef = BH,
//size = cc,
//sm = dsm,
Barcode = tm,
};
use.Add(us);
}
DevExpress.XtraEditors.XtraMessageBox.Show("导入成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//MessageBox.Show("已成功导入");
Maticsoft.BLL.parts pr = new Maticsoft.BLL.parts();
DataSet ds2 = pr.GetAllList();
main_gc.DataSource = ds2.Tables[0];
}
: super(InputSectionPartKind.Region, position, length, line, parts) {
this.startMessage = startMessage;
this.endMessage = endMessage;
}
: super(InputSectionPartKind.Else, position, length, line, parts, skippedSection) {
}
: super(InputSectionPartKind.If, position, length, line, parts, skippedSection, expressionValue) {
}
: super(type, position, length, line, parts, skippedSection)
{
this.expressionValue = expressionValue;
}
public Quaternion GetLocalRotation(parts part)
{
return(GetLocalRotation((int)part));
}
public Vector3 GetLocalPosition(parts part)
{
return(GetLocalPosition((int)part));
}
return(AddSort(parts, sortRandom, sort));
: super(InputSectionPartKind.Else, position, length, line, parts, skippedSection)
{
}
: super(InputSectionPartKind.If, position, length, line, parts, skippedSection, expressionValue)
{
}
: super(type, position, length, line, parts, skippedSection) {
this.expressionValue = expressionValue;
}
void OnCustomize(parts part, string newImage)
{
print("ok" + newImage);
HeadAsset.sprite = Resources.Load("heads/" + newImage, typeof(Sprite)) as Sprite;
}
private void PurchaseOrder_Load(object sender, EventArgs e)
{
//get list of suppliers
var supplierlist = db.Suppliers;
var warehouselist = db.Warehouses;
var partslist = db.Parts;
Dictionary <long, string> supplier = new Dictionary <long, string>();
Dictionary <long, string> warehouses = new Dictionary <long, string>();
Dictionary <long, string> parts = new Dictionary <long, string>();
foreach (var s in supplierlist)
{
supplier.Add(s.ID, s.Name);
}
foreach (var w in warehouselist)
{
warehouses.Add(w.ID, w.Name);
}
foreach (var p in partslist)
{
parts.Add(p.ID, p.Name);
}
supplierbox.DataSource = new BindingSource(supplier, null);
supplierbox.DisplayMember = "Value";
supplierbox.ValueMember = "Key";
warehousebox.DataSource = new BindingSource(warehouses, null);
warehousebox.DisplayMember = "Value";
warehousebox.ValueMember = "Key";
partsBox.DataSource = new BindingSource(parts, null);
partsBox.DisplayMember = "Value";
partsBox.ValueMember = "Key";
if (edit == true)
{
//retrieve existing orderitems that are associated with the purchase order
using (Session4Entities db = new Session4Entities())
{
var getOrderDetails = db.Orders.Where(po => po.ID == OID).FirstOrDefault();
var getexistingOrderitems = db.OrderItems.Where(order => order.OrderID == OID);
var supplierId = getOrderDetails.SupplierID;
var destinationwarehouseid = getOrderDetails.DestinationWarehouseID;
foreach (var item in supplierbox.Items)
{
var s = ((KeyValuePair <long, string>)item).Key;
if (s == supplierId)
{
supplierbox.SelectedItem = item;
}
}
foreach (var item in warehousebox.Items)
{
var wh = ((KeyValuePair <long, string>)item).Key;
if (wh == destinationwarehouseid)
{
warehousebox.SelectedItem = item;
}
}
foreach (var item in getexistingOrderitems)
{
parts expts = new parts();
expts.partid = item.PartID;
expts.amount = item.Amount;
expts.batchnumber = item.BatchNumber;
expts.partname = item.Part.Name;
listofparts.Add(expts);
}
dateTimePicker1.Value = getOrderDetails.Date;
showParts(sender, e);
}
}
}
