public int UptZt(int cid)
{
try
{
string sql = "select * from Agent";
List <Model.Agent> la = DapperHelper.GetList <Model.Agent>(sql);
Model.Agent aa = la.FirstOrDefault(x => x.AgentId.Equals(cid));
string sql1 = "";
if (aa.AgentState == 0)
{
sql1 = $"UPDATE Agent SET AgentState=AgentState+1 where AgentId={cid}";
}
else
{
sql1 = $"UPDATE Agent SET AgentState=AgentState-1 where AgentId={cid}";
}
int i = DapperHelper.Execute(sql1);
return(i);
}
catch (Exception)
{
throw;
}
}
public void add_unit(Model.Agent card)
{
try
{
string con_str = Properties.Settings.Default.con_str;
SqlConnection connection = new SqlConnection(con_str);
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[CreateNewUnit]";
cmd.Parameters.Add(new SqlParameter("@boss", card.Boss)
{
Direction = ParameterDirection.Input
});
cmd.Parameters.Add(new SqlParameter("@name", card.Name)
{
Direction = ParameterDirection.Input
});
cmd.Parameters.Add(new SqlParameter("@id", card.Id)
{
Direction = ParameterDirection.Output
});
//cmd.Parameters.Add(new SqlParameter("@status_code",100) { Direction=ParameterDirection.Input};
cmd.ExecuteNonQuery();
((App)App.Current).all_data.stat_it(0, ((App)App.Current).the_person.Id, "success add_unit");
card.Id = Convert.ToInt64(cmd.Parameters["@id"].Value);
connection.Close();
}
catch (Exception e) { MessageBox.Show(e.ToString()); ((App)App.Current).all_data.stat_it(0, ((App)App.Current).the_person.Id, "fail add_unit"); }
}
protected void Page_Load(object sender, EventArgs e)
{
//-----------权限控制开始-----------
//当前角色
int Rid = CurrentManager.RoleId;
BLL.Sys_role_rightManager rrService = new BLL.Sys_role_rightManager();
//查看权限
if (!rrService.IsPermission(Rid, 44))
{
viewAc = false;
Response.Write("<script>alert('非法操作，请返回!');history.go(-1);</script>");
Response.End();
}
//修改权限
if (!rrService.IsPermission(Rid, 124))
{
mdfAc = false;
}
//查找权限
if (!rrService.IsPermission(Rid, 125))
{
searchAc = false;
}
//-----------权限控制结束-----------
//代理初始化
Model.Agent agent = BLL.AgentManager.GetAgentByPK(agentUserID);
UserName = agentUserName;
RoleId = (agentRoleID + 1).ToString();
ID = agentUserID.ToString();
}
void _del_card(object param)
{
((App)App.Current).all_data.stat_it(agent.Id, ((App)App.Current).the_person.Id, "deleting agent");
((App)App.Current).all_data.delete_unit(agent);
units.Remove(agent);
agent = new Model.Agent();
}
public IActionResult ActivityShowFT(int ftid)
{
//获取全部数据
var ls = _agentRepository.ShowAgent();
Model.Agent aa = ls.FirstOrDefault(x => x.AgentId.Equals(ftid));
return(Ok(aa));
}
public IEither <IEnumerable <ICommandError>, Agent> CreateOrUpdateAgent(Model.Agent agent)
{
return(this.CommandProcessor.Process(
new Business.Agent.Commands.AgentUpdateCommand
{
Data = agent
}));
}
protected void Page_Load(object sender, EventArgs e)
{
//-----------权限控制开始-----------
//当前角色
int Rid = CurrentManager.RoleId;
BLL.Sys_role_rightManager rrService = new BLL.Sys_role_rightManager();
//查看权限
if (!rrService.IsPermission(Rid, 180))
{
viewAc = false;
Response.Write("<script>alert('非法操作，请返回!');history.go(-1);</script>");
Response.End();
}
//增加权限
if (!rrService.IsPermission(Rid, 120))
{
addAc = false;
}
//修改权限
if (!rrService.IsPermission(Rid, 121))
{
mdfAc = false;
}
//查找权限
if (!rrService.IsPermission(Rid, 122))
{
searchAc = false;
}
//修改密码
if (!rrService.IsPermission(Rid, 123))
{
passwordAc = false;
}
//-----------权限控制结束-----------
//代理初始化
Model.Agent agent = BLL.AgentManager.GetAgentByPK(agentUserID);
Credit = agent.Credit.ToString();
UserCredit = agent.UserCredit.ToString();
ResetCredit = agent.ResetCredit;
UserName = agentUserName;
RoleId = (agentRoleID + 1).ToString();
Percent = (agent.Percent * 100).ToString();
CommissionA = (agent.CommissionA * 100).ToString("0");
CommissionB = (agent.CommissionB * 100).ToString("0");
CommissionC = (agent.CommissionC * 100).ToString("0");
ID = agentUserID.ToString();
ItemMin = agent.ItemMin.ToString();
ItemMax = agent.ItemMax.ToString();
ItemsMax = agent.ItemsMax.ToString();
Currency = agent.Currency;
}
public IEither <IEnumerable <ICommandError>, IEnumerable <IEvent> > Handle(
Model.Agent agent,
Commands.AgentUpdateCommand command)
{
if (command.AggregateId == Guid.Empty)
{
return(CommandResult.Handled(new Events.AgentNewEvent(command.Data)));
}
return(CommandResult.Handled(new Events.AgentUpdatedEvent(command.Data)));
}
public int AddAgent(Model.Agent a)
{
try
{
string sql = $"insert into Agent values (null,'{a.AgentName}','{a.BackgroudColor}','{a.Icon}','{a.BCImg}','{a.Fans}',{a.Consume},{a.Money},'{a.NFans}',{a.Two},{a.Three},{a.One},'{a.Explaina}',{a.AgentState})";
return(DapperHelper.Execute(sql));
}
catch (Exception)
{
throw;
}
}
public int UptAgent(Model.Agent a)
{
try
{
string sql = $"update Agent set AgentName='{a.AgentName}',BackgroudColor='{a.BackgroudColor}',Icon='{a.Icon}',BCImg='{a.BCImg}',Fans='{a.Fans}',Consume={a.Consume},Money={a.Money},NFans='{a.NFans}',Two={a.Two},Three={a.Three},One={a.One},Explaina='{a.Explaina}',AgentState={a.AgentState} where AgentId={a.AgentId}";
return(DapperHelper.Execute(sql));
}
catch (Exception)
{
throw;
}
}
public IEither <IEnumerable <ICommandError>, IEnumerable <IEvent> > Handle(
Model.Agent agent,
Commands.AppointmentUpdateCommand command)
{
if (command.AggregateId == Guid.Empty)
{
return(CommandResult.Failed(
new AgentNotFoundError(command.AggregateId)));
}
if (!agent.IsValidAddress(command.Data.Address))
{
return(CommandResult.Failed(
new InvalidAddressError(command.Data.Address)));
}
if (!agent.IsValidSchedule(command.Data.StartDate, command.Data.EndDate))
{
return(CommandResult.Failed(
new InvalidScheduleError(
command.Data.StartDate,
command.Data.EndDate,
command.Data.AgentId)));
}
if (command.Data.AppointmentId != 0)
{
if (agent.HasAppointment(command.Data.AppointmentId))
{
return(CommandResult.Handled(new Events.AppointmentUpdatedEvent(command.Data)));
}
return(CommandResult.Failed(
new MissingAppointmentError(
command.Data.AppointmentId,
command.Data.AgentId)));
}
if (agent.CanScheduleAppointment(command.Data.StartDate, command.Data.EndDate))
{
return
(CommandResult.Handled(new Events.AppointmentNewEvent(agent.Appointments.Count() + 1,
command.Data)));
}
return(CommandResult.Failed(
new AppointmentConflictError(
command.Data.StartDate,
command.Data.EndDate,
command.Data.AgentId)));
}
public IHttpActionResult PostAgent(Model.Agent agent)
{
try
{
return(this.AgentService.CreateOrUpdateAgent(agent)
.Case <IHttpActionResult>(
errors => this.Conflict(),
newAgent => this.Ok(newAgent)));
}
catch (Exception ex)
{
return(this.InternalServerError(ex));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Agent model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Agent set ");
strSql.Append("TrueName=@TrueName,");
strSql.Append("Phone=@Phone,");
strSql.Append("Words=@Words,");
strSql.Append("ComID=@ComID,");
strSql.Append("Account=@Account,");
strSql.Append("PassWord=@PassWord,");
strSql.Append("QQ=@QQ,");
strSql.Append("WeChat=@WeChat,");
strSql.Append("Xiaoqu=@Xiaoqu");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@TrueName", DbType.String),
new SQLiteParameter("@Phone", DbType.String),
new SQLiteParameter("@Words", DbType.String),
new SQLiteParameter("@ComID", DbType.Int32,8),
new SQLiteParameter("@Account", DbType.String),
new SQLiteParameter("@PassWord", DbType.String),
new SQLiteParameter("@QQ", DbType.String),
new SQLiteParameter("@WeChat", DbType.String),
new SQLiteParameter("@Xiaoqu", DbType.String),
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = model.TrueName;
parameters[1].Value = model.Phone;
parameters[2].Value = model.Words;
parameters[3].Value = model.ComID;
parameters[4].Value = model.Account;
parameters[5].Value = model.PassWord;
parameters[6].Value = model.QQ;
parameters[7].Value = model.WeChat;
parameters[8].Value = model.Xiaoqu;
parameters[9].Value = model.ID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Agent DataRowToModel(DataRow row)
{
Model.Agent model = new Model.Agent();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["TrueName"] != null)
{
model.TrueName = row["TrueName"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["Words"] != null)
{
model.Words = row["Words"].ToString();
}
if (row["ComID"] != null && row["ComID"].ToString() != "")
{
model.ComID = int.Parse(row["ComID"].ToString());
}
if (row["Account"] != null)
{
model.Account = row["Account"].ToString();
}
if (row["PassWord"] != null)
{
model.PassWord = row["PassWord"].ToString();
}
if (row["QQ"] != null)
{
model.QQ = row["QQ"].ToString();
}
if (row["WeChat"] != null)
{
model.WeChat = row["WeChat"].ToString();
}
if (row["Xiaoqu"] != null)
{
model.Xiaoqu = row["Xiaoqu"].ToString();
}
}
return(model);
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Model.Affiliate affiliate = new Model.Affiliate
{
Id = Convert.ToInt32(affiliateDropDown.SelectedItem.Value)
};
Model.Agent agent = new Model.Agent
{
Id = Convert.ToInt32(agentDropDown.SelectedItem.Value)
};
Model.RiskPackage riskPackage = new Model.RiskPackage
{
Id = Convert.ToInt32(riskPackageDropDown.SelectedItem.Value)
};
Model.Insured insured = new Model.Insured
{
Id = Convert.ToInt32(insuredDropDown.SelectedItem.Value)
};
Model.Vehicle vehicle = new Model.Vehicle
{
RegisterNumber = registerNumberDropDown.SelectedItem.Value
};
Model.Policy policy = new Model.Policy
{
CreatedOn = DateTime.Now,
StartDate = Convert.ToDateTime(startDateTextBox.Value),
EndDate = Convert.ToDateTime(expireDateTextBox.Value),
Affiliate = affiliate,
Agent = agent,
Insured = insured,
Premium = Convert.ToDecimal(premiumTextBox.Text),
RiskPackage = riskPackage,
Vehicle = vehicle
};
policyDao.InsertPolicy(policy);
Response.Redirect("~/Pages/Policy/Policies.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.Agent model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Agent(");
strSql.Append("ID,TrueName,Phone,Words,ComID,Account,PassWord,QQ,WeChat,Xiaoqu)");
strSql.Append(" values (");
strSql.Append("@ID,@TrueName,@Phone,@Words,@ComID,@Account,@PassWord,@QQ,@WeChat,@Xiaoqu)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8),
new SQLiteParameter("@TrueName", DbType.String),
new SQLiteParameter("@Phone", DbType.String),
new SQLiteParameter("@Words", DbType.String),
new SQLiteParameter("@ComID", DbType.Int32, 8),
new SQLiteParameter("@Account", DbType.String),
new SQLiteParameter("@PassWord", DbType.String),
new SQLiteParameter("@QQ", DbType.String),
new SQLiteParameter("@WeChat", DbType.String),
new SQLiteParameter("@Xiaoqu", DbType.String)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TrueName;
parameters[2].Value = model.Phone;
parameters[3].Value = model.Words;
parameters[4].Value = model.ComID;
parameters[5].Value = model.Account;
parameters[6].Value = model.PassWord;
parameters[7].Value = model.QQ;
parameters[8].Value = model.WeChat;
parameters[9].Value = model.Xiaoqu;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//-----------权限控制开始-----------
//当前角色
int Rid = CurrentManager.RoleId;
BLL.Sys_role_rightManager rrService = new BLL.Sys_role_rightManager();
//查看权限
if (!rrService.IsPermission(Rid, 47))
{
viewAc = false;
Response.Write("<script>alert('非法操作，请返回!');history.go(-1);</script>");
Response.End();
}
//修改权限
if (!rrService.IsPermission(Rid, 130))
{
mdfAc = false;
}
//查找权限
if (!rrService.IsPermission(Rid, 131))
{
searchAc = false;
}
//-----------权限控制结束-----------
//代理初始化
//BLL.AgentManager agentManager = new BLL.AgentManager();
//string names = agentManager.getUserNames(agentUserName);
//double nPercent = 0;
//IList<Model.Agent> agents = agentManager.GetAgentByUserNames(names);
//foreach (Model.Agent iagent in agents)
//{
// nPercent += iagent.Percent;
//}
Model.Agent agent = BLL.AgentManager.GetAgentByPK(agentUserID);
UserName = agentUserName;
RoleId = (agentRoleID + 1).ToString();
Percent = (agent.Percent * 100).ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Agent GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,TrueName,Phone,Words,ComID,Account,PassWord,QQ,WeChat,Xiaoqu from Agent ");
strSql.Append(" where ID=@ID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ID", DbType.Int32, 8)
};
parameters[0].Value = ID;
Model.Agent model = new Model.Agent();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public string AddUser(string UserName, string Password, string TCpassword, DateTime Birthday, string Name,
string Tel, string Email, string Agent, string post, string Answer)
{
if (UserName.Trim() == "")
{
return("err8");
}
else
{
if (UserName.Trim().Length < 6 || UserName.Trim().Length > 15)
{
return("err9");
}
}
if (ChkBadWord(UserName.Trim()))//检测是否有非法字符
{
return("err8");
}
Model.User info = new Model.User();
Model.Agent agent = null;
Model.Agent subAgent = null;
Model.Agent parAgent = null;
Model.Agent zAgent = null;
if (!string.IsNullOrEmpty(Email))
{
if (DAL.UserService.IsExistEmail(Email))
{
return("err:email"); //邮箱重复
}
}
AgentManager am = new AgentManager();
if (string.IsNullOrEmpty(Agent) || Agent == "undefined")
{
//网站直接会员
ConfigManager cm = new ConfigManager();
string styp = "人民币";
Model.Config config = cm.GetConfigByOtype(styp);
Agent = config.Oval;
}
//代理会员
agent = am.GetAgentByUserName(Agent);
//if (agent==null)
//{
// return "err2";
//}
//选择的币种是否与推荐人币种一致
//info.parentcode = agent.ParentCode;
subAgent = am.GetAgentByUserName(agent.SubCompany);
parAgent = am.GetAgentByUserName(agent.Partner);
zAgent = am.GetAgentByUserName(agent.GeneralAgent);
info.GeneralAgent = agent.GeneralAgent;
info.GeneralAgentPercent = Convert.ToDecimal(zAgent.Percent);
info.GeneralAgentCommission = zAgent.CommissionA;
info.Agent = Agent;
info.AgentPercent = Convert.ToDecimal(agent.Percent);
info.AgentCommission = agent.CommissionA;
info.CompanyPercent = 0;
info.PartnerCommission = 0;
info.SubCompany = agent.SubCompany;
info.SubCompanyPercent = Convert.ToDecimal(subAgent.Percent);
info.SubCompanyCommission = subAgent.CommissionA;
info.Partner = agent.Partner;
info.PartnerPercent = Convert.ToDecimal(parAgent.Percent);
info.PartnerCommission = parAgent.CommissionA;
info.Percent = 0;
info.Commission = 0;
info.Credit = 0;
info.UpUserName = agent.UserName;
info.UpUserID = agent.ID;
info.UpRoleId = agent.RoleId;
info.ItemMin = agent.ItemMin;
info.ItemMax = agent.ItemMax;
info.ItemsMax = agent.ItemsMax;
info.Group = "A";
info.ResetCredit = "0";
info.RegistrationTime = DateTime.Now;
info.LastLoginTime = DateTime.Now;
info.UserLevel = "5";
info.Coefficient = 0;
info.Proportion = 0;
info.Balance = 0;
info.RoleId = 6;
info.UserName = UserName.Trim();
info.Password = Password;
info.TCpassword = TCpassword;
info.Birthday = Birthday;
info.Name = Name.Trim();
info.Tel = Tel;
info.Email = Email;
info.Agent = Agent.Trim();
info.Status = 1;
info.MoneyType = "0";
info.regip = Util.RequestHelper.GetIP();
info.Post = post.Trim();
info.Answer = Answer.Trim();
bool reval = UserManager.AddAgentUser2(info);
if (reval)
{
//用户登录
UserManager um = new UserManager();
Model.User user = null;
user = um.GetUserByUserName(info.UserName);
if (user != null)
{
Session[ProjectConfig.LOGINUSER] = user;
CookieHelper cook = new CookieHelper();
//cook.SetCookie(ProjectConfig.LANGUAGE_COOK, "tw", TimeSpan.FromDays(1));
Application[user.ID + "Session"] = this.Session.SessionID;
user.LastLoginIP = RequestHelper.GetIP();
UserManager.UpdateUser(user);
//会员登录日志
UserManager.AddLogClient(user.UserName);
//发送游戏帐号开通信息到后台
Boolean isOk = Getpwds(Password, "1");
}
}
if (reval)
{
//当注册成功时，发送邮件。
try
{
string isok = SendEmail2(Email, UserName, Name);
if (isok != "ok")
{
return("1000");
}
//else return "ok";
return("ok");
}
catch (Exception)
{
return("8008");
}
}
else
{
return("err");
}
}
public int UptAgent(Model.Agent a)
{
string sql = $"update Agent set values (null,'{a.AgentName}', '{a.Icon}', '{a.BCImg}', '{a.BackgroudColor}', '{a.Fans}', {a.AgentState}, {a.One}, {a.Two}, {a.Three},'{a.Explaina}')";
return(DapperHelper.Execute(sql));
}
void _new_card(object param)
{
is_redacting = false;
agent = new Model.Agent();
}
void Refresh(object param)
{
agent = new Model.Agent();
_units = ((App)App.Current).all_data.get_units();
}