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