C# (CSharp) PIC.VDS2G.BSM.ALO VDS_ALO_PATTERNSPEC_MAIN_DBO.doGetValidationDataForCheck Exemples

Exemple #1

Fichier : MaintainPatternSpec.cs Projet : ChiangHanLung/PIC_VDS

        public bool CheckPATTERNSPECCanAdd(Hashtable htParams,ref string strErrMsg)
        {
            #region
            try
            {
                bool bResult = false;
                Int32 iErrCounts = 0;

                VDS_ALO_PATTERNSPEC_MAIN_DBO ALOM = new VDS_ALO_PATTERNSPEC_MAIN_DBO(ref USEDB);

                MaintainStoreAssignItem BCO = new MaintainStoreAssignItem(strConn);

                #region
                DataTable dt1 = ALOM.doGetValidationDataForCheck(htParams);


                if (dt1 != null && dt1.Rows.Count > 0) 
                {
                    //是否存在於通路主檔
                    if (dt1.Rows[0][0].ToString().Trim() == "0") 
                    {
                        strErrMsg += "通路不存在,";
                        iErrCounts++;
                    }

                    //是否存在於門市主檔
                    if (dt1.Rows[0][1].ToString().Trim() == "0")
                    {
                        strErrMsg += "門市不存在,";
                        iErrCounts++;
                    }
                }
                #endregion

                if (strErrMsg.Trim().Length > 0)
                {
                    if (strErrMsg.Substring(strErrMsg.Length - 1, 1) == ",")
                    {
                        strErrMsg = strErrMsg.Substring(0, strErrMsg.Length - 1);
                    }
                }


                if (iErrCounts == 0)
                    bResult = true;
                else
                    bResult = false;

                return bResult;
            }
            catch (Exception ex)
            {
                throw GetNewException(ex);
            }
            #endregion
        }