contacter.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

            parms.AddInParameter("@HomePhone", DbType.String, contacterInfo.HomePhone);
            parms.AddInParameter("@PHS", DbType.String, contacterInfo.Phs);
            parms.AddInParameter("@Fax", DbType.String, contacterInfo.Fax);
            parms.AddInParameter("@Homepage", DbType.String, contacterInfo.Homepage);
            parms.AddInParameter("@Email", DbType.String, contacterInfo.Email);
            parms.AddInParameter("@QQ", DbType.String, contacterInfo.QQ);
            parms.AddInParameter("@MSN", DbType.String, contacterInfo.Msn);
            parms.AddInParameter("@ICQ", DbType.String, contacterInfo.Icq);
            parms.AddInParameter("@Yahoo", DbType.String, contacterInfo.Yahoo);
            parms.AddInParameter("@UC", DbType.String, contacterInfo.UC);
            parms.AddInParameter("@Aim", DbType.String, contacterInfo.Aim);
            parms.AddInParameter("@Company", DbType.String, contacterInfo.Company);
            parms.AddInParameter("@Operation", DbType.String, contacterInfo.Operation);
            parms.AddInParameter("@CompanyAddress", DbType.String, contacterInfo.CompanyAddress);
            parms.AddInParameter("@Department", DbType.String, contacterInfo.Department);
            parms.AddInParameter("@Position", DbType.String, contacterInfo.Position);
            parms.AddInParameter("@Title", DbType.String, contacterInfo.Title);
            parms.AddInParameter("@BirthDay", DbType.DateTime, contacterInfo.Birthday);
            parms.AddInParameter("@IDCard", DbType.String, contacterInfo.IdCard);
            parms.AddInParameter("@NativePlace", DbType.String, contacterInfo.NativePlace);
            parms.AddInParameter("@Nation", DbType.String, contacterInfo.Nation);
            parms.AddInParameter("@Sex", DbType.Int32, contacterInfo.Sex);
            parms.AddInParameter("@Marriage", DbType.Int32, contacterInfo.Marriage);
            parms.AddInParameter("@Education", DbType.Int32, contacterInfo.Education);
            parms.AddInParameter("@GraduateFrom", DbType.String, contacterInfo.GraduateFrom);
            parms.AddInParameter("@InterestsOfLife", DbType.String, contacterInfo.InterestsOfLife);
            parms.AddInParameter("@InterestsOfCulture", DbType.String, contacterInfo.InterestsOfCulture);
            parms.AddInParameter("@InterestsOfAmusement", DbType.String, contacterInfo.InterestsOfAmusement);
            parms.AddInParameter("@InterestsOfSport", DbType.String, contacterInfo.InterestsOfSport);
            parms.AddInParameter("@InterestsOfOther", DbType.String, contacterInfo.InterestsOfOther);
            parms.AddInParameter("@Family", DbType.String, contacterInfo.Family);
            parms.AddInParameter("@Income", DbType.Int32, contacterInfo.Income);
            parms.AddInParameter("@UpdateTime", DbType.DateTime, DateTime.Now);
        }

        public IList<ContacterInfo> GetList(int startRowIndexId, int maxNumberRows, int searchType, string keyword)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList");
            string str = "PE_Contacter C inner join PE_Client Cl on C.ClientID=Cl.ClientID";
            List<ContacterInfo> list = new List<ContacterInfo>();
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "ContacterID");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "C.*,Cl.ShortedForm");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, str);
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, 10);
            StringBuilder builder = new StringBuilder("UserType>0 ");
            switch (searchType)
            {
                case 1:
                    builder.Append("and ContacterID=" + Convert.ToInt32(keyword));
                    break;

                case 2:
                    builder.Append("and TrueName like '%" + keyword + "%'");
                    break;

                case 3:
                    builder.Append("and UserType=1");
                    break;

                case 4:
                    builder.Append("and UserType=2");
                    break;

                case 5:
                    builder.Append("and TrueName like '%" + keyword + "%'");
                    break;

                case 6:
                    builder.Append("and C.ClientID=" + Convert.ToInt32(keyword));
                    break;

                case 7:
                    builder.Append("and C.Owner='" + PEContext.Current.Admin.AdminName + "'");
                    break;
            }
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, builder.ToString());
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(ContacterFromrdr(reader, 1));
                }
            }
            this.m_TotalOfContacter = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public int GetMaxId()
        {
            return DBHelper.GetMaxId("PE_Contacter", "ContacterID");
        }

        public IList<ContacterInfo> GetMobileContacterByGroupId(string groupId)
        {
            string strSql = "SELECT C.* \r\n                            FROM PE_Contacter C INNER JOIN PE_Users U ON C.UserName=U.UserName \r\n                            WHERE U.GroupId IN(" + groupId + ") AND (C.Mobile <>'' OR C.PHS <> '')";
            List<ContacterInfo> list = new List<ContacterInfo>();
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(strSql)))
            {
                while (reader.Read())
                {
                    list.Add(ContacterFromrdr(reader, 0));
                }
            }
            return list;
        }

        public IList<ContacterInfo> GetMobileContacterByRegion(string country, string province, string city)
        {
            string strSql = "SELECT *\r\n                              FROM PE_Contacter \r\n                              WHERE Country=@Country AND Province=@Province AND City=@City AND (Mobile <>'' OR PHS <>'')";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@Country", DbType.String, country);
            cmdParams.AddInParameter("@Province", DbType.String, province);
            cmdParams.AddInParameter("@City", DbType.String, city);
            List<ContacterInfo> list = new List<ContacterInfo>();
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(strSql, cmdParams)))
            {
                while (reader.Read())
                {
                    list.Add(ContacterFromrdr(reader, 0));
                }
            }
            return list;
        }

        public IList<ContacterInfo> GetMobileContacterByTrueName(string trueName)
        {
            string strSql = "SELECT * \r\n                              FROM PE_Contacter \r\n                              WHERE TrueName IN ('" + trueName + "') AND (Mobile <>'' OR PHS <>'')";
            List<ContacterInfo> list = new List<ContacterInfo>();
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(strSql)))
            {
                while (reader.Read())
                {
                    list.Add(ContacterFromrdr(reader, 0));
                }
            }
            return list;
        }

        public IList<ContacterInfo> GetMobileContacterByUserId(int startId, int endId)
        {
            string strSql = "SELECT C.* \r\n                              FROM PE_Contacter C INNER JOIN PE_Users U ON C.UserName=U.UserName \r\n                              WHERE U.UserId>=@StartId AND U.UserId<=@EndId AND (C.Mobile <>'' OR C.PHS <>'')";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@StartId", DbType.Int32, startId);
            cmdParams.AddInParameter("@EndId", DbType.Int32, endId);
            List<ContacterInfo> list = new List<ContacterInfo>();
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(strSql, cmdParams)))
            {
                while (reader.Read())
                {
                    list.Add(ContacterFromrdr(reader, 0));
                }
            }
            return list;
        }

        public IList<ContacterInfo> GetMobileContacterByUserName(string userName)
        {
            string strSql = "SELECT C.* \r\n                              FROM PE_Contacter C INNER JOIN PE_Users U ON C.UserName=U.UserName \r\n                              WHERE U.UserName IN('" + userName + "') AND (C.Mobile <>'' OR C.PHS <>'')";
            List<ContacterInfo> list = new List<ContacterInfo>();
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(strSql)))
            {
                while (reader.Read())
                {
                    list.Add(ContacterFromrdr(reader, 0));
                }
            }
            return list;
        }

        public int GetTotalOfContacter()
        {
            return this.m_TotalOfContacter;
        }

        public bool Update(ContacterInfo contacterInfo)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@ContacterID", DbType.Int32, contacterInfo.ContacterId);
            parms.AddInParameter("@ClientID", DbType.Int32, contacterInfo.ClientId);
            parms.AddInParameter("@ParentID", DbType.Int32, contacterInfo.ParentId);
            GetContacterParameters(contacterInfo, parms);
            return DBHelper.ExecuteProc("PR_Crm_Contacter_Update", parms);
        }

        public bool UpdateClientForSameCompany(int clientId, int companyId)
        {
            string strSql = "update PE_Contacter Set ClientID=@ClientID where ContacterID in(select ContacterID from PE_Users where companyID = @CompanyID)";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ClientID", DbType.Int32, clientId);
            cmdParams.AddInParameter("@CompanyID", DbType.Int32, companyId);
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }
    }
}