public DataTable QueryPatternSpecByFindForPattern(ArrayList Paramslist)
{
#region
try
{
VDS_ALO_PATTERNSPEC_MAIN_DBO ALOM = new VDS_ALO_PATTERNSPEC_MAIN_DBO(ref USEDB);
QueryALOCommon ALOCommon = new QueryALOCommon(strConn);
DataTable dt = ALOM.doQueryByFindForPattern(Paramslist);
#region
ArrayList ParameterList = new ArrayList();
string strStstusCode = "", strStstus = "", strStstusDesc = "";
if (dt != null)
{
for (Int32 i = 0; i <= dt.Rows.Count - 1; i++)
{
strStstusCode = "";
strStstus = "";
strStstusDesc = "";
ParameterList.Clear();
ParameterList.Add(dt.Rows[i]["chan_no"]);
ParameterList.Add(dt.Rows[i]["store"]);
strStstusDesc = ALOCommon.CheckCurrentStoreState(ParameterList);
if (strStstusDesc.Trim() != "")
{
strStstus = "未生效";
strStstusCode = "0";
}
else
{
strStstus = "生效";
strStstusCode = "1";
}
if (strStstusDesc.Trim().Length > 0)
{
if (strStstusDesc.Substring(strStstusDesc.Length - 1, 1) == ",")
{
strStstusDesc = strStstusDesc.Substring(0, strStstusDesc.Length - 1);
}
}
dt.Rows[i]["storestatusCode"] = strStstusCode;
dt.Rows[i]["storestatus"] = strStstus;
dt.Rows[i]["storestatusdesc"] = strStstusDesc;
}
}
#endregion
return dt;
}
catch (Exception ex)
{
throw GetNewException(ex);
}
#endregion
}
