/// <summary>
/// 取运单号
/// </summary>
/// <param name="orderCode">订单号</param>
/// <returns></returns>
public string GetExpressCodeByOrderCode(string orderCode)
{
string sql = @"Select top 1 ExpressList from orderexpress nolock where OrderCode=@OrderCode order by id asc;";
try
{
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@OrderCode", orderCode);
return(DbSFO2OMain.ExecuteSqlScalar <string>(sql, parameters));
}
catch (Exception ex)
{
LogHelper.Error(ex);
return(string.Empty);
}
}
