public string GetNextSequence(string code)
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@CodePrefix", SqlDbType.VarChar, 50);
parm[0].Value = code;
parm[1] = new SqlParameter("@NextSequence", SqlDbType.Int, 50);
parm[1].Direction = ParameterDirection.InputOutput;
sqlHelperDao.ExecuteStoredProcedure("GetNextSequence", parm);
return(parm[1].Value.ToString());
}
public void ImportKPOrder(DateTime startTime)
{
SqlParameter [] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@CodePrefix", SqlDbType.DateTime, 50);
sqlParameter[0].Value = startTime;
sqlHelperDao.ExecuteStoredProcedure("USP_Busi_ImportKPOrder", sqlParameter);
}
private void GetLoctransInfo(DssExportHistory dssExportHistory)
{
OrderLocationTransaction orderLocationTransaction =
commonOutboundMgr.GetOrderLocationTransactionInfo(dssExportHistory.OrderNo, dssExportHistory.Item, BusinessConstants.IO_TYPE_OUT);
if (orderLocationTransaction != null)
{
//dssExportHistory.Location = orderLocationTransaction.Location != null ? orderLocationTransaction.Location.Code : null;//发出库位
dssExportHistory.PartyFrom = orderLocationTransaction.OrderDetail.OrderHead.PartyFrom.Code;//发出区域
}
else
{
////归档库查找
//DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction));
//criteria.CreateAlias("OrderDetail", "od");
//criteria.Add(Expression.Eq("od.OrderHead.OrderNo", dssExportHistory.OrderNo));
//criteria.Add(Expression.Eq("Item.Code", dssExportHistory.Item));
//criteria.Add(Expression.Eq("IOType", BusinessConstants.IO_TYPE_OUT));
//IList<OrderLocationTransaction> result = archCriteriaMgr.FindAll<OrderLocationTransaction>(criteria);
//if (result != null && result.Count > 0)
//{
// orderLocationTransaction= result[0];
// dssExportHistory.PartyFrom = orderLocationTransaction.OrderDetail.OrderHead.PartyFrom.Code;//发出区域
//}
//else
//{
//}
try
{
SqlParameter[] sqlParameter = new SqlParameter[3];
sqlParameter[0] = new SqlParameter("@Item", SqlDbType.VarChar, 50);
sqlParameter[0].Value = dssExportHistory.Item;
sqlParameter[1] = new SqlParameter("@OrderNo", SqlDbType.VarChar, 50);
sqlParameter[1].Value = dssExportHistory.OrderNo;
sqlParameter[2] = new SqlParameter("@PartyFrom", SqlDbType.VarChar, 50);
sqlParameter[2].Direction = ParameterDirection.InputOutput;
sqlHelperDao.ExecuteStoredProcedure("GetPartyFrom", sqlParameter);
dssExportHistory.PartyFrom = sqlParameter[2].Value.ToString();
}
catch (Exception)
{
dssExportHistory.PartyFrom = string.Empty;
}
}
}