private bool GetOpenDateByStore(string strChan, string strStore) { #region bool bResult = false; try { CRMModel.QueryCRMCommon BCO = new CRMModel.QueryCRMCommon(ConnectionDB); ArrayList ParameterList1 = new ArrayList(); ParameterList1.Clear(); ParameterList1.Add(strStore); ParameterList1.Add(strChan); ParameterList1.Add(Session["UID"].ToString()); DataTable dtTemp = BCO.QUERY_STORE_BY_STOREANDCHAN(ParameterList1); if (dtTemp != null && dtTemp.Rows.Count != 0 && dtTemp.Rows[0]["STORE_OPEN_DATE"] != null && dtTemp.Rows[0]["STORE_OPEN_DATE"].ToString().Trim() != "") { s_STORE_OPEN_DATE = DateTime.Parse(dtTemp.Rows[0]["STORE_OPEN_DATE"].ToString()).ToString("yyyy/MM/dd"); s_STORE_NAME = dtTemp.Rows[0]["STORE_NAME"].ToString(); bResult = true; } else { s_STORE_OPEN_DATE = ""; s_STORE_NAME = ""; bResult = false; } } catch (Exception ex) { throw ex; } return bResult; #endregion }