public override object Do(object obj)
{
GetCompleteApplyBarCodePrintData bpObj = (GetCompleteApplyBarCodePrintData)obj;
if (bpObj.CompleteApplyBarCodeIDs == null || bpObj.CompleteApplyBarCodeIDs.Count == 0)
{
return(null);
}
string sql = string.Format(@"
select barcode.ID as BarCodeID,
barcode.BarCode as BarCode,
barcode.ActualLength,
barcode.MarkingLength,
item.ID as ItemID,
item.Code as ItemCode,
item.Name as ItemName,
item.SPECS as ItemSPECS,
op.ID as OperatorsID,
op.Code as OperatorsCode,
opTrl.Name as OperatorsName
from Cust_CompleteApplyBarCode barcode
inner join CBO_ItemMaster as item on barcode.Item=item.ID
left join CBO_Operators as op on barcode.Operators=op.ID
left join CBO_Operators_Trl as opTrl on op.ID=opTrl.ID and opTrl.SysMLFlag='zh-CN'
where barcode.ID in ({0})", string.Join(",", bpObj.CompleteApplyBarCodeIDs.ToArray()));
DataSet dataset = new DataSet();
DataAccessor.RunSQL(DatabaseManager.GetCurrentConnection(), sql, null, out dataset);
if (dataset == null || dataset.Tables.Count == 0 || dataset.Tables[0].Rows.Count == 0)
{
return(null);
}
List <CompleteApplyBarCodeDTO> barCodeDTOs = new List <CompleteApplyBarCodeDTO>();
foreach (DataRow dataRow in dataset.Tables[0].Rows)
{
CompleteApplyBarCodeDTO barCodeDTO = new CompleteApplyBarCodeDTO();
barCodeDTO.ActualLength = TypeHelper.ConvertType <int>(dataRow["ActualLength"], 0);
barCodeDTO.MarkingLength = TypeHelper.ConvertType <int>(dataRow["MarkingLength"], 0);
barCodeDTO.BarCodeID = TypeHelper.ConvertType <long>(dataRow["BarCodeID"], 0);
barCodeDTO.BarCode = TypeHelper.ConvertType <string>(dataRow["BarCode"], "");
barCodeDTO.ItemID = TypeHelper.ConvertType <long>(dataRow["ItemID"], 0);
barCodeDTO.ItemCode = TypeHelper.ConvertType <string>(dataRow["ItemCode"], "");
barCodeDTO.ItemName = TypeHelper.ConvertType <string>(dataRow["ItemName"], "");
barCodeDTO.ItemSPECS = TypeHelper.ConvertType <string>(dataRow["ItemSPECS"], "");
barCodeDTO.OperatorsID = TypeHelper.ConvertType <long>(dataRow["OperatorsID"], 0);
barCodeDTO.OperatorsCode = TypeHelper.ConvertType <string>(dataRow["OperatorsCode"], "");
barCodeDTO.OperatorsName = TypeHelper.ConvertType <string>(dataRow["OperatorsName"], "");
barCodeDTOs.Add(barCodeDTO);
}
return(barCodeDTOs);
}
//[OperationBehavior]
public List <UFIDA.U9.Cust.JSDY.BarCode.CompleteApplyBarCodeDTOData> DoEx(ICommonDataContract commonData, List <System.String> completeApplyBarCodeIDs)
{
this.CommonData = commonData;
try
{
BeforeInvoke("UFIDA.U9.Cust.JSDY.BarCode.GetCompleteApplyBarCodePrintData");
GetCompleteApplyBarCodePrintData objectRef = new GetCompleteApplyBarCodePrintData();
objectRef.CompleteApplyBarCodeIDs = completeApplyBarCodeIDs;
//处理返回类型.
List <UFIDA.U9.Cust.JSDY.BarCode.CompleteApplyBarCodeDTO> result = objectRef.Do();
if (result == null)
{
return(null);
}
List <UFIDA.U9.Cust.JSDY.BarCode.CompleteApplyBarCodeDTOData> list = new List <UFIDA.U9.Cust.JSDY.BarCode.CompleteApplyBarCodeDTOData>();
foreach (UFIDA.U9.Cust.JSDY.BarCode.CompleteApplyBarCodeDTO obj in result)
{
if (obj == null)
{
continue;
}
UFIDA.U9.Cust.JSDY.BarCode.CompleteApplyBarCodeDTOData resultdata = obj.ToEntityData();
list.Add(resultdata);
}
DoSerializeKey(list, "UFIDA.U9.Cust.JSDY.BarCode.GetCompleteApplyBarCodePrintData");
return(list);
}
catch (System.Exception e)
{
DealException(e);
throw;
}
finally
{
FinallyInvoke("UFIDA.U9.Cust.JSDY.BarCode.GetCompleteApplyBarCodePrintData");
}
}
