Beispiel #1
0
        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));
        }
Beispiel #2
0
 protected override int GetUnSelectedRowCount()
 {
     if (_Facade == null)
     {
         _Facade = new FacadeFactory(base.DataProvider).CreateSPFacade();
     }
     return(this._Facade.QueryUnselectedObjectCount(_SelectQueryInfo, this.txtCodeQuery.Text, this.GetSelectedCodes()));
 }
Beispiel #3
0
 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()));
 }
Beispiel #7
0
 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()));
 }
Beispiel #8
0
 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));
 }
Beispiel #9
0
        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()));
        }
Beispiel #10
0
 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]));
 }
Beispiel #12
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));
 }
Beispiel #14
0
 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;
     //}
 }
Beispiel #15
0
        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));
        }