protected override int GetRowCount2()
{
if (_TSfacade == null)
{
_TSfacade = new QueryTSDetailsFacade(base.DataProvider);
}
return(this._TSfacade.QueryTSDetailsCount(
FormatHelper.CleanString(this.txtMO.Value).ToUpper(),
FormatHelper.CleanString(this.txtSN.Value).ToUpper(),
int.Parse(this.txtSeq.Value)
));
}
protected override object[] LoadDataSource2(int inclusive, int exclusive)
{
if (_TSfacade == null)
{
_TSfacade = new QueryTSDetailsFacade(base.DataProvider);
}
return(this._TSfacade.QueryTSDetails(
FormatHelper.CleanString(this.txtMO.Value).ToUpper(),
FormatHelper.CleanString(this.txtSN.Value).ToUpper(),
int.Parse(this.txtSeq.Value),
1, int.MaxValue));
}
protected override object[] LoadDataSource2(int inclusive, int exclusive)
{
int seq;
try
{
seq = int.Parse(this.txtSeq.Value);
}
catch
{
seq = -1;
}
if (_tsFacade == null)
{
_tsFacade = new QueryTSDetailsFacade(base.DataProvider);
}
return(this._tsFacade.QueryTSDetails(
this.txtSN.Value,
seq,
1, int.MaxValue));
}
//样本明细导出
public object[] ExportQueryOQCLotSampleDetails(string productiontype, string ss,
string itemCodes, string moCodes,
string oqclot, string state, string startSn, string endSn,
string firstClass, string secondClass, string thirdClass, string crewCode,
string bigLine, string materialModelCode, string materialMachineType, string materialExportImport,
string decideMan, string oqcLotType, string reWorkMO,
int ReworkStartDate, int ReworkEndDate,
int packedstartDate, int packedstartTime,
int packedendDate, int packedendTime,
int teststartDate, int teststartTime,
int testendDate, int testendTime,
bool isQueryHistory,
int inclusive, int exclusive)
{
object[] mainLotInfo = this.QueryOQCLotDetails(productiontype, ss, itemCodes, moCodes,
oqclot, state, startSn, endSn,
firstClass, secondClass, thirdClass, crewCode,
bigLine, materialModelCode, materialMachineType, materialExportImport,
decideMan, oqcLotType, reWorkMO,
ReworkStartDate, ReworkEndDate,
packedstartDate, packedstartTime,
packedendDate, packedendTime,
teststartDate, teststartTime,
testendDate, testendTime,
isQueryHistory,
1, int.MaxValue);
QueryTSDetailsFacade tsdetailFacade = new QueryTSDetailsFacade(this.DataProvider);
ArrayList returnList = new ArrayList();
if (mainLotInfo != null && mainLotInfo.Length > 0)
{
foreach (QueryOQCLot qlot in mainLotInfo)
{
object[] detials = tsdetailFacade.QueryOQCSampleNGDetails(qlot.LOTNO, 1, int.MaxValue);
if (detials != null && detials.Length > 0)
{
foreach (QDOTSDetails1 tsdetail in detials)
{
ExportQueryOQCLotSampleDetails exportdetail = new ExportQueryOQCLotSampleDetails();
//主档信息映射
exportdetail.ItemCode = qlot.ItemCode;
exportdetail.BigStepSequenceCode = qlot.BigStepSequenceCode;
exportdetail.LOTNO = qlot.LOTNO;
exportdetail.SSCode = qlot.SSCode;
exportdetail.CrewCode = qlot.CrewCode;//Added By Nettie Chen 2009/09/23
exportdetail.LotSize = qlot.LotSize;
exportdetail.OQCLotType = qlot.OQCLotType;
exportdetail.LOTStatus = qlot.LOTStatus;
exportdetail.SampleCount = qlot.SampleCount;
exportdetail.SampleNGCount = qlot.SampleNGCount;
exportdetail.FirstGoodCount = qlot.FirstGoodCount;
exportdetail.AGradeTimes = qlot.AGradeTimes;
exportdetail.BGradeTimes = qlot.BGradeTimes;
exportdetail.CGradeTimes = qlot.CGradeTimes;
exportdetail.ZGradeTimes = qlot.ZGradeTimes;
exportdetail.MaintainUser = qlot.MaintainUser;
exportdetail.MaintainDate = qlot.MaintainDate;
exportdetail.MaintainTime = qlot.MaintainTime;
exportdetail.DealUser = qlot.DealUser;
exportdetail.DealDate = qlot.DealDate;
exportdetail.DealTime = qlot.DealTime;
exportdetail.MaterialMachineType = qlot.MaterialMachineType;
exportdetail.MaterialModelCode = qlot.MaterialModelCode;
exportdetail.MaterialExportImport = qlot.MaterialExportImport;
exportdetail.ReworkCode = qlot.ReworkCode;
exportdetail.OldLotNo = qlot.OldLotNo;
exportdetail.LotFrozen = qlot.LotFrozen;
//样本不良明细映射
exportdetail.RunningCard = tsdetail.RunningCard;
exportdetail.ErrorCodeGroupDescription = tsdetail.ErrorCodeGroupDescription;
exportdetail.ErrorCodeDescription = tsdetail.ErrorCodeDescription;
exportdetail.ErrorCauseDescription = tsdetail.ErrorCauseDescription;
exportdetail.ErrorLocation = tsdetail.ErrorLocation;
exportdetail.ErrorParts = tsdetail.ErrorParts;
exportdetail.SolutionDescription = tsdetail.SolutionDescription;
exportdetail.DutyDescription = tsdetail.DutyDescription;
exportdetail.Memo = tsdetail.Memo;
exportdetail.TSOperator = tsdetail.TSOperator;
exportdetail.TSDate = tsdetail.TSDate;
exportdetail.TSTime = tsdetail.TSTime;
returnList.Add(exportdetail);
}
}
}
}
return((ExportQueryOQCLotSampleDetails[])returnList.ToArray(typeof(ExportQueryOQCLotSampleDetails)));
}
