/// <summary>
/// 检查小组下是否存在对应的成员
/// </summary>
private void CheckGroupMembers()
{
//检查该小组有无对应学生
_checkins = CheckinInfo.Query(_groupClassInfo.ID);
_students.Clear();
if (_checkins.Count > 0)
{
add_simpleButton.Hide();
update_simpleButton.Show();
update_simpleButton.Location = add_simpleButton.Location;
checkin_simpleButton.Enabled = true;
}
else
{
add_simpleButton.Show();
update_simpleButton.Hide();
checkin_simpleButton.Enabled = false;
}
foreach (var v in _checkins)
{
_students.Add(StudentInfo.QueryFromID(v.StudentID));
}
gridControl2.DataSource = _students;
gridControl2.RefreshDataSource();
}
private void update_simpleButton_Click(object sender, EventArgs e)
{
if (_removeStudents.Count == 0 && _addStudents.Count == 0)
{
XtraMessageBox.Show("未进行任何修改操作", "消息", MessageBoxButtons.OK);
return;
}
if (XtraMessageBox.Show("确认更新学生分组信息吗", "消息",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (_removeStudents.Count > 0)
{
_removeStudents.ForEach(p => CheckinInfo.DeleteMemebers(_groupClassInfo.ID, p.ID));
_removeStudents.Clear();
}
if (_addStudents.Count > 0)
{
int[] studenIDs = new int[_addStudents.Count];
for (int i = 0; i < studenIDs.Length; i++)
{
studenIDs[i] = _addStudents[i].ID;
}
int result = CheckinInfo.AddMembers(_groupClassInfo.ID, studenIDs);
_addStudents.Clear();
}
CheckGroupMembers();
}
private void oneKey_toolStripMenuItem_Click(object sender, EventArgs e)
{
GroupClassInfo arg = gridView1.GetRow(gridView1.FocusedRowHandle) as GroupClassInfo;
if (arg == null)
{
XtraMessageBox.Show("所选数据错误，请刷新后重试", "消息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//获取小组里所有的成员
List <CheckinInfo> results = CheckinInfo.Query(arg.ID);
foreach (var c in results)
{
StudentInfo stu = StudentInfo.QueryFromID(c.StudentID);
stu.Remaining--;
int iResult = StudentInfo.Updata(stu);
if (iResult <= 0)
{
string msg = string.Format("{0} 签到失败", stu.Name);
XtraMessageBox.Show(msg, "消息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
continue;
}
}
XtraMessageBox.Show("签到完成", "消息", MessageBoxButtons.OK);
Query();
}
private void add_simpleButton_Click(object sender, EventArgs e)
{
if (_addStudents.Count <= 0)
{
XtraMessageBox.Show("请添加小组成员！", "消息", MessageBoxButtons.OK);
return;
}
if (XtraMessageBox.Show("确认为小组新建以下学生吗？", "消息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
int[] studenIDs = new int[_addStudents.Count];
for (int i = 0; i < studenIDs.Length; i++)
{
studenIDs[i] = _addStudents[i].ID;
}
int result = CheckinInfo.AddMembers(_groupClassInfo.ID, studenIDs);
if (result != studenIDs.Length)
{
XtraMessageBox.Show("部分成员添加失败，请刷新后重试", "消息", MessageBoxButtons.OK);
return;
}
_addStudents.Clear();
CheckGroupMembers();
}
public IActionResult checkin([FromBody] CheckinInfo checkinInfo)
{
try
{
var apiKey = Request.Headers["apiKey"];
var correlationId = Request.Headers["correlationId"];
// Authenticate
if (!string.Equals(AppConfigStore.ApiKey, apiKey))
{
return(this.Unauthorized());
}
// Validate request details
if (checkinInfo == null)
{
return(this.BadRequest("Invalid request object"));
}
// Save to db
dbContext.Database.ExecuteSqlCommand(
"dbo.uspAddUser @p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10",
parameters: new object[] {
checkinInfo.ZipCode,
checkinInfo.AgeBracket,
checkinInfo.IsDuplicated,
checkinInfo.IsHoused,
checkinInfo.FamilySizeCategory1Count,
checkinInfo.FamilySizeCategory2Count,
checkinInfo.FamilySizeCategory3Count,
checkinInfo.FamilySizeCategory4Count,
checkinInfo.Race,
checkinInfo.Gender,
checkinInfo.SpokenLanguage
});
return(this.NoContent());
}
catch (Exception ex)
{
return(this.StatusCode(
(int)HttpStatusCode.InternalServerError,
ex.Message));
}
}
