public LocationResponse GetLocationResponse(string SN)
{
string methodName = MethodBase.GetCurrentMethod().Name;
logger.DebugFormat("BEGIN: {0}(CustSN:{1})", methodName, SN);
try
{
//1.检查传进来的参数
Execute.ValidateParameter(SN);
//2.获取DB中的数据
LocationResponse locationResponse = Execute.GetLocationandCoordinateInfo(SN);
logger.DebugFormat("Reponse data:{0}", locationResponse.ToString());
return locationResponse;
}
catch (Exception e)
{
logger.Error(e.Message, e);
LocationResponse locationResponse = new LocationResponse();
locationResponse.SN = SN;
locationResponse.Location = "";
locationResponse.Coordinate = "";
locationResponse.Status = -2;
locationResponse.ErrorMsg = e.Message;
logger.DebugFormat("Reponse data:{0}", locationResponse.ToString());
return locationResponse;
}
finally
{
logger.DebugFormat("END: {0}()", methodName);
}
}
public LocationResponse GetLocationResponse(string SN)
{
try
{
//1.检查传进来的参数
Execute.ValidateParameter(SN);
//2.获取DB中的数据
LocationResponse locationResponse = Execute.GetLocationandCoordinateInfo(SN);
return locationResponse;
}
catch (Exception e)
{
LocationResponse locationResponse = new LocationResponse();
locationResponse.SN = SN;
locationResponse.Location = "";
locationResponse.Coordinate = "";
locationResponse.Status = -2;
locationResponse.ErrorMsg = e.Message;
return locationResponse;
}
}
private static LocationResponse ToLocationResponse(DataRow row)
{
LocationResponse locationResponse = new LocationResponse();
locationResponse.SN = (string)row["SN"];
locationResponse.Location = (string)row["Location"];
locationResponse.Coordinate = (string)row["Coordinate"];
locationResponse.ErrorMsg = "";
locationResponse.Status = 1;
return locationResponse;
}
public static LocationResponse GetLocationandCoordinateBySN(string sn)
{
string sqlStr = @"select CUSTSN as SN,@Location as Location,@Coordinate as Coordinate
from Product where CUSTSN=@SN";
DataTable dt = SqlHelper.ExecuteDataTable(HistoryDBName,System.Data.CommandType.Text, sqlStr,
new SqlParameter("@SN", sn),
new SqlParameter("@Location", "Location"),
new SqlParameter("@Coordinate", "Coordinate"));
if (dt == null || dt.Rows.Count == 0)
{
LocationResponse locationResponse = new LocationResponse();
locationResponse.SN = sn;
locationResponse.Location = "";
locationResponse.Coordinate = "";
locationResponse.Status = -1;
locationResponse.ErrorMsg = "The SN: " + sn + " is not exist in DB!";
return locationResponse;
}
else
{
return ToLocationResponse(dt.Rows[0]);
}
}
public static LocationResponse GetLocationandCoordinateBySN(string sn)
{
string sqlStr = @"select c.PartNo,ltrim(rtrim(c.LightNo)) as Location,ltrim(rtrim(d.Descr)) as Coordinate
from Product a(nolock), ModelBOM b(nolock), WipBuffer c(nolock),
FamilyInfo d(nolock) ,Model e(nolock)
where c.Code='Automatic' and a.CUSTSN=@SN
and a.Model=b.Material and b.Component=c.PartNo
and a.Model=e.Model and d.Family=e.Family
and c.Code=d.Name and c.PartNo=d.Value
order by c.PartNo";
DataTable dt = SqlHelper.ExecuteDataTable(HistoryDBName,System.Data.CommandType.Text, sqlStr,
new SqlParameter("@SN", sn));
if (dt == null || dt.Rows.Count == 0)
{
LocationResponse locationResponse = new LocationResponse();
locationResponse.SN = sn;
locationResponse.Location = "";
locationResponse.Coordinate = "";
locationResponse.Status = -1;
locationResponse.ErrorMsg = "Cant't find the information for SN: '" + sn + "' in DB!";
return locationResponse;
}
else
{
DataRowCollection rows = dt.Rows;
LocationResponse locationResponse = new LocationResponse();
string locations = "";
string coordinates = "";
//将多个Location整理到一个栏位,多个Coordinate整理到一个栏位
for (int i = 0; i < rows.Count; i++)
{
DataRow row = rows[i];
string location = (string)row["Location"];
string coordinate = (string)row["Coordinate"];
if (i == rows.Count - 1)
{
locations = locations + location;
coordinates = coordinates + "(" + coordinate + ")";
}
else
{
locations = locations + location + ",";
coordinates = coordinates + "(" + coordinate + "),";
}
}
locationResponse.SN = sn;
locationResponse.Location = locations;
locationResponse.Coordinate = coordinates;
locationResponse.ErrorMsg = "";
locationResponse.Status = 1;
return locationResponse;
}
}
