private bool CheckExist_PROMOTE(string strPROMOTE_ID) { bool bResult = true; BCO.VAM15_BCO BCO = new BCO.VAM15_BCO(ConntionDB); if (strPROMOTE_ID != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Add(strPROMOTE_ID); DataTable dt = BCO.QueryForSLP(ParameterList); if (dt.Rows.Count == 0) bResult = false; } return bResult; }
public string PROMOTE_NAME(string strPROMOTE_ID) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; VAM15_BCO BCO = new VAM15_BCO(ConnectionDBStr); if (strPROMOTE_ID != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Add(strPROMOTE_ID); DataTable dt = BCO.QueryForSLP(ParameterList); Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["PROMOTE_NAME"].ToString() : "查無資料"); } return Name; }