C# (CSharp) PIC.VDS2G.BSM.CRM QueryCRMCommon.QUERY_STORE_BY_STOREANDCHAN Examples

Example #1

File: ALO192.aspx.cs Project: ChiangHanLung/PIC_VDS

    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
    }