public int GetInsert(M_ExAttendance exAttendance)
{
string sqlStr = "INSERT INTO [dbo].[ZL_ExAttendance] ([Stuid],[LogTime],[Logtimeout],[Location],[StuName]) VALUES (@Stuid,@LogTime,@Logtimeout,@Location,@StuName);SET @AttID = SCOPE_IDENTITY()";
SqlParameter[] cmdParams = initmod.GetParameters(exAttendance);
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
}
public void MyCoruse_Study()
{
B_ExAttendance bExAttendance = new B_ExAttendance();
M_ExAttendance mExAttendance = new M_ExAttendance();
mExAttendance.Stuid = mu.UserID;
mExAttendance.StuName = mu.UserName;
mExAttendance.LogTime = DateTime.Now;
mExAttendance.Logtimeout = 0;
mExAttendance.Location = Request["fileurl"] ?? "";
bExAttendance.insert(mExAttendance);
}
public int insert(M_ExAttendance model)
{
return(Sql.insert(strTableName, model.GetParameters(model), model.GetParas(), model.GetFields()));
}
public bool GetUpdate(M_ExAttendance model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.AttID.ToString(), model.GetFieldAndPara(), model.GetParameters(model)));
}
