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