/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="Salesman"></param>
/// <returns></returns>
public bool AddSalesman(Model.Salesman Salesman)
{
const string sql =
@"INSERT INTO Salesman (RealName,Phone,Address,Sex,Email,IdCard,ResponsibleArea,LastMonthResults,
GoalsMonth,PerformanceMonth,RoyaltyRatio,Royalty,CustomerSource,Remark) VALUES(@RealName,@Phone,@Address,@Sex,@Email,@IdCard,@ResponsibleArea,
@LastMonthResults,@GoalsMonth,@PerformanceMonth,@RoyaltyRatio,@Royalty,@CustomerSource,@Remark)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
Salesman.RealName,
Salesman.Phone,
Salesman.Address,
Salesman.Sex,
Salesman.Email,
Salesman.IdCard,
Salesman.ResponsibleArea,
Salesman.LastMonthResults,
Salesman.GoalsMonth,
Salesman.PerformanceMonth,
Salesman.RoyaltyRatio,
Salesman.Royalty,
Salesman.CustomerSource,
Salesman.Remark,
})));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="Salesman"></param>
/// <returns></returns>
public bool EditSalesman(Model.Salesman Salesman)
{
const string sql =
@"UPDATE Salesman SET RealName=@RealName,Phone=@Phone,Address=@Address,Sex=@Sex,Email=@Email,IdCard=@IdCard,ResponsibleArea=@ResponsibleArea,
LastMonthResults=@LastMonthResults,GoalsMonth=@GoalsMonth,PerformanceMonth=@PerformanceMonth,RoyaltyRatio=@RoyaltyRatio,
Royalty=@Royalty,CustomerSource=@CustomerSource,Remark=@Remark
WHERE ID=@ID";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
Salesman.RealName,
Salesman.Phone,
Salesman.Address,
Salesman.Sex,
Salesman.Email,
Salesman.IdCard,
Salesman.ResponsibleArea,
Salesman.LastMonthResults,
Salesman.GoalsMonth,
Salesman.PerformanceMonth,
Salesman.RoyaltyRatio,
Salesman.Royalty,
Salesman.CustomerSource,
Salesman.Remark,
Salesman.ID,
})));
}
public ActionResult Edit()
{
Business.Sys_Salesman Sys_Salesman = new Business.Sys_Salesman();
Model.Salesman Salesman = Sys_Salesman.GetInfo(Request["ID"]);
ViewData["GetSexList"] = GetSexList(Salesman.Sex);
return(View(Salesman));
}
public ActionResult EditInfo(Model.Salesman Saleman)
{
ViewData["GetSexList"] = GetSexList();
Business.Sys_Salesman Sys_Salesman = new Business.Sys_Salesman();
if (Sys_Salesman.EditSalesman(Saleman))
{
return(Content("1"));
}
return(Content("0"));
}
