예제 #1
0
        public string AddRegistCode(string salemanId)
        {
            try
            {
                int Id = Convert.ToInt32(salemanId);
                if (Id <= 0)
                {
                    return("Request Parameter Error");
                }

                for (int i = 0; i < 10; i++)
                {
                    RegistCode code = new RegistCode();
                    code.SalemanId       = Id;
                    code.MemberId        = 0;
                    code.RegistCodeState = 1;
                    code.GenerDate       = DateTime.Now;
                    //code.UseDate = DateTime.MinValue;

                    db.RegistCode.Add(code);
                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                return("程序出错,信息为:" + ex.InnerException);
            }

            return("Succss");
        }
예제 #2
0
        public string BindMember(dynamic requestData)
        {
            string memberId  = requestData.MemberId;
            string salemanId = requestData.SalemanId;

            if (string.IsNullOrEmpty(memberId) || string.IsNullOrEmpty(salemanId))
            {
                return("Exc error");
            }

            try
            {
                RegistCode model = new RegistCode();
                model.SalemanId       = Convert.ToInt32(salemanId);
                model.MemberId        = Convert.ToInt32(memberId);
                model.RegistCodeState = 2;
                model.GenerDate       = DateTime.Now;
                model.UseDate         = DateTime.Now;

                db.RegistCode.Add(model);
                db.SaveChanges();

                string useCodeSql = string.Format("Insert into MemberRef Values({0}, {2}, '{1}'); Update RegistMember Set RecommendId = {2} where MemberId = {0};", memberId, DateTime.Now, salemanId);
                dataContext.ExecuteNonQuery(CommandType.Text, useCodeSql);
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }


            return("Exc Success");
        }