添加分数
语法格式:
参数:
ID 团队ID
成员ID
成员姓名
分数
打分人ID
打分人姓名
任务数量
时间
前端javascript调用数据库存储过程示例(可在编辑区域修改参数):
U.A.Request("http://cd.1473.cn/php", (["db.1473.cn", "UseStudio_Task", "Task_CreateScoremen","6ff68add-c8e4-11e7-81ee-005056b350a4","e4a5b03b-febd-4ab4-bc6a-a74f02a8110d","傅昊","A","8606f9db-b69e-4991-b713-424ecac79f1f","曾振峰","15","2017-12-03","04d033cb-d822-11e7-a7c4-005056aa632a"]),AsynFun);
前端javascript调用示例:
SET @sid = UUID();
INSERT INTO Task_Fraction (Id,TimeId,MemberId,MemberName,Frachtion,MarkerId,Marker,TaskNumber,CreationTime,ScoreId)VALUES
(@sid,tid,menid,menname,fra,mid,mname,tnub,tim,fid);
SELECT @sid as Id;
UPDATE Task_ScoreManage SET TotalNumber = TotalNumber + 1 WHERE Id = fid;