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; }