/// <summary>
/// 编辑分配学员信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditDistributeStudents(Model.DistributeStudentsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_DistributeStudents set ");
strSql.Append("CoachID=@CoachID,CreateTime=@CreateTime,Operater=@Operater,DistributeStuStatus=1");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CoachID", SqlDbType.Int),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Operater", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.CoachID;
parameters[1].Value = model.ID;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.Operater;
int rows = Convert.ToInt32(DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStrDriveData, CommandType.Text, strSql.ToString(), parameters));
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string action = context.Request.Params["action"];
DriveMgr.Model.UserOperateLog userOperateLog = null; //操作日志对象
try
{
DriveMgr.Model.User userFromCookie = DriveMgr.Common.UserHelper.GetUser(context); //获取cookie里的用户对象
userOperateLog = new Model.UserOperateLog();
userOperateLog.UserIp = context.Request.UserHostAddress;
userOperateLog.UserName = userFromCookie.UserId;
switch (action)
{
case "search":
string strWhere = "1=1";
string sort = context.Request.Params["sort"]; //排序列
string order = context.Request.Params["order"]; //排序方式 asc或者desc
int pageindex = int.Parse(context.Request.Params["page"]);
int pagesize = int.Parse(context.Request.Params["rows"]);
string ui_distributeStudents_name = context.Request.Params["ui_distributeStudents_name"] ?? "";
string ui_distributeStudents_code = context.Request.Params["ui_distributeStudents_code"] ?? "";
string ui_distributeStudents_coach = context.Request.Params["ui_distributeStudents_coach"] ?? "";
strWhere += " and flag=1 and PeriodsID = (SELECT TOP 1 CurrentPeroidID FROM tb_CurrentPeroid)";
if (ui_distributeStudents_name.Trim() != "" && !DriveMgr.Common.SqlInjection.GetString(ui_distributeStudents_name)) //防止sql注入
{
strWhere += string.Format(" and StudentsName like '%{0}%'", ui_distributeStudents_name.Trim());
}
if (ui_distributeStudents_code.Trim() != "" && !DriveMgr.Common.SqlInjection.GetString(ui_distributeStudents_code))
{
strWhere += string.Format(" and StudentCode like '%{0}%'", ui_distributeStudents_code.Trim());
}
if (ui_distributeStudents_coach.Trim() != "" && !DriveMgr.Common.SqlInjection.GetString(ui_distributeStudents_coach))
{
strWhere += string.Format(" and CoachID ={0}", ui_distributeStudents_coach.Trim());
}
int totalCount; //输出参数
string strJson = new DriveMgr.BLL.ScoresBLL().GetPager("V_DistributeStudents", "*", sort + " " + order, pagesize, pageindex, strWhere, out totalCount);
context.Response.Write("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}");
userOperateLog.OperateInfo = "查询分配学员";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "查询条件：" + strWhere + " 排序：" + sort + " " + order + " 页码/每页大小：" + pageindex + " " + pagesize;
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "autoDistributeStu": //分配学员
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("distributeStudents", "autoDistributeStu", userFromCookie.Id))
{
string distributeResult = new DriveMgr.BLL.CoachBLL().AutoDistributeStudents(userFromCookie.UserId);
userOperateLog.OperateInfo = "自动分配学员";
userOperateLog.IfSuccess = true;
userOperateLog.Description = distributeResult;
context.Response.Write("{\"msg\":\"" + distributeResult + "\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "自动分配学员";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "edit":
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("distributeStudents", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["ui_distributeStudentsid_edit"]);
int ui_distributeStudents_coach_edit = Int32.Parse(context.Request.Params["ui_distributeStudents_coach_edit"] ?? "0");
DriveMgr.Model.DistributeStudentsModel distributeStudentsEdit = new Model.DistributeStudentsModel();
distributeStudentsEdit.ID = id;
distributeStudentsEdit.CoachID = ui_distributeStudents_coach_edit;
distributeStudentsEdit.CreateTime = DateTime.Now;
distributeStudentsEdit.Operater = userFromCookie.UserName;
if (new DriveMgr.BLL.CoachBLL().EditDistributeStudents(distributeStudentsEdit))
{
userOperateLog.OperateInfo = "修改分配学员信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，分配学员主键：" + distributeStudentsEdit.ID;
context.Response.Write("{\"msg\":\"修改分配学员信息成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改分配学员信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改分配学员信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
default:
context.Response.Write("{\"msg\":\"参数错误！\",\"success\":false}");
break;
}
}
catch (Exception ex)
{
context.Response.Write("{\"msg\":\"" + DriveMgr.Common.JsonHelper.StringFilter(ex.Message) + "\",\"success\":false}");
userOperateLog.OperateInfo = "分配学员功能异常";
userOperateLog.IfSuccess = false;
userOperateLog.Description = DriveMgr.Common.JsonHelper.StringFilter(ex.Message);
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
}
