protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { // if ( this.GetRequestParam("frompage") == "FOnWipQP" ) // { // return this.facade.QueryUnSelectedMOByItemCode( // FormatHelper.PKCapitalFormat( FormatHelper.CleanString(this.txtItemCodeQuery.Text) ), // FormatHelper.PKCapitalFormat( FormatHelper.CleanString(this.txtMOCodeQuery.Text) ), // MOManufactureStatus.MOSTATUS_OPEN + "," + MOManufactureStatus.MOSTATUS_PENDING, // this.GetSelectedCodes(), // inclusive, exclusive ) ; // } if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedMO( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModelCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeQuery.Text)), this.drpFactory.SelectedValue, this.GetSelectedCodes(), this.getMOStatus(), inclusive, exclusive)); }
protected override int GetUnSelectedRowCount() { if (_Facade == null) { _Facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this._Facade.QueryUnselectedObjectCount(_SelectQueryInfo, this.txtCodeQuery.Text, this.GetSelectedCodes())); }
protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { if (_Facade == null) { _Facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this._Facade.QueryUnselectedObject(_SelectQueryInfo, this.txtCodeQuery.Text, this.GetSelectedCodes(), inclusive, exclusive)); }
protected override int GetUnSelectedRowCount() { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedErrorCode2OPReworkCount(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtErrorCodeQuery.Text)), FormatHelper.CleanString(this.txtErrorCodeDescQuery.Text), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtErrorCodeGroupQuery.Text)), FormatHelper.CleanString(this.txtErrorCodeGroupDescQuery.Text), this.GetSelectedCodes())); }
protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedErrorCode2OPRework(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtErrorCodeQuery.Text)), FormatHelper.CleanString(this.txtErrorCodeDescQuery.Text), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtErrorCodeGroupQuery.Text)), FormatHelper.CleanString(this.txtErrorCodeGroupDescQuery.Text), this.GetSelectedCodes(), inclusive, exclusive)); }
protected override object[] LoadSelectedDataSource(int inclusive, int exclusive) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QuerySelectedErrorCode2OPRework(this.GetSelectedCodes())); }
protected override int GetUnSelectedRowCount() { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedErrorCodeCount(this.drpModelEdit.SelectedValue, this.drpErrorCodeGroupEdit.SelectedValue, string.Empty, this.GetSelectedCodes())); }
protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedErrorCode(this.drpModelEdit.SelectedValue, this.drpErrorCodeGroupEdit.SelectedValue, string.Empty, this.GetSelectedCodes(), inclusive, exclusive)); }
protected override int GetUnSelectedRowCount() { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedSymptomCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModelCodeQuery.Text)), this.GetSelectedCodes())); }
protected override int GetUnSelectedRowCount() { //string strugc = checkuser(); //if (strugc != "") //{ // return this.DataProvider.GetCount(new SQLCondition(string.Format("select count(*) from USERGROUP2ITEM where USERGROUPCODE ='{0}'", strugc))); //} if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedItemCount(this.txtModelCodeQuery.Text, this.txtItemCodeQuery.Text, this.txtItemNameQuery.Text, this.txtItemDescQuery.Text, this.GetSelectedCodes())); }
protected override int GetUnSelectedRowCount() { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedReworkMOCount( this.ReworkCode, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModelCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeQuery.Text)), this.drpFactory.SelectedValue, new string[0])); }
protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedReworkSheet( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModelCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtReworkSheetQuery.Text)), this.GetSelectedCodes(), inclusive, exclusive)); }
protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedReworkMO( this.ReworkCode, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModelCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeQuery.Text)), this.drpFactory.SelectedValue, new string[0], inclusive, exclusive, MOType.MOTYPE_RMAREWORKMOTYPE)); }
protected override object[] LoadSelectedDataSource(int inclusive, int exclusive) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QuerySelectedItem(this.GetSelectedCodes())); //string strugc = checkuser(); //if (strugc != "") //{ // object[] obj = this.DataProvider.CustomQuery(typeof(ItemForQuery), new SQLCondition(string.Format( // "select {0} from tblitem,tblmodel2item where 1=1 and tblitem.itemcode = tblmodel2item.itemcode " + GlobalVariables.CurrentOrganizations.GetSQLCondition() + " and itemcode in ({1}) and itemcode in (select itemcode from usergroup2item where usergroupcode = '{2}') order by itemcode", // DomainObjectUtility.GetDomainObjectFieldsString(typeof(ItemForQuery)), // ("'" + string.Join("','", this.GetSelectedCodes()) + "'").ToUpper(), // strugc.ToUpper() // ))); // return obj; //} }
protected override object[] LoadUnSelectedDataSource(int inclusive, int exclusive) { //string strugc = checkuser(); //if (strugc != "") //{ // //object[] obj = this.DataProvider.CustomQuery(typeof(ItemForQuery), new SQLCondition(string.Format( // // "select {0} from tblitem,tblmodel2item where 1=1 and tblitem.itemcode = tblmodel2item.itemcode " + GlobalVariables.CurrentOrganizations.GetSQLCondition() + " and itemcode like '{2}%' and itemname like '%{3}%' and itemdesc like '%{4}%' and itemcode in (select itemcode from usergroup2item where usergroupcode = '{1}') ", // // DomainObjectUtility.GetDomainObjectFieldsString(typeof(ItemForQuery)), // // strugc.ToUpper(), // // this.txtItemCodeQuery.Text.ToUpper(), // // this.txtItemNameQuery.Text, // // this.txtItemDescQuery.Text // // ))); // object[] obj = this.facade.QueryUnSelectedItem(this.txtItemCodeQuery.Text, this.txtModelCodeQuery.Text, this.txtItemNameQuery.Text, this.txtItemDescQuery.Text, strugc); // return obj; //} if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateSPFacade(); } return(this.facade.QueryUnSelectedItem(this.txtModelCodeQuery.Text, this.txtItemCodeQuery.Text, this.txtItemNameQuery.Text, this.txtItemDescQuery.Text, this.GetSelectedCodes(), inclusive, exclusive)); }