private void BindSegment() { BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null; try { this.drpSegment.Items.Clear(); provider = base.DataProvider; BenQGuru.eMES.BaseSetting.BaseModelFacade facade = new BenQGuru.eMES.BaseSetting.BaseModelFacade(provider); object[] objs = facade.GetAllSegment(); if (objs != null && objs.Length > 0) { foreach (object obj in objs) { BenQGuru.eMES.Domain.BaseSetting.Segment seg = obj as BenQGuru.eMES.Domain.BaseSetting.Segment; if (seg != null) { //this.drpSegment.Items.Add(new ListItem(seg.SegmentCode,seg.ShiftTypeCode)); this.drpSegment.Items.Add(seg.SegmentCode); } } } } finally { if (provider != null) { ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection(); } } }
protected override int GetRowCount() { BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null; try { provider = base.DataProvider; BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider); string no = this.Session["FInvRCardQP_No"].ToString(); string seq = this.Session["FInvRCardQP_Seq"].ToString(); string status = this.Session["FInvRCardQP_Status"].ToString(); string rcardfrom = this.Session["FInvRCardQP_From"].ToString(); string rcardto = this.Session["FInvRCardQP_To"].ToString(); string datefrom = this.Session["FInvRCardQP_DateFrom"].ToString(); string dateto = this.Session["FInvRCardQP_DateTo"].ToString(); if (_type == "ship") { return(facade.QueryInvShipRCardWebCount(no, seq, datefrom, dateto, rcardfrom, rcardto)); } else { return(facade.QueryInvRCardWebCount(no, seq, status, datefrom, dateto, rcardfrom, rcardto)); } } finally { if (provider != null) { BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider p = provider as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; BenQGuru.eMES.Common.PersistBroker.OLEDBPersistBroker b = p.PersistBroker as BenQGuru.eMES.Common.PersistBroker.OLEDBPersistBroker; //b.CloseConnection(); } //((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection(); } }
protected override object[] LoadDataSource(int inclusive, int exclusive) { BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null; try { provider = base.DataProvider; BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider); string no = this.Session["FInvRCardQP_No"].ToString(); string seq = this.Session["FInvRCardQP_Seq"].ToString(); string status = this.Session["FInvRCardQP_Status"].ToString(); string rcardfrom = this.Session["FInvRCardQP_From"].ToString(); string rcardto = this.Session["FInvRCardQP_To"].ToString(); string datefrom = this.Session["FInvRCardQP_DateFrom"].ToString(); string dateto = this.Session["FInvRCardQP_DateTo"].ToString(); if (_type == "ship") { return(facade.QueryInvShipRCardWeb(no, seq, datefrom, dateto, rcardfrom, rcardto, inclusive, exclusive)); } else { return(facade.QueryInvRCardWeb(no, seq, status, datefrom, dateto, rcardfrom, rcardto, inclusive, exclusive)); } } finally { //if(provider != null) // ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection(); } }
//Bind产品别下拉列表 private void BindModel(BenQGuru.eMES.Common.Domain.IDomainDataProvider provider, UserControl.UCLabelCombox cbx) { cbx.ComboBoxData.Items.Clear(); this.cbxItemCode.ComboBoxData.Items.Clear(); this.txtItemDesc.InnerTextBox.Text = string.Empty; //只列出可入库的产品别 object[] objs = new BenQGuru.eMES.Material.InventoryFacade(this.DataProvider).GetInventoryModel(); if (objs != null) { foreach (object obj in objs) { BenQGuru.eMES.Domain.MOModel.Model model = obj as BenQGuru.eMES.Domain.MOModel.Model; if (model != null) { cbx.AddItem(model.ModelCode, model.ModelCode); } } } }
private void BindShift() { BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null; try { provider = base.DataProvider; this.drpShift.Items.Clear(); if (this.drpSegment.SelectedItem != null) { BenQGuru.eMES.BaseSetting.BaseModelFacade facade = new BenQGuru.eMES.BaseSetting.BaseModelFacade(provider); BenQGuru.eMES.Domain.BaseSetting.Segment seg = facade.GetSegment(this.drpSegment.SelectedItem.ToString()) as BenQGuru.eMES.Domain.BaseSetting.Segment; if (seg != null) { //string shifttype = seg.ShiftTypeCode; //object[] objs = provider.CustomQuery(typeof(Shift), new SQLCondition(string.Format("select {0} from TBLSHIFT where shifttypecode='{1}'order by SHIFTBTIME", DomainObjectUtility.GetDomainObjectFieldsString(typeof(Shift)),shifttype))); object[] objs = (new ShiftModelFacade(base.DataProvider)).QueryShiftBySegment("", seg.SegmentCode, 0, int.MaxValue); if (objs != null && objs.Length > 0) { foreach (object obj in objs) { Shift s = obj as BenQGuru.eMES.Domain.BaseSetting.Shift; if (s != null) { this.drpShift.Items.Add(s.ShiftCode); } } } } } this.drpShift.Items.Insert(0, new ListItem("所有", string.Empty)); } finally { if (provider != null) { ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection(); } } }
//bind 料品下拉列表 private void BindItem(BenQGuru.eMES.Common.Domain.IDomainDataProvider provider, string model, UCLabelCombox cbx) { cbx.Clear(); this.txtItemDesc.InnerTextBox.Text = string.Empty; if (provider == null || model == null || model == string.Empty) { return; } BenQGuru.eMES.MOModel.ModelFacade _facade = new BenQGuru.eMES.MOModel.ModelFacade(provider); object[] objs = _facade.GetModelAllItem(model); if (objs != null) { foreach (object obj in objs) { BenQGuru.eMES.Domain.MOModel.Model2Item mo = obj as BenQGuru.eMES.Domain.MOModel.Model2Item; if (mo != null) { cbx.AddItem(mo.ItemCode, mo.ItemCode); } } } }
public int QueryFirstOnlineWebCount(BenQGuru.eMES.Common.Domain.IDomainDataProvider provider, string date, string dateto, string shift, string ss, string itemcode, string model, string seg) { string str = this.GetFirstOnlineWhere(date, dateto, shift, ss, itemcode, model, seg); return(provider.GetCount(new SQLCondition(string.Format("select count(*) c {0}", str)))); }
public object[] QueryFirstOnlineWeb(BenQGuru.eMES.Common.Domain.IDomainDataProvider provider, string date, string dateto, string shift, string ss, string itemcode, string model, string seg, int inclusive, int exclusive) { string str = this.GetFirstOnlineWhere(date, dateto, shift, ss, itemcode, model, seg); return(provider.CustomQuery(typeof(FirstOnline), new PagerCondition(string.Format("select {0} {1}", DomainObjectUtility.GetDomainObjectFieldsString(typeof(FirstOnline)), str), "MDATE,SSCODE", inclusive, exclusive))); }
private void _helper_LoadGridDataSource(object sender, EventArgs e) { PageCheckManager manager = new PageCheckManager(); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return; } BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null; try { provider = base.DataProvider; WebQueryEventArgs we = e as WebQueryEventArgs; string shift; if (drpShift.SelectedValue == null) { shift = string.Empty; } else { shift = drpShift.SelectedValue.ToString(); } if (shift == string.Empty) { string[] shiftArray = new string[drpShift.Items.Count]; for (int i = 0; i < shiftArray.Length; i++) { shiftArray[i] = drpShift.Items[i].Value; } shift = FormatHelper.ProcessQueryValues(shiftArray); } else { shift = FormatHelper.ProcessQueryValues(drpShift.SelectedValue); } object[] dataSource = QueryFirstOnlineWeb(provider, this.txtDate.Text, this.txtDateTo.Text, shift, this.txtSS.Text.Trim(), this.txtItemCode.Text.Trim(), txtModel.Text.Trim(), this.drpSegment.SelectedValue, we.StartRow, we.EndRow); we.GridDataSource = dataSource; we.RowCount = QueryFirstOnlineWebCount(provider, this.txtDate.Text, this.txtDateTo.Text, shift, this.txtSS.Text.Trim(), this.txtItemCode.Text.Trim(), txtModel.Text.Trim(), this.drpSegment.SelectedValue); } finally { if (provider != null) { ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection(); } } }
public Messages CKeyPartsCollect(XmlNode node) { string action = node.Attributes["action"].Value; string card = node["code"].InnerText; string res = node["resource"].InnerText; string usr = node["user"].InnerText; string data = node["data"].InnerText; string[] ss = data.Split(';'); string MOSplitRule = node["MOSplitRule"].InnerText; Messages productmessages = new Messages(); try { //数据准备 productmessages.AddMessages(dataCollect.GetIDInfo(card)); ProductInfo product; if (productmessages.IsSuccess()) { product = (ProductInfo)productmessages.GetData().Values[0]; } else { return(productmessages); } #region 先推途程,然后找OPBOM productmessages.AddMessages(dataCollect.CheckID(new CKeypartsActionEventArgs( ActionType.DataCollectAction_CollectKeyParts, card, usr, res, product, null))); if (productmessages.IsSuccess()) { } else { return(productmessages); } OPBomKeyparts opBomKeyparts; try { BenQGuru.eMES.Common.Domain.IDomainDataProvider _provider = _provider = BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider(); OPBOMFacade opBOMFacade = new OPBOMFacade(_provider); opBomKeyparts = new OPBomKeyparts(opBOMFacade.GetOPBOMDetails(product.NowSimulation.MOCode, product.NowSimulation.RouteCode, product.NowSimulation.OPCode), Convert.ToInt32(MOSplitRule), this.DataProvider); if (opBomKeyparts.Count == 0) { productmessages.Add(new Message("$CS_NOOPBomInfo $CS_Param_MOCode=" + product.NowSimulation.MOCode + " $CS_Param_RouteCode=" + product.NowSimulation.RouteCode + " $CS_Param_OPCode=" + product.NowSimulation.OPCode)); return(productmessages); } #endregion for (int i = 0; i < ss.Length; i++) { opBomKeyparts.AddKeyparts(ss[i].ToUpper()); } } catch (Exception e) { productmessages.Add(new Message(e)); return(productmessages); } productmessages.AddMessages(dataCollect.Action(new CKeypartsActionEventArgs(action, card, usr, res, product, opBomKeyparts))); //检查数据 if (productmessages.IsSuccess()) { DataCollectFacade df = new DataCollectFacade(); Simulation s2 = (Simulation)df.GetSimulation(card); if (s2 == null) { productmessages.Add(new Message(MessageType.Error, "天拉")); return(productmessages); } } else { return(productmessages); } return(productmessages); } catch (Exception e) { productmessages.Add(new Message(e)); return(productmessages); } }