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