public static DataTable GetPartTable(string optrType)
{
var dt = EquipmentInformation.Find(CK.K["OptrType"] == optrType && CK.K["Condition"] == "生产").ToDataTable();
dt.Columns[1].ColumnName = "设备分类";
dt.Columns[2].ColumnName = "机台号";
dt.Columns[3].ColumnName = "设备型号";
dt.Columns[4].ColumnName = "适应产品";
dt.Columns[5].ColumnName = "单位产量";
dt.Columns[6].ColumnName = "班产定额";
dt.Columns[7].ColumnName = "使用状态";
dt.Columns[8].ColumnName = "管理分组";
dt.Columns[9].ColumnName = "设备分级";
dt.Columns[10].ColumnName = "测试站";
dt.Columns[11].ColumnName = "通道数";
dt.Columns[12].ColumnName = "制造厂家";
dt.Columns[13].ColumnName = "制造时间";
dt.Columns[14].ColumnName = "进厂时间";
dt.Columns[15].ColumnName = "生产适应性";
dt.Columns[16].ColumnName = "统计分类";
dt.Columns[17].ColumnName = "工序";
dt.Columns[18].ColumnName = "模具号";
dt.Columns[19].ColumnName = "备注";
dt.Columns[20].ColumnName = "操作类型";
return(dt);
}
/// <summary>
/// 创建物品到背包
/// </summary>
/// <param name="str">物品ID</param>
/// <param name="nabo">物品（消耗品）数量，装备为0</param>
public void NewReadInventoryItemInfo(int str, int nabo)
{
Equipment equipment = new Equipment(); //创建背包上的物品
EquipmentInformation equipmentInformation = GetEquipmentInformationDictionary(str); //获取物品类型信息
equipment.equipmentInformation = equipmentInformation;
//判断是不是消耗品
if (equipmentInformation.EquipmentType == EquipmentType.consumables) //EquipmentType.consumables && equipmentInformation.IdInt == equipmentPlayerInfoDictionary[str].equipmentInformation.IdInt
{
equipment.NumberInt = nabo; //消耗品数量
//foreach (Equipment equ in equipmentPlayerInfoDictionary)
//{
// if (str == equ.equipmentInformation.IdInt)
// {
// equipmentPlayerInfoDictionary[str].Number += 1;//如果存在消耗品就增加数量
// return;
// }
//}
equipmentPlayerInfoDictionary.Add(equipment);//不然就增加物品
}
else
{
equipmentPlayerInfoDictionary.Add(equipment);//不然就增加物品
}
//Debug.Log(equipmentPlayerInfoDictionary[0].equipmentInformation.IdInt);
//Debug.Log(equipmentPlayerInfoDictionary[0].equipmentInformation.IdInt);
backpackText.text = equipmentPlayerInfoDictionary.Count + "/20";
}
/// <summary>
/// 把字符串解析成物品类型
/// </summary>
/// <param name="o"></param>
/// <returns>物品类型</returns>
private EquipmentInformation NewInvnentory(string o)
{
//ID 名称 图标 类型（Equip，Drug） 装备类型(Helm,Cloth,Weapon,Shoes,Necklace,Bracelet,Ring,Wing) 售价 星级 品质 伤害 生命 战斗力 作用类型 作用值 描述
EquipmentInformation equipmentInformation = new EquipmentInformation();//[itemStrArray.Length];
string[] proArray = o.Split('|');
equipmentInformation.IdInt = int.Parse(proArray[0]); //Convert.ToInt32(proArray[0]);
equipmentInformation.NameString = proArray[1];
equipmentInformation.IconString = proArray[2];
equipmentInformation.EquipmentType = Equipment(proArray[3]);
equipmentInformation.EquipType = Equip(proArray[4]);
equipmentInformation.PriceInt = int.Parse(proArray[5]);//售价
//星级 品质 伤害 生命 战斗力
if (EquipmentType.equipment == equipmentInformation.EquipmentType)
{
equipmentInformation.StarInt = int.Parse(proArray[6]);
equipmentInformation.QualityInt = int.Parse(proArray[7]);
equipmentInformation.DamageInt = int.Parse(proArray[8]);
equipmentInformation.HpInt = int.Parse(proArray[9]);
equipmentInformation.EffectivenessInt = int.Parse(proArray[10]);
}
//作用类型 作用值 描述
equipmentInformation.InfoType = Inventory(proArray[11]);
equipmentInformation.ApplyValue = int.Parse(proArray[12]);
equipmentInformation.DescribeString = proArray[13];
//equipmentInformationDictionary.Add(int.Parse(proArray[0]), equipmentInformation);
return(equipmentInformation);
}
protected override void Saving()
{
if (IsAdd)
{
var obj = EquipmentInformation.New;
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.OptrType = UserStatics.OptrType;
if (UserStatics.OptrType == "Test")
{
obj.Process = "测试";
}
obj.Save();
}
else
{
var obj = EquipmentInformation.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.OptrType = UserStatics.OptrType;
if (UserStatics.OptrType == "Test")
{
obj.Process = "测试";
}
obj.Save();
}
}
private void ctEquipmentNo_SelectedValueChanged(object sender, EventArgs e)
{
if (UserStatics.OptrType == "Package" || UserStatics.OptrType == "Assembly")
{
EquipmentInformation ei = (EquipmentInformation)ctEquipmentNo.SelectedItem;
if (ei.ModeNo != null)
{
ctModeNo.Text = ei.ModeNo.ToString();
}
}
}
public static List <EquipmentInformation> GetEquipmentType(string optrType, string equipmentType)
{
EquipmentInformation md = EquipmentInformation.New;
md.Id = 0;
md.EquipmentNo = "";
List <EquipmentInformation> equipmentInformations = EquipmentInformation.Find(CK.K["OptrType"] == optrType && CK.K["EquipmentType"] == equipmentType && CK.K["Condition"] == "生产");
equipmentInformations.Insert(0, md);
return(equipmentInformations);
}
public static List <EquipmentInformation> GetEquipmentNoByProcess(string optrType, string process)
{
EquipmentInformation md = EquipmentInformation.New;
md.Id = 0;
md.EquipmentNo = "";
List <EquipmentInformation> equipmentInformations = EquipmentInformation.Find(CK.K["OptrType"] == optrType && CK.K["Process"] == process && CK.K["Condition"] == "生产" && CK.K["EquipmentType"] != "测试仪" && CK.K["EquipmentType"] != "测试系统");
equipmentInformations.Insert(0, md);
return(equipmentInformations);
}
public static List <EquipmentInformation> GetEquipmentNo(string optrType)
{
EquipmentInformation md = EquipmentInformation.New;
md.Id = 0;
md.EquipmentNo = "";
List <EquipmentInformation> equipmentInformations = EquipmentInformation.Find(CK.K["OptrType"] == optrType && CK.K["Condition"] == "生产" && (CK.K["EquipmentType"] == "机械手" || CK.K["EquipmentType"] == "打印机" || CK.K["EquipmentType"] == "编带机" || CK.K["EquipmentType"] == "成型机"));
equipmentInformations.Insert(0, md);
return(equipmentInformations);
}
private void ctEquipmentNo_Click(object sender, EventArgs e)
{
FrmEquipmentInformation fei = new FrmEquipmentInformation();;
fei.IsSelect = true;
fei.ShowDialog();
//返回的SelectedValue,取出SelectedValue的EquipmentInformation
EquipmentInformation ei = EquipmentInformation.FindById(fei.SelectedValue);
//绑定各个控件
FrmAddEditBindComboBoxText.BindObjectToControls(ei, tabPage1);
fei.Dispose();
}
private void RaiseSearchWindow()
{
FrmEquipmentInformation fei = new FrmEquipmentInformation();;
fei.IsSelect = true;
fei.ShowDialog();
//返回的SelectedValue,取出SelectedValue的EquipmentInformation
EquipmentInformation ei = EquipmentInformation.FindById(fei.SelectedValue);
//绑定各个控件
FrmAddEditBindComboBoxText.BindObjectToControls(ei, tabPage1);
fei.Dispose();
}
protected override void Loading()
{
if (UserStatics.OptrType != "Package")
{
ctModeNo.Enabled = false;
}
if (UserStatics.OptrType == "Package" || UserStatics.OptrType == "Assembly")
{
ctTestStation.Enabled = false;
ctChannelCount.Enabled = false;
}
if (UserStatics.OptrType == "Test")
{
ctProcess.Enabled = false;
}
ctEquipmentType.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "设备分类");
ctEquipmentType.DisplayMember = "Name";
ctProductAdaptation.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "适应产品");
ctProductAdaptation.DisplayMember = "Name";
ctCondition.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "使用状态");
ctCondition.DisplayMember = "Name";
ctManagementGroup.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "管理分组");
ctManagementGroup.DisplayMember = "Name";
ctProcess.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "工序");
ctProcess.DisplayMember = "Name";
ctDeviceClass.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "设备分级");
ctDeviceClass.DisplayMember = "Name";
ctStatisticalClass.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "统计分类");
ctStatisticalClass.DisplayMember = "Name";
ctManufacturer.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "制造厂家");
ctManufacturer.DisplayMember = "Name";
if (!IsAdd)
{
var obj = EquipmentInformation.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1);
}
}
private void RaiseSearchWindow()
{
FrmEquipmentInformation fei = new FrmEquipmentInformation();;
fei.IsSelect = true;
fei.SelectedValue = -1;
fei.ShowDialog();
if (fei.SelectedValue != -1)
{
//返回的SelectedValue,取出SelectedValue的EquipmentInformation
EquipmentInformation ei = EquipmentInformation.FindById(fei.SelectedValue);
ctEquipmentNo.Text = ei.EquipmentNo;
}
else
{
ctEquipmentNo.Text = "";
}
fei.Dispose();
}
public static List <string> GetEquipmentTypeString(string optrType, string equipmentType)
{
EquipmentInformation md = EquipmentInformation.New;
md.Id = 0;
md.EquipmentNo = "";
List <EquipmentInformation> equipmentInformations = EquipmentInformation.Find(CK.K["OptrType"] == optrType && CK.K["EquipmentType"] == equipmentType && CK.K["Condition"] == "生产");
equipmentInformations.Insert(0, md);
List <string> s = null;
foreach (var equipmentInformation in equipmentInformations)
{
s.Add(equipmentInformation.EquipmentNo);
}
return(s);
}
/// <summary>
/// 获取物品类型表
/// </summary>
private void ReadInventoryInfo()
{
string str = inventoryTxt.ToString();
string[] itemStrArray = str.Split('\n');
//ID 名称 图标 类型（Equip，Drug） 装备类型(Helm,Cloth,Weapon,Shoes,Necklace,Bracelet,Ring,Wing) 售价 星级 品质 伤害 生命 战斗力 作用类型 作用值 描述
foreach (string item in itemStrArray)
{
EquipmentInformation equipmentInformation = NewInvnentory(item);
equipmentInformationDictionary.Add(equipmentInformation.IdInt, equipmentInformation);
}
//EquipmentInformation equipmentInformation = new EquipmentInformation();//[itemStrArray.Length];
//foreach (string o in itemStrArray)
//{
// string[] proArray = o.Split('|');
// equipmentInformation.IdInt = int.Parse(proArray[0]);
// equipmentInformation.NameString = proArray[1];
// equipmentInformation.IconString = proArray[2];
// equipmentInformation.EquipmentType = Equipment(proArray[3]);
// equipmentInformation.EquipType = Equip(proArray[4]);
// equipmentInformation.PriceInt = int.Parse(proArray[5]);//售价
// //星级 品质 伤害 生命 战斗力
// if (EquipmentType.equipment == equipmentInformation.EquipmentType)
// {
// equipmentInformation.StarInt = int.Parse(proArray[6]);
// equipmentInformation.QualityInt = int.Parse(proArray[7]);
// equipmentInformation.DamageInt = int.Parse(proArray[8]);
// equipmentInformation.HpInt = int.Parse(proArray[9]);
// equipmentInformation.EffectivenessInt = int.Parse(proArray[10]);
// }
// //作用类型 作用值 描述
// equipmentInformation.InfoType = Inventory(proArray[11]);
// equipmentInformation.ApplyValue = int.Parse(proArray[12]);
// equipmentInformation.DescribeString = proArray[13];
// equipmentInformationDictionary.Add(equipmentInformation.IdInt, equipmentInformation);
//}
}
public static void DelCell(long id)
{
EquipmentInformation.DeleteAll(CK.K["Id"] == id);
}
/// <summary>
/// 通过“索引”获取物品类型
/// </summary>
/// <param name="id">索引</param>
/// <returns>物品类型</returns>
private EquipmentInformation GetEquipmentInformationDictionary(int id)
{
EquipmentInformation equipmentInformation = equipmentInformationDictionary[id];
return(equipmentInformation);
}
private void btnSave_Click(object sender, EventArgs e)
{
EquipmentManage EquipmentManage = new EquipmentManage();
if (txtEquipmentID.Text.Trim() == "")
{
this.ShowAlertMessage("请输入编号!");
txtEquipmentID.Focus();
return;
}
if (EquipmentManage.IsExistEquipementID(txtEquipmentGuID.Text.Trim().Replace("'", "''").Trim(), txtEquipmentID.Text.Trim().Replace("'", "''").Trim()) == true)
{
this.ShowAlertMessage("编号已经存在，请重新输入!");
txtEquipmentID.Focus();
return;
}
if (txtEquipmentName.Text.Trim() == "")
{
this.ShowAlertMessage("请输入名称!");
txtEquipmentName.Focus();
return;
}
if (cboEquipmentType.Text.Trim() == "")
{
this.ShowAlertMessage("请选择分类!");
cboEquipmentType.Focus();
return;
}
if (txtSavePlace.Text.Trim() == "")
{
this.ShowAlertMessage("请输入存放地点!");
txtSavePlace.Focus();
return;
}
Equipment Equipment = new Equipment();
EquipmentDie EquipmentDie = new EquipmentDie();
EquipmentGage EquipmentGage = new EquipmentGage();
EquipmentFrock EquipmentFrock = new EquipmentFrock();
EquipmentInformation EquipmentInformation = new EquipmentInformation();
EquipmentOffice EquipmentOffice = new EquipmentOffice();
//保存主表
Equipment.EquipmentGuID = txtEquipmentGuID.Text.Trim().Replace("'", "''");
Equipment.EquipmentID = txtEquipmentID.Text.Trim().Replace("'", "''");
Equipment.EquipmentName = txtEquipmentName.Text.Trim().Replace("'", "''");
Equipment.EquipmentType = ((ListItem)cboEquipmentType.SelectedItem).Value;
Equipment.UsePerson = txtUsePerson.Text.Trim().Replace("'", "''");
if (chkEquipmentState.Checked == true)
{
Equipment.EquipmentState = "0"; //状态：1-可用 0-停用
}
else
{
Equipment.EquipmentState = "1";
}
Equipment.SavePlace = txtSavePlace.Text.Trim().Replace("'", "''");
Equipment.Remark = txtRemark.Text.Trim().Replace("'", "''");
//保存明细
switch (cboEquipmentType.SelectedIndex)
{
case 0: //tabEquipmentDie
EquipmentDie.DieGuID = Guid.NewGuid().ToString();
EquipmentDie.EquipmentGuID = txtEquipmentGuID.Text.Trim().Replace("'", "''");
EquipmentDie.DieType = txtDieType.Text.Trim().Replace("'", "''");
EquipmentDie.ProductType = txtProductType.Text.Trim().Replace("'", "''");
EquipmentDie.Life = txtLife.Text.Trim().Replace("'", "''");
EquipmentDie.Energy = txtEnergy.Text.Trim().Replace("'", "''");
EquipmentDie.PartName = txtPartName.Text.Trim().Replace("'", "''");
EquipmentDie.PartID = txtPartID.Text.Trim().Replace("'", "''");
EquipmentDie.ExteriorSize = txtExteriorSize.Text.Trim().Replace("'", "''");
EquipmentDie.Datum = txtDatum.Text.Trim().Replace("'", "''");
EquipmentDie.DieSource = txtDieSource.Text.Trim().Replace("'", "''");
EquipmentDie.Aperture = txtAperture.Text.Trim().Replace("'", "''");
break;
case 1: //tabEquipmentGage
EquipmentGage.GageGuID = Guid.NewGuid().ToString();
EquipmentGage.EquipmentGuID = txtEquipmentGuID.Text.Trim().Replace("'", "''"); //无名称
EquipmentGage.GageSpec = txtGageSpec.Text.Trim().Replace("'", "''"); //规格型号
EquipmentGage.LeaveFactoryID = txtLeaveFactoryID.Text.Trim().Replace("'", "''"); //出厂编号
EquipmentGage.ScaleArea = txtScaleArea.Text.Trim().Replace("'", "''"); //测量范围
EquipmentGage.ScalePrecision = txtScalePrecision.Text.Trim().Replace("'", "''"); //精度
EquipmentGage.ManageLevel = txtManageLevel.Text.Trim().Replace("'", "''"); //管理级别
EquipmentGage.CheckType = txtCheckType.Text.Trim().Replace("'", "''"); //检定方式
EquipmentGage.CheckCycle = txtCheckCycle.Text.Trim().Replace("'", "''"); //校准周期
EquipmentGage.CheckUnit = txtCheckUnit.Text.Trim().Replace("'", "''"); //校准单位
EquipmentGage.AppraisalRecord = txtAppraisalRecord.Text.Trim().Replace("'", "''"); //鉴定记录
break;
case 2: //tabEquipmentInformation
EquipmentInformation.EquipmentInformationGuID = Guid.NewGuid().ToString();
EquipmentInformation.EquipmentGuID = txtEquipmentGuID.Text.Trim().Replace("'", "''"); //无名称
EquipmentInformation.EquipmentInformationSpec = txtEquipmentInformationSpec.Text.Trim().Replace("'", "''"); //设备型号规格
EquipmentInformation.MadeManufacturer = txtMadeManufacturer.Text.Trim().Replace("'", "''"); //设备制造厂商
if (deMadeDate.Text.Trim() == "")
{
EquipmentInformation.MadeDate = DateTime.Parse("1900-01-01");
}
else
{
EquipmentInformation.MadeDate = DateTime.Parse(deMadeDate.Text);
}
if (deUseDate.Text.Trim() == "")
{
EquipmentInformation.UseDate = DateTime.Parse("1900-01-01");
}
else
{
EquipmentInformation.UseDate = DateTime.Parse(deUseDate.Text);
}
EquipmentInformation.HistoryRecord = txtHistoryRecord.Text.Trim().Replace("'", "''"); //历史记录
break;
case 3: //tabEquipmentOffice
EquipmentOffice.EquipmentOfficeGuID = Guid.NewGuid().ToString();
EquipmentOffice.EquipmentGuID = txtEquipmentGuID.Text.Trim().Replace("'", "''"); //无名称
EquipmentOffice.Brand = txtBrand.Text.Trim().Replace("'", "''"); //品牌
EquipmentOffice.EquipmentOfficeSpec = txtEquipmentOfficeSpec.Text.Trim().Replace("'", "''"); //规格
EquipmentOffice.DiskSize = txtDiskSize.Text.Trim().Replace("'", "''"); //硬盘大小
EquipmentOffice.CPU = txtCPU.Text.Trim().Replace("'", "''"); //CPU
EquipmentOffice.Memory = txtMemory.Text.Trim().Replace("'", "''"); //内存
EquipmentOffice.DisplayCar = txtDisplayCar.Text.Trim().Replace("'", "''"); //显卡
break;
case 4: //tabEquipmentFrock
EquipmentFrock.EquipmentFrockGuID = Guid.NewGuid().ToString();
EquipmentFrock.EquipmentGuID = txtEquipmentGuID.Text.Trim().Replace("'", "''"); //主表guid
EquipmentFrock.ProductClass = txtProductClass.Text.Trim().Replace("'", "''"); //产品类别
EquipmentFrock.WorkEfficiency = txtWorkEfficiency.Text.Trim().Replace("'", "''"); //工位
EquipmentFrock.EquipmentStuff = txtEquipmentStuff.Text.Trim().Replace("'", "''"); //材料
EquipmentFrock.EquipmentFormal = txtEquipmentFormal.Text.Trim().Replace("'", "''"); //外形尺寸
EquipmentFrock.FrockSource = txtFrockSource.Text.Trim().Replace("'", "''"); //工装来源
break;
}
EquipmentManage.SaveBill(Equipment, EquipmentDie, EquipmentFrock, EquipmentGage, EquipmentOffice, EquipmentInformation);
//刷新父窗口
frmEquipment.frmequipment.LoadEquipmentTypeData();
this.ShowMessage("保存成功！");
}
