public bool Insert(Model.Agents agents) { String sql = @"INSERT INTO [dbo].[Agents] ([Id] ,[Name] ,[Province] ,[City] ,[Village] ,[Birthday] ,[CareerStatus] ,[JoinDate] ,[Rank] ,[RefereeId] ,[RefereeName] ,[AgencyId] ,[AgencyName] ,[AccountBank] ,[AccountBankBranch] ,[Account] ,[Address] ,[ZipCode] ,[Phone] ,[CreateTime] ,[CreatePerson] ,[UpdateTime] ,[UpdatePerson] ,[State],[AgentsStatus]) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}')"; sql = String.Format(sql, agents.Id , agents.Name , agents.Province , agents.City , agents.Village , agents.Birthday , agents.CareerStatus , agents.JoinDate , agents.Rank , agents.RefereeId , agents.RefereeName , agents.AgencyId , agents.AgencyName , agents.AccountBank , agents.AccountBankBranch , agents.Account , agents.Address , agents.ZipCode , agents.Phone , agents.CreateTime , agents.CreatePerson , agents.UpdateTime , agents.UpdatePerson , agents.State, agents.AgentsStatus); return(DataBase.Base_cmd(sql)); }
public bool Update(Model.Agents agents) { DataTable dt_Agents = GetAgents(" and Id='" + agents.RefereeId + "'"); if (dt_Agents != null && dt_Agents.Rows.Count > 0) { agents.RefereeName = dt_Agents.Rows[0]["AgentsName"].ToString(); agents.AgencyId = dt_Agents.Rows[0]["AgencyId"].ToString(); agents.AgencyName = dt_Agents.Rows[0]["AgencyName"].ToString(); } return(new DAL.AgentsDal().Update(agents)); }
public bool Insert(Model.Agents agents) { DataTable dt_Agents = GetAgents(" and Id='" + agents.RefereeId + "'"); if (dt_Agents != null && dt_Agents.Rows.Count > 0) { agents.RefereeName = dt_Agents.Rows[0]["AgentsName"].ToString(); String rank = dt_Agents.Rows[0]["Rank"].ToString(); if (rank.StartsWith("S"))//如果推荐人是代理人,则资深代理商为推荐人的资深代理商 { agents.AgencyId = dt_Agents.Rows[0]["AgencyId"].ToString(); agents.AgencyName = dt_Agents.Rows[0]["AgencyName"].ToString(); } else if (rank.StartsWith("D") || rank.StartsWith("P"))//如果推荐人是代理商或者合伙人,则资深代理商为推荐人 { agents.AgencyId = dt_Agents.Rows[0]["Id"].ToString(); agents.AgencyName = dt_Agents.Rows[0]["AgentsName"].ToString(); } } return(new DAL.AgentsDal().Insert(agents)); }
public bool Update(Model.Agents agents) { String sql = @"UPDATE [dbo].[Agents] SET [Name] = '{0}' ,[Province] = '{1}' ,[City] = '{2}' ,[Birthday] = '{3}' ,[JoinDate] = '{4}' ,[RefereeId] = '{5}' ,[RefereeName] = '{6}' ,[AccountBank] = '{7}' ,[AccountBankBranch] = '{8}' ,[Account] = '{9}' ,[Address] = '{10}' ,[ZipCode] = '{11}' ,[Phone] = '{12}' ,[UpdateTime] = '{13}' ,[UpdatePerson] = '{14}' WHERE Id='{15}'"; sql = String.Format(sql, agents.Name , agents.Province , agents.City , agents.Birthday , agents.JoinDate , agents.RefereeId , agents.RefereeName , agents.AccountBank , agents.AccountBankBranch , agents.Account , agents.Address , agents.ZipCode , agents.Phone , agents.UpdateTime , agents.UpdatePerson, agents.Id); return(DataBase.Base_cmd(sql)); }
//修改当前会员的职级和事业状态(代理人) public void UpdateAgents(Model.Agents agents, Model.Income income, OleDbTransaction tr) { //判断是否为代理人 if (agents.Rank == "S1" || agents.Rank == "S2") { if (income.AllMonthMoney >= 2500) { agents.CareerStatus = "A"; if (income.AllMonthMoney >= 10000) { agents.Rank = "S2"; } else { agents.Rank = "S1"; } } else { agents.Rank = "S1"; } new DAL.AgentsDal().UpdateAgents(agents); } }
public bool UpdateAgents(Model.Agents agents) { String sql = "update [dbo].[Agents] set Rank='" + agents.Rank + "',CareerStatus='" + agents.CareerStatus + "',State='" + agents.State + "' where Id='" + agents.Id + "'"; return(DataBase.Base_cmd(sql)); }