public FlowControll(ConfigXmlIO MyXml, logManager alogManager) { MyLogManager = alogManager; MyEquipmentManage = new EquipmentManage(alogManager); MyEquipList = new EquipmentList(); MyTestModelList = new TestModelList(); MyTestModelManage = new TestModelManage(); EquipmenNameArray = new SortedList <string, string>(); // EquipmenNameArray = GetEquipmentNameList(TestPlanId); if (MyXml.DatabaseType.ToUpper() == "LOCATIONDATABASE") { MyDataio = new LocalDatabase(MyXml.DatabasePath); } else//SqlDatabase { MyXml.DatabasePath = @"INPCSZ0518\ATS_HOME"; MyDataio = new SqlDatabase(MyXml.DatabasePath); } dtCurrentTestModelTestData = new DataTable(); dtCurrentConditionResultData = new DataTable(); dtCurrentTestModelList = new DataTable(); dtCurrentTestModeParameterlList = new DataTable(); //----------------------------------- TotalTestData = new DataTable(); DtMyConditionDataTable = new DataTable(); DtMyTestModelParameter = new DataTable(); DtMyDutInf = new DataTable(); }
public static bool OperateKnownClass(ref Transfer trans) { var pubInfo = default(PubInfo); switch (trans.Class) { case "QualityManage": pubInfo = new QualityManage(); break; case "EquipmentManage": pubInfo = new EquipmentManage(); break; default: return(false); } if (pubInfo == null) { return(false); } var HashString = trans.Attribute.ToString() + DateTime.Now.ToString("yyyyMMdd") + pubInfo.Token; var Mac = AppPKI.getMd5Hash(HashString); //if (trans.Mac == Mac) { pubInfo.Operate(ref trans); return(true); } return(false); }
public Form1() { // Control.CheckForIllegalCrossThreadCalls = false; InitializeComponent(); MyEquipmentManage = new EquipmentManage(plogManager); aEquipList = new EquipmentList(); ReadXmlInf(); if (MyXml.DataBaseUserLever == "1") { if (MessageBox.Show("Do you want to Use Location Database?", "Database Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "D:\\Patch"; openFileDialog1.Filter = "All files (*.accdb)|*.accdb|All files (*.*)|*.* "; // dlg.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.* " openFileDialog1.FilterIndex = 1; openFileDialog1.RestoreDirectory = true; MyXml.DatabaseType = "LocationDatabase"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { MyXml.DatabasePath = openFileDialog1.FileName; } pflowControl = new FlowControll(MyXml, plogManager); } else { MyXml.DatabaseType = "SqlDatabase"; pflowControl = new FlowControll(MyXml, plogManager); } } else { MyXml.DatabaseType = "SqlDatabase"; pflowControl = new FlowControll(MyXml, plogManager); } // string resultFile = ""; }
private void frmEquipmentDie_Load(object sender, EventArgs e) { EquipmentManage EquipmentManage = new EquipmentManage(); gridControl1.DataSource = EquipmentManage.GetEquipmentDataByEquipmentType("1"); }
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("保存成功!"); }
/// <summary> /// 加载设备数据 /// </summary> /// <param name="strEquipmentGuID"></param> public void EquipmentEdit(string strEquipmentGuID) { EquipmentManage EquipmentManage = new EquipmentManage(); DataTable dtl = new DataTable(); dtl = EquipmentManage.GetEquipmentDataByEquipmentGuID(strEquipmentGuID); txtEquipmentGuID.Text = strEquipmentGuID; //dtl.Rows[i]["EquipmentGuID"].ToString().Trim(); //无名称 txtEquipmentID.Text = dtl.Rows[0]["EquipmentID"].ToString().Trim(); //工装设备编号 txtEquipmentName.Text = dtl.Rows[0]["EquipmentName"].ToString().Trim(); //工装设备名称 IniEquipmentType(); switch (dtl.Rows[0]["EquipmentType"].ToString().Trim()) //工装设备分类 { case "1": cboEquipmentType.SelectedIndex = 0; tabEquipment.SelectTab(tabEquipmentDie); break; case "2": cboEquipmentType.SelectedIndex = 1; tabEquipment.SelectTab(tabEquipmentGage); break; case "3": cboEquipmentType.SelectedIndex = 2; tabEquipment.SelectTab(tabEquipmentInformation); break; case "4": cboEquipmentType.SelectedIndex = 3; tabEquipment.SelectTab(tabEquipmentOffice); break; case "5": cboEquipmentType.SelectedIndex = 4; tabEquipment.SelectTab(tabEquipmentFrock); break; } txtUsePerson.Text = dtl.Rows[0]["UsePerson"].ToString().Trim(); //使用者 if (dtl.Rows[0]["EquipmentState"].ToString().Trim() == "0") //状态:1-可用 0-停用 { chkEquipmentState.Checked = true; } else { chkEquipmentState.Checked = false; } txtSavePlace.Text = dtl.Rows[0]["SavePlace"].ToString().Trim(); //存放地点 txtRemark.Text = dtl.Rows[0]["Remark"].ToString().Trim(); //备注 DataTable dtlDetail = new DataTable(); dtlDetail = EquipmentManage.GetEquipmentDetailData(strEquipmentGuID, dtl.Rows[0]["EquipmentType"].ToString()); if (dtlDetail.Rows.Count > 0) { switch (dtl.Rows[0]["EquipmentType"].ToString().Trim()) //工装设备分类 { case "1": txtEquipmentGuID.Text = dtlDetail.Rows[0]["EquipmentGuID"].ToString().Trim(); //工装设备主表号 txtDieType.Text = dtlDetail.Rows[0]["DieType"].ToString().Trim(); //模具类别 txtProductType.Text = dtlDetail.Rows[0]["ProductType"].ToString().Trim(); //产品类别 txtLife.Text = dtlDetail.Rows[0]["Life"].ToString().Trim(); //寿命 txtEnergy.Text = dtlDetail.Rows[0]["Energy"].ToString().Trim(); //产能 txtPartName.Text = dtlDetail.Rows[0]["PartName"].ToString().Trim(); //零件名称 txtPartID.Text = dtlDetail.Rows[0]["PartID"].ToString().Trim(); //零件物料编号 txtExteriorSize.Text = dtlDetail.Rows[0]["ExteriorSize"].ToString().Trim(); //外型尺寸(mm) txtDatum.Text = dtlDetail.Rows[0]["Datum"].ToString().Trim(); //无名称 txtDieSource.Text = dtlDetail.Rows[0]["DieSource"].ToString().Trim(); //模具来源 txtAperture.Text = dtlDetail.Rows[0]["Aperture"].ToString().Trim(); //模穴 break; case "2": txtEquipmentGuID.Text = dtlDetail.Rows[0]["EquipmentGuID"].ToString().Trim(); //无名称 txtGageSpec.Text = dtlDetail.Rows[0]["GageSpec"].ToString().Trim(); //规格型号 txtLeaveFactoryID.Text = dtlDetail.Rows[0]["LeaveFactoryID"].ToString().Trim(); //出厂编号 txtScaleArea.Text = dtlDetail.Rows[0]["ScaleArea"].ToString().Trim(); //测量范围 txtScalePrecision.Text = dtlDetail.Rows[0]["ScalePrecision"].ToString().Trim(); //精度 txtManageLevel.Text = dtlDetail.Rows[0]["ManageLevel"].ToString().Trim(); //管理级别 txtCheckType.Text = dtlDetail.Rows[0]["CheckType"].ToString().Trim(); //检定方式 txtCheckCycle.Text = dtlDetail.Rows[0]["CheckCycle"].ToString().Trim(); //校准周期 txtCheckUnit.Text = dtlDetail.Rows[0]["CheckUnit"].ToString().Trim(); //校准单位 txtAppraisalRecord.Text = dtlDetail.Rows[0]["AppraisalRecord"].ToString().Trim(); //鉴定记录 break; case "3": txtEquipmentGuID.Text = dtlDetail.Rows[0]["EquipmentGuID"].ToString().Trim(); //无名称 txtEquipmentInformationSpec.Text = dtlDetail.Rows[0]["EquipmentInformationSpec"].ToString().Trim(); //设备型号规格 txtMadeManufacturer.Text = dtlDetail.Rows[0]["MadeManufacturer"].ToString().Trim(); //设备制造厂商 txtHistoryRecord.Text = dtlDetail.Rows[0]["HistoryRecord"].ToString().Trim(); //历史记录 if (DateTime.Parse(dtlDetail.Rows[0]["MadeDate"].ToString().Trim()).ToString("yyyy-MM-dd") != "1900-01-01") { deMadeDate.Text = DateTime.Parse(dtlDetail.Rows[0]["MadeDate"].ToString().Trim()).ToString("yyyy-MM-dd"); } if (DateTime.Parse(dtlDetail.Rows[0]["UseDate"].ToString().Trim()).ToString("yyyy-MM-dd") != "1900-01-01") { deUseDate.Text = DateTime.Parse(dtlDetail.Rows[0]["UseDate"].ToString().Trim()).ToString("yyyy-MM-dd"); } break; case "4": txtEquipmentGuID.Text = dtlDetail.Rows[0]["EquipmentGuID"].ToString().Trim(); //无名称 txtBrand.Text = dtlDetail.Rows[0]["Brand"].ToString().Trim(); //品牌 txtEquipmentOfficeSpec.Text = dtlDetail.Rows[0]["EquipmentOfficeSpec"].ToString().Trim(); //规格 txtDiskSize.Text = dtlDetail.Rows[0]["DiskSize"].ToString().Trim(); //硬盘大小 txtCPU.Text = dtlDetail.Rows[0]["CPU"].ToString().Trim(); //CPU txtMemory.Text = dtlDetail.Rows[0]["Memory"].ToString().Trim(); //内存 txtDisplayCar.Text = dtlDetail.Rows[0]["DisplayCar"].ToString().Trim(); //显卡 break; case "5": txtEquipmentGuID.Text = dtlDetail.Rows[0]["EquipmentGuID"].ToString().Trim(); //主表guid txtProductClass.Text = dtlDetail.Rows[0]["ProductClass"].ToString().Trim(); //产品类别 txtWorkEfficiency.Text = dtlDetail.Rows[0]["WorkEfficiency"].ToString().Trim(); //工位 txtEquipmentStuff.Text = dtlDetail.Rows[0]["EquipmentStuff"].ToString().Trim(); //材料 txtEquipmentFormal.Text = dtlDetail.Rows[0]["EquipmentFormal"].ToString().Trim(); //外形尺寸 txtFrockSource.Text = dtlDetail.Rows[0]["FrockSource"].ToString().Trim(); //工装来源 break; } } this.ShowDialog(); }
private void frmEquipmentInformationReport_Load(object sender, EventArgs e) { EquipmentManage EquipmentManage = new EquipmentManage(); gridControl1.DataSource = EquipmentManage.GetEquipmentDataByEquipmentType("3"); }