public void AgentStructHandle(AgentStruct AgentStruct) { string select_str = "select levelId, l9, l8, l7,companyId , betSetting from [lottery].[dbo].[member] with(nolock) "; string where_str = " Where id = @id "; var e = conn.Query <member>(select_str + where_str, new { Id = AgentStruct.ParentId }).FirstOrDefault(); select_str = "select betRate, defaultBetSetting from [lottery].[dbo].[company] with(nolock) "; where_str = " Where principalId = @principalId "; var h = conn.Query <company>(select_str + where_str, new { principalId = AgentStruct.ParentId }).FirstOrDefault(); Define memberDefine = new Define(); member m = new member() { username = AgentStruct.Username, password = AgentStruct.Password, levelId = memberDefine.GetNextLevelId(e.levelId), companyId = 0, parentId = AgentStruct.ParentId, externalId = "", createDateTime = DateTime.Now, l9 = e.l9, l8 = e.l8, l7 = e.l7, betSetting = e.betSetting, status = Define.MemberStauts.Enable, nickname = AgentStruct.Nickname }; dcdc.members.InsertOnSubmit(m); dcdc.SubmitChanges(); int principalId = m.id; company c = new company() { title = AgentStruct.Title, createDateTime = DateTime.Now, principalId = principalId, betRate = h.betRate, defaultBetSetting = h.defaultBetSetting }; dcdc.companies.InsertOnSubmit(c); dcdc.SubmitChanges(); int companyId = c.Id; if (AgentStruct.LevelId == Define.MemberLevels.UpAgent) { m.l8 = principalId; } if (AgentStruct.LevelId == Define.MemberLevels.Agent) { m.l7 = principalId; } m.companyId = companyId; dcdc.SubmitChanges(); }