public static Boolean fnStudentCheckIn(ref FpStudentObject fso, FpSite fpSite, DateTime lDtCheckin)
{
bool isCheckin = false;
//FpSite fpSite = SimpleOrmOperator.Query<FpSite>(site_id);
string bustype = fpSite.BUSTYPE;
int localType = fso.LOCALTYPE;
if (fpSite.LIMIT > 0)
{
string condition = string.Format(" where SITE_ID={0} and BUSTYPE='{1}' and to_char(CHECKIN_DATE,'YYYY-MM-DD') = '{2}' order by CHECKIN_DATE DESC "
, fpSite.ID
, bustype
, lDtCheckin
);
int checkinCount = SimpleOrmOperator.QueryCounts <FpSite>(condition);
if (checkinCount >= fpSite.LIMIT)
{
string fullMsg = string.Format("场地：{0} 今天的入场人数已超过{1},不能再入场", fpSite.NAME, fpSite.LIMIT);
throw new Exception(fullMsg);
}
}
FpLocalType fpLocalType = null;
if (DictFpLocalTypes.ContainsKey(localType))
{
fpLocalType = DictFpLocalTypes[localType];
}
else
{
fpLocalType = SimpleOrmOperator.Query <FpLocalType>(localType);
DictFpLocalTypes.Add(localType, fpLocalType);
}
isCheckin = fso.checkin(fpSite, fpLocalType, lDtCheckin);
//fso.IDCARD="'"+fso.IDCARD+"'";
SimpleOrmOperator.Update(fso);
fso.IDCARD = fso.IDCARD.Trim('\'');;
if (isCheckin)
{
FpCheckinLog log = new FpCheckinLog();
log.BUSTYPE = bustype;
log.SITE_ID = fpSite.ID;
log.CHECKIN_NAME = fso.NAME;
log.CHECKIN_IDCARD = fso.IDCARD;
log.CHECKIN_DATE = lDtCheckin;
log.REMARK = fso.REMARK;
log.CHECKIN_STATUE = fso.STATUE;
int statue = fso.STATUE;
if (statue == FpStudentObject.STATUE_KM1_ENTER)
{
log.REMARK = "科目1进场";
}
else if (statue == FpStudentObject.STATUE_KM2_ENTER)
{
log.REMARK = "科目2进场";
}
else if (statue == FpStudentObject.STATUE_KM1_ENTER)
{
log.REMARK = "科目3进场";
}
else if (statue == FpStudentObject.STATUE_LESSON_START)
{
log.REMARK = "上课进场";
}
else if (statue == FpStudentObject.STATUE_LESSON_END)
{
log.REMARK = "下课离场";
}
isCheckin = SimpleOrmOperator.Create(log);
}
return(isCheckin);
}
public static Boolean fnStudentCheckIn(ref FpStudentObject fso, FpSite fpSite, DateTime lDtCheckin)
{
bool isCheckin = false;
//FpSite fpSite = SimpleOrmOperator.Query<FpSite>(site_id);
string bustype = fpSite.BUSTYPE;
int localType = fso.LOCALTYPE;
if (fpSite.LIMIT > 0)
{
string condition = string.Format(" where SITE_ID={0} and BUSTYPE='{1}' and to_char(CHECKIN_DATE,'YYYY-MM-DD') = '{2}' order by CHECKIN_DATE DESC "
, fpSite.ID
, bustype
, lDtCheckin
);
int checkinCount = SimpleOrmOperator.QueryCounts<FpSite>(condition);
if (checkinCount >= fpSite.LIMIT) {
string fullMsg=string.Format("场地：{0} 今天的入场人数已超过{1},不能再入场",fpSite.NAME,fpSite.LIMIT);
throw new Exception(fullMsg);
}
}
FpLocalType fpLocalType=null;
if (DictFpLocalTypes.ContainsKey(localType))
{
fpLocalType = DictFpLocalTypes[localType];
}
else {
fpLocalType = SimpleOrmOperator.Query<FpLocalType>(localType);
DictFpLocalTypes.Add(localType, fpLocalType);
}
isCheckin = fso.checkin(fpSite,fpLocalType,lDtCheckin);
//fso.IDCARD="'"+fso.IDCARD+"'";
SimpleOrmOperator.Update(fso);
fso.IDCARD = fso.IDCARD.Trim('\''); ;
if (isCheckin) {
FpCheckinLog log = new FpCheckinLog();
log.BUSTYPE = bustype;
log.SITE_ID = fpSite.ID;
log.CHECKIN_NAME = fso.NAME;
log.CHECKIN_IDCARD = fso.IDCARD;
log.CHECKIN_DATE = lDtCheckin;
log.REMARK = fso.REMARK;
log.CHECKIN_STATUE = fso.STATUE;
int statue = fso.STATUE;
if (statue == FpStudentObject.STATUE_KM1_ENTER)
{
log.REMARK = "科目1进场";
}
else if (statue == FpStudentObject.STATUE_KM2_ENTER) {
log.REMARK = "科目2进场";
}
else if (statue == FpStudentObject.STATUE_KM1_ENTER)
{
log.REMARK = "科目3进场";
}
else if (statue == FpStudentObject.STATUE_LESSON_START)
{
log.REMARK = "上课进场";
}
else if (statue == FpStudentObject.STATUE_LESSON_END)
{
log.REMARK = "下课离场";
}
isCheckin= SimpleOrmOperator.Create(log);
}
return isCheckin;
}
