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))); }