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));
}