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"); }
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"); }