private string GetStoreCountByRoute(string strRoute, string strROWID, string strPageTimeStamp, string strTRANS_NO)
{
#region
string strResult = "";
try
{
#region Check Duplicated
DataTable dtTemp = (DataTable)Session[string.Format("dtRoute_{0}", strPageTimeStamp)];
DataRow[] drAry = dtTemp.Select(string.Format("ROUTE ='{0}'", strRoute));
if (drAry != null && drAry.Length > 0 && drAry[0]["ROWID"].ToString() != strROWID)
{
strResult = "DUPLICATED";//"路線資料維護之路線重複";
}
#endregion
#region Check USED
if (strResult == "")
{
TRNModel.VDS_TRN13_BCO BCO = new TRNModel.VDS_TRN13_BCO(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strTRANS_NO);
ParameterList.Add(strRoute);
DataTable dtUse = BCO.CHECK_ROUTE_USE(ParameterList);
if (dtUse.Rows.Count > 0)
{
//此路線已存在路線運費歸屬檔，運輸代碼= XXX中，請確認!
strResult = string.Format("{0}||{1}||{2}||{3}",
"USED",
dtUse.Rows[0]["TRANS_NO"].ToString(),
"",
"");
}
}
#endregion
#region Get Data
if (strResult == "")
{
TRNModel.VDS_TRN13_BCO BCO = new TRNModel.VDS_TRN13_BCO(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strRoute);
DataTable dt = BCO.QUERY_STORE_COUNT_DSIR(ParameterList);
if (dt != null && dt.Rows.Count > 0)
{
strResult = string.Format("{0}||{1}||{2}||{3}",
dt.Rows[0]["EFF_START"].ToString(),
dt.Rows[0]["EFF_END"].ToString(),
dt.Rows[0]["D_SIR_NAME"].ToString(),
dt.Rows[0]["STORE_CNT"].ToString());
}
else
{
strResult = "INVALID";//"路線未生效";
}
}
#endregion
}
catch (Exception ex)
{
throw ex;
}
return strResult;
#endregion
}
