public static string GetAcDateTimeAtServer(string strTransNo)
{
string strResult = "";
try
{
DataTable dtTemp = null;
TRN_TRN181 TRN18 = new TRN_TRN181();
dtTemp = TRN18.GetDataByTransNo(strTransNo);
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
strResult = string.Format("{0}||{1}", ((DateTime)dtTemp.Rows[0]["AC_START_DATE"]).ToString("yyyy/MM/dd"),
((DateTime)dtTemp.Rows[0]["AC_END_DATE"]).ToString("yyyy/MM/dd"));
}
}
catch (Exception ex)
{
throw ex;
}
return strResult;
}
public static string GetDirverByRouteAtServer(string strRoute, string strPageTimeStamp)
{
string strResult = "";
try
{
TRN_TRN181 TRN18 = new TRN_TRN181();
DataTable dtTemp = TRN18.GetDataTableDriverNameAvailable(strPageTimeStamp);
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
DataRow[] drAry = dtTemp.Select(string.Format("ROUTE = '{0}'", strRoute));
if (drAry != null && drAry.Length > 0)
{
strResult = drAry[0]["DRIVER_NAME"].ToString().Trim();
}
}
}
catch (Exception ex)
{
throw ex;
}
return strResult;
}
