public void TestSMTCopy() { persistBroker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo"); // clear data // insert info of MO UT_MOCODE1 string sql = "INSERT INTO TBLSMTRESBOM (MOCODE,ROUTECODE,OPCODE,RESCODE,STATIONCODE,ITEMCODE,OPBOMCODE,OPBOMVER,LOTNO,PCBA,BIOS,VERSION,VENDERITEMCODE,VENDORCODE,DATECODE,FEEDERCODE,MUSER,MDATE,MTIME,EATTRIBUTE1,OBITEMCODE) VALUES ('UT_MOCODE1','UT_ROUTECODE1','UT_OPERATIONCODE1','UT_RESOURCE1','{0}','UT_ITEMCODE1','UT_ROUTECODE1','OPBOMVER1','LOTNO','PCBA','BIOS','VERSION','VENDERITEMCODE','VENDORCODE','DATECODE','FEEDER1','vizo UnitTest',20050509,0,NULL,'P007-10594-03')"; persistBroker.Execute(string.Format(sql, "UT_STATION1")); persistBroker.Execute(string.Format(sql, "UT_STATION2")); persistBroker.Execute(string.Format(sql, "UT_STATION3")); // copy from UT_MOCODE1 to UT_MOCODE2 BenQGuru.eMES.SMT.SMTFacade facade = new BenQGuru.eMES.SMT.SMTFacade(); facade.CopySMTResourceBOM("UT_MOCODE1", "UT_MOCODE2", "UT_ROUTECODE1", "UT_OPERATIONCODE1", "UT_RESOURCE1"); // check smtbom count of UT_MOCODE2 int cnt1 = facade.QuerySMTResourceBOMCount(string.Empty, "UT_MOCODE1", string.Empty, string.Empty, string.Empty, string.Empty); int cnt2 = facade.QuerySMTResourceBOMCount(string.Empty, "UT_MOCODE2", string.Empty, string.Empty, string.Empty, string.Empty); // clear data sql = "delete from tblsmtresbom where mocode like 'UT_%'"; persistBroker.Execute(sql); Console.WriteLine("cnt1={0} , cnt2={1}", cnt1, cnt2); Assert.AreEqual(cnt1, cnt2); Assert.AreEqual(3, cnt1); }
protected void Page_Load(object sender, System.EventArgs e) { this.txtMaxCountEdit.Attributes.Add("onkeyup", "CalAlertCount()"); if (!this.IsPostBack) { // 初始化页面语言 this.InitPageLanguage(this.languageComponent1, false); if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } object[] objSpec = _facade.GetAllFeederSpec(); if (objSpec != null) { this.ddlFeederSpecCodeQuery.Items.Add(string.Empty); for (int i = 0; i < objSpec.Length; i++) { FeederSpec spec = (FeederSpec)objSpec[i]; this.ddlFeederSpecCodeQuery.Items.Add(new ListItem(spec.FeederSpecCode, spec.FeederSpecCode)); this.ddlFeederSpecCodeEdit.Items.Add(new ListItem(spec.FeederSpecCode, spec.FeederSpecCode)); } } SystemParameterListBuilder _builder = new SystemParameterListBuilder("FEEDERTYPE", base.DataProvider); //_builder.Build(this.ddlFeederTypeEdit); this.ddlFeederTypeEdit.Items.Add(new ListItem("CP", "CP")); _builder = new SystemParameterListBuilder("FEEDERSTATUS", base.DataProvider); _builder.Build(this.ddlStatusQuery); _builder.AddAllItem(this.languageComponent1); } }
protected override object GetEditObject() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } Reel reel = this._facade.CreateNewReel(); reel.ReelNo = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtReelNoEdit.Text, 40)); Reel reelTmp = (Reel)_facade.GetReel(reel.ReelNo); if (reelTmp != null) { reel = reelTmp; } reel.PartNo = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtPartNoEdit.Text, 40)); reel.Qty = Convert.ToDecimal(this.txtQtyEdit.Text); reel.LotNo = this.txtLotNoEdit.Text.Trim().ToUpper(); reel.DateCode = this.txtDateCodeEdit.Text.Trim().ToUpper(); reel.MaintainUser = this.GetUserCode(); reel.MaintainDate = FormatHelper.TODateInt(DateTime.Today); reel.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now); return(reel); }
protected override void AddDomainObject(object domainObject) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } this._facade.AddReel((Reel)domainObject); }
protected override void UpdateDomainObject(object domainObject) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } this._facade.UpdateSMTSensorQtyDifferenceReason(this.txtMOCode.Text, this.txtShiftDay.Text, this.txtTPCode.Text, this.txtDiffReason.Text, this.GetUserCode()); }
protected override void DeleteDomainObjects(ArrayList domainObjects) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } this._facade.DeleteFeeder((Feeder[])domainObjects.ToArray(typeof(Feeder))); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(_facade.CheckSMTMaterial(this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtSSCodeQuery.Text.Trim().ToUpper(), this.GetUserCode(), false)); }
protected override void UpdateDomainObject(object domainObject) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } this._facade.UpdateFeeder((Feeder)domainObject); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryFeederSpecCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFeederSpecCodeQuery.Text)))); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTFeederMaterialImportLogDetailCount( this.GetRequestParam("logno"))); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryReelValidityCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMaterialPrefixQuery.Text)))); }
protected void cmdSave_ServerClick(object sender, EventArgs e) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } this._facade.UpdateSMTTargetQty(this.drpSegmentCode.SelectedValue, this.drpSSCode.SelectedValue, this.txtMOCode.Text.Trim().ToUpper(), decimal.Parse(this.txtQtyPerHour.Text), this.GetUserCode()); this.cmdQuery_Click(null, null); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTFeederMaterialImportLogDetail( this.GetRequestParam("logno"), inclusive, exclusive)); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryStationCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtStationCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.drpResourceCodeQuery.SelectedValue)))); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTRCardMaterialDetailCount( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtRCardQuery.Text.Trim().ToUpper())); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryFeederSpec( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFeederSpecCodeQuery.Text)), inclusive, exclusive)); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryRptMOTimePeriodActualQtyCount( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtTPCodeQuery.Text.Trim().ToUpper())); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryStation( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtStationCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.drpResourceCodeQuery.SelectedValue)), inclusive, exclusive)); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTMachineDiscardCount( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtSSCodeQuery.Text.Trim().ToUpper() )); }
//protected override void cmdQuery_Click(object sender, EventArgs e) //{ // base.cmdQuery_Click(sender, e); // foreach (GridRecord row in this.gridWebGrid.Rows) // { // if (qty.ActualQty < qty.CurrentQty && qty.MaintainDate == 0) // { // DateTime dtEnd = Convert.ToDateTime(FormatHelper.ToDateString(qty.Day) + " " + FormatHelper.ToTimeString(qty.TPEndTime)); // if (dtEnd < DateTime.Now) // { // row.CssClass = "ForeColorRed"; // } // } // } // //base.cmdQuery_Click(sender, e); //} protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryRptMOTimePeriodActualQty( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtTPCodeQuery.Text.Trim().ToUpper(), inclusive, exclusive)); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTRCardMaterialDetail( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtRCardQuery.Text.Trim().ToUpper(), inclusive, exclusive)); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryMOMaterialRptCount( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtLineCodeQuery.Text.Trim().ToUpper(), this.txtMaterialCodeQuery.Text.Trim().ToUpper(), this.txtMachineStationCodeQuery.Text.Trim().ToUpper())); }
protected override void UpdateDomainObject(object domainObject) { if (FormatHelper.StringToBoolean(((Reel)domainObject).UsedFlag) == true) { throw new Exception("$SMT_Prepare_Reel_Used_Already"); } if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } this._facade.UpdateReel((Reel)domainObject); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTFeederMaterialImportLogCount( this.txtItemCodeQuery.Text.Trim().ToUpper(), this.txtSSCodeQuery.Text.Trim().ToUpper(), this.txtImportUserQuery.Text.Trim().ToUpper(), FormatHelper.TODateInt(this.txtImportDate.Text).ToString())); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryFeederStatusLogCount( this.txtConditionItem.Text.Trim().ToUpper(), this.txtConditionMo.Text.Trim().ToUpper(), this.txtSSCode.Text.Trim().ToUpper(), this.txtFeederSpecCode.Text.Trim().ToUpper(), this.txtFeederCode.Text.Trim().ToUpper())); }
protected override int GetRowCount() { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTFeederMaterialCount( this.txtItemCodeQuery.Text.Trim().ToUpper(), this.txtSSCodeQuery.Text.Trim().ToUpper(), this.txtMachineCodeQuery.Text.Trim().ToUpper(), string.Empty, string.Empty)); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTFeederMaterialImportLog( this.txtItemCodeQuery.Text.Trim().ToUpper(), this.txtSSCodeQuery.Text.Trim().ToUpper(), this.txtImportUserQuery.Text.Trim().ToUpper(), FormatHelper.TODateInt(this.txtImportDate.Text).ToString(), inclusive, exclusive)); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QueryMOMaterialRpt( this.txtMOCodeQuery.Text.Trim().ToUpper(), this.txtLineCodeQuery.Text.Trim().ToUpper(), this.txtMaterialCodeQuery.Text.Trim().ToUpper(), this.txtMachineStationCodeQuery.Text.Trim().ToUpper(), inclusive, exclusive)); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { if (_facade == null) { _facade = new SMTFacadeFactory(base.DataProvider).Create(); } return(this._facade.QuerySMTFeederMaterial( this.txtItemCodeQuery.Text.Trim().ToUpper(), this.txtSSCodeQuery.Text.Trim().ToUpper(), this.txtMachineCodeQuery.Text.Trim().ToUpper(), string.Empty, string.Empty, inclusive, exclusive)); }
protected void cmdImport_ServerClick(object sender, System.EventArgs e) { if (_facade == null) { _facade = new SMTFacade(base.DataProvider); } if (items == null) { items = GetAllItem(); if (items == null || items.Length == 0) { return; } } string strMessage = ""; ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection(); this.DataProvider.BeginTransaction(); try { int iRet = this._facade.ImportSMTMachineDiscard(items, this.GetUserCode()); this.DataProvider.CommitTransaction(); if (iRet > 0) { strMessage = languageComponent1.GetString("$SMTMachineDiscard_Import_Success"); this.cmdEnter.Disabled = true; } else { strMessage = languageComponent1.GetString("$SMTMachineDiscard_Import_Error"); } } catch (Exception ex) { this.DataProvider.RollbackTransaction(); throw ex; } finally { ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection(); } string alertInfo = string.Format("<script language=javascript>alert('{0}');</script>", strMessage); if (!this.IsClientScriptBlockRegistered("ImportAlert")) { this.RegisterClientScriptBlock("ImportAlert", alertInfo); } items = null; }